<?
function tab_cal($result) {
  $nombre=mysql_num_fields($result);
  for ($jour=1; $jour<64; $jour++) {
    $present[$jour]=0;
  }
  $nuitees=0;

  $row=0;
  while (mysql_fetch_row($result))
    {
      $name  = @mysql_result($result,$row,0);
      $firstname  = @mysql_result($result,$row,1);
      $email  = @mysql_result($result,$row,2);
      $institution = @mysql_result($result,$row,3);
      $url= @mysql_result($result,$row,4);
      $vapproxstay= @mysql_result($result,$row,7);
      $arrlum=  @mysql_result($result,$row,5);

      $deplum=  @mysql_result($result,$row,6);
      $daydep=@mysql_result($result,$row,9);
      $dayarr=@mysql_result($result,$row,8);
      $typechambre=@mysql_result($result,$row,10);
      if (strcmp($typechambre,'N')!=0) {
	for ($jour=1; $jour<63; $jour++) {
	  if (($dayarr<$jour+182)&($daydep>$jour+181)) {
	    $present[$jour]+=1;
	    $nuitees+=1;}
	}
      }
      $vdate="<BR>";
      if (strcmp($arrlum,"0000-00-00")!=0) {
	$vdate=substr($arrlum,5,2)."/".substr($arrlum,8,2)." - ";
      }

      $deplum=  @mysql_result($result,$row,6);
      if (strcmp($deplum,"0000-00-00")!=0) {
	$vdate.=substr($deplum,5,2)."/".substr($deplum,8,2);
      }


      if ( (strcmp($vapproxstay,"NC")!=0)&&( strlen(  $vapproxstay)!=0) ) {
	$vdate.=   " (". $vapproxstay .")";
      }
      $row += 1 ;
      echo "<TR BGCOLOR=KHAKI>";
      if ( (!strcmp($url,"NC"))|(!$url)) {
	echo "<TD>$row</TD><TD BGCOLOR=KHAKI>
             <A HREF=MAILTO:$email><FONT SIZE=-1>$name</FONT></A></TD>
             <TD BGCOLOR=KHAKI><FONT SIZE=-1>$firstname</FONT></TD>
             <TD BGCOLOR=KHAKI> <FONT SIZE=-1>$institution</FONT></TD>
             <TD>$arrlum</TD><TD>$deplum</TD><TD>$typechambre</TD></TR>";
      }
      else {
	if (!strstr($url,"http")) $url="http://".$url;
	echo "<TD>$row</TD><TD BGCOLOR=KHAKI>
             <A HREF=MAILTO:$email><FONT SIZE=-1>$name</FONT></A></TD>
             <TD BGCOLOR=KHAKI> <FONT SIZE=-1>$firstname</FONT></TD>
             <TD BGCOLOR=KHAKI><A HREF=$url><FONT SIZE=-1>$institution</FONT></A></TD>
             <TD>$arrlum</TD><TD>$deplum</TD><TD>$typechambre</TD></TR>";
      }
    }
  echo "</TABLE>";
  @mysql_free_result($result);
  @mysql_close($res) ;
  $present[63]=$nuitees;
  return $present;
}
include("top.php3");?>

<? 
//include("debtable.php3");
$sel="luminy";
$categ="all";
?>
<B><FONT FACE="Lucida,Verdana,Helvetica,Arial">
<CENTER><FONT COLOR="#009900">CEMRACS 2005</FONT><BR>
<FONT COLOR="#3366FF">
In
<A HREF=http://www.cirm.univ-mrs.fr/>CIRM</A><BR>
Euromech colloquium : 
July 18 - July 20.<BR>
Summer school : 
July 21 - July 25.<BR>
Research projects : July 25 - August 26.<BR>
</FONT></FONT></B>
List of participants (cat: <?print($categ);?>)    
<?
//echo "appel de mysql_func<br>";
include ("mysql_func.php3");
$lk=connect();
$db="cemracs05";
//echo $db;
echo "<TABLE BORDER=1 CELLPADDING='2' CELLSPACING='2' >";
echo "<TR BGCOLOR=PALEGREEN>";
echo "<TH><BR></TH><TH><FONT SIZE=-1>NAME</TH><TH><FONT SIZE=-1>FIRSTNAME</TH><TH><FONT SIZE=-1>INSTITUTION</TH><TH>ARRIVAL</TH><TH>DEPARTURE</TH><TH>LODGINGS</TH>";
echo "</TR>";
$sql="SELECT Name, Firstname,Email,Institution,Url,ArrDay,DepDay,ApproxStay,dayofyear(ArrDay),dayofyear(DepDay),TypeChambre FROM participants  ORDER BY Name";
if ($res=send_sql($db,$sql)) { $present=tab_cal($res); }
echo "</TABLE>";
include ("cal-juilletaout.php3");
calja($present,$pass);
?>
