Code: Alles auswählen
// For the Birthday Mod
$query = "select user_id, username, user_birthday
FROM ".USERS_TABLE." u
WHERE month(date_add(\"1970-01-01\", interval(user_birthday) day)) = '".$monthView['month']."'
AND dayofmonth(date_add(\"1970-01-01\", interval(user_birthday) day)) = '$day'
AND user_birthday < '999999';";
if (!$result = $db->sql_query($query)) {
message_die(GENERAL_ERROR, 'Error querying dates for calendar.');
}
while ($topic = $db->sql_fetchrow($result)) {
$topic_text = $lang['Birthday'];
$username = $topic['username'];
$birthday = $monthView['year'] - date('Y', $topic['user_birthday']);
$user_id = $topic['user_id'];
$profillink = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id");
$template->assign_block_vars('date_row.date_cell.switch_date_cells.date_event', array(
'U_EVENT' => "$first_date<span class='gensmall'><font color='#000000'>•</font></span> <a href=\"$profillink\" align='left' onMouseOver=\"createTitle(this, '<b>" . $lang['Birthday'] . ":</b> $username<br>" . $lang['Calendar_birthday_greeting_first'] . " <b>$birthday</b> " . $lang['Calendar_birthday_greeting_sec'] . "', event.pageX, event.pageY);\" onMouseOut=\"destroyTitle();\" class=\"gensmall\">$topic_text: <b>$username</b></a>\n\t<div style='height: 1px;'><IMG SRC='dot.gif' WIDTH='1' HEIGHT='1' BORDER=0></div>")
);
$numEvents++;
}