phpBB.de

Code: Alles auswählen

function mchat_obtain_guest_count()
{
	global $db, $config, $phpEx;

	$reading_sql = ' AND s.session_page = "mchat.'.$phpEx.'"';

	$time = (time() - (intval($config['load_online_time']) * 60));

	// Get number of online guests

	if ($db->sql_layer === 'sqlite')
	{
		$sql = 'SELECT COUNT(session_ip) as num_guests
			FROM (
				SELECT DISTINCT s.session_ip
				FROM ' . SESSIONS_TABLE . ' s
				WHERE s.session_user_id = ' . ANONYMOUS . '
					AND s.session_time >= ' . ($time - ((int) ($time % 60))) . 
				$reading_sql . '
			)';
	}
	else
	{
		$sql = 'SELECT COUNT(DISTINCT s.session_ip) as num_guests
			FROM ' . SESSIONS_TABLE . ' s
			WHERE s.session_user_id = ' . ANONYMOUS . '
				AND s.session_time >= ' . ($time - ((int) ($time % 60))) .
			$reading_sql;
	}
	$result = $db->sql_query($sql);
	$mchat_guests_online = (int) $db->sql_fetchfield('num_guests');
	$db->sql_freeresult($result);

	return $mchat_guests_online;
}