|
From: Paul S. O. <ps...@us...> - 2002-05-16 12:32:04
|
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 . "
|