Remove Thread Ratings

[Ohiosweetheart]

After someone has rated a thread, is there a way to remove/delete the rating?

[MickDoneDee]

Only manually within the database. I use phpMyAdmin to see and edit the tables in the database. The table that stores thread ratings is called "threadrate". It has several fields to make searching for the specific vote you want removed a very simple operation. For example, threadid; userid; vote. If you know the thread id you can see all the individual votes for that thread and delete the record containing the user's vote you want removed.

Warning! You also have to manually ammend the "thread" table in the votenum and votetotal fields. If you didn't update these fields with the new number of votes and new total votes then the average vote (number of stars) would not change.

After updating the "thread" table refresh the showthreads page to see the new thread rating.

[Ohiosweetheart]

yikes... forget that

thank you for answering