coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: eXess on September 19, 2006, 06:26:09 PM

Title: Reset Voting for all pictures to 0 ?
Post by: eXess on September 19, 2006, 06:26:09 PM
Is there a way to reset all votes for pictures to 0. I want voting for every picture to start again. Is it possible?  :o
Title: Re: Reset Voting for all pictures to 0 ?
Post by: Joachim Müller on September 19, 2006, 06:36:44 PM
Using the Coppermine user interface, you can only reset the votes/ratings by album (go to album properties, scroll to the bottom of the page, tick the corresponding checkbox, submit the form), so you would have to perform those steps for all your albums. Resetting all votes at once is not possible using the Coppermine interface - you'd have to edit your database with a third-party tool like phpMyAdmin. (not recommended). You'll have to truncate (i.e. empty, not delete!) Coppermine's votes table there. Then, you'd have to run a query like this:
QuoteUPDATE `yourCopperminePrefix_pictures` SET `pic_rating` = '0',  `votes` = '0';
I repeat: it's not recommended at all to fiddle directly with the database if you're not absolutely sure what you're doing. Backup your database before performing those steps, so you can savely go back if you mess up.