From b2f29e9084cc3f0184a9a01e9a52f86b0fd77086 Mon Sep 17 00:00:00 2001
From: David M <davidmj@users.sourceforge.net>
Date: Fri, 10 Aug 2007 03:15:23 +0000
Subject: work for everybody

git-svn-id: file:///svn/phpbb/trunk@8020 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/includes/acp/acp_users.php | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'phpBB')

diff --git a/phpBB/includes/acp/acp_users.php b/phpBB/includes/acp/acp_users.php
index 0b18a5c132..edd5096862 100644
--- a/phpBB/includes/acp/acp_users.php
+++ b/phpBB/includes/acp/acp_users.php
@@ -115,12 +115,11 @@ class acp_users
 		$s_form_options = '';
 
 		// Build modes dropdown list
-		$sql = 'SELECT module_mode, module_auth
+		$sql = 'SELECT DISTINCT module_mode, module_auth
 			FROM ' . MODULES_TABLE . "
 			WHERE module_basename = 'users'
 				AND module_enabled = 1
 				AND module_class = 'acp'
-			GROUP BY module_mode, module_auth, left_id
 			ORDER BY left_id";
 		$result = $db->sql_query($sql);
 
-- 
cgit v1.2.1