-
Keeper of the Fridge
Stats on Majestic12
Bok, I was wondering why is Free-DC ranked 6th on our Free-DC stats but the Majestic12 stats show that we are 4th overall?
Just curious.
-
Administrator
It's because I'm calculating the team totals from the sum of the users totals (which may well be wrong, and I should change it..)
mysql> select team0,sum(metric1) as total from maj_user group by team0 order by total desc;
+---------------------+-----------+
| team0 | total |
+---------------------+-----------+
| | 674167922 |
| Team Canada | 426167364 |
| AMD Users | 360116540 |
| Team Kansas | 292245454 |
| X Grubbers Kick Ass | 261115500 |
| team lazytom | 260751208 |
| Free-DC | 192942450 |
| Busy nerds | 175215092 |
| Team Finland | 138542385 |
| Team Europe | 108886555 |
| 256/64Kbps | 107306388 |
| Team Iowa | 89059734 |
| TeAm AnandTech | 65032137 |
| Team Magion | 48976227 |
| Knights Who Say Ni! | 24129429 |
| Team Ninja | 17458333 |
| Team France | 16240000 |
| FBK | 13189239 |
| Seti.nl | 8752029 |
| Info Sharkz | 8594403 |
| Ars Technica | 7400000 |
| Rechenkraft.net | 5899906 |
| Team Deutschland | 300000 |
| Crunchers Inc | 280000 |
| DC-Gemeinschaft | 20000 |
+---------------------+-----------+
25 rows in set (0.00 sec)
It might be that you can't do this, like in sob. I'll switch it to use the team_total.csv scores instead. It might make the totals look screwy for a while though...
Bok
-
Keeper of the Fridge
Thanks Bok.
Any chance of adding this project to the DCr and also the stats signature?
-
Administrator
I will, just got a couple of other things I'm taking care of first....
like
this
and
this
graphs are being tweaked for size right now...
I'll get the majestic12 stuff in the sigs and dcr tomorrow though.
Bok
-
Keeper of the Fridge
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules