Top Referrals

[Snoop Dogg]

How about a hack that displays the people with the top refferals? Like the top posters.

$users = $DB_site->query("SELECT COUNT(*) AS count, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid
ORDER BY count DESC");

Thanks, so I just insert this code where I want it to appear in any of the vB files?

You have to fetch the $users variable and run it through a while loop but I have you the important part.