[Phpbb-checkins] CVS: phpBB2 update_to_201.php,1.1.2.4,1.1.2.5

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

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

Modified Files:
      Tag: phpBB-2_0_0
	update_to_201.php 
Log Message:
Hopefully add a work-around for user_timezone datatype change ... needs testing really.

Index: update_to_201.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/Attic/update_to_201.php,v
retrieving revision 1.1.2.4
retrieving revision 1.1.2.5
diff -C2 -r1.1.2.4 -r1.1.2.5
*** update_to_201.php	16 May 2002 01:15:48 -0000	1.1.2.4
--- update_to_201.php	16 May 2002 12:32:00 -0000	1.1.2.5
***************
*** 367,374 ****
  				break;
  			case 'postgresql':
! //				$sql[] = "ALTER TABLE " . USERS_TABLE . " 
! //					RENAME COLUMN user_timezone TO user_timezone_old";
! //				$sql[] = "ALTER TABLE " . USERS_TABLE . " 
! //					ADD COLUMN user_timezone decimal(4)";
  				break;
  			case 'mssql':
--- 367,374 ----
  				break;
  			case 'postgresql':
! 				$sql[] = "ALTER TABLE " . USERS_TABLE . " 
! 					RENAME COLUMN user_timezone TO user_timezone_old";
! 				$sql[] = "ALTER TABLE " . USERS_TABLE . " 
! 					ADD COLUMN user_timezone decimal(4)";
  				break;
  			case 'mssql':
***************
*** 517,520 ****
--- 517,535 ----
  	case 'RC-4':
  	case '.0.0':
+ 		if ( SQL_LAYER == 'postgresql' )
+ 		{
+ 			$sql = "SELECT user_id, user_timezone_old 
+ 				FROM " . USERS_TABLE;
+ 			_sql($sql, $errored, $error_ary);
+ 
+ 			while ( $row = $db->sql_fetchrow($result) )
+ 			{
+ 				$sql = "UPDATE " . USERS_TABLE . " 
+ 					SET user_timezone = " . $row['user_timezone_old'] . " 
+ 					WHERE user_id = " . $row['user_id'];
+ 				_sql($sql, $errored, $error_ary);
+ 			}			
+ 		}
+ 
  		$sql = "SELECT topic_id, topic_moved_id 
  			FROM " . TOPICS_TABLE . "