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.

[Paul]

You've got me sitting on the edge of my seat... any luck? I'll be away from the computer until late tonight (four-five hours) so I won't be able to help with any other problems until then. Let me know if it was successful for you. I've updated the original post on this thread with the latest version. You'll note I've added the $useunixtime variable in case there's anyone out there that needs the date processing I did with the old version I had. For 5.0, just leave it set to "1".

Paul

[voclain]

......

Well sorry to tell you, the contractions are still there.

NEW PROBLEM:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/virtual/site1/fst/var/www/html/cmc/bbs0/webbbs.php on line 310


KEEP ME POSTED!!

Kirk

[Paul]

I always forget the little things This time it was two periods

Here's the updated file. Please work!

[voclain]

GETTING CLOSER!!! This time it says this:

Script Version 1.09t-WebBBS
WebBBS-to-vBulletin 2.2 Message Converter

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

THANKS AGAIN!!

Kirk

[Paul]

Keep pushing.

Edit: Hah. I uploaded the same file as last time Try again!

[Paul]

What a waste of a perfectly good thread

[voclain]

OK this looks promising!!! But still not working!!! I really would like to give birth to a boy or even a girl!!!

HERE's what it says:

Script Version 1.10t-WebBBS
WebBBS-to-vBulletin 2.2 Message Converter

Connected successfully

Warning: Unable to jump to row 0 on MySQL result index 2 in /home/virtual/site1/fst/var/www/html/cmc/bbs0/webbbs.php on line 146

Warning: Unable to jump to row 0 on MySQL result index 2 in /home/virtual/site1/fst/var/www/html/cmc/bbs0/webbbs.php on line 147
Query failed updating forum counts: UPDATE forum SET replycount=, threadcount=, lastpost=-1, lastposter='Ralph Tomaccio' WHERE forumid = ''

Where are you from??? I'm going to owe you some family portraits or something when this is all over!!

Thank you so much!!!

Kirk Voclain

[Paul]

It's a girl:

[voclain]

IT's a girl??? But I don't think it human yet. But it definately has arms and legs!!!

OK, First here is the results of what happened, it's long, but here goes:

Script Version 1.11r-WebBBS
WebBBS-to-vBulletin 2.2 Message Converter

Connected successfully
Processed 157
Connected successfully
Processed 158
Connected successfully
Query failed inserting post: INSERT INTO `post` (`postid`, `threadid`, `username`, `userid`, `title`, `dateline`, `attachmentid`, `pagetext`, `allowsmilie`, `showsignature`, `ipaddress`, `iconid`, `visible`, `edituserid`, `editdate`, `originalid`) VALUES ('', '17', 'Rick McDaniel', '0', '4x5 view camera.', '-1', '0', 'You need the movements to keep the camera out of the reflections. You can do it as you suggested, if you do it well, but then the volume of shots you need to do it on, is significant, so that isn\'t really the best way. If you only had a handful to do, that might be a different story. 1. Dark gray paper 2. I would use a diffused spot, so the contrast reflected is reproducible. 3. Probably wouldn\'t use that technique. Since I don\'t Photoshop extensively, uncertain what might be best. 4. Edge reflections should be adequate with diffusion panels skimming the frames, with gobos to control the spill, and a light on either side. 5. Use hanging methods that keep the frame as flat to the wall as possible. If you use a hanger on each side, placed with a level for precision alignment, and group them by size, then you should be able to keep them fairly flat. Use spacers under the bottom edge, to tilt the base of the frame back up for top to bottom level. Use Polaroid or digital for previewing, to be certain everything is correct, before final exposure. Good luck. L'allure Photographic ', '1', '0', 'IP_ADDRESS>165.95.207.169', '0', '1', '0', '0', '159')


--


NOW the good news is that this is the first time that when I go back to my messages board on VB that I actually see more than just the test messages on the home page.

HOWEVER, when I click on the board, NOTHING is there except the test message that I put there previously.

I did an "update counters" but it did not fix the problem.

Thanks, can I at least send your wife some flowers or something?????????

Kirk

[Paul]

This time it's a girl. Like it or not.

The ' in L'allure Photographic was what was messing it up. I had to rearrange some code, but this time it will work. That's part of the code I added to include image and link attachments from WebBBS.

I also noticed that the format used in WebBBS 5.0 for storing the IP address has changed and have altered the code to account for that as well.

Hopefully we've thought of everything so far!