[Phpbb-checkins] CVS: phpBB2 upgrade.php,1.11,1.12

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

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

Modified Files:
	upgrade.php 
Log Message:
Fixed bug #498191

Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/upgrade.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** upgrade.php	2001/12/31 19:05:34	1.11
--- upgrade.php	2001/12/31 21:59:34	1.12
***************
*** 835,851 ****
  			$post_total = $db->sql_numrows($result);
  
! 			$post_id_ary = array();
! 			while( $row = $db->sql_fetchrow($result) )
  			{
! 				$post_id_ary[] = $row['post_id'];
! 			}
  
! 			$sql = "DELETE FROM " . POSTS_TABLE . "  
! 				WHERE post_id IN (" . implode(", ", $post_id_ary) . ")";
! 			query($sql, "Couldn't update posts to remove deleted user poster_id values");
  
! 			$sql = "DELETE FROM " . POSTS_TEXT_TABLE . "
! 				WHERE post_id IN (" . implode(", ", $post_id_ary) . ")";
! 			query($sql, "Couldn't update posts to remove deleted user poster_id values");
  
  			echo "Removed $post_total posts ... Done<br />\n";
--- 835,854 ----
  			$post_total = $db->sql_numrows($result);
  
! 			if( $post_total )
  			{
! 				$post_id_ary = array();
! 				while( $row = $db->sql_fetchrow($result) )
! 				{
! 					$post_id_ary[] = $row['post_id'];
! 				}
  
! 				$sql = "DELETE FROM " . POSTS_TABLE . "  
! 					WHERE post_id IN (" . implode(", ", $post_id_ary) . ")";
! 				query($sql, "Couldn't update posts to remove deleted user poster_id values");
  
! 				$sql = "DELETE FROM " . POSTS_TEXT_TABLE . "
! 					WHERE post_id IN (" . implode(", ", $post_id_ary) . ")";
! 				query($sql, "Couldn't update posts to remove deleted user poster_id values");
! 			}
  
  			echo "Removed $post_total posts ... Done<br />\n";