Hi Hugh.

Updating AuthRADIUS.pm made no diffderence.

I ran the following select statement mSQL:

select DateAdd(Day, ma.extension, maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.password, sa.login, sa.shell, sa.TimeLeft, sa.LoginLimit ,sa.LoginLimit
from masteraccounts ma, subaccounts sa
where (sa.login = 'adsleyework' or sa.shell = 'adsleyework')
and ma.customerid = sa.customerid
and sa.active <> 0 and ma.active <> 0

Here is the result:

                                                         AccountID 
AccountType     password                                         login 
                     shell TimeLeft    LoginLimit LoginLimit
-------------------------- --------------------------- ----------- 
--------------- ------------------------------------------------ 
------------------------------ ----- ----------- ---------- ----------
1999-12-31 00:00:00.000     2037-01-01 
00:00:00.000     8903        PPP             xxxxxxxx 
                   adsleyework                          NULL        1          1


===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to