Print Page - reset

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';

coppermine-gallery.com/forum

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