Re: [Emerald] Daily Online Time Limited store procedure

Dale E. Reed Jr. ( (no email) )
Wed, 17 Nov 1999 09:51:16 -0800

dan@dmn.com.au wrote:
>
> Dale,
> We want to implement a daily online limited for our user. RadGetConfigs is
> for additional Radius attributes for particular subaccounts, if we modify it
> as follow, will it work? (Can not use RadGetATConfigs, because it does not
> pass username).
>
> In our Database the particular account type would be DAYx, the x is the hour
> limit in a day, any body should be able to change to monthly time limit type
> of account as well.

I would look at the monthly recurring scripts I wrote that use the
timeleft
field and then write a proc that runs nightly to modify the timeleft.
Check out the pieces at:

ftp://ftp.iea-software.com/Emerald/sql/at_timelimits.sql

This makes things a lot cleanier on the RadiusNT side (you don't have to
do anything to it) and more compatable with what we will be doing in
the future.

-- 

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

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart