[Phpbb-checkins] CVS: phpBB2 viewforum.php,1.115,1.116

[Paul S. O. <ps...@us...>]

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) )
  {