Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11912
Latest: tom789
New This Month: 13
New This Week: 1
New Today: 0
Stats
Total Posts: 37890
Total Topics: 6667
Most Online Today: 80
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 62
Total: 62

Author Topic: Delete ratings from profile?  (Read 358 times)

0 Members and 1 Guest are viewing this topic.

Offline yameth

  • Newbie
  • *
  • Posts: 9
    • View Profile
Delete ratings from profile?
« 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?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14029
    • View Profile
Re: Delete ratings from profile?
« Reply #1 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
Get your Forum Ranked! at http://www.forumrankings.net - find out how your forum compares with others! Also contests/promotions for verified sites.

Offline yameth

  • Newbie
  • *
  • Posts: 9
    • View Profile
Re: Delete ratings from profile?
« Reply #2 on: March 17, 2017, 04:32:17 am »
Thanks for the quick reply!

 

Related Topics

  Subject / Started by Replies Last post
6 Replies
5202 Views
Last post March 08, 2007, 07:22:56 pm
by marcbkk
1 Replies
3246 Views
Last post November 12, 2007, 10:17:19 pm
by SMFHacks
5 Replies
5767 Views
Last post August 16, 2008, 12:59:46 pm
by SMFHacks
Ratings

Started by Nugget Support

2 Replies
2973 Views
Last post January 17, 2009, 01:11:02 am
by Nugget
7 Replies
3183 Views
Last post February 17, 2014, 06:36:26 pm
by shuban

+- Recent Topics

RSS Feed killed my forum by hippieboy123
April 18, 2017, 07:39:26 am

Is there a converter than converts all files found in topics of a specific board by SMFHacks
April 13, 2017, 02:46:18 pm

Sidebar Image width by hippieboy123
April 12, 2017, 01:32:00 pm

I run a Custom Theme and have many Test Failed - What to do? by SMFHacks
April 11, 2017, 05:12:15 pm

Daughter menus by Labradoodle-360
April 08, 2017, 05:37:22 pm

Lost my copyright removal when I converted forum to SSL by Nova
April 08, 2017, 01:19:50 pm

With .htaccess, how do I redirect an action to another action by shuban
April 06, 2017, 11:45:50 pm

Newsletter Pro errors in log by SMFHacks
April 03, 2017, 04:54:40 pm

Random Image Block code by landyvlad
March 30, 2017, 02:54:32 am

Upgrade Account - Download SMF Gallery Pro by mrsclaudio
March 29, 2017, 10:14:11 am

Powered by EzPortal