Top Referrer In Forum Statistic
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #2
RE: Top Referrer In Forum Statistic
Nice simple mod RateU Smile

I might suggest adding a secondary sort, eg by referrals, then by uid (or maybe registration date) since it's not exactly known what would happen with two people with the same number of referrals.  Not really an issue, but might help be a bit more consistent.
Maybe also stick an index on the referrals column when activating the plugin (or if you decide to sort by referrals then uid, make a composite index KEY(referrals,uid) ).  Alternatively, you could cache the user with most referrals.
Hope that helps, and thanks for sharing!

My Blog
03-19-2011 04:09 PM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
Top Referrer In Forum Statistic - RateU - 03-19-2011, 07:31 AM
RE: Top Referrer In Forum Statistic - ZiNgA BuRgA - 03-19-2011 04:09 PM

 Standard Tools
Forum Jump: