How to clean up masses of rubbish votes?

[FretNoMore]

My site has either been visited by a robot (I understand this can cause lots of Rubbish votes) or some sad person has set out to ruin my stats. I tried to look at the database using MySQL Control Center but feel I don't have a good understanding of the tables. Is there a way of safely deleting all votes for a specific day, for a specific IP address or just all Rubbish votes?
Thanks,
Anders

[Joachim Müller]

The date of votes is not being recorded, so the answer is no, sorry. The only option is to disable voting for guests. This won't take care of the votes you got so far of course, it's just a method to stay clear for the future.

[FretNoMore]

The cpg11d_vote_stats table contains an sdate column and the cgp11d_votes table has a  vote_time column (?)

Anyway, just killing all votes from a specific IP address would be good.

[Joachim Müller]

vote stats are kept independently from the actual rating that is kept in the pictures table. The vote stats are an extra info that is not related directly to the voting. Voting will still work if you turn vote stats off in coppermine's config.
If you must fiddle with votings, you'll have to manually compare the entries in the vote stats table to the records in the pictures table and adjust them. A lot of work for little effect.
You just had to find out the painful way why we recommend to disallow anonymous voting in the first place. There is no easy method to restore things. Sorry.

[FretNoMore]

OK, thanks!

I'll just have to turn voting off then.