Is there an easy way to reset the click count to zero??
The SQL is as follows:
UPDATE feeds SET clicks=0
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:
<?php require("../includes/common.php"); $sql = "UPDATE `".$config_databaseTablePrefix."feeds` SET clicks=0"; database_queryModify($sql,$insertId);?>
Hope this helps...
Does it still work today? Do I need to browse http://XXXX.com/pt/resetClicks.php once to reset every time?
Just want to make sure before going with it
Yes - still current!