SMFHacks.com

Awesome Post Ratings => Support => Topic started by: yameth on March 17, 2017, 04:02:27 am

Title: Delete ratings from profile?
Post by: yameth on March 17, 2017, 04:02:27 am
There's someone on my forum who is not happy with the moderation team.
He has therefore given many thumbs down for no reason to the mods posts, before he was banned.

How can I delete these thumbs down ratings from a members profile?
Title: Re: Delete ratings from profile?
Post by: SMFHacks on March 17, 2017, 04:29:22 am
Here is a couple SQL queries you can run

This will remove anything the member rated
Code: [Select]
Delete FROM smf_awesome_ratelog where id_member = MEMMBERIDHERE



If there is only a specific type you wan to remove
You would add to such as
Code: [Select]
Delete FROM smf_awesome_ratelog where id_member = MEMMBERIDHERE AND id_ratetype = 2
That example removes thumbs down
Title: Re: Delete ratings from profile?
Post by: yameth on March 17, 2017, 04:32:17 am
Thanks for the quick reply!