phpBB.nl

Code: Selecteer alles

<?

//
// Get user list
//
$sql = "SELECT u.user_id, u.username, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_time, s.session_page, 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 = mysql_query($sql)) )
{
	die('Could not obtain regd user/online information');
}
$prev_userip = 0;
$users = array();
while ( $row = $db->sql_fetchrow($result) )
{
	$view_online = false;

	//if ( $row['session_logged_in'] ) 
	{
		$uid = $row['user_id'];

		if ( $uidip != $prev_user )
		{
			$uname = $row['username'];

			$style_color = '';
			if ( $row['user_level'] == 1 )
			{
				$uname = '<b>' . $uname . '</b>';
				$style_color = '  style="color:#' . $theme['fontcolor3'] . '"';
			}
			else if ( $row['user_level'] == 2 )
			{
				$uname = '<b>' . $uname . '</b>';
				$style_color = ' style="color:#' . $theme['fontcolor2'] . '"';
			}

			$prev_userip = $row['session_ip'];
			$users[] = "<a href=\"profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $uid . "\" " . $style_color . ">" . $uname . "</a>";
		}
	}
}
$users = implode(', ', $users);
$users = ( !empty($users) ) ? $users : 'Geen' ;
$users = '' . $lang['online_users'] . $users . '';
echo $users;

function query_stats($table){
    $sql = "SELECT * FROM " . $table;
    if( !($result = mysql_query($sql)) ){
	    '<span style="color: #ff0000;">query failed</span>';
	} return mysql_num_rows($result);
}
?>
Posts: query_stats('phpbb_posts')