phpBB.de

Code: Alles auswählen

// CODE TAKEN FROM Birthday Mod Version 1.4.15 from Niels Chr. Rød Denmark http://mods.db9.dk/ START 
$sql = ($board_config['birthday_check_day']) ? "SELECT user_id, username, user_birthday,user_level FROM " . USERS_TABLE. " WHERE user_birthday!=999999 ORDER BY username" :""; 
if($result = $db->sql_query($sql)) 
{ 
   if (!empty($result)) 
   { 
      $time_now = time(); 
      $this_year = create_date('Y', $time_now, $board_config['board_timezone']); 
      $date_today = create_date('Ymd', $time_now, $board_config['board_timezone']); 
      $date_forward = create_date('Ymd', $time_now+($board_config['birthday_check_day']*86400), $board_config['board_timezone']); 
         while ($birthdayrow = $db->sql_fetchrow($result)) 
      { 
            $user_birthday2 = $this_year.($user_birthday = realdate("md",$birthdayrow['user_birthday'] )); 
            if ( $user_birthday2 < $date_today ) $user_birthday2 += 1000; 
         if ( $user_birthday2 > $date_today  && $user_birthday2 <= $date_forward ) 
         { 
            // user are having birthday within the next days 
            $user_age = ( $this_year.$user_birthday < $date_today ) ? $this_year - realdate ('Y',$birthdayrow['user_birthday'])+1 : $this_year- realdate ('Y',$birthdayrow['user_birthday']); 
            switch ($birthdayrow['user_level']) 
            { 
               case ADMIN : 
                     $birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>'; 
                     $style_color = 'style="color:#' . $theme['fontcolor3'] . '"';                  break; 
               case MOD : 
                     $birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>'; 
                     $style_color = 'style="color:#' . $theme['fontcolor2'] . '"';                  break; 
               default: $style_color = ''; 
            } 
            $birthday_week_list .= ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $birthdayrow['user_id']) . '"' . $style_color .'>' . $birthdayrow['username'] . ' ('.$user_age.')</a>,'; 
         } else if ( $user_birthday2 == $date_today ) 
            { 
            //user have birthday today 
            $user_age = $this_year - realdate ( 'Y',$birthdayrow['user_birthday'] ); 
            switch ($birthdayrow['user_level']) 
            { 
               case ADMIN : 
                     $birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>'; 
                     $style_color = 'style="color:#' . $theme['fontcolor3'] . '"';                  break; 
               case MOD : 
                     $birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>'; 
                     $style_color = 'style="color:#' . $theme['fontcolor2'] . '"';                  break; 
               default: $style_color = ''; 
            } 
            $birthday_today_list .= ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $birthdayrow['user_id']) . '"' . $style_color .'>' . $birthdayrow['username'] . ' ('.$user_age.')</a>,'; 
            } 
      } 
      if ($birthday_today_list) $birthday_today_list[ strlen( $birthday_today_list)-1] = ' '; 
      if ($birthday_week_list) $birthday_week_list[ strlen( $birthday_week_list)-1] = ' '; 
   } 
   $db->sql_freeresult($result); 
} 
// CODE TAKEN FROM Birthday Mod Version 1.4.15 from Niels Chr. Rød Denmark http://mods.db9.dk/ END

Code: Alles auswählen

// CODE TAKEN FROM Birthday Mod Version 1.51 from Niels Chr. Rød Denmark http://mods.db9.dk/ START
$time_now = time();
$date_now = create_date('md', $time_now, $board_config['board_timezone']);
$date_forward = create_date('md', $time_now+($board_config['birthday_check_day']*86400), $board_config['board_timezone']);
$sql = ($board_config['birthday_check_day']) ? "SELECT user_id, username, user_birthday, user_level FROM ".USERS_TABLE." WHERE user_birthday<>999999 AND
(user_birthday<0 OR DATE_FORMAT(FROM_DAYS(user_birthday),'%m%d') BETWEEN ".(($date_now<$date_forward) ? "'($date_now+0)' AND '$date_forward'" : "'($date_now+0)' AND '1231' OR DATE_FORMAT(FROM_DAYS(user_birthday),'%m%d') BETWEEN '0101' AND '$date_forward'") .") ORDER BY username" : "";
if(!$result = $db->sql_query($sql))
{
     	message_die(GENERAL_ERROR, "Could not fetch birthday for users.", "", __LINE__, __FILE__, $sql);
} else
{
	$birthdayrows = array();
	$birthdayrows = $db->sql_fetchrowset($result);
}
	if (!empty($birthdayrows))
	{
		$this_year = create_date('Y', $time_now, $board_config['board_timezone']);
		$date_today = $this_year.$date_now;
		$date_forward = $this_year.$date_forward;
	      while (list($user_number, $birthdayrow) = each($birthdayrows))
		{
		      $user_birthday2 = $this_year.($user_birthday = realdate("md",$birthdayrow['user_birthday'] ));
			// give user a year more, if he alread have had birthday
      		if ( $user_birthday2 < $date_today ) $user_birthday2 += 10000;
			if ( $user_birthday2 == $date_today )
      		{
				//user have birthday today
				$user_age = $this_year - realdate ( 'Y',$birthdayrow['user_birthday'] );
				switch ($birthdayrow['user_level'])
				{
					case ADMIN :
		      			$birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>';
      					$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';						break;
					case MOD :
			      		$birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>';
      					$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';						break;
					default: $style_color = '';
				}
				$birthday_today_list .= ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $birthdayrow['user_id']) . '"' . $style_color .'>' . $birthdayrow['username'] . ' ('.$user_age.')</a>,';
		      } else if ( $user_birthday2 > $date_today  && $user_birthday2 <= $date_forward )
			{
				// user are having birthday within the next days
				$user_age = ( $this_year.$user_birthday < $date_today ) ? $this_year - realdate ('Y',$birthdayrow['user_birthday'])+1 : $this_year- realdate ('Y',$birthdayrow['user_birthday']);
				switch ($birthdayrow['user_level'])
				{
					case ADMIN :
		      			$birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>';
      					$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';break;
					case MOD :
		      			$birthdayrow['username'] = '<b>' . $birthdayrow['username'] . '</b>';
      					$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';break;
					default: $style_color = '';
				}
				$birthday_week_list .= ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $birthdayrow['user_id']) . '"' . $style_color .'>' . $birthdayrow['username'] . ' ('.$user_age.')</a>,';
			}
		}
		if ($birthday_today_list) $birthday_today_list[ strlen( $birthday_today_list)-1] = ' ';
		if ($birthday_week_list) $birthday_week_list[ strlen( $birthday_week_list)-1] = ' ';
	}
if (isset($result))
{
	$db->sql_freeresult($result);
}
// CODE TAKEN FROM Birthday Mod Version 1.51 from Niels Chr. Rød Denmark http://mods.db9.dk/ END