My search terms have returned no listings for my question so here it goes.
I have ubb classic 6.72 which I would like to import the forum structure, member files( at least name,email,password) and forum topics to Snitz using the access database.
I found in the Snitz forum "setup tools" a conversion script but it is for a older version 5 which has a different file structure but I tried anyway with no success.
UBB allows me to export to multiple txt files all the data but my first hurdle is the member password. UBB does not encript the password. Is there some way that I can import all the members and encript the password before or after I import them to the Forum_Members table?
You may need to write your own script to do it. Snitz uses the SHA256 encryption algorythm, and its found in inc_sha256.asp. You'd have to pass the unencrypted password through it as you were pulling from one database to the other.
Okay, Writing a script is way above my head. What if I were to sign in as a guest accountand Guest password, then look in the Password field and append that number to all registered members. Then I could email them all with a password to login with and change their password to what they want? I also during the import would turn off the autonumber field then after turn it back on with a starting number greater than my list. Is there a issue with any of this?
Topic Locked
Posted - 24 June 2007 : 16:58:30
