aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--phpBB/includes/acp/acp_users.php5
1 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/includes/acp/acp_users.php b/phpBB/includes/acp/acp_users.php
index edd5096862..077764ddbb 100644
--- a/phpBB/includes/acp/acp_users.php
+++ b/phpBB/includes/acp/acp_users.php
@@ -115,12 +115,13 @@ class acp_users
$s_form_options = '';
// Build modes dropdown list
- $sql = 'SELECT DISTINCT module_mode, module_auth
+ $sql = 'SELECT module_mode, module_auth
FROM ' . MODULES_TABLE . "
WHERE module_basename = 'users'
AND module_enabled = 1
AND module_class = 'acp'
- ORDER BY left_id";
+ GROUP BY module_mode, module_auth
+ ORDER BY MIN(left_id)";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))