Removing thread ratings?

[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.