Advanced search  


cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.

Pages: [1]   Go Down

Author Topic: reset  (Read 2534 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 17
« on: June 13, 2005, 08:45:16 pm »


how can i reset the counter that counts how many a picture is shown?  (my english is really bad)
i mean reset all the counters from all the  pictures at the same time, not pic for pic.

« Last Edit: June 13, 2005, 09:08:48 pm by jan64 »

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
Re: reset
« Reply #1 on: June 14, 2005, 03:23:41 am »

you would need a tool like phpMyAdmin that allows database queries to be run directly. To reset the views in a particular album, the query would be something like
Code: [Select]
UPDATE `yourCopperminePrefix_pictures` SET `hits` = '0' WHERE `aid` ='62';where 62 is the album ID. To reset all views in all albums, the query would be
Code: [Select]
UPDATE `yourCopperminePrefix_pictures` SET `hits` = '0';
Pages: [1]   Go Up

Page created in 0.021 seconds with 19 queries.