<?php

/*
 * user/listproject.php
 * lists current projects of the user
 *
 */


//add by Isa on 08.09.2009: keep login info
if (isset($_COOKIE['login'])) { $login = strip_tags($_COOKIE['login']); } else { $login = ""; }
if (isset($_COOKIE['password'])) { $password = strip_tags($_COOKIE['password']); } else { $password = ""; }


require_once("../databases.php");
include("../sequencer.php");
require("../opendb.php");

require("checkpass.php");

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD>
<LINK rel="stylesheet" type="text/css" href="../sequencerstyle.css">
<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<META name="Author" lang="fr" content="Pierre Berthier">
<META name="keywords" lang="en"    content="">
<META name="keywords" lang="fr"    content="">
<META http-equiv="Pragma" content="no-cache">
<META http-equiv="Cache-Control" content="no-cache">
<META http-equiv="Cache-Control" content="must-revalidate">
<META http-equiv="Content-Script-Type" content="text/javascript">

<TITLE>CMPG sequencer - Open a Project</TITLE>
</HEAD>

<BODY><A NAME="TOP"></A>

<TABLE BORDER=0 WIDTH="100%">
<TR>
<TD ALIGN=LEFT VALIGN=BOTTOM>
<A HREF="http://www.unibe.ch" TARGET=BLANK><IMG SRC="../images/unibern_logo.gif" BORDER=0></A>&nbsp;
<A HREF="http://cmpg.unibe.ch" TARGET=BLANK><IMG SRC="../images/new_banner_CMPG_Panorama_s3.jpg" BORDER=0></A>
</TD>
<TD ALIGN=RIGHT VALIGN=BOTTOM>
<H1 ALIGN=RIGHT CLASS=RED><A HREF="http://cmpg.unibe.ch/sequencer/">ABI 3100</A></H1>
</TD>
</TR>
</TABLE>



<HR NOSHADE SIZE=3>



<H2>Open a project</H2>


<?php
echo "<A HREF=\"$home\">Home</A> | <A HREF=\"login.php\">user page</A><P>" ;
?>

<TABLE WIDTH="50%" CELLSPACING=0 CELLPADDING=0 BORDER=0><TR><TD><HR SIZE=3 NOSHADE></TD></TR></TABLE>


<H3>List of projects you did join:</H3>

<?php

 $request = "SELECT DISTINCT projects.id_project, projects.name
             FROM projects_people, projects
	     WHERE projects_people.id_people=$myid
	      AND projects_people.id_project=projects.id_project
	     ORDER BY projects.name;";

 $result = mysql_query ($request, $db)
 or
 mysql_die("Query SELECT failed.");

 $nbprojects = mysql_num_rows($result);

 if($nbprojects==0)
 {
  echo "<B>No projects</B>";
 }
 else
 {
  echo "<TABLE BORDER=0 CELLPADDING=5>\n";

  echo "<TR><TH>Id</TH><TH ALIGN=LEFT>Name</TH><TH>&nbsp;</TH><TH ALIGN=LEFT>Members</TH></TR>\n";
  echo "<TR><TD COLSPAN=4><HR SIZE=3 NOSHADE></TD></TR>\n";

  $i=0;
  while ($i < $nbprojects)
  {
   $id_project = mysql_result($result, $i, "id_project");
   echo "<TR>";
   echo "<TD>$id_project</TD>";
   echo "<TD><B>" . mysql_result($result, $i, "name") . "<B></TD>";
   echo "<TD><A HREF=\"./openproject.php?id_project=$id_project\">Open now</A></TD>";


   echo "<TD><CODE>";

   $request = "SELECT login
               FROM projects_people, people
	       WHERE projects_people.id_project=$id_project
	         AND projects_people.id_people=people.id_people
	       ORDER BY login;";

   $result2 = mysql_query ($request, $db)
   or
   mysql_die("Query SELECT failed.");

   $nbpeople = mysql_num_rows($result2);

   echo mysql_result($result2, 0, "login") ;

   $j=1;
   while ($j < $nbpeople)
   {
    echo ", " . mysql_result($result2, $j, "login");
    $j++;
   }

   mysql_free_result($result2);
   echo "</CODE></TD>";

   echo "</TR>\n";

   $i++;
  }

  echo "</TABLE>\n";
 }

 mysql_free_result($result);


?>

<P><TABLE WIDTH="50%" CELLSPACING=0 CELLPADDING=0 BORDER=0><TR><TD><HR SIZE=3 NOSHADE></TD></TR></TABLE>


<?php
 echo "<P>Return to <A HREF=\"$home\">home page</A>&nbsp;|&nbsp;<A HREF=\"login.php\">user page</A>\n";
?>

<P><I>Any problem?</I> Please contact the <A HREF="mailto:isabelle.duperret@iee.unibe.ch">Webmaster</A>.


</TD></TR></TABLE>



<HR NOSHADE SIZE=3>

<TABLE WIDTH="100%">
<TR>
<TD WIDTH="50%" VALIGN=MIDDLE><A HREF="mailto:isabelle.duperret@iee.unibe.ch"><IMG SRC="../images/mail.gif" BORDER=0 WIDTH=30 ALIGN=TOP HSPACE=2 ALT="[Webmaster: isabelle.duperret@iee.unibe.ch]">Webmaster</A><BR><A HREF="../version.html">Version</A>: 2.0, 07.09.2009
</TD>
</TR>
</TABLE>

</BODY>
</HTML>


<?php mysql_close($db); ?>
