Investigating the reputation system & stats porn | Final update

[Don Pellegrino]

People mocked me when I suggested this a while back, and here we all are eagerly discussing the results. Thank you Don for providing all the stats!

You asked for the size of the dump. In number of rows? size of the sql file? You can see the number of rep rows in the first screenshot if you do the sum of each type of rep and I don't know the size of the sql file because entrox just copied the DB.

Over 100 rep but didn't make any lists

You didn't have 100 at the moment the snapshot was taken.

Don can we make requests? If so, most ignored posters, most infracted, most reported?

telephone

Those shouldn't be too hard, I'll do it when I can.

[Doomed Predator]

Honestly it doesn't look like too much of a ciclejerk to me. At most the same guy +repped someone about 10-15 times which isn't even 10% of their accumulated rep. Sure, a few do pop up frequently, but maybe they just give a shit about using the rep system while the rest of FHC don't.

[Lana Torrin]

I don't know how I forgot this one:

I took the 30 posters with the most posts since 2011-07-02 and sorted them by the average number of posts to increase their rep by 1. Obviously the negative rep posters go to the bottom, not to the top

  Spoiler:

SELECT
	@rownum:=@rownum+1 AS rank,
	z.*
FROM (
	SELECT
		stats.user,
		stats.rep,
		stats.postcount,
		stats.nb AS 'average nb of posts to get 1 rep'
	FROM (
		SELECT
			u.username AS user,
			u.reputation AS rep,
			t.nb AS postcount,
			(t.nb / (u.reputation - 10)) AS nb
		FROM
			user u
		INNER JOIN (
			SELECT
				userid,
				COUNT(*) AS nb
			FROM
				post
			WHERE
				DATE(FROM_UNIXTIME(dateline)) >= '2011-07-02'
			GROUP BY
				userid
			ORDER BY
				nb DESC
		) t ON u.userid = t.userid
		WHERE
			u.posts >= 250
		ORDER BY
			t.nb DESC
		LIMIT 30
	) stats
	ORDER BY
		stats.nb ASC
	LIMIT 30
) z, (SELECT @rownum:=0) y

So apparently Chris now has most posts than me.. I knew it would happen one day.. Need to get off IRC and back in to daythreads.

[Tellenta]

I don't know how I forgot this one:

I took the 30 posters with the most posts since 2011-07-02 and sorted them by the average number of posts to increase their rep by 1. Obviously the negative rep posters go to the bottom, not to the top

  Spoiler:

SELECT
	@rownum:=@rownum+1 AS rank,
	z.*
FROM (
	SELECT
		stats.user,
		stats.rep,
		stats.postcount,
		stats.nb AS 'average nb of posts to get 1 rep'
	FROM (
		SELECT
			u.username AS user,
			u.reputation AS rep,
			t.nb AS postcount,
			(t.nb / (u.reputation - 10)) AS nb
		FROM
			user u
		INNER JOIN (
			SELECT
				userid,
				COUNT(*) AS nb
			FROM
				post
			WHERE
				DATE(FROM_UNIXTIME(dateline)) >= '2011-07-02'
			GROUP BY
				userid
			ORDER BY
				nb DESC
		) t ON u.userid = t.userid
		WHERE
			u.posts >= 250
		ORDER BY
			t.nb DESC
		LIMIT 30
	) stats
	ORDER BY
		stats.nb ASC
	LIMIT 30
) z, (SELECT @rownum:=0) y

  Spoiler:

So apparently Chris now has most posts than me.. I knew it would happen one day.. Need to get off IRC and back in to daythreads.

You're only 522 posts from having two bubbles!!!

[Lief Siddhe]

inb4 faggots start giving out more reps in order to make it on the next iteration of this analysis

[Don Pellegrino]

inb4 faggots start giving out more reps in order to make it on the next iteration of this analysis

I'll try to remember to do it again in one year and I'll be only looking at rep and posts during that year and not since the beginning.

[Lief Siddhe]

inb4 faggots start giving out more reps in order to make it on the next iteration of this analysis

I'll try to remember to do it again in one year and I'll be only looking at rep and posts during that year and not since the beginning.

It has already started, rep received

Thread:Investigating the reputation system & stats porn
faggot checking in
July 14 2012 07:47:56 PM
marcus xero

[marcus xero]

inb4 faggots start giving out more reps in order to make it on the next iteration of this analysis

I'll try to remember to do it again in one year and I'll be only looking at rep and posts during that year and not since the beginning.

It has already started, rep received

Thread:Investigating the reputation system & stats porn
faggot checking in
July 14 2012 07:47:56 PM
marcus xero

edit: ive picked up a bitter stalker l.o.l

[Tellenta]

inb4 faggots start giving out more reps in order to make it on the next iteration of this analysis

I've been handing out a lot of rep lately, there is only one other FHCer that knows why. This will continue until my next target for a mini forum game is accomplished.

[tHornton]

inb4 faggots start giving out more reps in order to make it on the next iteration of this analysis

I'll try to remember to do it again in one year and I'll be only looking at rep and posts during that year and not since the beginning.

It has already started, rep received

Thread:Investigating the reputation system & stats porn
faggot checking in
July 14 2012 07:47:56 PM
marcus xero

edit: ive picked up a bitter stalker l.o.l

if u dont wna show up on next stats porn as biggets negrep circlejerk thats ur own loss

[kzig]

Please could we have a ranking by posts per point, counting + or - rep as the same?

[Don Pellegrino]

Please could we have a ranking by posts per point, counting + or - rep as the same?

Not sure if I understand. List of posts by the amount of rep received, no matter what kind of rep?

[Traxio Nacho]

inb4 faggots start giving out more reps in order to make it on the next iteration of this analysis

I'll try to remember to do it again in one year and I'll be only looking at rep and posts during that year and not since the beginning.

It has already started, rep received

Thread:Investigating the reputation system & stats porn
faggot checking in
July 14 2012 07:47:56 PM
marcus xero

edit: ive picked up a bitter stalker l.o.l

if u dont wna show up on next stats porn as biggets negrep circlejerk thats ur own loss

Been drinking?

[kzig]

Please could we have a ranking by posts per point, counting + or - rep as the same?

Not sure if I understand. List of posts by the amount of rep received, no matter what kind of rep?

Sorry, should have phrased that as postcount / number of times repped (ignoring whether good or bad rep). i.e. who writes the most posts that attract the least attention.

Edit: on reflection, perhaps it would be better to do this as postcount / (number of times repped + 1) to allow for people who have never received any rep at all.

[Loire]

You have given out too much Reputation in the last 24 hours, try again later.

[marcus xero]

You have given out too much Reputation in the last 24 hours, try again later.

[marcus xero]

double post of fail

[Lana Torrin]

double post of fail

Diluting your own stats?!

[NoirAvlaa]

Stats on who does the most doubleposts?

[ctrlchris]

stats on the most empty quoting