aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGraham Eames <grahamje@users.sourceforge.net>2006-06-10 14:20:55 +0000
committerGraham Eames <grahamje@users.sourceforge.net>2006-06-10 14:20:55 +0000
commit90c514188a1128dcf7975ec03440d74f23b4e784 (patch)
treeb39d872e9c287873b989cf4c1b267e996df99e3f
parenta3570cd0484594247bccdd423d1d5e4a7094025d (diff)
downloadforums-90c514188a1128dcf7975ec03440d74f23b4e784.tar
forums-90c514188a1128dcf7975ec03440d74f23b4e784.tar.gz
forums-90c514188a1128dcf7975ec03440d74f23b4e784.tar.bz2
forums-90c514188a1128dcf7975ec03440d74f23b4e784.tar.xz
forums-90c514188a1128dcf7975ec03440d74f23b4e784.zip
Group ordering on legend
git-svn-id: file:///svn/phpbb/trunk@6037 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/index.php3
-rw-r--r--phpBB/viewonline.php3
2 files changed, 4 insertions, 2 deletions
diff --git a/phpBB/index.php b/phpBB/index.php
index 862eb5234f..5cf918cda2 100644
--- a/phpBB/index.php
+++ b/phpBB/index.php
@@ -39,7 +39,8 @@ $l_total_topic_s = ($total_topics == 0) ? 'TOTAL_TOPICS_ZERO' : 'TOTAL_TOPICS_OT
$sql = 'SELECT group_id, group_name, group_colour, group_type
FROM ' . GROUPS_TABLE . '
WHERE group_legend = 1
- AND group_type <> ' . GROUP_HIDDEN;
+ AND group_type <> ' . GROUP_HIDDEN . '
+ ORDER BY group_name ASC';
$result = $db->sql_query($sql);
$legend = '';
diff --git a/phpBB/viewonline.php b/phpBB/viewonline.php
index 60339ce8ad..569f5297f6 100644
--- a/phpBB/viewonline.php
+++ b/phpBB/viewonline.php
@@ -324,7 +324,8 @@ $pagination = generate_pagination(append_sid("{$phpbb_root_path}viewonline.$phpE
// Grab group details for legend display
$sql = 'SELECT group_id, group_name, group_colour, group_type
FROM ' . GROUPS_TABLE . '
- WHERE group_legend = 1';
+ WHERE group_legend = 1
+ ORDER BY group_name ASC';
$result = $db->sql_query($sql);
$legend = '';