Re: [Emerald] 2.5.xxx feature request

Dale E. Reed Jr. ( (no email) )
Mon, 10 May 1999 13:26:07 -0700

"Ronnie D. Franklin" wrote:
>
> > 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????

You are looking at the wrong proc. Radusers uses the RU_ procs, not
the RadUsers proces (Emerald uses the RadUsers proc to export out
the list of users).

> ================
>
> 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)
> From MasterAccounts ma, SubAccounts sa, Groups g, Domains d
> Where ma.CustomerID = sa.CustomerID
> AND ma.GroupID = g.GroupID
> AND g.DomainID = d.DomainID
> AND sa.Login<>' '
> AND ma.Active = 1 AND sa.Active = 1
>
> GO

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com