Display top referrer on forum index

This was requested by PeterNRG and actually hacked by Freddie (but it's my thread ).

1. In index.php find

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


and above it add

PHP Code:

// get top referrer
if ($usereferrer) {
  $ref = $DB_site->query_first("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
                   LEFT JOIN user ON (users.referrerid = user.userid)
                   WHERE users.referrerid <> 0 AND
                   user.userid NOT IN (1,5,7)
                   GROUP BY users.referrerid
                   ORDER BY referrals DESC
                   LIMIT 1");

  eval("\$topreferrer = \"".gettemplate('topref')."\";");
} 


2. Create a new template called topref. In this template, you can use $ref[referrals] (number of referrals), $ref[username] (for the top referrar's username) and $ref[userid] (for top referrar's user ID).
For example:

Top referrer of this forum: <b><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$ref[userid]">$ref[username]</a></b> with <b>$ref[referrals]</b> referrals

3. Add an index to field referrerid in table user.

4. Place $topreferrer wherever you want the topref template to be displayed.

That's it. Demo can be found here.

Good luck, and thank freddie!

[mfacer]

great hack.. got it to work perfectly!! (2.3.2)

maybe another good hack would be to show the top 10 referrers and their referral count?

I'm gonna try it, but if someone else has already done it, that'd be super!!

www.yu-gi-oh-online.co.uk/forum/

[Riot-Boards]

Wow! I the code above actually made it work, fix your codes!

Nice Job!

[bigdaddy04]

does this have to be on index? what if I want to have this on a new template that I made?