Changeset 428 for branches/XPressMU/xpressme_integration_kit/include

Timestamp:

Oct 31, 2009, 11:36:52 PM (15 years ago)

Author:

toemon

Message:

WPMUで閲覧数が正常に機能しないバグ修正 Fixes #241

Location:

branches/XPressMU/xpressme_integration_kit/include

Files:

• oninstall.php (modified) (1 diff)
• onupdate.php (modified) (3 diffs)

branches/XPressMU/xpressme_integration_kit/include/oninstall.php

@@ -100 +100 @@
         }
         $views_queries ="CREATE TABLE $views_table (
+                blog_id bigint(20) unsigned NOT NULL default '0',
                 post_id bigint(20) unsigned NOT NULL default '0',
                 post_views bigint(20) unsigned NOT NULL default '0',

branches/XPressMU/xpressme_integration_kit/include/onupdate.php

@@ -175 +175 @@
         $msgs = array();
 
+        $views_table = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_views' ;
         if (! enhanced_table_check($mydirname,'views')){
-                $views_table = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_views' ;
                 $queries ="CREATE TABLE $views_table (
+                blog_id bigint(20) unsigned NOT NULL default '0',
                 post_id bigint(20) unsigned NOT NULL default '0',
                 post_views bigint(20) unsigned NOT NULL default '0',
@@ -184 +185 @@
                 $db->queryF( $queries ) ;
                 $msgs[] = "$views_table table of XPressME was made.";
+        } else {
+                if (!is_found_table_column($views_table,'blog_id')){
+                        $queries ="ALTER TABLE $views_table ADD blog_id bigint(20)  FIRST";
+                        $db->queryF( $queries ) ;
+                        $msgs[] = "$views_table  ADD blog_id .";
+                }
         }
         
@@ -261 +268 @@
 endif;
 
+if( ! function_exists( 'is_found_table_column' ) ) :
+function is_found_table_column($table,$column){
+                global $xoopsModule;
+                $xoopsDB =& Database::getInstance();
+
+                $sql = "DESCRIBE $table $column";
+                $res = $xoopsDB->queryF($sql, 0, 0);
+                if ($res === false){
+                        return false;
+                } else {
+                        if ($xoopsDB->getRowsNum($res)  > 0)
+                                return true;
+                        else
+                                return false;
+                }
+}
+endif;