diff options
| author | David M <davidmj@users.sourceforge.net> | 2007-08-11 20:51:02 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2007-08-11 20:51:02 +0000 |
| commit | ca0139c939cf6c781a12035cf90ea49446ced5bc (patch) | |
| tree | 778e18cd7a3148164975e7523f71622bcb072a2c /phpBB | |
| parent | b2f29e9084cc3f0184a9a01e9a52f86b0fd77086 (diff) | |
| download | forums-ca0139c939cf6c781a12035cf90ea49446ced5bc.tar forums-ca0139c939cf6c781a12035cf90ea49446ced5bc.tar.gz forums-ca0139c939cf6c781a12035cf90ea49446ced5bc.tar.bz2 forums-ca0139c939cf6c781a12035cf90ea49446ced5bc.tar.xz forums-ca0139c939cf6c781a12035cf90ea49446ced5bc.zip | |
finally got my dev machine running a decent DBMS
git-svn-id: file:///svn/phpbb/trunk@8021 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -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)) |