fix inflated advertising source numbers
authorivan <ivan>
Sat, 20 Dec 2003 03:47:09 +0000 (03:47 +0000)
committerivan <ivan>
Sat, 20 Dec 2003 03:47:09 +0000 (03:47 +0000)
httemplate/browse/part_referral.cgi

index 69bb95a..3f59abc 100755 (executable)
@@ -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;
 %>