From cd6a49deff31eb40300317cb4416a51707378316 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Fri, 22 Feb 2008 00:54:15 +0000
Subject: [PATCH] on accounts overview: show time applied after multipliers,
 not actual time worked

---
 httemplate/search/svc_acct.cgi | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

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 = ? 
-- 
2.11.0