Investigating the reputation system & stats porn | Final update

[cullnean]

oh fuck, turns out im some kinda of subliminal spaz fanboy

[Spaztick]

oh fuck, turns out im some kinda of subliminal spaz fanboy

(USER WAS BANNED FOR THIS POST)

[marcus xero]

I am on lists for everything

[cullnean]

oh fuck, turns out im some kinda of subliminal spaz fanboy

+reped

fuck!

[Airow]

Jolin fanboy reporting in

[ChaeDoc II]

Browsed the lists and notice I'm not in the better lists. If i was i'd be all like "like a fucking boss", but I'm not, so fuck you all.

[Don Pellegrino]

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

[cullnean]

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 herschal is a cunt who needs to average 1000+post to gain rep?

if thats not the case hes still a cunt anyway

[indi]

excellent post, and a bit of anal-retentive correction. Indi and Mynxee is, as far as i know, females and yet you lump them in with the "guys"

There's at least one more hidden in that list.. gogogogo, find her

Also, Don is a modern guy. No need for women's lib with dudes like him around - we are part of the guys!

[EntroX]

oh fuck, turns out im some kinda of subliminal spaz fanboy

(USER WAS BANNED FOR THIS POST)

i warned you

[Airow]

What are the 'titles' for rep?

will be famous soon enough
shining bacon of light etc etc...

bumping this because I too am curious

[Phrixus Zephyr]

[Joe Appleby]

What are the 'titles' for rep?

will be famous soon enough
shining bacon of light etc etc...

bumping this because I too am curious

Hover your mouse over the green or red pip under your name.

[Morax Marbas]

Bitter people in being bitter nonshock

Nice Stats btw.

[Omega Supreme]

What are the 'titles' for rep?

will be famous soon enough
shining bacon of light etc etc...

bumping this because I too am curious

Famous
Name known to all
Shining Beacon of light
Off the Scale

Those're the ones for +20 rep I've seen. 1-10 has unknown quantity, -1 has can only hope to improve.

[Aurora148]

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

yay i'm finally on a list

I'm surprised that spaztick isn't on the most bitter list after the month he spent negrepping every post I made

[Frug]

Fight of the titans...

Jolin posts once with like 10 images per post.

Krans shitposts with one image per post.

So that list is gonna be way off. You need the total count of occurrences of [img

[KathDougans]

What are the 'titles' for rep?

will be famous soon enough
shining bacon of light etc etc...

vbulletin default would appear to have these:

  Spoiler:

Entrox has probably modified some of the titles, or added some, and has definitely modified the amounts required.

i.e. Quackbot has a rep title iirc of "off the scale", which doesn't appear in that pic.

[Don Pellegrino]

excellent post, and a bit of anal-retentive correction. Indi and Mynxee is, as far as i know, females and yet you lump them in with the "guys"

There's at least one more hidden in that list.. gogogogo, find her

Also, Don is a modern guy. No need for women's lib with dudes like him around - we are part of the guys!

I find it a bit pathetic to always have to add the female equivalent, I'm sure most women appreciate not being treated differently by guys because they have tits. Of course it's different in a formal context.

Fight of the titans...

Jolin posts once with like 10 images per post.

Krans shitposts with one image per post.

So that list is gonna be way off. You need the total count of occurrences of [img

As I said, number of posts that contain at least an image, not number of images.

so herschal is a cunt who needs to average 1000+post to gain rep?

if thats not the case hes still a cunt anyway

He gets a lot of both +rep and -rep, so to increase the total by 1 takes forever. 2200 posts divided by (12-10) [the starting 10 rep] = 1100

[Varcaus]

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

Yay I see my name.