[dustyb]

Originally Posted by tgmorris

Here it is. It will likely need tweaking for each individual as I tuned it to handle how I did smilies on my site. The vb3 sections could probably be used for any other system as well.

Outstanding! I've got an ancient installation of WebBBS that I'm converting to VB3. About the only thing I needed to adjust was the table names in all the SQL. I have the vb prefix in front of everything.

Some comments... follow the instructions VERY carefully in regard to the sequences. You have to convert in order, you can't bounce around. It's probably easiest to copy your webbs files from each forum out of their respective bbs(x) directories and into a single location and run the script. One forum at a time.

One extremely important point. If you have multiple webbbs forums, which I presume most people do, you will need to clear the originalid and previousid bookmark fields from the vbulletin post table after each forum conversion, (using an update query). This is not documented in the instructions. The script relies on these "bookmark" fields and if you don't clear out the previous forum's data from these fields, your threads will be hopelessly jumbled.

Also, given the above two points on multiple forum conversions, it follows that you need to turn off your webbbs forums and do the conversions all at once. It would be extremely difficult to come back and update a multiple forum conversion process as you'd have lost your original/previous references for all but the last forum you converted. It really is a one shot deal.

Again, great work. This script saved me who knows how many hours and probably a fair chunk of $$$ in consulting expense. Many thanks!