From 1ee153d68626a9fdfb0451ee03ab942158670435 Mon Sep 17 00:00:00 2001 From: Arran Cudbard-Bell Date: Mon, 2 Dec 2013 23:19:06 +0000 Subject: [PATCH] Fix formatting and typo --- .../mods-config/sql/counter/postgresql/dailycounter.conf | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/raddb/mods-config/sql/counter/postgresql/dailycounter.conf b/raddb/mods-config/sql/counter/postgresql/dailycounter.conf index fd193d0c39..48ef816a07 100644 --- a/raddb/mods-config/sql/counter/postgresql/dailycounter.conf +++ b/raddb/mods-config/sql/counter/postgresql/dailycounter.conf @@ -3,15 +3,15 @@ # involves more work for the SQL server than those # below query = "SELECT SUM(AcctSessionTime - \ - GREATER((%b - AcctStartTime::ABSTIME::INT4), 0)) \ - FROM radacct WHERE UserName='%{${key}}' AND \ - AcctStartTime::ABSTIME::INT4 + AcctSessionTime > '%b'" + GREATER((%b - AcctStartTime::ABSTIME::INT4), 0)) \ + FROM radacct WHERE UserName='%{${key}}' AND \ + AcctStartTime::ABSTIME::INT4 + AcctSessionTime > '%b'" # This query ignores calls that started in a previous # reset period and continue into into this one. But it # is a little easier on the SQL server # query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE \ -# UserName='%{${key}}' AND AND AcctStartTime::ABSTIME::INT4 > '%b'" +# UserName='%{${key}}' AND AcctStartTime::ABSTIME::INT4 > '%b'" # This query is the same as above, but demonstrates an # additional counter parameter '%e' which is the -- 2.47.3