aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/ucp.php
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/ucp.php')
-rwxr-xr-xphpBB/ucp.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/ucp.php b/phpBB/ucp.php
index 61679d5076..73d976f3b1 100755
--- a/phpBB/ucp.php
+++ b/phpBB/ucp.php
@@ -144,8 +144,8 @@ if (!$user->data['is_registered'])
$update_time = $config['load_online_time'] * 60;
$sql = 'SELECT DISTINCT u.user_id, u.username, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline
- FROM ((' . ZEBRA_TABLE . ' z
- LEFT JOIN ' . SESSIONS_TABLE . ' s ON s.session_user_id = z.zebra_id), ' . USERS_TABLE . ' u)
+ FROM (' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u)
+ LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = z.zebra_id)
WHERE z.user_id = ' . $user->data['user_id'] . '
AND z.friend = 1
AND u.user_id = z.zebra_id