RE: [Emerald] 2.5.xxx feature request

Ronnie D. Franklin ( ronnie@itexas.net )
Sun, 9 May 1999 13:09:04 -0500

> If you use radusers to do the export, it uses a stored proc for the
> information that you can modify to include those (actually, I think
> the default ones do).

I finally had time to look at the stored proc for Radusers.. and it appears
that it is trying to add the extend days to come up with a "real" expire,
but when it creates the txt file the expiration date is the actual
expiration date without the extenstions added in... What is it missing????

================

if exists (select * from sysobjects where id = object_id('dbo.RadUsers') and
sysstat & 0xf = 4)
drop procedure dbo.RadUsers
GO

CREATE PROCEDURE RadUsers AS
SELECT sa.Login, sa.Password, sa.Email, d.MailDomain, sa.AccountType,
sa.LoginLimit, sa.TimeLeft,
MasterExpire=DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate),
SubExpire=DateAdd(Day, sa.Extension, saExpireDate)