<?php
defined (
'main'
)
or
die
(
'no direct access'
);
$limit
= 1;
$recht
= 0;
$showavatars
= 1;
$count
= 0;
$timestamp
= time();
$akttime
=
date
(
'Y-m-d'
,
$timestamp
);
function
get_gebtage (
$datum
) {
list(
$y
,
$m
,
$d
) =
explode
(
'-'
,
$datum
);
return
(
$d
.
'.'
.
$m
.
'.'
.
$y
);
}
# DIE krasse Abfrage :-)... von Manue
$q
= "SELECT name, id, avatar,
CASE WHEN ( MONTH(gebdatum) < MONTH(NOW()) ) OR ( MONTH(gebdatum) <= MONTH(NOW()) AND DAYOFMONTH(gebdatum) < DAYOFMONTH(NOW()) ) THEN
gebdatum + INTERVAL (YEAR(NOW()) - YEAR(gebdatum) + 1) YEAR
ELSE
gebdatum + INTERVAL (YEAR(NOW()) - YEAR(gebdatum)) YEAR
END
AS gebtage
FROM prefix_user WHERE gebdatum > 0000-00-00 AND recht <=
".$recht."
ORDER BY gebtage LIMIT ".
$limit
;
$erg
= db_query(
$q
);
echo
'<table width="100%" cellspacing="0" cellpadding="0">'
;
$i
= 1;
while
(
$row
= db_fetch_object(
$erg
)) {
if
(
$akttime
==
$row
->gebtage) {
echo
'<tr><td align="center">'
.
$lang
[
'today'
].
' '
.
$lang
[
'had'
].
' <a class="box" href="index.php?user-details-'
.
$row
->id.
'">'
.
$row
->name.
'</a><br / >'
.
$lang
[
'birthday'
].
'<br / ><img border="0" src="include/images/icons/birthday.gif"></td></tr>'
;
}
else
{
$gebtage
= get_gebtage (
$row
->gebtage);
echo
'<tr><td align="center"><a class="box" href="index.php?user-details-'
.
$row
->id.
'">'
.
$row
->name.
'</a> '
.
$lang
[
'had'
].
' '
.
$lang
[
'on'
].
' '
.
$gebtage
.
' '
.
$lang
[
'birthday'
];
if
(
$showavatars
&&
$row
->avatar) {
echo
'<br /><img border="0" src="'
.
$row
->avatar.
'">'
;
}
echo
"</td></tr>"
;
}
if
(
$i
<
$limit
) {
echo
'<tr><td> </td></tr>'
;
}
$i
++;
}
echo
'</table>'
;
?>