<?php
// sc_nextbirthday_V3 Addon
// in Zeile 31 wird festgelegt wieviele User angezeigt werden!
// LIMIT 0,3 --> 3 User werden angezeigt
// LIMIT 0,4 --> 4 User werden angezeigt
// LIMIT 0,6 --> 6 User werden angezeigt
$_language->read_module('sc_nextbirthday');
// TODAY birthdays
$ergebnis=safe_query("SELECT nickname, userID, YEAR(CURRENT_DATE()) -YEAR(birthday) 'age' FROM ".PREFIX."user WHERE DATE_FORMAT(`birthday`, '%m%d') = DATE_FORMAT(NOW(), '%m%d')");
$n=0;
while($db=mysql_fetch_array($ergebnis)) {
$n++;
$years=$db['age'];
if($n>1) $birthdays.='<a href="index.php?site=profile&id='.$db['userID'].'"><b>'.$db['nickname'].'</b></a> ('.$years.')<br/>';
else $birthdays=''.$_language->module['today'].'<br/> <a href="index.php?site=profile&id='.$db['userID'].'"><b>'.$db['nickname'].'</b></a> ('.$years.')<br/>';
}
// NEXT birthdays
$ergebnis=safe_query
(
"SELECT nickname, birthday, userID,
DATE_FORMAT ( FROM_DAYS ( TO_DAYS( now( ) ) - TO_DAYS( birthday ) ) , '%y' ) + 1 AS age
FROM ".PREFIX."user
WHERE DAYOFYEAR( birthday ) < ( DAYOFYEAR( now( ) ) +150 ) AND DAYOFYEAR( birthday ) > DAYOFYEAR( now( ) )
ORDER BY ABS( DAYOFYEAR ( now( ) ) -DAYOFYEAR( birthday ) ) ASC LIMIT 0,100"
);
$ergebnis2=safe_query
(
"SELECT nickname, birthday, userID,
DATE_FORMAT ( FROM_DAYS ( TO_DAYS( now( ) ) - TO_DAYS( birthday ) ) , '%y' ) + 1 AS age
FROM ".PREFIX."user
WHERE ( DAYOFYEAR( birthday ) < DAYOFYEAR( now( ) ) AND ( DAYOFYEAR( birthday ) - DAYOFYEAR( now( ) ) +365 ) <= 150 )
ORDER BY ABS( DAYOFYEAR ( now( ) ) -DAYOFYEAR( birthday ) ) DESC LIMIT 0,20"
);
$n=0;
while( $db = mysql_fetch_array ( $ergebnis ) )
{
list ( $bdate, $btime ) = explode ( ' ' , $db['birthday'] );
list ( $year, $month, $day ) = explode( '-', $bdate );
$n++;
$years = $db['age'];
$birthweek.=''.$day.'.'.$month.'. <a href="index.php?site=profile&id='.$db['userID'].'"><b>'.$db['nickname'].'</b></a> ('.$years.')<br/>';
};
$n=0;
while( $db = mysql_fetch_array ( $ergebnis2 ) )
{
list ( $bdate, $btime ) = explode ( ' ' , $db['birthday'] );
list ( $year, $month, $day ) = explode( '-', $bdate );
$n++;
$years = $db['age'];
$birthweek.=''.$day.'.'.$month.'. <a href="index.php?site=profile&id='.$db['userID'].'"><b>'.$db['nickname'].'</b></a> ('.$years.')<br/>';
};
eval ("\$sc_nextbirthday = \"".gettemplate("sc_nextbirthday")."\";");
echo $sc_nextbirthday;
?> | 
« ‹ 1 2 3 4 5 › »
25.05.2013 - 03:18 - 0 Replies
28.03.2013 -