From: ivan <ivan>
Date: Tue, 17 Dec 2002 10:36:39 +0000 (+0000)
Subject: sqlradius time calculation fix wrt open sessions
X-Git-Tag: freeside_1_5_0pre1~85
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=641e3f253b22c54c8970213ef86e04337caab948

sqlradius time calculation fix wrt open sessions
---

diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm
index 8bcb0fcca..66daec17b 100644
--- a/FS/FS/cust_svc.pm
+++ b/FS/FS/cust_svc.pm
@@ -394,11 +394,12 @@ sub seconds_since_sqlradacct {
                 FROM radacct
                 WHERE UserName = ?
                   AND $str2time AcctStartTime ) >= ?
+                  AND $str2time AcctStartTime ) <  ?
                   AND ( ? - $str2time AcctStartTime ) ) < 86400
                   AND (    $str2time AcctStopTime ) = 0
                                     OR AcctStopTime IS NULL )";
     $sth = $dbh->prepare($query) or die $dbh->errstr;
-    $sth->execute($end, $username, $start, $end)
+    $sth->execute($end, $username, $start, $end, $end)
       or die $sth->errstr. " executing query $query";
     my $start_during = $sth->fetchrow_arrayref->[0];