Referers and top 10 posts

[The Realist]

Within vBulletin under members/top 10 Posters is there a way or a hack that shows the 10 best Referers.

If there a top 10 posters so why not one for the top 10 referers, might give an Insentive to find new members with there name in lights.



Thanks,

Brian

Kevin (Tubedogg) actually came out with a Top 10 Posters script, that if you modify it correctly can pull off what you need.

If you go get that script, I think that changing this line :

PHP Code:

$postsresult = mysql_query("SELECT username,posts,userid FROM user $exn ORDER BY posts desc LIMIT 0,$maxposters") or die("Unable to complete query"); 


where it says posts (2 times) change that to referrerid .. then again it might not work... I might play with it later tonight... as soon as I get a couple of other things done.

Hard for me to test though, hehe I none of my ohh 10 members have refferals

[Freddie Bingham]

You will have to GROUP BY to get referrer totals. Refer to the code in admin/user.php (I believe) for help.

[The Realist]

Thanks guys forn your help but I have not one clue on what to look for regarding user.php file or how to us eit to get this little problem I have to get to work.

Is there anyone who can perhaps show me or who is willing to sort the right script I need.

Thanks,