###############################################################################
# Module Anniversaire (birthday) for PostNuke 0.76x
# =============================================================================
#
# Matthieu
# Website: http://www.mes-anniversaires.com
#
#
# copyright 2003-2006 26enforce.com, mathsysteme, Mes anniversaires & Jean-Michel Védrine
###############################################################################
if (!authorised(0, 'anniversaire::', "::", ACCESS_READ)) die ("Permission denied.");
if (!defined("LOADED_AS_MODULE")) die ("You can't access this file directly...");
$ModName = basename( dirname( __FILE__ ) );
$dbconn =& pnDBGetConn(true);
pnModDBInfoLoad('anniversaire', 'anniversaire');
$pntable =& pnDBGetTables();
modules_get_language();
$currentlang = pnUserGetLang();
include_once("modules/$ModName/function.php");
include("header.php");
OpenTable();
$ipp = "".pnModGetVar('anniversaire_config','affichageanniversaire')."";
list($sort, $mois, $page, $nb)= pnVarCleanFromInput('sort','mois', 'page', 'nb');
if ($sort ==''){
$sort=pn_anniversaire;
}
if ($mois ==''){
$mois=date("m");
}
if ($page ==''){
$page=1;
}
if ($sort!='pn_uid' && $sort!='pn_anniversaire' && $sort!='pn_anniversaire DESC' && $sort!='pn_sexe') {
echo _MODARGSERROR;
CloseTable();
include 'footer.php';
exit;
}
$date = date("dm");
$result_total = $dbconn->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 "
\n";
echo "
\n";
echo "
\n";
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 ""._NOANNIVERSAIRETODAY."\n";
echo " |
\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 ""._PAGE." : $page/$pages\n";
echo " | \n";
echo "
\n";
echo "\n";
echo "\n";
echo " $numbers am $day1. $nommois Geburtstag\n";
echo " | \n";
echo "
\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";
echo "$avatarm \n";
echo " | \n";
$datef = "$day2/$month2/$year2";
$age = calcul_age($datef);
if ($anniversaire == 0) {
$ages = "N.C";
} else {
$ages ="$age "._ANS."";
}
echo "\n";
echo " $sexc $unname wird heute $ages jung\n";
echo " | \n";
//affichage signe astrologique
$signeastro = "$day2-$month2-$year2";
$signe = signe_astro($signeastro);
echo "\n";
echo ""._SASTRO.": $signe\n";
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 "$envoyeremail";
echo "$envoyerpm";
echo " "._PROFIL." \n";
echo " | \n";
echo "
\n";
echo "
\n";
}
if ($pages > 1) {
$pcnt=1;
echo "";
echo "";
echo "";
if ($page > 1) {
echo " | ";
} else {
echo " | | ";
}
while ($pcnt < $page) {
echo "[ $pcnt ] ";
$pcnt++;
}
echo "[ $page ]";
$pcnt++;
while ($pcnt <= $pages) {
echo " [ $pcnt ]";
$pcnt++;
}
if ($page < $pages) {
echo " | | \n";
} else {
echo " | \n";
}
echo "
";
}
}
//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 " "._NOANNIVERSAIREMONTH."\n";
echo " |
\n";
} else {
if ($numrows == 1) {
$numbers = "$numrows "._MEMBRESNELE."";
}
if ($numrows > 1) {
$numbers ="$numrows "._MEMBRESNESLE."";
}
echo "\n";
echo "\n";
echo " $numbers außerdem noch in diesem Monat Geburtstag\n";
echo " | \n";
echo "
\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";
echo "$avatarm \n";
echo " | \n";
$datef = "$day3/$month3/$year3";
$age = calcul_age1($datef);
if($anniversaire == 0) {
$ages = "N.C";
} else {
$ages ="$age "._ANS."";
}
echo "\n";
echo " $sexc geboren "._LEMEMBREFETERA." $ages jung\n";
echo " | \n";
//affichage signe astrologique
$signeastro = "$day3-$month3-$year3";
$signe = signe_astro($signeastro);
echo "\n";
echo ""._SASTRO.": $signe\n";
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 "$envoyeremail";
echo "$envoyerpm";
echo " "._PROFIL."\n";
echo " | \n";
echo "
\n";
echo "
\n";
}
}
CloseTable();
include("footer.php");
?>