You could issue this through PHPMyAdmin, Webmin, or via the mysql command line tool if you have Telnet / SSH access. Alternatively; the following script should work, if you save it in your /admin folder:
resetClicks.php:
<?php require("../includes/common.php"); $sql = "UPDATE `".$config_databaseTablePrefix."feeds` SET clicks=0"; database_queryModify($sql,$insertId); ?>
The SQL is as follows:
UPDATE feeds SET clicks=0You could issue this through PHPMyAdmin, Webmin, or via the mysql command line tool if you have Telnet / SSH access. Alternatively; the following script should work, if you save it in your /admin folder:
resetClicks.php:
<?phprequire("../includes/common.php");
$sql = "UPDATE `".$config_databaseTablePrefix."feeds` SET clicks=0";
database_queryModify($sql,$insertId);
?>
Hope this helps...