Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: reset  (Read 2535 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.016 seconds with 20 queries.