SQL forum - Transfer all user and pass..

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BrownGhost Members Profile Find Members Posts Groupie Joined: 26 November 2002 Status: Offline Points: 193	Post Options Post Reply Quote BrownGhost Report Post Thanks(0) Quote Reply Topic: SQL forum - Transfer all user and pass.. 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

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply Posted: 27 June 2003 at 9:33pm
	See http://forums.webwiz.net/forum_posts.asp?TID=1681
	L. Jamal Walton L. Jamal Inc : Web/ Print Design and ASP Programming

BrownGhost Members Profile Find Members Posts Groupie Joined: 26 November 2002 Status: Offline Points: 193	Post Options Post Reply Quote BrownGhost Report Post Thanks(0) Quote Reply 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??

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply 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 L. Jamal Inc : Web/ Print Design and ASP Programming

BrownGhost Members Profile Find Members Posts Groupie Joined: 26 November 2002 Status: Offline Points: 193	Post Options Post Reply Quote BrownGhost Report Post Thanks(0) Quote Reply 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 :)) BG

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum