Top Referrals

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.