MyBB Community Forums

My site is integrated with myBB. From my site guests can click on one of 5 links to rate a file. Well, I have crawler bots visiting those links now. They automatically rate the file anywhere from 1-5.

I've solved the problem, but I think I might have to reset all 500 votes (for ~120 files) because i'm not sure how many are valid.

All that needs to be done is set numratings and totalratings to 0 in mybb_threads, and clear mybb_threadratings, correct? Are there any other traces I will need to clear?

Those are the values you need to modify, yes. So the queries would be:

UPDATE mybb_threads SET numratings=0, totalratings=0;
TRUNCATE mybb_threadratings;

Chris