We have the cs-cart affiliate system setup and we are ONLY using a value in Payout Sales (the other clicks, show banner, etc are set to zero). Is it possible to NOT log every “show” and “click” in the database? I can see this thing filling up the database extremely fast if we get a lot of activity. We only need to log and show the actual payouts (i.e. non-zero amounts in the cscart_aff_partner_actions table).
[font=monospace]Any ideas would be helpful.[/font]
[font=monospace]Thank you[/font]
Hello Hucklebuck,
If it is still actual, please let me know the version of your CS-Cart.
In any way, you can find the following string in func.php file:
$action_id = db_query("INSERT INTO ?:aff_partner_actions ?e", $data);
And add the condition there. For example like this:
if ($action == 'sale' && !empty($data['amount'])) {
$action_id = db_query("INSERT INTO ?:aff_partner_actions ?e", $data);
}
Also, please visit the following topic: Affiliate, Gift Registry, Product Configurator, Recurring Billing, Statistics Addons. - Third-Party Services - CS-Cart Community Forums
Hope it will be helpful.