From: ivan <ivan>
Date: Sat, 20 Dec 2003 03:47:09 +0000 (+0000)
Subject: fix inflated advertising source numbers
X-Git-Tag: NET_WHOIS_RAW_0_31~226
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=7c67ed5982f05a562c30e45938a9fa164cbeb7cb

fix inflated advertising source numbers
---

diff --git a/httemplate/browse/part_referral.cgi b/httemplate/browse/part_referral.cgi
index 69bb95aa5..3f59abcf5 100755
--- a/httemplate/browse/part_referral.cgi
+++ b/httemplate/browse/part_referral.cgi
@@ -23,7 +23,8 @@ Where a customer heard about your service. Tracked for informational purposes.
   ;
 
   my $sth = dbh->prepare("SELECT COUNT(*) FROM h_cust_main
-                            WHERE refnum = ?
+                            WHERE history_action = 'insert'
+                              AND refnum = ?
                               AND history_date > ?         ")
     or die dbh->errstr;
 %>