Results 1 to 5 of 5

Thread: Stats on Majestic12

  1. #1
    Keeper of the Fridge PY 222's Avatar
    Join Date
    Jul 2002
    Location
    San Jose, CA
    Posts
    2,706

    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.

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    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

  3. #3
    Keeper of the Fridge PY 222's Avatar
    Join Date
    Jul 2002
    Location
    San Jose, CA
    Posts
    2,706
    Thanks Bok.

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

  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    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

  5. #5
    Keeper of the Fridge PY 222's Avatar
    Join Date
    Jul 2002
    Location
    San Jose, CA
    Posts
    2,706


    More stats!!!!!

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

Posting Permissions

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