vBulletin LTS

vBJournal to WordPress MU Conversion
Mod Version: 1.00, by Cloud-Warrior

This is for advanced users only, and your mileage may vary.

With the demise of vBJournal recently, I wrote some pretty basic scripts to convert to WordPress MU. Since I just finished them about an hour ago, and I'm about to go on a month's holidays, there are bound to be some bugs. However, I have managed to convert around 100 journals from vBJournal to WordPress MU and so far it looks okay. I would advise that only those who are familiar with PHP and MySQL use these scripts.

I am attaching them to save other people time who may be thinking of doing something similar.

Note that users have to login to WPMU with a new account, details of which will be e-mailed to them using the e-mail address from their vBulletin account.

The procedure:

• Download and install WordPress MU STABLE from http://mu.wordpress.org/
• If you want to use the same database (not recommended) as vBulletin, you would skip the next two steps.
• Dump your user, journals, journal_entries, journal_comments tables from your vB database, e.g.:
  mysqldump -u vbusername -p vbulletin user > vbulletin_user.sql
  mysqldump -u vbusername -p vbulletin journals > vbulletin_journals.sql
  mysqldump -u vbusername -p vbulletin journal_entries > vbulletin_journal_entries.sql
  mysqldump -u vbusername -p vbulletin journal_comments > vbulletin_journal_comments.sql
• Import these tables into your WordPress MU database, e.g.
  mysql -u wpmuusername -p < vbulletin_journals.sql (and the same for user, journal_entries, journal_comments)
• Download the three script files here and copy to your wpmu/wp-inst directory.
• Edit the three script files, and change things like your_url (in wp-vbjusers.php), database, username, password, where_vbulletin_is, etc.
• From the command line (since it uses a HTTP POST to create each account, which can be slow if you have multiple accounts), in the wp-inst directory, do a php wp-vbjusers.php to create a blog for each user. Repeat this process for wp-vbjentries.php and wp-vbjcomments.php.

Good luck!

John.
--