how to reset rating of pictures to 0?
You can reset pic ratings using 'edit pics' from the album properties menu. Tick the 'Reset votes' box on the pic(s) then apply. If you want to reset *all* the ratings, then use an SQL query like:
UPDATE `cpg_pictures` SET `pic_rating` = '0', `votes` = '0';
in phpmyadmin or eq.
QuoteUPDATE `cpg_pictures` SET `pic_rating` = '0', `votes` = '0';
What (side)effect will this have to the cpg_votes table? Is there any need to delete or update anything there?
I have problems with users try to mirror or "leech" my coppermine gallery - one sideeffect is a lot of zero-ratings caused by the download tools who just follow every link they find. It'd like to reset all zero-votes by users (because they also influence the regular votes), but I'm not sure what's the best solution for that problem.
my first advice would be to use the most recent stable version cpg1.3.2, not the outdated cpg1.2.x
The query you refer to will reset all votings on your gallery.
Joachim