if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }



if (file_exists(INFUSIONS."birthday_panel/locale/".$settings['locale'].".php")) {



	include INFUSIONS."birthday_panel/locale/".$settings['locale'].".php";



} else {



	include INFUSIONS."birthday_panel/locale/Polish.php";



}



openside($locale['GEB001']);

echo "<b>".$locale['GEB003']."</b><br>";



$heute = "____-".date("m-d");



$result = dbquery("SELECT user_birthdate,user_name,user_avatar,user_id FROM ".$db_prefix."users WHERE user_birthdate like '$heute' ORDER BY user_name ASC");





if (dbrows($result) == 0) {



echo $locale['GEB002'];



}



while ($data = dbarray($result)):



if ($data['user_avatar'] != "") {

			echo "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='' border='0' width='25' height='25'>";

			

		} else {

			echo "<img src='".IMAGES."imagenotfound.jpg' alt='' border='0' width='25' height='25'>";

			

		}





	echo " <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".trimlink($data['user_name'],15)."</a><br>";



 endwhile;

echo "<b>".$locale['GEB004']."</b>";



$result=dbquery("

SELECT user_id, user_name, DATE_FORMAT(user_birthdate, '%d') AS birth_day, EXTRACT(MONTH FROM user_birthdate) AS birth_month

FROM ".$db_prefix."users

WHERE EXTRACT(MONTH FROM user_birthdate)>EXTRACT(MONTH FROM NOW())

OR (EXTRACT(MONTH FROM user_birthdate)=EXTRACT(MONTH FROM NOW())

AND EXTRACT(DAY FROM user_birthdate)>EXTRACT(DAY FROM NOW()))

ORDER BY EXTRACT(MONTH FROM user_birthdate),EXTRACT(DAY FROM user_birthdate) LIMIT 0,5

");



echo "<table width='100%' cellpadding='0' cellspacing='0'>";

if(dbrows($result)!=0){

while($data = dbarray($result)) {

if ($data['birth_month'] == "1") {

$month = $locale['GEB100'];

} elseif ($data['birth_month'] == "2") {

$month = $locale['GEB101'];

} elseif ($data['birth_month'] == "3") {

$month = $locale['GEB102'];

} elseif ($data['birth_month'] == "4") {

$month = $locale['GEB103'];

} elseif ($data['birth_month'] == "5") {

$month = $locale['GEB104'];

} elseif ($data['birth_month'] == "6") {

$month = $locale['GEB105'];

} elseif ($data['birth_month'] == "7") {

$month = $locale['GEB106'];

} elseif ($data['birth_month'] == "8") {

$month = $locale['GEB107'];

} elseif ($data['birth_month'] == "9") {

$month = $locale['GEB108'];

} elseif ($data['birth_month'] == "10") {

$month = $locale['GEB109'];

} elseif ($data['birth_month'] == "11") {

$month = $locale['GEB110'];

} elseif ($data['birth_month'] == "12") {

$month = $locale['GEB111'];

}

echo "<tr><td class='small' align='left'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".trimlink($data['user_name'],15);

echo "</a></td><td class='small2' align='right'>".$data['birth_day'].". ".$month."</td></tr>";

}

}

echo "</table>";



closeside();



?>