Advanced search  

News:

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.
[more]

Pages: [1]   Go Down

Author Topic: reset  (Read 2540 times)

0 Members and 1 Guest are viewing this topic.

jan64

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

hi,

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.

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
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';
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.