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

:p

[BradC]

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 :


$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,