rating rating
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

rating

Started by nex, April 05, 2004, 01:02:14 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

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:


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


in phpmyadmin or eq.

lamama

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.


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