reset reset
 

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]

Main Menu

reset

Started by jan64, June 13, 2005, 08:45:16 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jan64

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

Joachim Müller

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 likeUPDATE `yourCopperminePrefix_pictures` SET `hits` = '0' WHERE `aid` ='62';where 62 is the album ID. To reset all views in all albums, the query would beUPDATE `yourCopperminePrefix_pictures` SET `hits` = '0';