Investigating the reputation system & stats porn | Final update

[Ralara]

Stats on most words written
Words to total posts (hi bart)
8th most common non-english character


Sent from my heart with all of my love using Ralatalka

[SAI Peregrinus]

Somehow I am on the list of top 30 for average number of posts to get 1 rep.
Clearly my shitposting skills are inferior.

[evil edna]

im not listed

all that shitposting for nothing

[Rexthor Hammerfists]

Theres a rep system? I should stop lurking and get posting then.

[Lana Torrin]

Stats on who does the most doubleposts?

Sup..

I have managed to do a double post via tapatalk (which has double post detection) 4 hours apart.

[NoirAvlaa]

Stats on who does the most doubleposts?

Sup..

I have managed to do a double post via tapatalk (which has double post detection) 4 hours apart.

Pro double poster is pro.

[marcus xero]

we are open for business

[ctrlchris]

we are open for business

no we're not

[Fitzy]

Only 82% Krans? I am dissapoint.

[Kransthow]

Only 82% Krans? I am dissapoint.

I occasionally post normally.

semi-ironically the thread I am most likely to not make an anime imagepost in is the anime thread.

we are open for business

no we're not

invite-only

[Mrenda]

I'd like to be in the rep cartel. If you give me one rep I'll give you two back. But only to cartel members who have signed up with a downpayment of 5 rep in the first place. The 5 rep is repayable on a drawback scheme over the life of Failheap Challenge. Reps not paid back at the end of the life of the forum go towards Calmdowns Coke and Hookers. Mrenda's Rep Payback Scheme is regulated by the Balistic Void's 'take them financiers for every penny I can' investments.

[Phrixus Zephyr]

Who is Calmdown?

[Sponk]

stats on the most empty quoting

[Spaztick]

stats on the most empty quoting

[ctrlchris]

Im surprised that took so long tbh

[Sponk]

My bad; I was busy goodposting elsewhere.

[Don Pellegrino]

Those 2 took just a few minutes each..

Number of infractions given per mod

  Spoiler:

SELECT
	@rownum:=@rownum+1 AS rank,
	z.*
FROM (
	SELECT
		u.username AS user,
		COUNT(*) AS nb
	FROM infraction i
	INNER JOIN user u ON i.whoadded = u.userid
	GROUP BY 
		i.whoadded
	ORDER BY
		nb DESC
) z, (SELECT @rownum:=0) y

Number of infractions and warnings received.

  Spoiler:

SELECT
	@rownum:=@rownum+1 AS rank,
	z.*
FROM (
	SELECT
		u.username AS user,
		COUNT(*) AS nb
	FROM infraction i
	INNER JOIN user u ON i.userid = u.userid
	GROUP BY 
		i.userid
	ORDER BY
		nb DESC
	LIMIT 30
) z, (SELECT @rownum:=0) y

Helen at #7


But these two took a lot of work because vB stores ignored users as a list of IDs in a text field, separated by spaces and MySQL doesn't have a split string function (and all the homemade MySQL functions on the internet are terrible).

Number of people that the user is ignoring

  Spoiler:

SELECT
	u.username AS user,
	t.ignorelist
FROM
	usertextfield t
	INNER JOIN user u ON t.userid = u.userid
WHERE
	LENGTH(t.ignorelist) > 0

followed by (in php)

  Spoiler:

function sort_nb_ignored($a, $b){
	if ($a["nb ignored"] > $b["nb ignored"])
		return -1;
	elseif ($a["nb ignored"] < $b["nb ignored"])
		return 1;
	else
		return 0;
}

$r = BD::run($value, BD::QUERY_SELECT);
foreach ($r as $key => $value){
	$r[$key]["nb ignored"] = sizeof(explode(" ", $value["ignorelist"]));
	unset($r[$key]["ignorelist"]);
}
usort($r, "sort_nb_ignored");
$r = array_slice($r, 0, 30);
$i = 1;
foreach($r as $key => $value){
	$r[$key] = Array("rank" => $i++, "user" => $value["user"], "nb ignored" => $value["nb ignored"]);
}
disp_array($r);

Most ignored users

  Spoiler:

SELECT
	u.username AS user,
	t.ignorelist
FROM
	usertextfield t
	INNER JOIN user u ON t.userid = u.userid
WHERE
	LENGTH(t.ignorelist) > 0

followed by (in php)

  Spoiler:

$u = BD::run("SELECT userid, username FROM user", BD::QUERY_SELECT);	
$users = Array();
foreach($u as $key => $value){
	$users[$u[$key]["userid"]] = $value;
}

$r = BD::run($value, BD::QUERY_SELECT);
$byname = Array();
foreach ($r as $key => $value){
	foreach (explode(" ", $value["ignorelist"]) as $key2 => $value2){
		if (isset($byname[$users[$value2]["username"]])){
			$byname[$users[$value2]["username"]]++;
		}else{
			$byname[$users[$value2]["username"]] = 1;
		}
	}
}
arsort($byname);
$i = 0;
$result = Array();
foreach ($byname as $key => $value){
	$result[$i++] = Array("rank" => $i, "username" => $key, "ignored by" => $value);
}
$result = array_slice($result, 0, 30);
disp_array($result);

[Lana Torrin]

26 on the infraction list (expected to be higher)
14 on the ignore list (also expected to be higher)..

Also.. Only 4 people are ignoring me?! WHO ARE THEY?! (I think Spank is one of them)

[lubica]

11 ppl ignoring Krans
BUT EVERYBODY LOVES KRANSTHOW

[Ralara]

Those 2 took just a few minutes each..

Number of infractions given per mod

LITERALLY HITLER


BAWHAHAHAHAHAHA


I WIN

I WIN

I WIN