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 : [EMAIL PROTECTED] ----- Original Message ----- From: "Anton Krall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] | Tel: 5233-9281 | Celular: 044-555-105-5160 | ICQ#: 4979450 | MSN: [EMAIL PROTECTED] | AIM: antonkrall | Web: http://www.intruder.com.mx | | | === | Archive at http://www.open.com.au/archives/radiator/ | Announcements on [EMAIL PROTECTED] | To unsubscribe, email '[EMAIL PROTECTED]' with | 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.