The new automatic stats (alpha test):
mysql_connect("127.0.0.1","root","") or die (mysql_error()); mysql_select_db("eseamembers") or die (mysql_error()); $sql = "SELECT * FROM members"; $boinccount=0; $seticount=0; $predcount=0; $climatecount=0; $lhccount=0; $pircount=0; $eincount=0; $burpcount=0; $orbitcount=0; $sztakicount=0; $messcount=0; $none=0; $project1=0; $project2=0; $project3=0; $project4=0; $project5=0; $project6=0; $project7=0; $project8=0; $project9=0; $project10=0; $boincoff=0; $setioff=0; $predoff=0; $climateoff=0; $lhcoff=0; $piroff=0; $einoff=0; $burpoff=0; $orbitoff=0; $sztakioff=0; $messoff=0; $status=mysql_query("$sql") or die (mysql_error()); while ($row = mysql_fetch_array($status)){ $boinccount++; $userproj=0; $boincoffcount=0; $memberid=$row["id"]; $Seti = "SELECT * FROM seti WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $seticount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $setioff++; } } $Seti = "SELECT * FROM predictor WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $predcount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $predoff++; } } $Seti = "SELECT * FROM climate WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $climatecount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $climateoff++; } } $Seti = "SELECT * FROM lhc WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $lhccount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $lhcoff++; } } $Seti = "SELECT * FROM pirates WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $pircount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $piroff++; } } $Seti = "SELECT * FROM einstein WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $eincount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $einoff++; } } $Seti = "SELECT * FROM burp WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $burpcount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $burpoff++; } } $Seti = "SELECT * FROM orbit WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $orbitcount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $orbitoff++; } } $Seti = "SELECT * FROM sztaki WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $sztakicount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $sztakioff++; } } $Seti = "SELECT * FROM mess WHERE memberid = $memberid ORDER BY id DESC"; $setistatus=mysql_query("$Seti") or die (mysql_error()); while ($setirow = mysql_fetch_array($setistatus)){ $messcount++; $userproj++; if ($setirow["official"]==1){ $boincoffcount++; $messoff++; } } if($userproj==0){ $none++; } } mysql_close() or die (mysql_error()); ?>All members:
This displays the share of users that participate in each project of all members in our member database. Some do not participate in any project at all, to our knowledge, some are not members of our team at the projects.
Fullblown members only:
This displays the share of fullblown members that participate in each project. Fullblown members means members that are a member of our team at every project they participate in (and NOT that they participate in all projects).