Execute("SELECT * FROM ".$pntable['anniversaire']." WHERE pn_date= $date ORDER by $sort"); $total = $result_total->RecordCount(); //on affiche le plus vieux $plusvieux = $dbconn->Execute("SELECT pn_anniversaire FROM ".$pntable['anniversaire']." WHERE pn_date=$date ORDER BY pn_anniversaire ASC LIMIT 1"); list($pv) = $plusvieux->fields; list($year, $month, $day) = explode("-", $pv); $plusvieux->Close(); //on affiche le plus jeune $plusjeune = $dbconn->Execute("SELECT pn_anniversaire FROM ".$pntable['anniversaire']." WHERE pn_date=$date ORDER BY pn_anniversaire DESC LIMIT 1"); list($pj) = $plusjeune->fields; list($year1, $month1, $day1) = explode("-", $pj); $plusjeune->Close(); pnThemeLoad(pnUserGetTheme()); $umfragecolor1 = pnThemeGetVar("bgcolor2"); $umfragecolor2 = pnThemeGetVar("bgcolor4"); $umfragecolor3 = pnThemeGetVar("bgcolor5"); $umfragecolor4 = pnThemeGetVar("link"); if ($page == ''){ $page="1"; } $order = "\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo " $\"Geburtstage$ \n"; echo "

\n"; echo "Geburtstage\n"; echo "

\n"; echo "
\n"; echo "

\n"; echo "Geburtstagsgrüße an die Mitglieder können in diesem Forum hinterlassen werden.

"; echo "[ Dein Geburtstagskonto | Geburtstagsstatistik | Geburtstage nach Monaten sortieren ]
\n"; echo "

\n"; echo "heutige Geburtstagskinder:"; echo "

\n"; echo "
\n"; echo " $order"; if ($total>$ipp) { $pages=ceil($total/$ipp); if ($page > $pages) { $page = $pages; } if (!$page) { $page=1; } $offset=($page-1)*$ipp; } else { $offset=0; $pages=1; $page=1; } echo "

"._AVERTISSEMENT."

\n"; if ($total == 0) { echo "\n"; echo "\n"; echo "\n"; echo "

"._NOANNIVERSAIRETODAY."\n"; echo "

\n"; } else { //à partir de la date de naissance, retourne l'âge dans la variable $age // date de naissance (partie à modifier) $datef = "$day/$month/$year"; $age = calcul_age($datef); if ($pv == 0) { $vieux = "N.C"; } else { $vieux ="$age "._ANS.""; } $datef = "$day1/$month1/$year1"; $age = calcul_age($datef); if ($pj == 0) { $jeune = "N.C"; } else { $jeune ="$age "._ANS.""; } if ($total == 1) { $numbers = "$total "._MEMBRESNELE.""; } else { $numbers = "$total "._MEMBRESNESLE.""; } //affichage des mois $mois = $month1; if($mois == 1) $nommois = ""._JANVIER.""; if($mois == 2) $nommois = ""._FEVRIER.""; if($mois == 3) $nommois = ""._MARS.""; if($mois == 4) $nommois = ""._AVRIL.""; if($mois == 5) $nommois = ""._MAI.""; if($mois == 6) $nommois = ""._JUIN.""; if($mois == 7) $nommois = ""._JUILLET.""; if($mois == 8) $nommois = ""._AOUT.""; if($mois == 9) $nommois = ""._SEPTEMBRE.""; if($mois == 10) $nommois = ""._OCTOBRE.""; if($mois == 11) $nommois = ""._NOVEMBRE.""; if($mois == 12) $nommois = ""._DECEMBRE.""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo ""._PAGE." : $page/$pages\n"; echo "

\n"; echo " $numbers am $day1. $nommois Geburtstag\n"; echo "

\n"; $result = $dbconn->Execute("select pn_uid, pn_anniversaire, pn_sexe from ".$pntable['anniversaire']." WHERE pn_date = $date ORDER by $sort LIMIT $offset,$ipp "); $numrows = $result->RecordCount(); while (list($id, $anniversaire, $sexe) = $result->fields) { list($year2, $month2, $day2) = explode("-", $anniversaire); pnModDBInfoLoad('users', 'users'); $infomember = $dbconn->Execute("SELECT pn_uid, pn_uname, pn_user_avatar, pn_email, pn_user_viewemail FROM ".$pntable['users']." where pn_uid=$id "); list($uid, $unname, $avatar, $email, $voiremail) = $infomember->fields; $infomember->Close(); $result->MoveNext(); echo "\n"; echo ""; //couleur garçon/fille if ($sexe == 0) { $sexc = " "._JA." $unname !"; } else { $sexc =" "._JA." $unname ! "; } // si pas d'avatar... on met blank.gif if ($avatar == "") { $avatarm = "

"; } else { $avatarm ="

"; } echo "\n"; $datef = "$day2/$month2/$year2"; $age = calcul_age($datef); if ($anniversaire == 0) { $ages = "N.C"; } else { $ages ="$age "._ANS.""; } echo "\n"; //affichage signe astrologique $signeastro = "$day2-$month2-$year2"; $signe = signe_astro($signeastro); echo "\n"; // envoyer par email /* $email = str_replace("@", "_at_", $email); $email = str_replace(".", "_dot_", $email); if ($voiremail == 0) { $envoyeremail = ""._IMPOSSIBLEENVOYER.""; } else { $envoyeremail =""._ENVOYER." "; } */ $envoyerpm = ""._ENVOYERPM." "; echo "\n"; echo "\n"; echo "

\n"; echo "$avatarm \n"; echo "

\n"; echo " $sexc
$unname wird heute $ages jung\n"; echo "

\n"; echo ""._SASTRO.": $signe\n"; echo "

\n"; // echo "$envoyeremail"; echo "$envoyerpm"; echo "
"._PROFIL." \n"; echo "

\n"; } if ($pages > 1) { $pcnt=1; echo ""; echo ""; echo ""; if ($page > 1) { echo "\n"; } else { echo "\n"; } echo "

$\""._PREVIOUS."\"$

"; } else { echo "

$\""._NOPREVIOUS."\"$

"; } while ($pcnt < $page) { echo "[ $pcnt ] "; $pcnt++; } echo "[ $page ]"; $pcnt++; while ($pcnt <= $pages) { echo " [ $pcnt ]"; $pcnt++; } if ($page < $pages) { echo "

$\""._NEXT."\"$

$\""._NONEXT."\"$

"; } } //on affiche les anniversaires futurs ! echo "

"; echo "Folgende Mitglieder haben ebenfalls bald Geburtstag:"; echo "

"; $sortnb = "\n"; echo " $sortnb"; echo "

\n"; if ($nb =='' || !is_int($nb)){ $nb=5; } $today = date("m-d"); $currentmonth = date("m"); $currentday = date("d"); $result1 = $dbconn->Execute("select pn_uid, pn_anniversaire, pn_sexe from ".$pntable['anniversaire'] ." WHERE SUBSTRING(pn_anniversaire, 6, 2) =$currentmonth AND SUBSTRING(pn_anniversaire, 9, 2) > $currentday LIMIT ".(int)pnVarPrepForStore($nb) .""); $numrows = $result1->RecordCount(); if ($numrows == 0) { echo " \n"; echo " \n"; } else { if ($numrows == 1) { $numbers = "$numrows "._MEMBRESNELE.""; } if ($numrows > 1) { $numbers ="$numrows "._MEMBRESNESLE.""; } echo "\n"; echo "\n"; echo "\n"; echo "

"._NOANNIVERSAIREMONTH."\n"; echo "

\n"; echo " $numbers außerdem noch in diesem Monat Geburtstag\n"; echo "

\n"; while(list ($id, $anniversaire, $sexe) = $result1->fields) { list($year3, $month3, $day3) = explode("-", $anniversaire); pnModDBInfoLoad('users', 'users'); $infomember = $dbconn->Execute("SELECT pn_uid, pn_uname, pn_user_avatar, pn_email, pn_user_viewemail FROM ".$pntable['users']." where pn_uid=$id "); list($uid, $unname, $avatar, $email, $voiremail) = $infomember->fields; $infomember->Close(); $result1->MoveNext(); echo "\n"; echo ""; //affichage des mois if($mois == 1) $nommois = ""._JANVIER.""; if($mois == 2) $nommois = ""._FEVRIER.""; if($mois == 3) $nommois = ""._MARS.""; if($mois == 4) $nommois = ""._AVRIL.""; if($mois == 5) $nommois = ""._MAI.""; if($mois == 6) $nommois = ""._JUIN.""; if($mois == 7) $nommois = ""._JUILLET.""; if($mois == 8) $nommois = ""._AOUT.""; if($mois == 9) $nommois = ""._SEPTEMBRE.""; if($mois == 10) $nommois = ""._OCTOBRE.""; if($mois == 11) $nommois = ""._NOVEMBRE.""; if($mois == 12) $nommois = ""._DECEMBRE.""; //couleur garçon/fille if ($sexe == 0) { $sexc = " $unname "._NELE." $day3. $nommois $year3"; } else { $sexc =" $unname "._NEELE." $day3. $nommois $year3"; } // si pas d'avatar... on met blank.gif if ($avatar == "") { $avatarm = "

"; } else { $avatarm ="

"; } echo "\n"; $datef = "$day3/$month3/$year3"; $age = calcul_age1($datef); if($anniversaire == 0) { $ages = "N.C"; } else { $ages ="$age "._ANS.""; } echo "\n"; //affichage signe astrologique $signeastro = "$day3-$month3-$year3"; $signe = signe_astro($signeastro); echo "\n"; // envoyer par email /* $email = str_replace("@", "_at_", $email); $email = str_replace(".", "_dot_", $email); if ($voiremail == 0) { $envoyeremail = ""._IMPOSSIBLEENVOYER.""; } else { $envoyeremail =""._ENVOYER." "; } */ $envoyerpm = ""._ENVOYERPM." "; echo "\n"; echo "\n"; echo "

\n"; echo "$avatarm \n"; echo "

\n"; echo " $sexc geboren
"._LEMEMBREFETERA." $ages jung\n"; echo "

\n"; echo ""._SASTRO.": $signe\n"; echo "

\n"; // echo "$envoyeremail"; echo "$envoyerpm"; echo "
"._PROFIL."\n"; echo "

\n"; } } CloseTable(); include("footer.php"); ?>