How to find member that have referred most users.

[nirvana43]

May i know how to find member that have referred the most members.
Is there any code snippet available for this??

Like, if i want to display a top referrer (or find his uid/uname whatever), on custom page? how do i find that?

[Brother Malachi]

I guess you can run a query, grab all the users whose referid isn't empty, then sort it through an array.

PHP Code:

$users_rep_query = $db->query_read("SELECT referrerid FROM  " . TABLE_PREFIX . "user WHERE  referrerid IS  NOT  NULL");

$users_rep_sort = array();
while ( $users_rep_array = $vbulletin->db->fetch_array($users_rep_query) ) {
    $users_rep_sort[$users_rep_array['referrerid']]++;
}
arsort($users_rep_sort); 


The above will give you an array with userID's, sorted by # of referrals.
You just need to take the userID and convert it to a username.

[Brandon Sheley]

There are several stats mods that will show this, there is also a referral mod if this is all you want to see.

[tbrown7552]

<a href="http://www.yoursitehere.com/forum/admincp/usertools.php?do=referrers" target="_blank">http://www.yoursitehere.com/forum/ad...p?do=referrers</a>

[nirvana43]

Thanks a million guyes for help..
@Loco.M, yap thats exactly what i was looking for.
Referrer Stats..
Thanks a million