Reset Ratings

[Jamie Durrant]

As I'm intending to award a winner of pictures uploaded once a week/month, I would really like to be able to reset the ratings every week/month.

Is this going to be possible, with a hack or some other way ?

Thank you,

Jamie.

[ConqSoft]

You should be able to just delete all the records from the gallery ratings table.

[Jamie Durrant]

Would that be delving into the Mysql database ? I dont think I'd be too happy letting my moderators do that, in case of an accidental screw up.

Is there no other way ?

The only way is going to be with some queries...

DELETE FROM adv_gallery_rate;
UPDATE adv_gallery_images SET votenum = 0, votetotal = 0;

[Jamie Durrant]

Ok, thank you Conqsoft & Brian.

[Ramses]

Originally Posted by Brian

The only way is going to be with some queries...

DELETE FROM adv_gallery_rate;
UPDATE adv_gallery_images SET votenum = 0, votetotal = 0;

Does this still work for vb 3.5?
thanks

Yes, it should.

[Ramses]

I got this error: Beim Ausführen Ihres Querys trat ein Fehler auf. Die folgenden Informationen wurden zurückgegeben.
Fehlernummer: 1064
Fehlerbeschreibung: You have an error in your SQL syntax near ';
UPDATE adv_gallery_images SET votenum = 0, votetotal = 0' at line 1

If you're running those through the vB admin cp then you can only run one at a time.

[Ramses]

Sorry Brian for asking again but I think I'm to stupid, what need I query exactly now? I tried:
DELETE FROM adv_gallery_rate;
or
DELETE FROM adv_gallery_rate;
UPDATE adv_gallery_images SET votenum = 0;

It gets an error,
thank you

What's the error? Do you use table prefixes with your forum? If so you'll need to add the table prefix in front of the table names before you run the queries.

[Ramses]

Thank you Brian it was the table prefix