Removing thread ratings?

[darnoldy]

Folks-

Okay, so I ask weird questions...

I don't want to remove the feature, I want to remove all the thread ratings that have been given.

I have been testing some stuff, and given ratings to threads during the test. I want to go back to zero before I go live.

--don

[ozzy47]

Take a backup first! This is untested.

Run this first:
SELECT user.username, user.userid, thread.title, threadrate.vote FROM threadrate LEFT JOIN user ON user.userid = threadrate.userid LEFT JOIN thread ON thread.threadid = threadrate.threadid ORDER BY thread.title

Then if you see what you expected, run this:
DELETE FROM threadrate WHERE userid = X

Change X to the userid of the offender.

You'll need to update your thread & forum information counters afterwards.

[darnoldy]

Thanks, Ozzy! I'll give it a try a little later (I have some more screwing around to do first).

--don

[ozzy47]

Not a problem, hopefully it works. :)