most top 10's

[Liuqyn]

the team ranking for AMD Users (http://stats.free-dc.org/stats.php?page=mmakers&subproj=pranktop10&team=AMD+Users) is messed up, we only have 3 members on list but they are ranked 5th and 2 tied for 6th in team.

[Bok]

hmmm, very strange.

I'll take a look when I get a chance..

[Liuqyn]

bump****

any news yet?:couchsleep:

[Bok]

is it broken again? It fixed itself when I last started to look into it, so I couldn't reproduce it. If it's broken again now, I'll have a look.

[Bok]

ha, fixed it!!

Quite an obscure little bug that one, caused by AMD Users being first in the list when ordered by team in this particular case, though there is a few users where team=NULL that come before hand, and seeing as I set a variable for @team=NULL it basically never reset my counter after getting to the first legitimate team...

So adding a 'and team IS NOT NULL' to the sql corrected it. I've re-ran the script to generate all of the 'most' data and it's correct now, thoug I see some pages still cached from the old values which will not last more than 30mins or so...

Bok

[Liuqyn]

I wondered why it only seamed to effect my team...

thank and great job as usual. :yourock:


:allhail: