forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: nex on April 05, 2004, 01:02:14 am

Title: rating
Post by: nex on April 05, 2004, 01:02:14 am

how to reset rating of pictures to 0?

Title: rating
Post by: Nibbler on April 05, 2004, 01:24:59 am

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.

Title: Re: rating
Post by: lamama on November 10, 2004, 01:20:02 pm

Quote

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.

Title: Re: rating
Post by: Joachim Müller on November 11, 2004, 06:48:40 am

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