MyBB Community Forums

Hi guys,

For a contest, I need to view the members with the highest referral count.. How can I do this?

Try this: http://yaldaram.com/showthread.php?tid=300

Or if you need to show top referrals as a separate box on index or any where else, let me know and I'll write a quick plugin for you.

No no - I need to personally (myself) see who on my forum has the highest referral count. I don't need others to see it, I need to know for a contest.

You'll need to run a SQL query in phpMyAdmin.

Try this: http://mybbhacks.zingaburga.com/showthread.php?tid=767

Can you tell me the query please?

I've added that plugin - however it doesn't show. :\

How to run SQL queries in phpMyAdmin: http://community.mybb.com/thread-4720.html

Once you get there, run the following query:

SELECT * FROM `mybb_users` ORDER BY `referrals` DESC

The first result in the table will be the one with the highest referral count.