(RADIATOR) help required ...

Muhammad Mushtaque mushtaque at eworld.net.pk
Wed Aug 7 06:19:15 CDT 2002


Hi,

Thanks for ur help ...(hugh) 

Now i want that the user gets disconnect when the amount field will be 
zero. is there any way to do it through radiator?

waiting for replies 

Mushtaque.
_______
This email and any files transmitted with it are confidential and are 
intended solely for the use of the individual or entity to which they 
are addressed. This communication represents the originator's personal 
views and opinions, which do not necessarily reflect those of eWorld 
(Pvt) Ltd. If you are not the original  / intended recipient or the 
person responsible for delivering the email to the intended recipient, 
be advised that you have received this email in error, and that any 
use, dissemination, forwarding, printing, or copying of this email is 
strictly prohibited. If you have received this email in error, we 
regret the inconvenience and request you to please immediately notify 
at info at eworld.net.pk 

----- Original Message -----
From: Hugh Irvine <hugh at open.com.au>
Date: Wednesday, August 7, 2002 7:10 am
Subject: Re: (RADIATOR) help required ...

> 
> Hello Mushtaque -
> 
> The first problem is that there is no Acct-Session-Time in an 
> accounting 
> start (and its numeric), therefore your statement below should 
> look like 
> this:
> 
>    ... amount=amount-(0%{Acct-Session-Time}/3600.00)*price ...
> 
> 
> There are some other errors shown, but I don't have the 
> configuration 
> file to see what you are trying to do.
> 
> regards
> 
> Hugh
> 
> 
> On Tuesday, August 6, 2002, at 09:09 PM, Muhammad Mushtaque wrote:
> 
> > Hi All,
> >
> > I m using Radiator-2.17 with Platypus and SQL Database. I am 
> trying to
> > do currency calculation with time calculation ( example: if any 
> of our
> > user used 1 hr (say) then the charges of 1 hr will be detected 
> through> the amount he paid us and if he has no amount in his 
> amount field so he
> > wont be able to connect. the charges will be different for different
> > durations of day.)
> > thats our whole scenario, I m trying to do this through SQL. 
> Ultimately> through AcctSQLStatement i m updating the field of 
> amount in SQL.
> > The error i m getting is when i m executing this query ...
> >
> >
> > AcctSQLStatement update customer set amount=amount-('%{Acct-
> Session-
> > Time}'/3600.00)*price from  priceCalculation,customer,timerate where
> > customer.username ='%n' and customer.accttype='TimePackages'
> >
> > I m attaching trace 4 detail file.
> >
> > waiting for replies.
> >
> > regards
> >
> > Mushtaque.
> >
> > _______
> > This email and any files transmitted with it are confidential 
> and are
> > intended solely for the use of the individual or entity to which 
> they> are addressed. This communication represents the 
> originator's personal
> > views and opinions, which do not necessarily reflect those of eWorld
> > (Pvt) Ltd. If you are not the original  / intended recipient or the
> > person responsible for delivering the email to the intended 
> recipient,> be advised that you have received this email in error, 
> and that any
> > use, dissemination, forwarding, printing, or copying of this 
> email is
> > strictly prohibited. If you have received this email in error, we
> > regret the inconvenience and request you to please immediately 
> notify> at info at eworld.net.pk
> >
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> 
> 

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list