Regards,
Graeme
---Graeme Slogrove, BSc (Eng) Elec (Wits)Director, Systems Development & Value Added ServicesNetActive InternetTel: 011-719-0333 Fax: 011-719-0444Support: 011-719-0300
-----Original Message-----From: Nicolaj Ottsen [mailto:no@webpartner.dk]Sent: 14 September 1999 05:32To: radiusnt@iea-software.comSubject: [RadiusNT] Changing StoredProcedures
I have tried to change some of the different StoredProcedures, ex.RadGetUser.
Before:
CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) ASSELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType,sa.LoginLimit, sa.TimeLeft, MasterExpire=DateAdd(Day, ma.Extension+ma.OverDue+1, maExpireDate), SubExpire=DateAdd(Day, sa.Extension+1, saExpireDate) FROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0 AND sa.Login = @user AND sa.Password = @password
Now:
CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) ASSELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType,sa.LoginLimitFROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0 AND sa.Login = @user AND sa.Password = @password
I removed the sections with ExpireDate verification, since we don't needthat, but the server still runs the same SQL when verifing users. That is
CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) ASSELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType,sa.LoginLimit, sa.TimeLeft, MasterExpire=DateAdd(Day, ma.Extension+ma.OverDue+1, maExpireDate), SubExpire=DateAdd(Day, sa.Extension+1, saExpireDate) FROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0 AND sa.Login = @user AND sa.Password = @password
Is the SQL code "HardCoded" into RadiusNT ?
Nicolaj OttsenTjantik
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart