Changeset 485 for trunk

Timestamp:

Dec 11, 2009, 4:32:34 PM (15 years ago)

Author:

toemon

Message:

統計情報にno_name統計が表示されるバグ修正 Fixes#269

File:

• trunk/xpressme_integration_kit/include/general_functions.php (modified) (3 diffs)

trunk/xpressme_integration_kit/include/general_functions.php

@@ -126 +126 @@
                 $table_list = array();
                 $ret = array();
+                $pattern = $wp_prefix . $table_name . '|' . $wp_prefix . '[0-9]*_' . $table_name;
+
                 if (!empty($wp_prefix) && !empty($table_name)){
                         $sql = "SHOW TABLES LIKE '" . $wp_prefix  . '%' . $table_name . "'";
@@ -132 +134 @@
                                 if($result = $xoopsDB->queryF($sql)){
                                         while($row = $xoopsDB->fetchRow($result)){
-                                                $table_list[] = $row[0];
+                                                if(preg_match('/' . $pattern . '/' , $row[0])){
+                                                        $table_list[] = $row[0];
+                                                }
                                         }
                                 }
@@ -138 +142 @@
                                 $rows = $xoops_db->get_results($sql, ARRAY_N);
                                 foreach ($rows as $row){
-                                        $table_list[] = $row[0];
+                                        if(preg_match('/' . $pattern . '/' , $row[0])){
+                                                $table_list[] = $row[0];
+                                        }
                                 }
                         }