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