PDA

View Full Version : Reputation


filburt1
09 Nov 2005, 02:41
I don't have any data to test this query on.


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


Does it look like it retrieves, for every user who has reputation at all:

Total awarded score (10 points + 10 points + (-10 points) = 20 points)
Total possible score (10 points + 10 points + 10 points = 30 points)
Total number of distinct users who left reputation for this user (filburt1 + filburt1 + Poor Sucker = 2 users)

If so, am I correct in that totalscore / totalpoints = reputation percent? In this case, ~67%?

Or if anybody has a reputation table filled with data I can play with, that would work too.