WebBBS to vBulletin 2.2.x Conversion Script

Hello all!

After much painstaking oogling at php code, I've created a conversion script to convert WebBBS messages to vBulletin. I created this a bit ago, but feel that it might be of use to someone out there so I thought I'd share it.

This was written to convert from a very old version of WebBBS (circa 1998), but has since been modified to work with 5.0. It should be a good start for anyone out there wanting to do this.

All of the instructions are included in the file as comments. Read them carefully! When finished, don't forget to update counters and the search table.

Anticipating vB3 like you wouldn't believe,
Paul

Update:

• Now corrects for GMT offset for older WebBBS versions (the newest versions use unix timestamps, so this isn't needed)
• Situation where extra carriage returns were being added should now be resolved.
• Link URLs and Images are now processed. URLs/Images in the actual message body (assuming you had HTML enabled on WebBBS) are not processed. Anyone willing to add this functionality, let me know.
• Situation where certain date strings would offset the timestamp incorrectly has now been corrected.
• Connection to the database is now handled much more efficiently.

NOTE: By downloading this, you agree that you will not send me countless PMs/e-mails asking for help with it. If you have a question, post it on this thread. I am by no means an expert. This is my first script in php. It was written to fill my need and may or may not fill yours. I do not have the time nor resources to provide support for it.

Also, as with all hacks on this site, this script is for registered vBulletin users ONLY. You are not permitted to distribute this script to anyone, under any circumstances.

[voclain]

Paul:

LOOKS like it's doing the same thing:

Script Version 1.045t-WebBBS5.0x
WebBBS-to-vBulletin 2.2 Message Converter

Connected successfullyQuery failed inserting post

AGAIN, your help is GREATLY APPRECIATED!!!

Yours,

Kirk Voclain

[voclain]

IT'S is also interesting to note that it does the first one??? When I go to the Data Base, it assignes the very first file (in this case number 157) to the data base. EVERYTHING is correct!! The threadid, title, lastpost, forumid, polit, open, replycount, postusername, postuserid, everything, even the originalid thing you had me add has the proper number in it: 157.

But when I go back to the forum, it does not show up???

NOW is it something to do with VB that is causing this???

AS I SAID, it's not 100% hooded up, I'm in the learning stages and getting it ready to swith the DNS stage.

I'm hoping I can just convert??? And then switch??? NOT have to switch and open my site up with an empty board???

ANYWAY again, THANKS FOR ALL OF YOUR HELP!! IT IS GREATLY APPRECIATED.

Kirk

[Paul]

I was just about to ask if you remembered to insert the originalid field. I actually messed up in the directions. You need to add the originalid field into both the thread and post tables. I've updated the instructions. Try the script attached after adding the additional originalid field to the post table so that you have an originalid in both post and thread.

[Paul]

Originally posted by voclain
IT'S is also interesting to note that it does the first one??? When I go to the Data Base, it assignes the very first file (in this case number 157) to the data base. EVERYTHING is correct!! The threadid, title, lastpost, forumid, polit, open, replycount, postusername, postuserid, everything, even the originalid thing you had me add has the proper number in it: 157.

It might be a good idea to delete that entry. Also, after you've run the script, log into vBulletin's Admin CP and update all of the counters.

[Paul]

I also noticed on your site a lot of posts seem to have pictures attached. I didn't account for pictures or links in this conversion script, simply because there weren't that many on my posts. I'll try to add it into the script now.

[voclain]

Did it do something????

HERE is the message I got when I ran the latest thing you sent me:

Script Version 1.05t-WebBBS5.0x
WebBBS-to-vBulletin 2.2 Message Converter

Connected successfullyQuery failed getting counts for forum: SELECT `replycount`,`threadcount` FROM `forum` WHERE forumid =

----------------

YOU HAVE NO IDEA how much I appreciate this!! I don't suppose you need a professional photographer for something??? OR an Adobe Photoshop GURU?? I am both and I would LOVE to repay the favor!!

Yours,

Kirk Voclain

[voclain]

Paul:

AS INFO, it did not work. I did an update of all counters in the admin. NOW when I go to the main board, it says there are 2 messages (used to only say one) but when you click on it, it still only shows ONE message.

So we are getting closer??? But it is still not working. PLUS it still only does ONE message, not all of them as intructed.

Yours,

Kirk

[Paul]

Originally posted by voclain
Did it do something????

HERE is the message I got when I ran the latest thing you sent me:

Script Version 1.05t-WebBBS5.0x
WebBBS-to-vBulletin 2.2 Message Converter

Connected successfullyQuery failed getting counts for forum: SELECT `replycount`,`threadcount` FROM `forum` WHERE forumid =

Alright.. we're getting there I suppose Thanks for the patience with this thing, as I've not tested it at all since I used it to convert 40,000 messages

Try the attached file. I added support for links and images since they seem to be used a lot in your forum. Hopefully, this will fix that error you got and not create any new ones!

[voclain]

WE are getting close!!!

HERE is the latest message, IT LOOKS different???

Parse error: parse error in /home/virtual/site1/fst/var/www/html/cmc/bbs0/webbbs.php on line 285

LET ME KNOW...Thank you so much!!

Kirk

[Paul]

WHOOPS!

Forgot a silly little parenthesis.

Try the attached version.