Teams DCR bug....

[Bok]

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

[KAMCOBILL]

Great Job Bok

[gopher_yarrowzoo]

Oh my I understood that I guess Im getting this SQL thing after all..
Good Job Bok

[Ken_g6[TA]]

...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. )

[birdman2584]

there are more than 2 teams in those projects now...i think thats why your rank has changed.

[Bok]

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

[KAMCOBILL]

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)

[birdman2584]

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!

[Bok]

hmm,

ok I'll fix.

Bok

[Bok]

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