Cloud-Warrior
06-26-2005, 10:00 PM
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.
--
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.
--