$result=dbquery(

"SELECT user_id, user_name, user_birthdate, user_avatar, 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()) AND EXTRACT(DAY FROM user_birthdate)=EXTRACT(DAY FROM NOW())) ".

"ORDER BY birth_month , birth_day LIMIT 0,15"

);



$rows = dbrows($result);

if ($rows != 0) {

@openside("Fødselsdage i dag");



echo "

";

echo "";

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

$months=explode("|", $locale['shortmonths']);

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

if ($data['user_birthdate'] != "0000-00-00")

{

$user_age = explode("-", $data['user_birthdate']);

$user_birthyear = $user_age[0];

$current_year = date("Y", time());

$user_age_years = $current_year - $user_birthyear;


if (mktime(0,0,0,$user_age[1], $user_age[2], $current_year) > time())

{

$user_age_years--;

}

$user_age_years = "(".$user_age_years." år)";


}

else

{

$user_age_years = "";

}


$letter = "";


echo "






";

}

}

echo "








";

if(!empty($data['user_avatar']))

{

$avatar="";}

else

{

$avatar="";}

echo"$avatar




".$data['user_name']." ".$user_age_years."


$letter Send en hilsen


 Gi'  en gave 



";

@closeside();

}