diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-03-22 01:49:32 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-03-22 01:49:32 +0000 |
| commit | 58466c2a9dbe1c2195ae24892ae8390eb8d03287 (patch) | |
| tree | ceae0b6fb57e184a414aa5367c0494a625583786 /phpBB/ucp.php | |
| parent | 3e1ca2ab65a90dd9a4029b5ad1dfcd712dd99562 (diff) | |
| download | forums-58466c2a9dbe1c2195ae24892ae8390eb8d03287.tar forums-58466c2a9dbe1c2195ae24892ae8390eb8d03287.tar.gz forums-58466c2a9dbe1c2195ae24892ae8390eb8d03287.tar.bz2 forums-58466c2a9dbe1c2195ae24892ae8390eb8d03287.tar.xz forums-58466c2a9dbe1c2195ae24892ae8390eb8d03287.zip | |
- Bug 1197
git-svn-id: file:///svn/phpbb/trunk@5687 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/ucp.php')
| -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)) |