Sorry, was sure I did write a reply before the weekend but somewhere that one got lost.
The component does not have a reset-hits function. I wrote a small script to do the job.
Counting hits is a bit tricky in the component, hits are linked to individual items so if a item is removed from the database the hits are also. And you might get clicks from bots.
A more reliable method is using (google)analytics to count the click outs. Either using a click trigger on your affiliate links, using a clickout page or using the google measurement protocol
Code:
<?php
#goes into the root of your site, next to the configuration.php
# file name for example reset-all.php
#requires a recent version of the component ( for mysqli.php)
include('configuration.php');
include('administrator/components/com_datafeeds/cron/mysqli.php');
$config=new JConfig;
$db_host= $config->host;
$db_host= $config->host;
$db_user= $config->user;
$db_password=$config->password;
$db_database=$config->db;
$fromname=$config->fromname;
$mailsite=$config->mailfrom;
$mailfrom="$fromname <$mailsite>";
$db_table= $config->dbprefix .'dataitems';
$db_feeds= $config->dbprefix .'datafeeds';
db_connect($db_host, $db_user, $db_password,$db_database);
$q="UPDATE `$db_table` set hits=0 ";
echo "Hits reset - " . db_query($q);
