Rating - How can I delete all ratings entered for images in an album ?

birs

Joined: 2008-01-19
Posts: 4
Posted: Mon, 2008-03-24 10:42

I want the members of my gallery to rate images in certain albums. The function was tested during a week and should now seriously start. Before this is possible I must delete all test ratings entered. How can I do this?


Gallery version (not just "2"): 2.2.3 Kern 1.2.0.5
Module / Theme name & version: Rating 1.0.8
PHP version (e.g. 5.1.6):
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33):
Database (e.g. MySql 5.0.32):
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux):
Browser (e.g. Firefox 2.0):

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Mon, 2008-03-24 16:17

Uninstall the ratings module and then reinstall it.
There is not an admin interface to clear / skew the votes.

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

 
birs

Joined: 2008-01-19
Posts: 4
Posted: Mon, 2008-03-24 16:39

Thanks, but I don't think I would want to do this. It would delete all ratings in the whole gallery and remove the settings that I made (authorizations, placement of rating interface etc.). In that case, I prefer to use some SQL and tackle the tables (g2_RatingCacheMap, g2_RatingMap). I would need to identify the itemIds of all images in a given album and then delete the respective rows in those tables (I assume).
Clearing both tables did what I wanted, but I would still prefer to be able to indicate the album first and purge only the records of images in that album. Maybe I find a way myself, but any help would surely be appreciated.

 
lightpainter

Joined: 2005-11-25
Posts: 64
Posted: Fri, 2009-10-02 15:18