diff options
author | ivan <ivan> | 2002-12-17 10:36:39 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-12-17 10:36:39 +0000 |
commit | 641e3f253b22c54c8970213ef86e04337caab948 (patch) | |
tree | 8b095604d941a506fe169adf805a06e272261b22 /FS | |
parent | 0d6147067e8d5317d01692f8588b3a0167c664c8 (diff) |
sqlradius time calculation fix wrt open sessions
Diffstat (limited to 'FS')
-rw-r--r-- | FS/FS/cust_svc.pm | 3 |
1 files changed, 2 insertions, 1 deletions
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]; |