snoopyhund wrote:

---

also wie ich es nun habe passt es perfekt
vieleicht kannst du noch meinen hoffe kleinen wunsch umsetzen ?!?!

<?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 u.nickname, u.userID, YEAR( CURRENT_DATE( ) ) - YEAR( u.birthday ) 'age'
FROM ".PREFIX."user u
LEFT JOIN ".PREFIX."squads_members s
ON s.userID = u.userID
WHERE DATE_FORMAT(`birthday`, '%m%d') = DATE_FORMAT(NOW(), '%m%d')") AND s.squadID > 0 ;
$n=0;
while($db=mysql_fetch_array($ergebnis))
{
$n++;
$years=$db['age'];
if($n>1) $birthdays.='<a href="index.php?site=profile&amp;id='.$db['userID'].'"><b>'.$db['nickname'].'</b></a> ('.$years.')<br/>';
else $birthdays=''.$_language->module['today'].'<br/> <a href="index.php?site=profile&amp;id='.$db['userID'].'"><b>'.$db['nickname'].'</b></a> ('.$years.')<br/>';
}

// NEXT birthdays
$ergebnis=safe_query
(
"SELECT DISTINCT u.nickname, u.birthday, u.userID, DATE_FORMAT ( FROM_DAYS ( TO_DAYS( now( ) ) - TO_DAYS( u.birthday ) ) , '%y' ) + 1 AS age
FROM ".PREFIX."user u
LEFT JOIN ".PREFIX."squads_members s
ON s.userID = u.userID
WHERE DAYOFYEAR( u.birthday ) < ( DAYOFYEAR( now( ) ) +150 ) AND DAYOFYEAR( u.birthday ) > DAYOFYEAR( now( ) )
AND s.squadID > 0
ORDER BY ABS( DAYOFYEAR ( now( ) ) - DAYOFYEAR( u.birthday ) ) ASC LIMIT 0,100"
);

$ergebnis2=safe_query
(
"SELECT DISTINCT u.nickname, u.birthday, u.userID, DATE_FORMAT ( FROM_DAYS ( TO_DAYS( now( ) ) - TO_DAYS( u.birthday ) ) , '%y' ) + 1 AS age
FROM ".PREFIX."user u
LEFT JOIN ".PREFIX."squads_members s
ON s.userID = u.userID
WHERE ( DAYOFYEAR( u.birthday ) < DAYOFYEAR( now( ) ) AND ( DAYOFYEAR( u.birthday ) - DAYOFYEAR( now( ) ) +365 ) <= 150 )
AND s.squadID > 0
ORDER BY ABS( DAYOFYEAR ( now( ) ) -DAYOFYEAR( u.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&amp;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&amp;id='.$db['userID'].'"><b>'.$db['nickname'].'</b></a> ('.$years.')<br/>';

};

eval ("\$sc_nextbirthday = \"".gettemplate("sc_nextbirthday")."\";");
echo $sc_nextbirthday;

?>