diff options
| -rwxr-xr-x | phpBB/ucp.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/ucp.php b/phpBB/ucp.php index 4cc01688cd..70b6447324 100755 --- a/phpBB/ucp.php +++ b/phpBB/ucp.php @@ -179,12 +179,12 @@ 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, ' . USERS_TABLE . ' u) + FROM (' . USERS_TABLE . ' u, ' . ZEBRA_TABLE . ' z) 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 - GROUP BY z.zebra_id'; + GROUP BY z.zebra_id, u.user_id, u.username'; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) |