phpBB.de

Code: Alles auswählen

$sql = "SELECT u.user_id, u.username, u.user_avatar, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_time, s.session_page, s.session_ip, b.uid, b.pic
	FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s, ".NICKPAGE_TABLE." b
	WHERE u.user_id = s.session_user_id
		AND s.session_time >= ".( time() - 300 )."
		AND u.user_id = b.uid
	ORDER BY u.username ASC, s.session_ip ASC";
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);
}

$guest_users = 0;
$registered_users = 0;
$hidden_users = 0;

$reg_counter = 0;
$guest_counter = 0;
$prev_user = 0;
$prev_ip = '';

while ( $row = $db->sql_fetchrow($result) )
{
	
if($row['pic'] != "")
	{
		$avatar = $row['pic'];
	}
	else
	{
		$avatar = "<img src='./images/user_avatar.gif'>";
	}

Code: Alles auswählen

$pic = $row['pic'];
if(isset($pic))
   {
      $avatar = "<img src='./images/$pic'>";
   }
   else
   {
      $avatar = "<img src='./images/user_avatar.gif'>";
   }