i need to know who has the most friends on my site

i am running a contest right now with who brings the most people and get them to be friend them. I thought there was a way to track who has the most friends on the site by a certain date wins. is there a way to track this or a module for tracking this. i really need to find out this information. please email me chuey@cincityrocks.com 

[Zarcon: All Content removed]

are you serious. i have had this post up for a while and there is no way of telling who has the most friends on their site. 

 If you take a look into your site database, the "Profiles" has only "Rate" and "Ratecount" and I think those only have to do with who is most popular..

There in no field for how many friends one has.

[edit] The easiest thing to do would be, "Who can get the most profile votes.."

that is displayed on the index page and already tracked.

Also, have you browsed the market?

http://www.boonex.com/m/Ultimate_Referrals

or something along the lines..

hmm! you want to know the count for friends someone made

1. by sending request

or

2.by receiving request

or

3.by any way doesn't matter just users with most friends.

??

Agreed. Dolphin does not have a built-in running total of friends a member has, so the only way to do that would be to write a script that loops through each member and counts their friends and displays the one with the highest count. And that would have to be a script that you would run only once in a while because doing that kind of counting will put a serious load on the database server.

 First I got the same thing in mind but then i realized that a site with 1000s members and doing this will be database suicide. If you want to do it you need to decrease load and need a powerful server. I tried few mysql query but the max that could be done is to count the request send by a user or received but not both.:(