From 58466c2a9dbe1c2195ae24892ae8390eb8d03287 Mon Sep 17 00:00:00 2001 From: David M Date: Wed, 22 Mar 2006 01:49:32 +0000 Subject: - Bug 1197 git-svn-id: file:///svn/phpbb/trunk@5687 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/ucp.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'phpBB/ucp.php') 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)) -- cgit v1.2.1