Resetting every users reputation
 

hi all,

is there an easy way to reset ALL users reputation? Guessing it would be a sql query but i am by no means experienced enough to come up with it ;)

Thanks in advance (and hello!)

Mark

DELETE FROM reputation;

AdminCP > Import & Maitence > Update Counters > Rebuild reputation

how about a way to DELETE all the reputation comments from their User Options? Not just rebuilding, but starting over?

Zachery's query will do just that.

oh, i was missing the "DELETE FROM reputation;"

thanks!

yeah! I've searchin this info, really thanks :).

I've had User Reputation disabled for a long period of time. I now want to enable it and set every member's reputation to whatever it should be depending on their current stats. Those that are defined in the User Reputation Options in AdminCP.

What is the query to do that? And do you follow that by Rebuilding User Reputation in Update Counters? Because Rebuilding User Reputation alone definitely doesn't work. All reputations are still the same after trying that.

And I assume the query will be a manual query you run in AdminCP > Maintenance > Execute Query?

Thanks.

Reputation doesn't grow as a user ages on the site with posts, etc. Their power does. If no one has had reuptuation up until now, everyone will be at 10 (default setting).

So is there a way to reset everyone back to 10. They love to rep wh0re on my board and its been a year of whoring, now I want to put them all back to 10 again. How is this done. I also dont want them to lose their reputation comments. Is this possible.

Considering enabling rep after a couple years of having it turned off, so would like an answer to this as well. No interest in keeping old comments, but would like to reset all user rep to 10.