Im kind of busy atm but i'm sure it will be no problem :) Once i get some free time ill look.
here u go tested and working...
Code:
<?php
require_once('global.php');
gzip();
dbconn(true);
maxsysop();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<title>Happy Birthday</title>
</head>
<body>
<?php
if($CURUSER){
define ('SKIP_CACHE_MESSAGE', true);
require_once INC_PATH . '/functions_cache2.php';
$no_cache = false;
if (!$showbday = cache_check2 ('tsf_bday'))
{
$no_cache = true;
}
if ($no_cache)
{
$todaybday = date ('j-n');
$query = sql_query ('' . 'SELECT u.id,u.username,u.birthday,g.namestyle FROM users u LEFT JOIN usergroups g ON (u.usergroup=g.gid) WHERE u.birthday REGEXP \'^' . $todaybday . '-([1-9][0-9][0-9][0-9])\' AND u.enabled = \'yes\' AND u.status=\'confirmed\' AND u.usergroup != ' . UC_BANNED);
$bdaycount = mysql_num_rows ($query);
if (0 < $bdaycount)
{
while ($bday = mysql_fetch_assoc ($query))
{
$userbday = explode ('-', $bday['birthday']);
$yearsold = date ('Y') - $userbday[2];
$showbday .= ' <a href="' . tsf_seo_clean_text ($bday['username'], 'u', $bday['id'], '', 'ts') . '" target="_top">' . get_user_color ($bday['username'], $bday['namestyle']) . '</a> (<b>' . $yearsold . '</b>) ';
}
}else{
$showbday .= '<center><b> No birthdays today!</b></center>';
}
cache_save2 ('tsf_bday', $showbday, '</td></tr>');
}
if (($cachesystem != 'yes' OR $no_cache))
{
$showbday .= '</td></tr>';
}
?>
<?php echo $showbday; ?>
</body>
</html>
<?php
}
?>