Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: WUProp Hours Stats Comparisons

  1. #1
    Platinum Member
    Maxwell's Avatar
    Join Date
    October 25th, 2010
    Location
    Everett, WA
    Posts
    3,300

    WUProp Hours Stats Comparisons

    Spoken from someone obsessive, I know...

    So, unless I'm blindly retarded (which is certainly possible), I can't find any way to compare hours stats across people like we do with credits. Even something simple like the Mega Milestones for WUProp hours (which is all the WUProp badge is, anyway), would be awesome. I'd like a way to see how I stack up against other people without having to go to individuals' stats pages and look. Something like the ability to find out "Maxwell has 107 applications with at least 100 hours, ranking him XXX on the team and XXX in the world."

    Is this out there and findable?

  2. #2
    Advisor - Stateside Division
    Bok's Avatar
    Join Date
    October 14th, 2010
    Location
    Wake Forest, NC
    Posts
    1,211

    Re: WUProp Hours Stats Comparisons

    I could do that easily enough, but remember it's only based on users who have switched on their flag at WuProp to allow the hours data to be exported.

    One quick sql

    Code:
    mysql> select a.id,b.nick, count(*) as mycount from wuprop_hours a join stats.boinc_user b where b.proj = 'wup' and a.id = b.id and a.running0 > 100 group by a.id order by mycount desc limit 0,50;+------+-------------------------------+---------+
    | id   | nick                          | mycount |
    +------+-------------------------------+---------+
    |  797 | zombie67 [MM]                 |     242 |
    | 2482 | LCB001                        |     207 |
    | 1169 | Coleslaw                      |     188 |
    | 5500 | Bryan                         |     167 |
    | 6346 | Steve Hawker*                 |     165 |
    |   68 | vaughan                       |     163 |
    |  276 | KAMCOBILL                     |     161 |
    |  747 | Jeff17                        |     158 |
    | 1504 | TBirdTheYuri                  |     157 |
    | 2536 | james ying                    |     156 |
    | 4230 | Sphynx[BlackOps]              |     151 |
    |  509 | Conan                         |     151 |
    | 1105 | arkiss                        |     147 |
    | 4492 | cpuid                         |     145 |
    | 6136 | Bazooka_CZ                    |     145 |
    | 1500 | Sabroe_SMC                    |     144 |
    |  846 | [SG]MichaelR.                 |     139 |
    | 6971 | JagDoc                        |     139 |
    | 3134 | fthibaud0001                  |     138 |
    |   84 | Bok                           |     138 |
    | 1882 | B Johansson                   |     137 |
    | 2826 | Dirk Broer                    |     136 |
    | 2317 | morgan                        |     136 |
    |  995 | Sir Stooper                   |     132 |
    |  825 | HGW                           |     130 |
    |  807 | 7ri9991 [MM]                  |     128 |
    | 2439 | L@MiR                         |     125 |
    | 1912 | PanStaszek                    |     125 |
    | 1039 | DoctorNow                     |     125 |
    | 7207 | Werinbert                     |     124 |
    | 4209 | aborek                        |     124 |
    |  795 | Mumps [MM]                    |     123 |
    | 6439 | georg70                       |     123 |
    | 4494 | eisler jiri                   |     123 |
    | 7257 | conf [MM]                     |     122 |
    | 2542 | [AF>France>Astro]Spica        |     122 |
    | 1739 | [AF>Libristes] Pascal         |     121 |
    | 7558 | [AF>Amis des Lapins] Phil1966 |     121 |
    | 2101 | Pete Broad                    |     118 |
    |  562 | Cruncher Pete                 |     118 |
    | 6100 | Roadranner                    |     116 |
    | 3123 | anchedo                       |     116 |
    | 1640 | [AF>Kirass>MPF] Nafrayou      |     115 |
    | 6277 | krezol                        |     114 |
    | 2978 | Fabrice.ltn                   |     113 |
    |  784 | [AF] Hildor                   |     110 |
    | 2479 | skgiven                       |     108 |
    |  728 | frankhagen                    |     107 |
    | 2762 | [AF>Libristes]IxPo            |     107 |
    |  801 | Maxwell [MM]                  |     107 |
    +------+-------------------------------+---------+
    50 rows in set (0.28 sec)

  3. #3
    Platinum Member
    Maxwell's Avatar
    Join Date
    October 25th, 2010
    Location
    Everett, WA
    Posts
    3,300

    Re: WUProp Hours Stats Comparisons

    Quote Originally Posted by Bok View Post
    I could do that easily enough, but remember it's only based on users who have switched on their flag at WuProp to allow the hours data to be exported.
    You are awesome, Bok! And yes - I knew that regarding exporting. I just think it's fun tracking and comparing numbers, and I didn't have a good way to do that for WUProp hours. Thanks!

  4. #4
    Advisor - Stateside Division
    Bok's Avatar
    Join Date
    October 14th, 2010
    Location
    Wake Forest, NC
    Posts
    1,211

    Re: WUProp Hours Stats Comparisons

    Have a think about what you'd like to see and I'll try and make it happen... but yeah, I think these could even be new MM categories...

  5. #5
    Platinum Member
    Maxwell's Avatar
    Join Date
    October 25th, 2010
    Location
    Everett, WA
    Posts
    3,300

    Re: WUProp Hours Stats Comparisons

    Quote Originally Posted by Bok View Post
    Have a think about what you'd like to see and I'll try and make it happen... but yeah, I think these could even be new MM categories...
    What I'm envisioning is a box on your individual WUProp page that has "WUProp Mega Milestone" almost exactly like what you see on the individual stats pages. Like with the MM tables, under the "type" column, there would be links to the counts for everyone, and links to counts within the team under the "RankT" column.

    Code:
    Type     Many      RankT          RankP
    1M Hrs    x           x            x
    500k Hrs  x           x            x
    250k Hrs  x           x            x
    100k Hrs  x           x            x
    50k Hrs   x           x            x
    25k Hrs   x           x            x
    10k Hrs   x           x            x
    5k Hrs    x           x            x
    2.5k Hrs  x           x            x
    1k Hrs    x           x            x
    500 Hrs   x           x            x
    250 Hrs   x           x            x
    100 Hrs   x           x            x

  6. #6
    Diamond Member
    zombie67's Avatar
    Join Date
    October 24th, 2010
    Location
    Reno, NV
    Posts
    7,381

    Re: WUProp Hours Stats Comparisons

    Code:
    | id   | nick                          | mycount |
    +------+-------------------------------+---------+
    |  797 | zombie67 [MM]                 |     242 |
    Awwwww yeeeeeeeeea!
    "Don't confront me with my failures, I had not forgotten them" - Jackson Browne

    Avatar source


  7. #7
    Platinum Member
    Maxwell's Avatar
    Join Date
    October 25th, 2010
    Location
    Everett, WA
    Posts
    3,300

    Re: WUProp Hours Stats Comparisons

    Quote Originally Posted by zombie67 View Post
    Code:
    | id   | nick                          | mycount |
    +------+-------------------------------+---------+
    |  797 | zombie67 [MM]                 |     242 |
    Awwwww yeeeeeeeeea!
    Of course, the last thing we need is more categories where zombie67 is in the lead by a ginormous margin...

  8. #8
    Advisor - Stateside Division
    Bok's Avatar
    Join Date
    October 14th, 2010
    Location
    Wake Forest, NC
    Posts
    1,211

    Re: WUProp Hours Stats Comparisons

    well..

    Code:
    mysql> select a.id,b.nick, count(*) as mycount from wuprop_hours a join stats.boinc_user b where b.proj = 'wup' and a.id = b.id and a.running0 > 100000 group by a.id order by mycount desc limit 0,50;+------+-------------------------------+---------+
    | id   | nick                          | mycount |
    +------+-------------------------------+---------+
    |  795 | Mumps [MM]                    |      18 |
    |  857 | [SG-FC] hl                    |       8 |
    | 7422 | tng*                          |       6 |
    | 1608 | Bikermatt                     |       5 |
    | 1535 | ..:: Thor ::..                |       5 |
    | 1912 | PanStaszek                    |       4 |
    | 6957 | Sylvester@Planet 3Dnow!       |       3 |
    | 8445 | Grandpa                       |       3 |
    | 6433 | PERPLEXER ~ Thomas Huettinger |       3 |
    | 6971 | JagDoc                        |       3 |
    | 5500 | Bryan                         |       2 |
    | 7222 | Gandalf_the_Grey              |       2 |
    | 2482 | LCB001                        |       2 |
    | 6154 | guiyuan                       |       2 |
    |  797 | zombie67 [MM]                 |       1 |
    | 1169 | Coleslaw                      |       1 |
    | 2536 | james ying                    |       1 |
    | 6467 | leprechaun                    |       1 |
    | 6736 | JugNut                        |       1 |
    | 4971 | ArcSedna                      |       1 |
    | 1953 | bundaboy                      |       1 |
    | 7306 | Perry Maskell                 |       1 |
    |  631 | Mad Matt                      |       1 |
    +------+-------------------------------+---------+
    23 rows in set (0.09 sec)

  9. #9
    Platinum Member
    Maxwell's Avatar
    Join Date
    October 25th, 2010
    Location
    Everett, WA
    Posts
    3,300

    Re: WUProp Hours Stats Comparisons

    Yeah - he's the other one.

  10. #10
    Platinum Member
    Mumps's Avatar
    Join Date
    October 28th, 2010
    Location
    Milwaukee, WI
    Posts
    4,002

    Re: WUProp Hours Stats Comparisons

    Quote Originally Posted by Bok View Post
    well..

    Code:
    mysql> select a.id,b.nick, count(*) as mycount from wuprop_hours a join stats.boinc_user b where b.proj = 'wup' and a.id = b.id and a.running0 > 100000 group by a.id order by mycount desc limit 0,50;+------+-------------------------------+---------+
    | id   | nick                          | mycount |
    +------+-------------------------------+---------+
    |  795 | Mumps [MM]                    |      18 |
    +------+-------------------------------+---------+
    23 rows in set (0.09 sec)
    Awwwww yeeeeeeeeea!

    I can't believe that there's still a chance to be the first person ever with a 100K Hours star...

Page 1 of 2 12 LastLast

Posting Permissions

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