From: ivan <ivan>
Date: Thu, 17 Oct 2002 14:46:04 +0000 (+0000)
Subject: really fix sqlradacct for old Pg
X-Git-Tag: freeside_1_5_0pre1~173
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=ee083facc9f4e18f27df07f829b224366483a56e

really fix sqlradacct for old Pg
---

diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm
index bed6a0ab3..6ce12cbe9 100644
--- a/FS/FS/cust_svc.pm
+++ b/FS/FS/cust_svc.pm
@@ -380,7 +380,7 @@ sub seconds_since_sqlradacct {
                                WHERE UserName = ?
                                  AND $str2time AcctStartTime) >= ?
                                  AND $str2time AcctStopTime ) <  ?
-                                 AND $str2time AcctStopTime ) =! 0
+                                 AND $str2time AcctStopTime ) > 0
                                  AND AcctStopTime IS NOT NULL"
     ) or die $dbh->errstr;
     $sth->execute($username, $start, $end) or die $sth->errstr;
@@ -407,7 +407,7 @@ sub seconds_since_sqlradacct {
                               AND $str2time AcctStartTime ) < ?
                               AND $str2time AcctStopTime  ) >= ?
                               AND $str2time AcctStopTime  ) <  ?
-                              AND $str2time AcctStopTime ) != 0
+                              AND $str2time AcctStopTime ) > 0
                               AND AcctStopTime IS NOT NULL"
     ) or die $dbh->errstr;
     $sth->execute($start, $username, $start, $start, $end ) or die $sth->errstr;