Hi, Here's an example how I do my prepaid cards (it's different now already but it fit's you) and there's no need for sql if statements.
################################################# <AuthBy SQL> Identifier AcctStartOnlyPrepaidCard DBSource DBUsername DBAuth IgnoreAuthentication AccountingStartsOnly AcctSQLStatement UPDATE cards SET \ START = from_unixtime(%{Timestamp}), \ END = from_unixtime(%{Timestamp} + START_CREDIT), \ START_CREDIT = NULL \ WHERE username='%n' and \ ACTIVE = 'Yes' and \ START_CREDIT is not null </AuthBy> ################################################# <AuthBy SQL> Identifier AuthPrepaidCard DBSource DBUsername DBAuth AuthSelect select \ TYPE, \ ACTIVE, \ LOCKED_TO, \ unix_timestamp(end), \ unix_timestamp(expires), \ PASSWORD, \ rate, \ rate, \ start_credit, \ (unix_timestamp(end) - unix_timestamp()) \ from cards where \ USERNAME ='%n' AuthColumnDef 0, ETC-Realm,check AuthColumnDef 1, ETC-Active,check AuthColumnDef 2, NAS-Port, check AuthColumnDef 3, Expiration, check AuthColumnDef 4, Expiration, check AuthColumnDef 5, User-Password, check AuthColumnDef 6, Nomadix-Bw-Down, reply AuthColumnDef 7, Nomadix-Bw-Up, reply AuthColumnDef 8, Session-Timeout, reply AuthColumnDef 9, Session-Timeout, reply DefaultSimultaneousUse 1 NoDefault RejectEmptyPassword AddToReplyIfNotExist Nomadix-Bw-Down=2000,Nomadix-Bw-Up=2000,Idle-Timeout=900 AcctSQLStatement insert into ..... </AuthBy> ################################################# <Realm pre1h> AuthLog LoginFailureLog RewriteUsername s/^([EMAIL PROTECTED]).*/$1/ RejectHasReason AuthByPolicy ContinueUntilReject AuthBy AcctStartOnlyPrepaidCard AuthBy AuthPrepaidCard PostAuthHook file:"/home/radius/etc/hooks/wn/PostAuthHook.pl" </Realm pre1h> ################################################# ----- Original Message ----- From: "Craig Gittens" <[EMAIL PROTECTED]> To: "Radiator" <[EMAIL PROTECTED]> Sent: Wednesday, November 26, 2003 11:51 PM Subject: (RADIATOR) Can you use SQL if statements in radiator? > Hey guys, > > I am trying to get a new product to work where when the username and > password is used and is valid then it would update the SQL database with an > end date for the product. So I need this logic to work in a SQL statement in > Radiator: > > User is a valid user and is allowed online, > User entry gets update in SQL with a date I set (today + 30 days) > > If not then it would not update the user entry of course.... > > Is this possible? I have tried SQL Functions but they can't update a > permanent table. > > Regards, > > Craig. > > > === > 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.