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?
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)
Re: WUProp Hours Stats Comparisons
Quote:
Originally Posted by
Bok
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!
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...
Re: WUProp Hours Stats Comparisons
Quote:
Originally Posted by
Bok
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
Re: WUProp Hours Stats Comparisons
Code:
| id | nick | mycount |
+------+-------------------------------+---------+
| 797 | zombie67 [MM] | 242 |
Awwwww yeeeeeeeeea!
Re: WUProp Hours Stats Comparisons
Quote:
Originally Posted by
zombie67
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... =))
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)
Re: WUProp Hours Stats Comparisons
Yeah - he's the other one. ;)
Re: WUProp Hours Stats Comparisons
Quote:
Originally Posted by
Bok
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...