Skip to:
Content

bbPress.org

Opened 6 years ago

Last modified 5 years ago

#2440 new enhancement

vBulletin v5.x Forum Import Template

Reported by: netweb Owned by: netweb
Milestone: Future Release Priority: normal
Severity: normal Version: trunk
Component: API - Importers Keywords: 2nd-opinion needs-testing
Cc:

Description

Introduce Forum Importer template for use with importing from vBulletin v5.x
​​​​​​http://codex.bbpress.org/import-forums/vbulletin

Working: Categories, Forums, Topics, Topic Tags, Replies, Comments & Users
Partial (needs testing): Custom BBCode for Topic & Reply Content
Not Working Yet: User Passwords

NOTES: Due to the structure of vBulletin v5.x database schema an additional importer depth 'comment' was added to the existing 'forum', 'topic', 'reply' & 'user' sections in converter.php to import 'comments' to 'replies' (hierarchal replies)

Attached is vBulletin5.php and converter-vb5.php

Due to complexity of the SQL statements in the 'reply' & 'comment' sections of vBulletin5.php your vBulletin database must not have a table prefix. Performance of this converter will also need to be taken into account when using this importer.

Huge hattip to Nick Croft (@Nick_theGeek) from copyblogger.com

Attachments (4)

vBulletin5.php (22.9 KB) - added by netweb 6 years ago.
converter-vb5.php (45.2 KB) - added by netweb 6 years ago.
Fix copy pasta error
2440-converter.php.diff (3.9 KB) - added by netweb 6 years ago.
2440-converter.php.2.diff (3.6 KB) - added by netweb 5 years ago.

Download all attachments as: .zip

Change History (13)

@netweb
6 years ago

#1 @netweb
6 years ago

I'm extremely hesitant to include vBulletin5.php or the changes included in converter-vb5.php into bbPress core at this stage, the updates to the converter will need some testing to ensure it does not break any of the other importers, it shouldn't break anything but a great deal of testing with existing and newly introduced importers is required first.

If the changes in converter-vb5.php will be included in bbPress core a seperate ticket will be needed.

Thoughts? Discussion? Comments? Add them below :)

@netweb
6 years ago

Fix copy pasta error

#2 @netweb
6 years ago

Attached 2440-converter.php.diff​ shows the diff between trunk\converter.php and the changes implemented in converter-vb5.php for those interested ;)

#3 @netweb
6 years ago

Instructions:

Upload via FTP vBulletin5.php to \wp-content\plugins\bbpress\includes\admin\converters

Rename converter-vb5.php to converter.php and overwrite the existing converter.php in \wp-content\plugins\bbpress\includes\admin

#4 @johnjamesjacoby
6 years ago

  • Milestone changed from Awaiting Review to Future Release

Let's move this to Future Release until you're more confident with the stability of these changes. Once you are, feel free to move this back into whatever milestone you see fit.

#5 @xenous
5 years ago

I have been testing this and it works fine except BB code issues and reply to post issues. for comment to replies (nested) I have ran the below SQL statement

$sql = "SELECT * FROM wp_postmeta WHERE `meta_key`='_bbp_vb5_reply_post_id'";
$results = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($results)){
	$newId = $row['post_id'];
	$oldID = $row['meta_value'];
	$update = "UPDATE wp_postmeta SET `meta_value` = '$newId' WHERE `meta_key`='_bbp_reply_to' AND `meta_value`='$oldID'";
	echo'<li>'.$update;
	mysql_query($update);
}

I am trying to fix BBCODE issues will post when done.
I will also try to implement comment fix in code :)
Great converter BTW

Last edited 5 years ago by xenous (previous) (diff)

#6 @netweb
5 years ago

In 2440-converter.php.2.diff​ refresh of 2440-converter.php.diff​ for /trunk

#7 @netweb
5 years ago

  • Milestone changed from Future Release to 2.6

Related #2603

#8 @netweb
5 years ago

  • Milestone changed from 2.6 to Future Release

Punting this back to 'Future Release' pending enhanced 'Join' statement support in converter.php

#9 @netweb
5 years ago

See r5527 for updated hierarchical/threaded replies import changes using _bbp_old_reply_to_id

Note: See TracTickets for help on using tickets.