aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/ucp/ucp_main.php
diff options
context:
space:
mode:
authorMarc Alexander <admin@m-a-styles.de>2014-08-23 16:36:39 +0200
committerMarc Alexander <admin@m-a-styles.de>2014-08-23 16:36:39 +0200
commite5e45f860b798c955f1817001f07aabcbccbabcf (patch)
treead24053bcae50549245054ac8b75e4965a810d3c /phpBB/includes/ucp/ucp_main.php
parent752c73193e04f7eb22b3b90ad746a6b277e59272 (diff)
downloadforums-e5e45f860b798c955f1817001f07aabcbccbabcf.tar
forums-e5e45f860b798c955f1817001f07aabcbccbabcf.tar.gz
forums-e5e45f860b798c955f1817001f07aabcbccbabcf.tar.bz2
forums-e5e45f860b798c955f1817001f07aabcbccbabcf.tar.xz
forums-e5e45f860b798c955f1817001f07aabcbccbabcf.zip
[ticket/12966] Sort by post_time and post_id where applicable
This change was not applied to the search as this would require a larger rewrite of the search methods. PHPBB3-12966
Diffstat (limited to 'phpBB/includes/ucp/ucp_main.php')
-rw-r--r--phpBB/includes/ucp/ucp_main.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/includes/ucp/ucp_main.php b/phpBB/includes/ucp/ucp_main.php
index 304c04eb3d..a1624e78ec 100644
--- a/phpBB/includes/ucp/ucp_main.php
+++ b/phpBB/includes/ucp/ucp_main.php
@@ -81,7 +81,7 @@ class ucp_main
FROM $sql_from
WHERE t.topic_type = " . POST_GLOBAL . '
AND ' . $db->sql_in_set('t.forum_id', $forum_ary) . '
- ORDER BY t.topic_last_post_time DESC';
+ ORDER BY t.topic_last_post_time DESC, t.topic_last_post_id DESC';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
@@ -693,7 +693,7 @@ class ucp_main
AND t.topic_id = tw.topic_id
AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true),
- 'ORDER_BY' => 't.topic_last_post_time DESC'
+ 'ORDER_BY' => 't.topic_last_post_time DESC, t.topic_last_post_id DESC'
);
$sql_array['LEFT_JOIN'] = array();
@@ -710,7 +710,7 @@ class ucp_main
'WHERE' => 'b.user_id = ' . $user->data['user_id'] . '
AND ' . $db->sql_in_set('f.forum_id', $forbidden_forum_ary, true, true),
- 'ORDER_BY' => 't.topic_last_post_time DESC'
+ 'ORDER_BY' => 't.topic_last_post_time DESC, t.topic_last_post_id DESC'
);
$sql_array['LEFT_JOIN'] = array();