You are here:  » Click Reset

Active Forum Topics


Click Reset

Submitted by searley on Tue, 2006-03-28 21:16 in
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...

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

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

Yes - still current!

Cheers,
David.
--
PriceTapestry.com