diff options
| author | Tom Beddard <subblue@users.sourceforge.net> | 2006-01-07 01:04:53 +0000 |
|---|---|---|
| committer | Tom Beddard <subblue@users.sourceforge.net> | 2006-01-07 01:04:53 +0000 |
| commit | 9187d51a4b96ab4030d67c835abce2e39632c419 (patch) | |
| tree | 01ade044478318d79cd561d35379dc1cade5c590 | |
| parent | 87ab0632d8af79d5ff5ef912b1e9b2cac0ace396 (diff) | |
| download | forums-9187d51a4b96ab4030d67c835abce2e39632c419.tar forums-9187d51a4b96ab4030d67c835abce2e39632c419.tar.gz forums-9187d51a4b96ab4030d67c835abce2e39632c419.tar.bz2 forums-9187d51a4b96ab4030d67c835abce2e39632c419.tar.xz forums-9187d51a4b96ab4030d67c835abce2e39632c419.zip | |
Added grouping by user_id to the team leader list query
git-svn-id: file:///svn/phpbb/trunk@5434 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/memberlist.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index 825819d3e4..791c40a63f 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -106,6 +106,7 @@ switch ($mode) 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 + GROUP BY u.user_id ORDER BY g.group_name ASC, u.username ASC'; $result = $db->sql_query($sql); |