Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Users Changing Password

Quote Reply
Users Changing Password
Hello,

I imported all my links from Links 2.0 and now all of the link users have a username but no password. I would like to set the password in the database to their ID and email all of them telling them how to change their password to whatever they want. How can I do this?



Thanks

Shane
Quote Reply
Re: [shane1800] Users Changing Password In reply to
If the passwords are unencrypted you could simply issue an SQL command:



update prefix_Users set Password = Username



Then send an email to all your members. But, this leaves a big security hole, as anyone who knows a Username, knows how to log on with it.

You could write a short script to put a random string of characters into the password field, then send a message to your users telling them to request their password from the system. That is much more secure than doing it the other way.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] Users Changing Password In reply to
Thanks for the help pugdog, I went ahead and did that. Is there a sql command I can enter to make random passwords? I don't know how to make a script that would do it. Or has anymody made a mod so that users can change their passwords?



Thanks

Shane

Last edited by:

shane1800: Feb 17, 2002, 7:13 PM
Quote Reply
Re: [shane1800] Users Changing Password In reply to
Hi,

You could try:

UPDATE Users SET Password = FLOOR(RAND() * 10000)

would give a user a random 5 digit number as their password.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Users Changing Password In reply to
Thank you works great.
Quote Reply
Re: [Alex] Users Changing Password In reply to
Hi

I tried the

UPDATE Users SET Password = FLOOR(RAND() * 10000)


but all I get is the same 4 digit number on every record.

I'm on a MS SQL Server, could this be the problem.?

Regards

minesite