Log in

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?

Bok
09-13-2008, 08:31 AM
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??

Bok
10-30-2008, 11:31 PM
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.