At 09:54 AM 2/21/2003 +0500, Eric wrote:
Hello,It will prevent the query from returning a value of < 0. Reading more
Please, can anyone show me the correct documentation about how to write new
modules for sqlcounter.
I meaning queries, like this:
SELECT SUM(AcctSessionTime - GREATEST(('%b' - UNIX_TIMESTAMP(AcctStartTime)),
0)) FROM radacct ......
or
"SELECT SUM(AcctInputOctets)+SUM(AcctOutputOctets) FROM radacct WHERE UserName
= '%{%k}' LIMIT 0, 30"
I don't know what GREATEST meens & destination of strange number following
after round brackets (0 or LIMIT 0 or 30).
about the queries at http://www.mysql.com would be suggested.
-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
