Web Wiz Forums - SQL forum - Transfer all user and pass..

Print Page | Close Window

SQL forum - Transfer all user and pass..

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3892
Printed Date: 01 April 2026 at 11:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL forum - Transfer all user and pass..

Posted By: BrownGhost
Subject: SQL forum - Transfer all user and pass..
Date Posted: 27 June 2003 at 9:15pm

hi, wel i have a website, whit 3335 in my website MS SQL database..

Now im adding Webwizz forum to my page.
And we are gona make it so when a user makes ann accound om my website it also creats the user in forum. so users dont have to login on both..

My qustion is, how do i transfer all the user and pass that is already on my website to webwizz forum???

Its the encryption thing im worryid about..
i cant just export and import them to forum user tabel :((

How can i do this so it will work ??

Thx BG

Replies:

Posted By: ljamal
Date Posted: 27 June 2003 at 9:33pm

See http://forums.webwiz.net/forum_posts.asp?TID=1681 - http://forums.webwiz.net/forum_posts.asp?TID=1681

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: BrownGhost
Date Posted: 28 June 2003 at 4:11am

yes i already saw that...

But this is version 701.. and passwords are incryptete.
and im taking about addind all the 3300 users usernames and passwords that i already have on my website..

i think we can figure out how to make my site duplicate the register process.. lige when some one registers on my site. a script will automatikly do the same on forum...

BUT as for importing all usernames and passwords.. i dont know how we can do that.. that is what im asking...

Remember its version 701 . and that has encryptet all passwords..

How do we do this??

Posted By: ljamal
Date Posted: 28 June 2003 at 8:44am

I'm using version 7.01 and the method that I mentioned in the thread. I bypass the forum's registration completely and use my web site's login to create the cookie needed for itself and the forum.

I would caution against using any other method simply because you will be storing information twice which means the information has to updated in two separate places when changed (such as passwords). If at any point something fails then the data will not be in sync and that user will not be able to use the forum and/or your web site.

There is no definitive way to integrate your member database with the forum author table, but no matter what method you use you will have to become familiar which the forum registration, login, profile update, and cookie code.

As for the forum password encyption it can be removed by altering the encryption function. It can be implemented by importing all the users and passwords (as plain text) into the forum database and then creating an ASP page that updates the database passwords with password after running it through the encryption function.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: BrownGhost
Date Posted: 28 June 2003 at 9:23am

Cool.. i will see if we will remove the encryption or use the metod you describe here...

Thx A lot :))