Re: New Customer Billings

Dale E. Reed Jr. ( (no email) )
Fri, 13 Feb 1998 12:56:02 -0800

iml@interconnect.net wrote:
>
> Dale which configid equals what time below obviously extend is ID9,
> however, what are the other 2? I tried to change values via the
> Emerald admin and it will not save the changes. I wanted expire =0,
> extend=15 and limit=20 as of now the emerald admin shows expire=0
> extend=5 yet an sql query shows
>
> If you can let me know what value goes to each config id I can update
> via SQL.
>
> ConfigID Type Value Data
>
> -----------------------------------------------------------------------------------------------
> 5 0 7200 (null)
> 8 0 0
> 9 0 6

INSERT Configs VALUES(5, 0, 5, NULL) /* Default Limit */
INSERT Configs VALUES(8, 0, 5, NULL) /* Default Expire */
INSERT Configs VALUES(9, 0, 5, NULL) /* Default Extend */

> >Your Configs table houses these values. Open up ISQL_W and
> >use the following statements to change the values:
> >
> >Update Configs Set Values = 0 Where ConfigID = 8
> >Update Configs Set Values = 14 Where ConfigID = 9
> >Update Configs Set Values = 0 Where ConfigID = 5

You would want:

Update Configs Set Values = 0 Where ConfigID = 8
Update Configs Set Values = 15 Where ConfigID = 9
Update Configs Set Values = 5 Where ConfigID = 5

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com