vBulletin v5.x Forum Import Template

[netweb]

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

[netweb]

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]

Fix copy pasta error

[netweb]

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

[netweb]

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

[johnjamesjacoby]

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.

[xenous]

I have been testing this and it works fine except BB code issues and reply to post issues. for reply to post 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

[netweb]

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

[netweb]

Related #2603

[netweb]

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

[netweb]

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