Resetting every users reputation

[spesh]

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

[Zachery]

DELETE FROM reputation;

AdminCP > Import & Maitence > Update Counters > Rebuild reputation

[bi11i]

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

[Tigga]

Zachery's query will do just that.

[bi11i]

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

thanks!

[Ejecutor Hanzo]

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

[USAMustangs.com]

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.

[Zachery]

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).

[mike2902]

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.

[Lupine]

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.

[Zachery]

Query is still the same.

[trilOByte]

Is there any way to reset reputation power? There is no point resetting reputation, while users retain huge rep giving abilities. It's completely out of balance without the ability to reset rep power to default.