[Admin]

Ok, here's the query for showthread.php:

$refcounts = $DB_site->query("
	SELECT COUNT(*) AS referrals,user.userid
	FROM user AS users
	LEFT JOIN user ON (users.referrerid=user.userid)
	WHERE users.referrerid<>0
	AND user.userid IN ($postuserids)
	GROUP BY users.referrerid
");

$referrals = array(0 => 0);
while ($refcount = $DB_site->fetch_array($refcounts)) {
	$referrals[$refcount['userid']] = $refcount['referrals'];
}

BEFORE doing that, you need to change the part invloves $getpostids to also catch the userid's of the posts, and store then in a comma separated list $postuserids that starts with 0: "0,3,7,23,75,12"