Skip to:

Opened 11 years ago

Last modified 10 years ago

#2440 new enhancement

vBulletin v5.x Forum Import Template

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


Introduce Forum Importer template for use with importing from vBulletin v5.x

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

Attachments (4)

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

Download all attachments as: .zip

Change History (13)

11 years ago

#1 @netweb
11 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 :)

11 years ago

Fix copy pasta error

#2 @netweb
11 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
11 years ago


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
11 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
10 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'";

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 10 years ago by xenous (previous) (diff)

#6 @netweb
10 years ago

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

#7 @netweb
10 years ago

  • Milestone changed from Future Release to 2.6

Related #2603

#8 @netweb
10 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
10 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.