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

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

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

Modified Files:
	upgrade.php 
Log Message:
Fix bug #498194

Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/upgrade.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** upgrade.php	2001/12/31 21:59:34	1.12
--- upgrade.php	2001/12/31 22:00:59	1.13
***************
*** 1217,1232 ****
  			$result = query($sql, "Couldn't obtain list of deleted users");
  			
! 			$post_id_ary = array();
! 			while( $row = $db->sql_fetchrow($result) )
  			{
! 				$post_id_ary[] = $row['post_id'];
! 			}
  
! 			$sql = "UPDATE " . POSTS_TABLE . " 
! 				SET poster_id = " . ANONYMOUS . ", enable_sig = 0 
! 				WHERE post_id IN (" . implode(", ", $post_id_ary) . ")";
! 			query($sql, "Couldn't update posts to remove deleted user poster_id values");
  
! 			print "Done<br />\n";
  
  			echo "<br />Complete<br />\n";
--- 1217,1237 ----
  			$result = query($sql, "Couldn't obtain list of deleted users");
  			
! 			$users_removed = $db->sql_numrows($result);
! 
! 			if( $users_removed )
  			{
! 				$post_id_ary = array();
! 				while( $row = $db->sql_fetchrow($result) )
! 				{
! 					$post_id_ary[] = $row['post_id'];
! 				}
  
! 				$sql = "UPDATE " . POSTS_TABLE . " 
! 					SET poster_id = " . ANONYMOUS . ", enable_sig = 0 
! 					WHERE post_id IN (" . implode(", ", $post_id_ary) . ")";
! 				query($sql, "Couldn't update posts to remove deleted user poster_id values");
! 			}
  
! 			print "Removed $users_removed Users ... Done<br />\n";
  
  			echo "<br />Complete<br />\n";