forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: Josiah on November 27, 2003, 12:52:13 am

Title: Votes/Rating
Post by: Josiah on November 27, 2003, 12:52:13 am

35 pictures in my NHL 2004 screenshot gallery were atomatically (sp?) rated 0/5, even though no one has visited the site (it isn't open yet).  How can I change this/prevent it from happening in the future?

http://nhl.josiahmackenzie.com/gallery/thumbnails.php?album=toprated

Title: Votes/Rating
Post by: Joachim Müller on November 27, 2003, 07:58:57 am

to reset all votings, run a query in mySQL like this:

Code: [Select]

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

It's hard to believe that this happened by chance, maybe somone did vote on it, running into your site by chance...

GauGau

Title: Votes/Rating
Post by: Josiah on December 02, 2003, 02:10:16 pm

Thank you!   :D

Title: Re: Votes/Rating
Post by: mustang_lex on July 01, 2005, 03:29:22 am

Thank you . I had to change mine to 133 and its cool I can run the query from Vbulletins Admin CP!!!! Thanks