(RADIATOR) Disabling users using mysql

[Romain Vergniol]

Hi all,

after adding a column called "ACTIVE" in the SUBSCRIBERS table,
you should try something like this in your "AuthBy SQL" statement :

AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME='%n' and
ACTIVE='1'
AuthColumnDef 0, User-Password, check

hope this helps,
Romain Vergniol
--- C E G E D I M ---
Equipe Reseau
Tel : +33 (0)1 49 09 84 02
Mail : romain.vergniol at cegedim.fr
----- Original Message -----
From: "Anton Krall" <akrall at intruder.com.mx>
To: <radiator at open.com.au>
Sent: Friday, December 13, 2002 5:32 PM
Subject: (RADIATOR) Disabling users using mysql


| Guys, I need help trying to figure how to do this:
|
| Im using mysql as my SUBSCRIBERS db for radiator users.
| I have 2 columns, username and password and I want to add a 3rd one
| saying active so that when a user tryies to login, radiator will also
| check this caloumn and if active is = 1 it lets him in otherwise, will
| not authenticate.
|
| How can I configure radiator to look for this column and check the value
| and if its 1 then proceed?
|
| Thx for any help you can provide.
|
| __________________________________________________________________
| Anton Krall
| Intruder Consulting
|
| Email: akrall at intruder.com.mx
| Tel: 5233-9281
| Celular: 044-555-105-5160
| ICQ#: 4979450
| MSN: akrall at hotmail.com
| AIM: antonkrall
| Web: http://www.intruder.com.mx
|
|
| ===
| Archive at http://www.open.com.au/archives/radiator/
| Announcements on radiator-announce at open.com.au
| To unsubscribe, email 'majordomo at open.com.au' with
| 'unsubscribe radiator' in the body of the message.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.