Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 4 Years, 2 Months ago Delete all ratings by a user
#1
Solved: 4 Years, 2 Months ago
Hello, how can i delete all ratings done by a user?
Heart MYBB  Heart
Reply
#2
Solved: 4 Years, 2 Months ago
(10-08-2015, 07:44 AM)Beautiful Wrote: Hello, how can i delete all ratings done by a user?

I assume you want to delete only the ratings and not the user, right?
[Image: axolis.png]

Project, Portfolio and Product management for freelancers.
Reply
#3
Solved: 4 Years, 2 Months ago
(10-08-2015, 08:02 AM)SentoWeb Wrote:
(10-08-2015, 07:44 AM)Beautiful Wrote: Hello, how can i delete all ratings done by a user?

I assume you want to delete only the ratings and not the user, right?

yes
Heart MYBB  Heart
Reply
#4
Solved: 4 Years, 2 Months ago
My be this can be done by a plugin, I am not sure core MyBB have this option.
By the way you may request for this plugin.
Reply
#5
Solved: 4 Years, 2 Months ago
(10-08-2015, 08:10 AM)Beautiful Wrote:
(10-08-2015, 08:02 AM)SentoWeb Wrote:
(10-08-2015, 07:44 AM)Beautiful Wrote: Hello, how can i delete all ratings done by a user?

I assume you want to delete only the ratings and not the user, right?

yes

You can execute this in phpMyAdmin:

DELETE FROM `mybb_threadratings` WHERE `uid`=USER_ID

Replace USER_ID with the id of the user (you can get it by clicking on the user's profile in the admin panel or front-end). If you have installed mybb with a different prefix you will have to use that instead of mybb_.

Once you have executed the query log in to the admin panel, go to Tools & Maintenance and click on "Recount & Rebuild" in the sidebar. Click "Go" for "Recount Thread Ratings".
[Image: axolis.png]

Project, Portfolio and Product management for freelancers.
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)