diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-04-22 18:34:13 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-04-22 18:34:13 +0000 |
| commit | 171a535dd52ab2a82db0a30e66ebf8b3ef0fe93a (patch) | |
| tree | 0a1bd231614b0f6d24b5554813d1514ca6c84af2 /phpBB/includes | |
| parent | 756aaf100559b920b564b06b934cd9dc6c65d867 (diff) | |
| download | forums-171a535dd52ab2a82db0a30e66ebf8b3ef0fe93a.tar forums-171a535dd52ab2a82db0a30e66ebf8b3ef0fe93a.tar.gz forums-171a535dd52ab2a82db0a30e66ebf8b3ef0fe93a.tar.bz2 forums-171a535dd52ab2a82db0a30e66ebf8b3ef0fe93a.tar.xz forums-171a535dd52ab2a82db0a30e66ebf8b3ef0fe93a.zip | |
- this works on other DBs now too :D
git-svn-id: file:///svn/phpbb/trunk@5829 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/acp/acp_groups.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/includes/acp/acp_groups.php b/phpBB/includes/acp/acp_groups.php index b3a9751d19..48e50881df 100644 --- a/phpBB/includes/acp/acp_groups.php +++ b/phpBB/includes/acp/acp_groups.php @@ -658,6 +658,7 @@ class acp_groups $sql = 'SELECT g.group_id, g.group_name, g.group_type, COUNT(ug.user_id) AS total_members FROM ' . GROUPS_TABLE . ' g LEFT JOIN ' . USER_GROUP_TABLE . ' ug USING (group_id) + GROUP BY g.group_id, g.group_name, g.group_type ORDER BY g.group_type ASC, g.group_name'; $result = $db->sql_query($sql); |