Gossamer Forum
Home : Products : Gossamer Links : Discussions :

blank password field

Quote Reply
blank password field
I have blank password fields in user tables after importing links 2.0 data into SQL 2.10

Now I would like to replace all blank password entries with a standard-password.

How to make it with one command?

Michael

--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] blank password field In reply to
UPDATE Links SET Password = 'Bla' WHERE Password = NULL (if it is NULL)

You'll need to encrypt it.

Last edited by:

RedRum: Jan 14, 2002, 11:54 AM
Post deleted by RedRum In reply to

Last edited by:

RedRum: Jan 14, 2002, 11:54 AM
Quote Reply
Re: [Michael Skaide] blank password field In reply to
One suggestion (as mentioned before in this forum):

--> SQL Monitor


UPDATE Users SET Password = RAND(Password) WHERE Password = Null


This will create a numerical random password for all the user accounts that do not have a password assigned.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [Heckler] blank password field In reply to
Eliot,

what kind of password will be created?

If it is something like that: DfGGtERe!299DfdDdfffJhh
i would prefere to set a standard password
which is the same for all. (User donīt know this)

Michael

--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] blank password field In reply to
Something like 0.8976

That is very dangerous to give out the same password to all your users...I hope they don't visit the product's forums that you use to lurk into information like you've posted.

Anyway, if all you want is the SAME password (which has also already been discussed in this forum quite a few times), then you would modify the SQL statement I've already provided you....


UPDATE Users SET Password = 'everyonecomeinandtakeadvantageofmysite' WHERE Password = Null


You can replace the following string:

"everyonecomeinandtakeadvantageofmysite"

With whatever generic and site threatening password you'd like to give your users....
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Heckler: Jan 14, 2002, 12:19 PM