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?
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 |
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 |
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 |