diff options
| -rwxr-xr-x | httemplate/search/svc_acct.cgi | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/httemplate/search/svc_acct.cgi b/httemplate/search/svc_acct.cgi index afdc5da47..fb9ce8aec 100755 --- a/httemplate/search/svc_acct.cgi +++ b/httemplate/search/svc_acct.cgi @@ -35,8 +35,10 @@ sub timelast { "; #Transactions +# my $sql = " +# SELECT SUM($transactiontime) FROM acct_rt_transaction my $sql = " - SELECT SUM($transactiontime) FROM acct_rt_transaction + SELECT SUM(support) FROM acct_rt_transaction LEFT JOIN Transactions ON Transactions.Id = acct_rt_transaction.transaction_id WHERE svcnum = ? |