forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: jan64 on June 13, 2005, 08:45:16 pm

Title: reset
Post by: jan64 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

Title: Re: reset
Post by: Joachim Müller 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';