View Full Version : Team stats
vigge_sWe
09-13-2008, 05:24 AM
Is it possible to get team stats on projects? Like, you write in the team id for every project and get stats for those projects in one image?
It's certainly possible (and quite easy), but I've never coded it.
Let me see what we can come up with.
paleseptember
09-13-2008, 08:48 AM
Go Bok! Go!
\o\ \o| |o| |o/ /o/
(Your own personal Mexican Wave :lmao:)
vigge_sWe
09-13-2008, 10:09 AM
It's certainly possible (and quite easy), but I've never coded it.
Let me see what we can come up with.
Wow that would be awesome.
gopher_yarrowzoo
09-14-2008, 10:56 AM
you mean like the individual ones that get done for each user but for the whole team, should be easy enough providing I can read off the data of something.
vigge_sWe
09-14-2008, 12:34 PM
you mean like the individual ones that get done for each user but for the whole team, should be easy enough providing I can read off the data of something.
ye, like it says:
teamname
project totalpoints
project2 totalpoints
outlnder
10-30-2008, 09:54 PM
Anyway of listing how many users each team has in total, all Boinc projects??
you mean a tally of distinct(users) across Boinc projects within a single team?
It's doable...but bear in mind it would take into account any slight variation on name..
Bok
p.s.
mysql> select count(distinct(nick)) from boinc_user a,boinc_team b where a.proj = b.proj and a.team0=b.id and b.team = 'Ars Technica';
+-----------------------+
| count(distinct(nick)) |
+-----------------------+
| 2380 |
+-----------------------+
1 row in set (0.25 sec)
outlnder
10-31-2008, 04:52 AM
Thanks, I was curious as to how many Arsians were still left.
Powered by vBulletin® Version 4.2.4 Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.