Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Validate users

Quote Reply
Validate users
at the begging i haven't required username and password for users ... now after 100 links added i have decided to lock .. require registration of user for submit .. they all got their id and passes (random) and now when they try to login .. i get error ..

Sorry, that account has not yet been validated.

..where can i validate them ... i have searched admin but no luck.

thanx in advance

Gregor
Quote Reply
Re: [sc2utp] Validate users In reply to
There is a column called "Status", that needs to be set to "Registered".

You'll need to update your USERS table.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [sc2utp] Validate users In reply to
Basically from mysqlman you will need to run something like:

UPDATE users SET Status='Registered' WHERE Status='Not Validated';

Last edited by:

RedRum: Oct 9, 2001, 7:35 AM
Quote Reply
Re: [RedRum] Validate users In reply to
Hi!
well it works what anthrorules said ... i did it for one user .... now this redrums suggestion? .. i'll have to put some mind on it .. don't know how to do it

UPDATE users SET Status='Registered' WHERE Status='Not Validated';

i hope redrum u have a minute to explain me how to do this in mysqlman .. cause doing this for 100 users one by one .. little long time would it take :))

thank you both guys


Gregor
Quote Reply
Re: [sc2utp] Validate users In reply to
Just paste the above code into the mysqlman monitor and hit Go......that's all

Just make sure that 'users' is the correct name for your users table.
Quote Reply
Re: [RedRum] Validate users In reply to
is it case sensitive? users =Users

Gregor
Quote Reply
Re: [sc2utp] Validate users In reply to
it worked .. thanx again .. i used Users with Capital U .. just in case :))

Gregor
Quote Reply
Re: [sc2utp] Validate users In reply to
If you did a default install it will be users