Click Reset

Submitted by searley on Tue, 2006-03-28 21:16 in Feed Management and Administration

Is there an easy way to reset the click count to zero??

The SQL is as

Submitted by support on Tue, 2006-03-28 21:21

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:

resetClicks.php:

<?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

Submitted by stonecold111 on Mon, 2013-08-19 06:03

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

Submitted by support on Mon, 2013-08-19 08:53

Yes - still current!

Cheers,
David.
--
PriceTapestry.com