Great Job 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
Great Job Bok
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..
Waaaaaaaaaaitaminute!!!Originally Posted by Bok
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!
Birdman is correct,Originally Posted by Ken_g6[TA]
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
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)
hmm,
ok I'll fix.
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