[Phpbb-checkins] CVS: phpBB2 viewtopic.php,1.180,1.181

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

Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv1103

Modified Files:
	viewtopic.php 
Log Message:
Minor rewrite of some sql fetchrow stuff

Index: viewtopic.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/viewtopic.php,v
retrieving revision 1.180
retrieving revision 1.181
diff -C2 -r1.180 -r1.181
*** viewtopic.php	18 Mar 2002 13:35:43 -0000	1.180
--- viewtopic.php	19 Mar 2002 00:43:19 -0000	1.181
***************
*** 404,427 ****
  	ORDER BY p.post_time $post_time_order
  	LIMIT $start, ".$board_config['posts_per_page'];
! if(!$result = $db->sql_query($sql))
  {
  	message_die(GENERAL_ERROR, "Couldn't obtain post/user information.", "", __LINE__, __FILE__, $sql);
  }
  
! if(!$total_posts = $db->sql_numrows($result))
  {
  	message_die(GENERAL_MESSAGE, $lang['No_posts_topic']);
  }
- $postrow = $db->sql_fetchrowset($result);
- $db->sql_freeresult($result);
  
  $sql = "SELECT *
  	FROM " . RANKS_TABLE . "
  	ORDER BY rank_special, rank_min";
! if( !($result = $db->sql_query($sql)) )
  {
  	message_die(GENERAL_ERROR, "Couldn't obtain ranks information.", "", __LINE__, __FILE__, $sql);
  }
! $ranksrow = $db->sql_fetchrowset($result);
  
  //
--- 404,443 ----
  	ORDER BY p.post_time $post_time_order
  	LIMIT $start, ".$board_config['posts_per_page'];
! if ( !($result = $db->sql_query($sql)) )
  {
  	message_die(GENERAL_ERROR, "Couldn't obtain post/user information.", "", __LINE__, __FILE__, $sql);
  }
  
! if ( $row = $db->sql_fetchrow($result) )
! {
! 	$postrow = array();
! 	do
! 	{
! 		$postrow[] = $row;
! 	}
! 	while ( $row = $db->sql_fetchrow($result) );
! 	$db->sql_freeresult($result);
! 
! 	$total_posts = count($postrow);
! }
! else
  {
  	message_die(GENERAL_MESSAGE, $lang['No_posts_topic']);
  }
  
  $sql = "SELECT *
  	FROM " . RANKS_TABLE . "
  	ORDER BY rank_special, rank_min";
! if ( !($result = $db->sql_query($sql)) )
  {
  	message_die(GENERAL_ERROR, "Couldn't obtain ranks information.", "", __LINE__, __FILE__, $sql);
  }
! 
! $ranksrow = array();
! while ( $row = $db->sql_fetchrow($result) )
! {
! 	$ranksrow[] = $row;
! }
! $db->sql_freeresult($result);
  
  //