phpBB.de

Code: Alles auswählen

mysql_select_db('datenbank'); 

$result = mysql_query("SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip 
FROM phpbb_users u, phpbb_sessions s 
WHERE u.user_id = s.session_user_id 
AND s.session_time >= ".( time() - 300 ) . " 
ORDER BY u.username ASC, s.session_ip ASC"); 

if (!$result) { 
die('Daten konnten nicht abgerufen werden: ' . mysql_error()); 
} 

$online_userlist = ''; 
$userlist_ary = array(); 
$userlist_visible = array(); 

$prev_user_id = 0; 


while( $row = mysql_fetch_array($result) ) 
{ 
// User is logged in and therefor not a guest 
if ( $row['session_logged_in'] ) 
{ 
// Skip multiple sessions for one user 
if ( $row['user_id'] != $prev_user_id ) 
{ 
$style_color = ''; 
if ( $row['user_level'] == '1' ) 
{ 
$row['username'] = '<b>' . $row['username'] . '</b>'; 
$style_color = 'style="color:#FF0000"'; 
} 
else if ( $row['user_level'] == '2' ) 
{ 
$row['username'] = '<b>' . $row['username'] . '</b>'; 
$style_color = 'style="color:#008000"'; 
} 

if ( $row['user_allow_viewonline'] ) 
{ 
$user_online_link = "<a href="http://teamlaupheim.te.funpic.de/index2.php?site=profil&id=" . $row['user_id'] . """ . $style_color .">" . $row['username'] . "</a>"; 



$online_userlist .= ( $online_userlist != '' ) ? ', ' . $user_online_link : $user_online_link; 
} 
} 

$prev_user_id = $row['user_id']; 
} 


} 


if ( empty($online_userlist) ) 
{ 
$online_userlist = "Es sind keine registrierten User online"; 
} 


echo $online_userlist;
?>