the team ranking for AMD Users is messed up, we only have 3 members on list but they are ranked 5th and 2 tied for 6th in team.
Printable View
the team ranking for AMD Users is messed up, we only have 3 members on list but they are ranked 5th and 2 tied for 6th in team.
hmmm, very strange.
I'll take a look when I get a chance..
bump****
any news yet?:couchsleep:
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.
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
I wondered why it only seamed to effect my team...
thank and great job as usual. :yourock:
:allhail: