phpBB.de

Code: Alles auswählen

function get_birthday_list( $time )
{
	global $db, $phpbb_root_path, $phpEx, $userdata, $admin_level, $level_prior;

	$res = '';

	// no guest here, sorry ;)
	if ( ($userdata['user_id'] == ANONYMOUS) || !$userdata['session_logged_in']) return $res;

	$today = date("md", $time);
	$date_lookforward = date("md", ($time + 14*24*60*60));
	$user_id = $userdata['user_id'];
	$sql = "SELECT u.*,
					(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore,
					(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend,
					(CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) AS user_visible
				FROM ((" . USERS_TABLE . " AS u
				LEFT JOIN " . BUDDYS_TABLE . " AS b	ON b.user_id=u.user_id AND b.buddy_id=$user_id)
				LEFT JOIN " . BUDDYS_TABLE . " AS i ON i.user_id=$user_id AND i.buddy_id=u.user_id)
				WHERE u.user_id <> " . ANONYMOUS . " AND u.user_birthday <> 0 AND u.user_birthday <> '' and RIGHT(u.user_birthday, 4) BETWEEN $today AND $date_lookforward
				ORDER BY username";
	//echo $sql;
	if ( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Could not read user table to get birthday today info', '', __LINE__, __FILE__, $sql);
	}
	while ($row = $db->sql_fetchrow($result))
	{
		// get user relational status
		$ignore  = $row['user_ignore'];
		$friend  = $row['user_friend'];
		$always_visible = $row['user_visible'];
		$geburtstag = $row['user_birthday'];
		$age = date("Y", $time) - substr($geburtstag,0,4);
		$datum = substr($geburtstag,6,2).".".substr($geburtstag,4,2).".";

		// get the status of each info
		$real_display = ( !$ignore && $userdata['user_allow_real'] && $row['user_allow_real'] && ( ($row['user_viewreal'] == YES) || ( ($row['user_viewreal'] == FRIEND_ONLY) && $friend ) ) );

		// take care of admin status
		if ( is_admin($userdata) || ($row['user_id'] == $userdata['user_id']) ) $real_display = true;

		if ($real_display)
		{
			$txtclass = get_user_level_class($row['user_level'], 'genmed', $row);
			if ($row['user_allow_viewonline'] != YES) $row['username'] = '<i>' . $row['username'] . '</i>';
			$temp_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']);
			$row['username'] = '<a href="' . $temp_url . '" class="' . $txtclass . '">' . $row['username'] . '</a> ('.$age.'
			 am ' . $datum . ')';


			// add to the user list
			$res .= ( $res != '' ) ? ', ' : '';
			$res .= $row['username'];
		}
	}
	return $res;
}