From 6d101df7dc3dc6f5542ccb11d626dcacbd148de6 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Mon, 28 Nov 2005 18:38:49 +0000 Subject: - some SQL:2003 changes (basicly joins, mysql5 is sql:2003 compliant in strict mode now) - postgresql not supporting this standard. :/ - acp changes git-svn-id: file:///svn/phpbb/trunk@5313 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/memberlist.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'phpBB/memberlist.php') diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index 253907f070..8949145126 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -102,7 +102,7 @@ switch ($mode) $db->sql_freeresult($result); $sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_rank, u.user_posts, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id - FROM ' . USERS_TABLE . ' u, ' . GROUPS_TABLE . ' g + FROM (' . USERS_TABLE . ' u, ' . GROUPS_TABLE . ' g) LEFT JOIN ' . USER_GROUP_TABLE . ' ug ON (ug.group_id = g.group_id AND ug.user_id = ' . $user->data['user_id'] . ') WHERE u.user_id IN (' . implode(', ', $admin_id_ary + $mod_id_ary) . ') AND u.group_id = g.group_id @@ -294,7 +294,7 @@ switch ($mode) $group_options .= ''; } - // We left join on the session table to see if the user is currently online + // $sql = 'SELECT username, user_id, user_type, user_colour, user_permissions, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_allow_viewemail, user_posts, user_regdate, user_rank, user_from, user_occ, user_interests, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_avatar, user_avatar_width, user_avatar_height, user_avatar_type, user_lastvisit FROM ' . USERS_TABLE . " WHERE user_id = $user_id -- cgit v1.2.1