Results 1 to 6 of 6

Thread: most top 10's

  1. #1

    most top 10's

    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.

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    hmmm, very strange.

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

  3. #3
    bump****

    any news yet?

  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    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.

  5. #5
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    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

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

    thank and great job as usual.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •