vBJournal to WordPress MU Conversion

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.
--

[Cloud-Warrior]

I think I've put this in the wrong place - sorry

[Reeve of shinra]

No user intergration huh? Thats the tough part that would be great to have.

if there is no link with vBulletin, it does not have to be released here...

this is not a forum for Wordpress development..,
(even if i work on the project myself!)

[Ghostsuit]

Originally Posted by nexialys

if there is no link with vBulletin, it does not have to be released here...

this is not a forum for Wordpress development..,
(even if i work on the project myself!)

Negative as usual. It's a shame that you can't be just be a tiny bit positive when I guys trying to help people who have a Journal hack from here which isn't working properly.

[Cloud-Warrior]

Well, I hope this helps those who are 'stranded' but agree that this is the wrong place too. Maybe this can be moved to a non-modifications forum on the site?

[Marco van Herwaarden]

Moved here since we don't really have a good place for it, and this section was so empty.

[Cloud-Warrior]

I think the next version of WPMU will have a single table for users, at that stage some integration may be easier (either a daily import, or a direct connection).

[AN-net]

not to intrude but i actually have one done but i want KirbyDE to check over it to make sure i caught everything

[Qwest]

Originally Posted by AN-net

not to intrude but i actually have one done but i want KirbyDE to check over it to make sure i caught everything

Are you gonna start a new vbjournal thread or reopen the old one?