Changeset 414 for trunk/xpressme_integration_kit/include/general_functions.php

Timestamp:

Oct 21, 2009, 9:00:31 AM (15 years ago)

Author:

toemon

Message:

WordPressMUを使用したときシステム情報の統計情報で存在しないテーブルを参照してしまうバグを修正 Fixes #230

File:

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

trunk/xpressme_integration_kit/include/general_functions.php

@@ -119 +119 @@
 }
 
+// Get Multi Blog table list for WordPressMU 
+if (!function_exists('get_multi_table_list')){
+        function get_table_list($wp_prefix = '',$table_name = ''){
+                global $xoopsDB,$xoops_db;
+
+                $table_list = array();
+                $ret = array();
+                if (!empty($wp_prefix) && !empty($table_name)){
+                        $sql = "SHOW TABLES LIKE '" . $wp_prefix  . '%' . $table_name . "'";
+
+                        if (empty($xoops_db)) { // not load XPressME                    
+                                if($result = $xoopsDB->queryF($sql)){
+                                        while($row = $xoopsDB->fetchRow($result)){
+                                                $table_list[] = $row[0];
+                                        }
+                                }
+                        } else { // load XPressME or not Load XOOPS
+                                $table_list = $xoops_db->get_results($sql);
+                        }                       
+                }
+                return $table_list;
+        }
+}
+
+// Get Middle Prefix from Table name for WordPressMU 
+if (!function_exists('get_multi_mid_prefix')){
+        function get_multi_mid_prefix($wp_prefix = '',$table_name = '' , $full_table_name){
+                $pattern = '/' . $wp_prefix . '(.*)' . $table_name . '/';
+                preg_match($pattern,$full_table_name,$match);
+                return $match[1];
+        }
+}
+
 ?>