Referrals In Postbit Template

I am not a master hacker *lol* and I spent a while trying to figure out how to get this damn thing to work!

Requested By : Mist

What Does It Do?
Simply allows you to use $referrals in the postbit template. This will display the users total number of referrals.

Hack temporarily Retracted

[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"

[Sadie Frost]

Okay - non-hacker here (notice hacks=0 ) so I'm sure this is a really stupid statement, but in any case - if referrals is already displayed when you view profile, isn't there a way to "copy" whatever it is that makes the profile display the number to the postbit?

[Matt]

lol - No Sadie That would be way too easy

[Dean C]

lol this hack must be the hardest hack to make ...

sure is creatin a few problems for people ...

[Matt]

I don't think its that its hard, its just that I am clueless. I know some PHP but not loads and so I am still having to look things up and try and understand them

[Sadie Frost]

Originally posted by Matt
lol - No Sadie That would be way too easy

Yeah, that's what I figured...

[Admin]

Matt, I posted 80% of the hack in my pervious post, you can figure the rest out I'm sure.