PDA

View Full Version : Stats on Majestic12



PY 222
12-12-2005, 03:19 PM
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.

Bok
12-12-2005, 03:25 PM
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

PY 222
12-12-2005, 09:36 PM
Thanks Bok.

Any chance of adding this project to the DCr and also the stats signature?

Bok
12-12-2005, 09:50 PM
I will, just got a couple of other things I'm taking care of first.... :)

like

this (http://devel.open-dc.org/new/userstats.php?proj=rah&name=4477)

and

this (http://devel.open-dc.org/new/teamstats.php?proj=rah&team=Free-DC)

graphs are being tweaked for size right now...

I'll get the majestic12 stuff in the sigs and dcr tomorrow though.

Bok

PY 222
12-12-2005, 09:54 PM
:woot:

More stats!!!!!

I could kiss you right now, but I won't. I'll leave that to your wife ;) :thumbs: