#include <lt2001.style>
#include "edit.style"

<page title="Edit Project" subtitle=Project>

<?

  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	       or die("Unable to connect to SQL server");

  # pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

  $query = sprintf ("SELECT * FROM project WHERE oid = %d ORDER BY name", $oid);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    $row = pg_fetch_array ($sth, 0);
  }
?>

<form method=post action=update.php3>
<input type=hidden name=type value="project">
<input type=hidden name=oid value="<? echo $oid; ?>">
<center><table cellpadding=0 cellspacing=1>

<row_input	name=name
		title="<b>Name</b>"
		value="<? echo $row['name']; ?>"
		>
<row_input	name=url
		title="<b>URL</b>"
		value="<? echo $row['url']; ?>"
		>
<row_input	name=boothnr
		title="<b>Booth Nr.</b>"
		value="<? echo $row['boothnr']; ?>"
		>
<row_input	name=boothsize
		title="<b>Booth Size</b>"
		value="<? echo $row['boothsize']; ?>"
		>
<row_input	name=computer
		title="<b>Computer</b>"
		value="<? echo $row['computer']; ?>"
		>

<? if ($oid > 0) { ?>
<row_radiobox	name=delete
		title="<b>Delete</b>"
		checked_0="checked"
		checked_1=""
		>
<? } ?>

<row_submit>

<? if ($oid > 0) { ?>
<tr><td valign=top align=right bgcolor="<colh>"><font face="Helvetica,Arial"><b>Members</b></font></td>
<td valign=top bgcolor="<cold>"><font face="Helvetica,Arial">
<?
  $query = sprintf ("SELECT name,email,list,oid FROM person WHERE project = '%s' ORDER BY name", $row['name']);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row = pg_fetch_array ($sth, $nr);
      if ($row['list']) {
        printf ("(<a href=\"edit_person.php3?oid=%d\">%s</a>)<br>", $row['oid'], $row['email']);
      } elseif ($row['email']) {
        printf ("<a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt;<br>", $row['oid'], $row['name'], $row['email']);
      } else {
        printf ("<a href=\"edit_person.php3?oid=%d\">%s</a><br>", $row['oid'], $row['name']);
      }
    }
  }
  # if ($oid > 0) {
  #   printf ("<a href=\"edit_person.php3?project=%d\">Add member</a>", $oid);
  # }
?>

</font></td></tr>
<? } ?>

</table></center></form>

</page>

# Local variables:
# mode: text
# mode: auto-fill
# end: