|
From: Paul S. O. <ps...@us...> - 2001-12-24 21:41:50
|
Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv27939
Modified Files:
viewforum.php
Log Message:
Minor update, big speed increase ... Bart's idea :)
Index: viewforum.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/viewforum.php,v
retrieving revision 1.115
retrieving revision 1.116
diff -C2 -r1.115 -r1.116
*** viewforum.php 2001/12/16 18:53:44 1.115
--- viewforum.php 2001/12/24 21:41:47 1.116
***************
*** 271,275 ****
AND t.topic_type <> " . POST_ANNOUNCE . "
$limit_topics_time
! ORDER BY t.topic_type DESC, p.post_time DESC
LIMIT $start, ".$board_config['topics_per_page'];
if( !$t_result = $db->sql_query($sql) )
--- 271,275 ----
AND t.topic_type <> " . POST_ANNOUNCE . "
$limit_topics_time
! 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) )
***************
*** 290,294 ****
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_ANNOUNCE . "
! ORDER BY p.post_time DESC";
if( !$ta_result = $db->sql_query($sql) )
{
--- 290,294 ----
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_ANNOUNCE . "
! ORDER BY t.topic_last_post_id DESC ";
if( !$ta_result = $db->sql_query($sql) )
{
|