Changeset 590 for trunk/xpressme_integration_kit/include/onupdate.php

Timestamp:

Apr 28, 2010, 4:20:08 PM (14 years ago)

Author:

toemon

Message:

D3Forumコメント統合のマルチブログ対応 Fixes#311

File:

• trunk/xpressme_integration_kit/include/onupdate.php (modified) (1 diff)

trunk/xpressme_integration_kit/include/onupdate.php

@@ -223 +223 @@
         }
         
+        $d3forum_link = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_d3forum_link' ;
         if (! enhanced_table_check($mydirname,'d3forum_link')){
-                $d3forum_link = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_d3forum_link' ;
                 $queries ="CREATE TABLE $d3forum_link (
                         comment_ID bigint(20) unsigned NOT NULL default '0',
                         post_id int(10) unsigned NOT NULL default '0' ,
                         wp_post_ID bigint(20) unsigned NOT NULL default '0',
+                        forum_id bigint(20) unsigned NOT NULL default '0',
+                        blog_id bigint(20) unsigned NOT NULL default '0',
                         KEY post_id (post_id)
                         )TYPE=MyISAM";
                 $db->queryF( $queries ) ;
                 $msgs[] = "$d3forum_link table of XPressME was made.";
+        } else {
+                if (!is_found_table_column($d3forum_link,'forum_id')){
+                        $queries ="ALTER TABLE $d3forum_link ADD forum_id bigint(20) unsigned NOT NULL default '0' AFTER wp_post_ID";
+                        $db->queryF( $queries ) ;
+                        $msgs[] = "$d3forum_link  ADD forum_id .";
+                        // The table is repaired.
+//                      $update_sql = "UPDATE $d3forum_link SET forum_id = 1 WHERE(forum_id IS NULL OR forum_id < 1)";
+//                      $db->queryF( $update_sql ) ;
+                }
+                if (!is_found_table_column($d3forum_link,'blog_id')){
+                        $queries ="ALTER TABLE $d3forum_link ADD blog_id bigint(20)  unsigned NOT NULL default '0' AFTER forum_id";
+                        $db->queryF( $queries ) ;
+                        $msgs[] = "$d3forum_link  ADD blog_id .";
+                        // The table is repaired.
+                        $update_sql = "UPDATE $d3forum_link SET blog_id = 1 WHERE(blog_id IS NULL OR blog_id < 1)";
+                        $db->queryF( $update_sql ) ;
+                }
         }