Results 1 to 10 of 10

Thread: Teams DCR bug....

  1. #1
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13

    Red face Teams DCR bug....

    I just found and fixed a fairly major bug in the calculation

    This has affected the scores fairly dramatically, but I think they are correct now.

    Let me try to explain for anyone interested

    I get the total score for all teams in the project also in the DCR. This is something like, for r5prp for instance (where I noticed the problem)

    select sum(a.metric1) from sob_team a,team_aliases b where a.team = b.sob and b.dcr = 'Y';

    Now there are only two teams with r5prp teams set up. Free-DC and X-Grubbers, so this should bring back the sum of their two scores... But because there is a team of spaces in r5prp (correctly as there is in a number of projects), this matches to many of the rows in team_aliases which are spaces, so skewing the scores downwards because of this..

    I added a condition to the where of ''and a.team <> '' to get around it..

    Bok

  2. #2
    Great Job Bok
    X Grubbers Kick Ass

    Check Out Our Site





  3. #3
    Free-DC Semi-retire gopher_yarrowzoo's Avatar
    Join Date
    Mar 2002
    Location
    Knoxville, TN
    Posts
    3,985
    Oh my I understood that I guess Im getting this SQL thing after all..
    Good Job Bok
    Semi-retired from Free-DC...
    I have some time to help.....
    I need a new laptop,but who needs a laptop when you have a phone...
    Now to remember my old computer specs..


  4. #4
    Former QueueMaster Ken_g6[TA]'s Avatar
    Join Date
    Nov 2002
    Location
    Colorado
    Posts
    184
    Quote Originally Posted by Bok
    ...Now there are only two teams with r5prp teams set up. Free-DC and X-Grubbers....
    Waaaaaaaaaaitaminute!!!

    If those are the only two teams with r5prp set up, how come AMD Users have 2 credits listed for r5prp? (And also s5prp?)

    (Since my team went from #2 to #4 , I'm looking for any looph - uh, I mean bugs I can find. )
    Proud member of the friendliest team around, Team Anandtech!
    The Queue is dead! (Or not needed.) Long Live George Woltman!

  5. #5
    Senior Member birdman2584's Avatar
    Join Date
    Jan 2005
    Location
    Louisville, KY
    Posts
    407
    there are more than 2 teams in those projects now...i think thats why your rank has changed.

  6. #6
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    Quote Originally Posted by Ken_g6[TA]
    Waaaaaaaaaaitaminute!!!

    If those are the only two teams with r5prp set up, how come AMD Users have 2 credits listed for r5prp? (And also s5prp?)

    (Since my team went from #2 to #4 , I'm looking for any looph - uh, I mean bugs I can find. )
    Birdman is correct,

    there are now 4 teams set up

    Free-DC
    AMD Users
    Rechenkraft.net
    X Grubbers Kick Ass

    If you look on TA's teampage here

    Do you have teams for any of the projects which show 0's ? If you have use the form to add them. If not.... well it might be beneficial to create a team You aren't too far behind AMD Users in the rankings.....

    Is there anything else I could add to the pages which would help track progress ?

    Bok

  7. #7
    Hi Bok,

    I don't know if this will help but here is the teams from stats pages:

    s5prp stats page

    rank teamname amount points
    1 Free-DC 89016 25514.542976
    2 Rechenkraft.net - Germany 10666 1494.780665
    3 Team Germany 5483 352.912819
    4 X Grubbers Kick Ass 246 46.358566
    5 CampusHafnia - Denmark 82 13.025394
    6 AMD Users 39 2.158892

    r5prp stats Page

    rank teamname amount points
    1 Free-DC 165706 26657.427621
    2 Rechenkraft.net - Germany 85172 16336.856182
    3 Team Germany 6113 607.967759
    4 X Grubbers Kick Ass 12 3.619504
    5 AMD Users 32 2.272482


    Our team was the seventh team created so there ia at least 7 team (some must not have points)
    X Grubbers Kick Ass

    Check Out Our Site





  8. #8
    Senior Member birdman2584's Avatar
    Join Date
    Jan 2005
    Location
    Louisville, KY
    Posts
    407
    Hey bok,

    The teams dcr doesnt appear to be working...at least it isnt showing up on my computer when taking the link from the main stats page. Thanks!

  9. #9
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    hmm,

    ok I'll fix.

    Bok

  10. #10
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    Fixed it. Seems like RenderFarm@Home have changed what they put in their team xml output. One of the metrics I keep is number of users, which they have dropped, causing a problem with my script which meant the teams had zero value.

    In the script which does all the computation for the DCR, this causes a divide by zero exception breaking the whole lot

    Fixed the original script to set it to zero if not found and added some code the DCR script to check for it being zero before trying the computation..

    Bok

Posting Permissions

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