Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 201
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 184
Total: 184

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

0 Members and 1 Guest are viewing this topic.

Offline yameth

  • Member
  • *
  • Posts: 14
    • 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: 16436
    • 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 https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline yameth

  • Member
  • *
  • Posts: 14
    • 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
8187 Views
Last post March 08, 2007, 07:22:56 pm
by marcbkk
1 Replies
5611 Views
Last post November 12, 2007, 10:17:19 pm
by SMFHacks
5 Replies
8047 Views
Last post August 16, 2008, 12:59:46 pm
by SMFHacks
Ratings

Started by Nugget Support

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

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal