aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB
diff options
context:
space:
mode:
authorMarc Alexander <admin@m-a-styles.de>2015-11-24 21:45:53 +0100
committerMarc Alexander <admin@m-a-styles.de>2015-11-24 21:45:53 +0100
commit8489cb6f408968e9d57afb0554e609d62caa8e05 (patch)
tree2c1fb5640e0fccd06366c56beb0fc2f73bc55f7a /phpBB
parente3f1cca911e001bcae9351d2c265deba26a752c8 (diff)
parentf4f6a4f810cf7aa6884e7bd71cd20f1c24ed2fc8 (diff)
downloadforums-8489cb6f408968e9d57afb0554e609d62caa8e05.tar
forums-8489cb6f408968e9d57afb0554e609d62caa8e05.tar.gz
forums-8489cb6f408968e9d57afb0554e609d62caa8e05.tar.bz2
forums-8489cb6f408968e9d57afb0554e609d62caa8e05.tar.xz
forums-8489cb6f408968e9d57afb0554e609d62caa8e05.zip
Merge pull request #4033 from tas2580/ticket/14297
[ticket/14297] Uppercase and lowercase when sorting topics
Diffstat (limited to 'phpBB')
-rw-r--r--phpBB/viewforum.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/viewforum.php b/phpBB/viewforum.php
index cd55114bad..6607f24833 100644
--- a/phpBB/viewforum.php
+++ b/phpBB/viewforum.php
@@ -264,7 +264,7 @@ gen_forum_auth_level('forum', $forum_id, $forum_data['forum_status']);
$limit_days = array(0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);
$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']);
-$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => array('t.topic_last_post_time', 't.topic_last_post_id'), 'r' => (($auth->acl_get('m_approve', $forum_id)) ? 't.topic_posts_approved + t.topic_posts_unapproved + t.topic_posts_softdeleted' : 't.topic_posts_approved'), 's' => 't.topic_title', 'v' => 't.topic_views');
+$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => array('t.topic_last_post_time', 't.topic_last_post_id'), 'r' => (($auth->acl_get('m_approve', $forum_id)) ? 't.topic_posts_approved + t.topic_posts_unapproved + t.topic_posts_softdeleted' : 't.topic_posts_approved'), 's' => 'LOWER(t.topic_title)', 'v' => 't.topic_views');
$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param, $default_sort_days, $default_sort_key, $default_sort_dir);