Execute("SELECT * FROM ".$pntable['anniversaire'] ." WHERE MONTH(pn_anniversaire) ='" . (int)pnVarPrepForStore($mois) . "' ORDER by $sort"); $total = $result_total->RecordCount(); //on affiche le plus vieux $plusvieux = $dbconn->Execute("SELECT pn_anniversaire FROM ".$pntable['anniversaire'] ." WHERE MONTH(pn_anniversaire) ='" . (int)pnVarPrepForStore($mois) . "' 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 MONTH(pn_anniversaire) ='" . (int)pnVarPrepForStore($mois) . "' 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"; } $sortmois = "\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 | heutige und bald bevorstehende Geburtstage ]
\n"; echo "

\n"; echo "Geburtstage nach Monaten sortiert"; echo "

\n"; echo "
\n"; echo "$sortmois"; //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.""; echo "

"._AVERTISSEMENT."

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

"._NOANNIVERSAIRE."\n"; echo "

\n"; } else { 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; } $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 "._MEMBRESNE.""; } if ($total > 1) { $numbers ="$total "._MEMBRESNES.""; } if ($pages > 1) { $pcnt=1; 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."\"$

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

\n"; echo " $numbers haben im $nommois Geburtstag\n"; echo "

\n"; $result = $dbconn->Execute("select pn_uid, pn_anniversaire, pn_sexe from ".$pntable['anniversaire'] ." WHERE MONTH(pn_anniversaire) ='" . (int)pnVarPrepForStore($mois) . "' ORDER by DAYOFMONTH(pn_anniversaire) LIMIT $offset,$ipp "); $numrows = $result->RecordCount(); while (list($id, $anniversaire, $sexe) = $result->fields) { list($year2, $month2, $day2) = explode("-", $anniversaire); pnModDBInfoLoad('users', 'users'); $pntable = pnDBGetTables(); $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 "\n"; //couleur garçon/fille if ($sexe == 0) { $sexc = "$unname "._NE.""; } else { $sexc ="$unname "._NEE." "; } // si pas d'avatar... on met blank.gif if ($avatar == "") { $avatarm = "

"; } else { $avatarm ="

"; } echo "\n"; //à partir de la date de naissance, retourne l'âge dans la variable $age // date de naissance (partie à modifier) $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 " $unname wurde am $day2. $nommois $year2 geboren.
$unname ist $ages jung.\n"; echo "

\n"; echo "Sternzeichen: $signe\n"; echo "

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