Changeset 5530 for trunk/src/includes/admin/converter.php

Timestamp:

09/20/2014 06:06:08 AM (10 years ago)

Author:

netweb

Message:

Converter import user meta data improvements and fixes:

• Original 'old' user meta key is now defined using _bbp_old_user_id
• Fixes the "Purge Previous Import" optional removal of previously imported users when using the database sync_table.
• Updates all included importers with the above changes including the custom callback in e107v1.php

See #2650

File:

• trunk/src/includes/admin/converter.php (modified) (2 diffs)

trunk/src/includes/admin/converter.php

@@ -1241 +1241 @@
 
         if ( true === $this->sync_table ) {
-            $query = 'SELECT value_id FROM ' . $this->sync_table_name . ' INNER JOIN ' . $this->wpdb->users . ' ON(value_id = ID) WHERE meta_key = "_bbp_user_id" AND value_type = "user" LIMIT ' . $this->max_rows;
+            $query = 'SELECT value_id FROM ' . $this->sync_table_name . ' INNER JOIN ' . $this->wpdb->users . ' ON(value_id = ID) WHERE meta_key = "_bbp_old_user_id" AND value_type = "user" LIMIT ' . $this->max_rows;
         } else {
-            $query = 'SELECT user_id AS value_id FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_user_id" LIMIT ' . $this->max_rows;
+            $query = 'SELECT user_id AS value_id FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_old_user_id" LIMIT ' . $this->max_rows;
         }
 
@@ -1431 +1431 @@
         if ( !isset( $this->map_userid[$field] ) ) {
             if ( !empty( $this->sync_table ) ) {
-                $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_user_id" AND meta_value = "%s" LIMIT 1', $field ) );
+                $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_old_user_id" AND meta_value = "%s" LIMIT 1', $field ) );
             } else {
-                $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT user_id AS value_id FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_user_id" AND meta_value = "%s" LIMIT 1', $field ) );
+                $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT user_id AS value_id FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_old_user_id" AND meta_value = "%s" LIMIT 1', $field ) );
             }