ESEA's General Milestone Monitor
The General Milestone Monitor keeps track of the team and it's members reaching
pre-set milestones. Below is a list of milestones reached by the ESEA (Earth
Space Exploration Agency) team and it's members the last 7 days, both for BOINC
combined and the individual projects.
|
Date
|
Member
|
Project
|
Milestone
|
='".date("Y-m-d",$newdate)."') ORDER BY dato DESC";
$status=mysql_query("$sql") or die (mysql_error());
$datoarray=Array();
$memberarray=Array();
$projectarray=Array();
$milestonearray=Array();
$arraycounter=0;
while ($row = mysql_fetch_array($status)){
if($row['projectid']<>0){
$sql2="SELECT * FROM projects WHERE (id=".$row['projectid'].")";
$status2=mysql_query("$sql2") or die (mysql_error());
while ($row2 = mysql_fetch_array($status2)){
if($row2['hidden']==0){
$datoarray[$arraycounter]=$row['dato'];
$milestonearray[$arraycounter]=$row['milestone'];
if($row['team']==0){
$sql3="SELECT * FROM members WHERE (id=".$row['memberid'].")";
$status3=mysql_query("$sql3") or die (mysql_error());
while ($row3 = mysql_fetch_array($status3)){
$memberarray[$arraycounter]=$row3['Nick'];
}
}else{
$memberarray[$arraycounter]="The ESEA (Earth Space Exploration Agency) team";
}
$projectarray[$arraycounter]=$row2['projectname'];
$arraycounter=$arraycounter+1;
}
}
}else{
$datoarray[$arraycounter]=$row['dato'];
$milestonearray[$arraycounter]=$row['milestone'];
if($row['team']==0){
$sql3="SELECT * FROM members WHERE (id=".$row['memberid'].")";
$status3=mysql_query("$sql3") or die (mysql_error());
while ($row3 = mysql_fetch_array($status3)){
$memberarray[$arraycounter]=$row3['Nick'];
}
}else{
$memberarray[$arraycounter]="The ESEA (Earth Space Exploration Agency) team";
}
$projectarray[$arraycounter]="BOINC combined";
$arraycounter=$arraycounter+1;
}
}
for($x=0;$x".$datoarray[$x]." | ".$memberarray[$x]." | ".$projectarray[$x]." | ".$milestonearray[$x]." | ";
}
?>
|
|