Changeset 640

Timestamp:

01/22/2007 06:47:52 PM (19 years ago)

Author:

mdawaffe

Message:

upgrade script for topic_resolved. Fixes #496

Location:

trunk/bb-admin

Files:

• upgrade-schema.php (modified) (1 diff)
• upgrade.php (modified) (3 diffs)

trunk/bb-admin/upgrade-schema.php

@@ -38 +38 @@
   forum_id int(10) NOT NULL default '1',
   topic_status tinyint(1) NOT NULL default '0',
-  topic_resolved varchar(15) NOT NULL default 'no',
   topic_open tinyint(1) NOT NULL default '1',
   topic_last_post_id bigint(20) NOT NULL default '1',

trunk/bb-admin/upgrade.php

@@ -125 +125 @@
 upgrade_170(); // Escaping in usermeta
 upgrade_180(); // Delete users for real
+upgrade_190(); // Move topic_resolved to topicmeta
 
 //alter user table column names
@@ -261 +262 @@
 function upgrade_180() {
     if ( ( $dbv = bb_get_option( 'bb_db_version' ) ) && $dbv >= 559 )
-                return;
+        return;
 
     global $bbdb;
@@ -271 +272 @@
 }
 
+function upgrade_190() {
+    if ( ( $dbv = bb_get_option( 'bb_db_version' ) ) && $dbv >= 630 )
+        return;
+
+    global $bbdb;
+    $topics = (array) $bbdb->get_results("SELECT topic_id, topic_resolved FROM $bbdb->topics" );
+    foreach ( $topics  as $topic )
+        bb_update_topicmeta( $topic->topic_id, 'topic_resolved', $topic->topic_resolved );
+    unset($topics,$topic);
+
+    $bbdb->query("ALTER TABLE $bbdb->topics DROP topic_resolved");
+
+    bb_update_option( 'bb_db_version', 630 );
+
+    echo "Done converting topic_resolved.<br />";
+}
+
 function deslash($content) {
     // Note: \\\ inside a regex denotes a single backslash.