Changeset 5795

Timestamp:

05/28/2015 04:40:08 AM (10 years ago)

Author:

netweb

Message:

Importers: Update phpbB importer to support phpBB 3.1.x database schema changes

• Note: Importing from phpBB 3.0.x is no longer supported, please update to phpBB 3.1.x before importing

Props netweb. Fixes #2716

File:

• trunk/src/includes/admin/converters/phpBB.php (modified) (12 diffs)

trunk/src/includes/admin/converters/phpBB.php

@@ -45 +45 @@
         $this->field_map[] = array(
             'from_tablename' => 'forums',
-            'from_fieldname' => 'forum_topics',
+            'from_fieldname' => 'forum_topics_approved',
             'to_type'        => 'forum',
             'to_fieldname'   => '_bbp_topic_count'
@@ -53 +53 @@
         $this->field_map[] = array(
             'from_tablename' => 'forums',
-            'from_fieldname' => 'forum_posts',
+            'from_fieldname' => 'forum_posts_approved',
             'to_type'        => 'forum',
             'to_fieldname'   => '_bbp_reply_count'
@@ -161 +161 @@
         $this->field_map[] = array(
             'from_tablename'  => 'topics',
-            'from_fieldname'  => 'topic_replies',
+            'from_fieldname'  => 'topic_posts_approved',
             'to_type'         => 'topic',
             'to_fieldname'    => '_bbp_reply_count',
@@ -170 +170 @@
         $this->field_map[] = array(
             'from_tablename'  => 'topics',
-            'from_fieldname'  => 'topic_replies_real',
+            'from_fieldname'  => 'topic_posts_approved',
             'to_type'         => 'topic',
             'to_fieldname'    => '_bbp_total_reply_count',
@@ -449 +449 @@
             'from_tablename'  => 'users',
             'from_fieldname'  => 'user_id',
-            'from_expression' => 'WHERE user_type !=2',
             'to_type'         => 'user',
             'to_fieldname'    => '_bbp_old_user_id'
@@ -496 +495 @@
         // User homepage.
         $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_website',
-            'to_type'        => 'user',
-            'to_fieldname'   => 'user_url'
+            'from_tablename'  => 'profile_fields_data',
+            'from_fieldname'  => 'pf_phpbb_website',
+            'join_tablename'  => 'users',
+            'join_type'       => 'LEFT',
+            'join_expression' => 'USING (user_id) WHERE users.user_type !=2',
+            'to_type'         => 'user',
+            'to_fieldname'    => 'user_url'
         );
 
@@ -511 +513 @@
         );
 
-        // User AIM (Stored in usermeta)
-        $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_aim',
+        // User AOL/AIM (Stored in usermeta)
+        $this->field_map[] = array(
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_aol',
             'to_type'        => 'user',
             'to_fieldname'   => 'aim'
@@ -521 +523 @@
         // User Yahoo (Stored in usermeta)
         $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_yim',
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_yahoo',
             'to_type'        => 'user',
             'to_fieldname'   => 'yim'
@@ -529 +531 @@
         // Store ICQ (Stored in usermeta)
         $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_icq',
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_icq',
             'to_type'        => 'user',
             'to_fieldname'   => '_bbp_phpbb_user_icq'
         );
 
-        // Store MSN (Stored in usermeta)
-        $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_msnm',
+        // Store MSN/WLM (Stored in usermeta)
+        $this->field_map[] = array(
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_wlm',
             'to_type'        => 'user',
             'to_fieldname'   => '_bbp_phpbb_user_msnm'
+        );
+
+        // Store Facebook (Stored in usermeta)
+        $this->field_map[] = array(
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_facebook',
+            'to_type'        => 'user',
+            'to_fieldname'   => '_bbp_phpbb_user_facebook'
+        );
+
+        // Store Google+ (Stored in usermeta)
+        $this->field_map[] = array(
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_googleplus',
+            'to_type'        => 'user',
+            'to_fieldname'   => '_bbp_phpbb_user_googleplus'
+        );
+
+        // Store Skype (Stored in usermeta)
+        $this->field_map[] = array(
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_skype',
+            'to_type'        => 'user',
+            'to_fieldname'   => '_bbp_phpbb_user_skype'
+        );
+
+        // Store Twitter (Stored in usermeta)
+        $this->field_map[] = array(
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_twitter',
+            'to_type'        => 'user',
+            'to_fieldname'   => '_bbp_phpbb_user_twitter'
+        );
+
+        // Store Youtube (Stored in usermeta)
+        $this->field_map[] = array(
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_youtube',
+            'to_type'        => 'user',
+            'to_fieldname'   => '_bbp_phpbb_user_youtube'
         );
 
@@ -553 +595 @@
         // Store Occupation (Stored in usermeta)
         $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_occ',
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_occupation',
             'to_type'        => 'user',
             'to_fieldname'   => '_bbp_phpbb_user_occ'
@@ -561 +603 @@
         // Store Interests (Stored in usermeta)
         $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_interests',
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_interests',
             'to_type'        => 'user',
             'to_fieldname'   => '_bbp_phpbb_user_interests'
@@ -578 +620 @@
         // Store Location (Stored in usermeta)
         $this->field_map[] = array(
-            'from_tablename' => 'users',
-            'from_fieldname' => 'user_from',
+            'from_tablename' => 'profile_fields_data',
+            'from_fieldname' => 'pf_phpbb_location',
             'to_type'        => 'user',
             'to_fieldname'   => '_bbp_phpbb_user_from'