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

Timestamp:

Nov 19, 2013, 9:47:43 PM (11 years ago)

Author:

toemon

Message:

MySQL5.5　TYPE=MyISAM エラー　バグ修正　fix #429

File:

• trunk/xpressme_integration_kit/include/onupdate.php (modified) (14 diffs)

trunk/xpressme_integration_kit/include/onupdate.php

@@ -23 +23 @@
         $db =& XoopsDatabaseFactory::getDatabaseConnection() ;
         $mid = $module->getVar('mid') ;
-        
+
 
 
@@ -39 +39 @@
         }
 
-//Site_url and home of an optional table are repaired. 
+//Site_url and home of an optional table are repaired.
         $site_url= XOOPS_URL."/modules/".$mydirname;
         xpress_put_siteurl($mydirname,$site_url);
@@ -61 +61 @@
         $t_mess = xpress_clean_templates_file($mydirname,$mod_version);
         $msgs = array_merge($msgs,$t_mess);
-        
+
         $t_mess = xpress_templates_make($mid,$mydirname);
         $msgs = array_merge($msgs,$t_mess);
 
-// The activation processing of the XPressME plugin is omitted. 
+// The activation processing of the XPressME plugin is omitted.
 // Because the XPressME plugin is done with wp-config in activation
 
@@ -73 +73 @@
 //              $msgs[] = 'The xpressme plug-in was activated.';
 //      }
-        
+
         return true ;
 }
@@ -110 +110 @@
 
                 $sql = "SELECT option_value FROM $option_table WHERE option_name = '" . $option_name . "'";
-                
+
                 $result =  $xoopsDB->query($sql, 0, 0);
                 if ($xoopsDB->getRowsNum($result)  > 0){
@@ -163 +163 @@
         }
 
-        switch ( $xoops_block_check->get_op() ) 
+        switch ( $xoops_block_check->get_op() )
         {
                 case "remove_block":
@@ -194 +194 @@
                 post_views bigint(20) unsigned NOT NULL default '0',
                 KEY post_id (post_id)
-                ) TYPE=MyISAM";
+                ) ENGINE=MyISAM";
                 $db->queryF( $queries ) ;
                 $msgs[] = "$views_table table of XPressME was made.";
@@ -203 +203 @@
                         $msgs[] = "$views_table  ADD blog_id .";
                 }
-                
+
                 // The table is repaired.
                 $non_blogid_sql ="SELECT * FROM $views_table WHERE blog_id IS NULL OR blog_id < 1";
@@ -222 +222 @@
                 }
         }
-        
+
         $d3forum_link = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_d3forum_link' ;
         if (! enhanced_table_check($mydirname,'d3forum_link')){
@@ -232 +232 @@
                         blog_id bigint(20) unsigned NOT NULL default '0',
                         KEY post_id (post_id)
-                        )TYPE=MyISAM";
+                        )ENGINE=MyISAM";
                 $db->queryF( $queries ) ;
                 $msgs[] = "$d3forum_link table of XPressME was made.";
@@ -265 +265 @@
                         login_all smallint(5) unsigned NOT NULL default '0' ,
                         KEY groupid (groupid)
-                        )TYPE=MyISAM";
+                        )ENGINE=MyISAM";
                 $db->queryF( $queries ) ;
                 $sql = "INSERT INTO $group_role (groupid, role) VALUES (1, 'administrator')";
@@ -280 +280 @@
                 $db->queryF( $update_sql ) ;
         }
-        
+
         if (! enhanced_table_check($mydirname,'notify_reserve')){
                 $notify_reserve = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_notify_reserve' ;
@@ -294 +294 @@
                         omit_user_id varchar(20) NOT NULL default '' ,
                         KEY notify_reserve_id (notify_reserve_id)
-                        )TYPE=MyISAM";
+                        )ENGINE=MyISAM";
                 $db->queryF( $queries ) ;
                 $msgs[] = "$notify_reserve table of XPressME was made.";
@@ -305 +305 @@
 function enhanced_table_check($mydirname,$table_name){
                 global $xoopsModule;
-                
+
                 $xoopsDB =& XoopsDatabaseFactory::getDatabaseConnection();
                 $xpress_prefix = $xoopsDB->prefix(preg_replace('/wordpress/','wp',$mydirname) . '_');