Changeset 665

Timestamp:

Nov 22, 2010, 9:53:31 AM (14 years ago)

Author:

toemon

Message:

db_prefix変更時、usermeta修正対象テーブルが見つからないときのバグ修正 Fixes#378

File:

• trunk/xpressme_integration_kit/wp-content/plugins/xpressme/include/user_sync_xoops.php (modified) (2 diffs)

trunk/xpressme_integration_kit/wp-content/plugins/xpressme/include/user_sync_xoops.php

@@ -390 +390 @@
         $sql = "SELECT * FROM $db_xpress_usermeta WHERE meta_key LIKE '%_" . $wp_prefix_only . "%'" ;
         $user_metas = $xoops_db->get_results($sql);
-        foreach($user_metas as $user_meta){
-                if (strpos($user_meta->meta_key,$user_meta_prefix) === false) {
-                        $new_meta_key = '';
-                        if (strpos($user_meta->meta_key,$wp_prefix_only.'user_level'))
-                                $new_meta_key = $user_meta_prefix . 'user_level';
-                        if (strpos($user_meta->meta_key,$wp_prefix_only.'capabilities'))
-                                $new_meta_key = $user_meta_prefix . 'capabilities';
-                        if (strpos($user_meta->meta_key,$wp_prefix_only.'autosave_draft_ids'))
-                                $new_meta_key = $user_meta_prefix . 'autosave_draft_ids';
-                        if (strpos($user_meta->meta_key,$wp_prefix_only.'usersettings')){
-                                if (strpos($user_meta->meta_key,$wp_prefix_only.'usersettingstime'))
-                                        $new_meta_key = $user_meta_prefix . 'usersettingstime';
-                                else
-                                        $new_meta_key = $user_meta_prefix . 'usersettings';
-                        }
-                        if (!empty($new_meta_key)){
-                                $repair_sql  =  "UPDATE $db_xpress_usermeta ";
-                                $repair_sql .=  'SET ';
-                                $repair_sql .=  "meta_key = '$new_meta_key' ";
-                                $repair_sql .=  "WHERE (umeta_id = $user_meta->umeta_id )";
-                                $xoops_db->query($repair_sql);
+        if(!empty($user_metas)){
+                foreach($user_metas as $user_meta){
+                        if (strpos($user_meta->meta_key,$user_meta_prefix) === false) {
+                                $new_meta_key = '';
+                                if (strpos($user_meta->meta_key,$wp_prefix_only.'user_level'))
+                                        $new_meta_key = $user_meta_prefix . 'user_level';
+                                if (strpos($user_meta->meta_key,$wp_prefix_only.'capabilities'))
+                                        $new_meta_key = $user_meta_prefix . 'capabilities';
+                                if (strpos($user_meta->meta_key,$wp_prefix_only.'autosave_draft_ids'))
+                                        $new_meta_key = $user_meta_prefix . 'autosave_draft_ids';
+                                if (strpos($user_meta->meta_key,$wp_prefix_only.'usersettings')){
+                                        if (strpos($user_meta->meta_key,$wp_prefix_only.'usersettingstime'))
+                                                $new_meta_key = $user_meta_prefix . 'usersettingstime';
+                                        else
+                                                $new_meta_key = $user_meta_prefix . 'usersettings';
+                                }
+                                if (!empty($new_meta_key)){
+                                        $repair_sql  =  "UPDATE $db_xpress_usermeta ";
+                                        $repair_sql .=  'SET ';
+                                        $repair_sql .=  "meta_key = '$new_meta_key' ";
+                                        $repair_sql .=  "WHERE (umeta_id = $user_meta->umeta_id )";
+                                        $xoops_db->query($repair_sql);
+                                }
                         }
                 }
@@ -420 +422 @@
         $prefix = get_wp_prefix();
         $option_tables = get_table_list($prefix,'options');
-        foreach( $option_tables as $option_table){
-                $mid_prefix = get_multi_mid_prefix($prefix,'options' , $option_table);
-
-                $new_option_name = $prefix .$mid_prefix . 'user_roles';
-                $sql = "SELECT option_id , option_name FROM $option_table WHERE option_name LIKE '%_user_roles'" ;
-                $option= $xoops_db->get_row($sql);
-                if ($option->option_name != $new_option_name){
-                        $repair_sql  =  "UPDATE $db_wp_option ";
-                        $repair_sql .=  'SET ';
-                        $repair_sql .=  "option_name = '$new_option_name' ";
-                        $repair_sql .=  "WHERE (option_id = $option->option_id )";
-                        $xoops_db->query($repair_sql);
+        if(!empty($option_tables)){
+                foreach( $option_tables as $option_table){
+                        $mid_prefix = get_multi_mid_prefix($prefix,'options' , $option_table);
+
+                        $new_option_name = $prefix .$mid_prefix . 'user_roles';
+                        $sql = "SELECT option_id , option_name FROM $option_table WHERE option_name LIKE '%_user_roles'" ;
+                        $option= $xoops_db->get_row($sql);
+                        if ($option->option_name != $new_option_name){
+                                $repair_sql  =  "UPDATE $db_wp_option ";
+                                $repair_sql .=  'SET ';
+                                $repair_sql .=  "option_name = '$new_option_name' ";
+                                $repair_sql .=  "WHERE (option_id = $option->option_id )";
+                                $xoops_db->query($repair_sql);
+                        }
                 }
         }