Quote:
|
Originally Posted by Ugly Bastard
I'll put my pos-rep to neg-rep awarded ratio up against anyone except maybe Orgazmo (not sure) (minimum 75 reps given).
|
This made me curious, so I did a little research. Below, you will find a breakdown of both positive and negative reps given. The only criteria is that the user has given at least 20 reps. The niceness is simply the +'s divided by the -'s.
The "all time" chart is quite skewed, though. At the beginning of rep, there was quite a bit of backlash (*ahem* BDH) and some testing and shit with everyone dipping their toes into the proverbial waters. Because of that, not all reps given came from the heart.
The "recent" chart below starts at Jan 1, 2009, just over a month after rep had been introduced and, based on the rep comments around that time, after all of the bullshit had settled down. Because of that, it is the more accurate chart.
Also, in case I ever want to do this in the future, I'm going to put the query here:
Code:
SELECT u.username, SUM( IF( r.reputation >0, 1, 0 ) ) AS Positive, SUM( IF( r.reputation <0, 1, 0 ) ) AS Negative, ifnull( (
SUM( IF( r.reputation >0, 1, 0 ) ) / SUM( IF( r.reputation <0, 1, 0 ) ) ) , 100000
) AS Niceness
FROM reputation r
INNER JOIN user u ON r.whoadded = u.userid
GROUP BY r.whoadded
HAVING (
SUM( IF( r.reputation >0, 1, 0 ) ) + SUM( IF( r.reputation <0, 1, 0 ) )
) >19
ORDER BY niceness DESC , Positive DESC