Changeset 5568

Timestamp:

11/22/2014 04:26:02 AM (11 years ago)

Author:

netweb

Message:

Xenforo 1.x importer: Fix regression introduced in r5349 where topics were imported a second time as part of the reply section import.

File:

• trunk/src/includes/admin/converters/XenForo.php (modified) (1 diff)

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

@@ -323 +323 @@
             'to_type'        => 'reply',
             'to_fieldname'   => '_bbp_old_reply_id'
+        );
+
+        // Join the 'thread' table to exclude topics from being imported as replies
+        $this->field_map[] = array(
+            'from_tablename'  => 'thread',
+            'from_fieldname'  => 'thread_id',
+            'join_tablename'  => 'post',
+            'join_type'       => 'LEFT',
+            'join_expression' => 'USING (thread_id) WHERE thread.first_post_id != post.post_id',
+            'to_type'         => 'reply'
         );