summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2003-12-20 03:47:10 +0000
committerivan <ivan>2003-12-20 03:47:10 +0000
commitf0671da6722f299f5200906f809ccb7f56db5a70 (patch)
tree1c00e80c24c2c2d0b9e954329a38e33dcac38f3c
parent81e6f70e7591d1f80b3576708a727aaa4ae0ef10 (diff)
fix inflated advertising source numbers
-rwxr-xr-xhttemplate/browse/part_referral.cgi3
1 files changed, 2 insertions, 1 deletions
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;
%>