Leaders - how to clear counts and start over?

I am starting a contest tomorrow involving "Leaders" for the month.  I need to know how to reset the votes to 0.  Anyone know how to do this?

newbreed
Quote · 31 Jan 2010

ok, I figured out how to do this through the DB directly, by editing sys_profile_rating.

Unfortunately, this system does not count properly, and is yet another thing to add to the "pretty much useless" list...

newbreed
Quote · 31 Jan 2010

ok, another update...

in order to completely reset a member's count, you have to set both pr_rating_count and pr_rating_summary to 0 in the database.  It looks like the count row is the monthly count, and the summary is the yearly count, or something like that.  What I know for sure though, is if you only set the rating to 0, the member will still show up on the leader board, but with 0 votes, which is obviously wrong...

newbreed
Quote · 31 Jan 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.