Print

[nex]

how to reset rating of pictures to 0?

[Nibbler]

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:

Code: [Select]


UPDATE `cpg_pictures` SET `pic_rating` = '0', `votes` = '0';


in phpmyadmin or eq.

[lamama]

UPDATE `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.

[Joachim Müller]

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