MyBB Community Forums

Hello, how can i delete all ratings done by a user?

(2015-10-08, 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?

(2015-10-08, 08:02 AM)SentoWeb Wrote: [ -> ]

(2015-10-08, 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

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.

(2015-10-08, 08:10 AM)Beautiful Wrote: [ -> ]

(2015-10-08, 08:02 AM)SentoWeb Wrote: [ -> ]

(2015-10-08, 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".