aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorTom Beddard <subblue@users.sourceforge.net>2005-12-30 21:03:05 +0000
committerTom Beddard <subblue@users.sourceforge.net>2005-12-30 21:03:05 +0000
commit82aed60ac0a85d46b440ada7bbb707512f239244 (patch)
tree3547a70751da15f261682f93476dadf1372dea7f
parent1324d64c9dbc78f55d476fc8ff2a63f96944009c (diff)
downloadforums-82aed60ac0a85d46b440ada7bbb707512f239244.tar
forums-82aed60ac0a85d46b440ada7bbb707512f239244.tar.gz
forums-82aed60ac0a85d46b440ada7bbb707512f239244.tar.bz2
forums-82aed60ac0a85d46b440ada7bbb707512f239244.tar.xz
forums-82aed60ac0a85d46b440ada7bbb707512f239244.zip
Registered group list query was showing duplicate groups.
git-svn-id: file:///svn/phpbb/trunk@5409 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/includes/ucp/ucp_groups.php1
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/includes/ucp/ucp_groups.php b/phpBB/includes/ucp/ucp_groups.php
index 4d424e0aeb..fce4dafe8a 100644
--- a/phpBB/includes/ucp/ucp_groups.php
+++ b/phpBB/includes/ucp/ucp_groups.php
@@ -251,6 +251,7 @@ class ucp_groups
FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . ' ug
WHERE ug.user_id = ' . $user->data['user_id'] . '
AND g.group_id = ug.group_id
+ GROUP BY g.group_id
ORDER BY g.group_type DESC, g.group_name';
$result = $db->sql_query($sql);