aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2001-12-24 21:41:47 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2001-12-24 21:41:47 +0000
commit52294e6d5adcf871fd657442710e7e6251a15b4d (patch)
tree727becb79da655d57c8fc1aef708df579a5d7b6a
parent0ef1407219d2f9ace762e54ccedcaba1df0d5deb (diff)
downloadforums-52294e6d5adcf871fd657442710e7e6251a15b4d.tar
forums-52294e6d5adcf871fd657442710e7e6251a15b4d.tar.gz
forums-52294e6d5adcf871fd657442710e7e6251a15b4d.tar.bz2
forums-52294e6d5adcf871fd657442710e7e6251a15b4d.tar.xz
forums-52294e6d5adcf871fd657442710e7e6251a15b4d.zip
Minor update, big speed increase ... Bart's idea :)
git-svn-id: file:///svn/phpbb/trunk@1716 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/viewforum.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/viewforum.php b/phpBB/viewforum.php
index bb16be83fc..1271ff97b9 100644
--- a/phpBB/viewforum.php
+++ b/phpBB/viewforum.php
@@ -270,7 +270,7 @@ $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as i
AND p.poster_id = u2.user_id
AND t.topic_type <> " . POST_ANNOUNCE . "
$limit_topics_time
- ORDER BY t.topic_type DESC, p.post_time DESC
+ ORDER BY t.topic_type DESC, t.topic_last_post_id DESC
LIMIT $start, ".$board_config['topics_per_page'];
if( !$t_result = $db->sql_query($sql) )
{
@@ -289,7 +289,7 @@ $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as i
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_ANNOUNCE . "
- ORDER BY p.post_time DESC";
+ ORDER BY t.topic_last_post_id DESC ";
if( !$ta_result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't obtain topic information", "", __LINE__, __FILE__, $sql);