Upgrade 6->7 SQL edition

Hi there guys and gals.

I just have to comment on this issue.

If -boRg- don't have time to fix upgrades to existing users it is OK for me, cause I know he then uses valuable time coding new features and fixing bugs. (Or drink beer)

The making of SQL upgrades scripts should/could probably be done by ourself. The users of WWF.

That said....
I have been adding some of the newest changes to the v 7.01 .sql scripts initially posted by Str8Dog, but need someone to test if they are doing the _thing_ right.

So anyone interested in giving it a try? It follows the same procedure as the inital beta 4 scripts, but with one minor change. Creation of all the SP's are now done by one single script.

Run it in the SQL Query Analyzer in the numeric order.

Please test it and comment changes below as it is probably not 100% yet.

IMPORTANT:
DON'T DO THIS WITHOUT MAKING A BACKUP FIRST. We ran it on our servers without any hassle, but don't take any chances.

NOTES:
1.) Every user is placed in the _Newbie_ group and the Number of posts are also copied as well. This causes every user to _enter_ the right ladder group when he does his first posting after upgrade.

2.) The encryption .asp pages encrypts 100 password at a time, and its just to move back and click once more until you're done, even if the text tell you not to...

Thanks to Str8Dog for sharing his copyrighted material with all of us. He's my hero now....at least for some days to come...

PAYMENT
If someone feels that they wish to share some of their funding, please feel free to PM me, and I will tell you what to spend your money on. (besides donations to -boRg-) No point in spending money without getting something 'more' back - right....

Best regards - ronhof - admin MyWgi.com
http://www.mywgi.com (Username: ronhof)

The zipfile can be downloaded from:
http://www.mywgi.com/WWF_Upgrade_6_34_to_7_01.zip

Don't forget to PM me then, ok?

THANK YOU!

Aside from seemingly not converting the Private Messages, this modified set of scripts worked like a dream!

I made a backup of the 6.34 SQL database, but never needed it as the in-place upgrade worked beautifully!  For end users: remember to run the SQL files in the order listed by file/directory name, and then copy and run the two ASP files into the OLD 6.34 Admin directory *before* copying up the new 7.01 forum files.  (They might work after the fact, but why tempt fate?)  Also, remember to modify the SQL access file in the Admin directory of the new 7.01 forum and DELETE the SQL setup file from the root folder as that won't be necessary when using these upgrade scripts.

Thank you again! 

- James -