diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-24 21:41:47 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-24 21:41:47 +0000 |
| commit | 52294e6d5adcf871fd657442710e7e6251a15b4d (patch) | |
| tree | 727becb79da655d57c8fc1aef708df579a5d7b6a | |
| parent | 0ef1407219d2f9ace762e54ccedcaba1df0d5deb (diff) | |
| download | forums-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.php | 4 |
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); |