diff options
-rw-r--r-- | phpBB/includes/acp/acp_users.php | 5 |
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)) |