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

<page title="Edit Workshop" subtitle=Workshops>

<?

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

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

  if ($project) {
    $query = sprintf ("SELECT name FROM project WHERE oid = %d", $project);
  } else {
    if ($oid > 0) {
      $query = sprintf ("SELECT * FROM workshop WHERE oid = %d", $oid);
    } else {
      $query = '';
    }
  }
  if (strlen ($query)) {

    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      if ($project) {
	$row['project'] = $row['name'];
      }
    }
  }
?>

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

<row_input	name=title
		title="<b>Title</b>"
		value="<? echo $row['title']; ?>"
		>
<row_input	name=speaker
		title="<b>Speaker</b>"
		value="<? echo $row['speaker']; ?>"
		>
<row_input	name=project
		title="<b>Project</b>"
		value="<? echo $row['project']; ?>"
		>

<?
  $date	= explode (" ", $row['date_time']);
  $time	= $date[1];
  $time	= explode (":", $time);
  $time = sprintf ("%02d:%02d", $time[0], $time[1]);
  $date	= $date[0];
?>

<tr><td align=right bgcolor="<colh>"><font face="Helvetica,Arial"><b>Date/Time</b></font></td>
<td bgcolor="<cold>"><font face="Helvetica,Arial"><select name=date>
<option value=2001-07-05<? if ($date=="2001-07-05") { echo " selected";} ?>>Thu, Jul 5th
<option value=2001-07-06<? if ($date=="2001-07-06") { echo " selected";} ?>>Fri, Jul 6th
<option value=2001-07-07<? if ($date=="2001-07-07") { echo " selected";} ?>>Sat, Jul 7th
<option value=2001-07-08<? if ($date=="2001-07-08") { echo " selected";} ?>>Sun, Jul 8th
</select>&nbsp;<select name=time>
<:
    $start = 10;
    while ($start < 18) {
	printf "<option value=\"%02d:00:00\"<? if (\$time==\"%02d:00\") { echo \" selected\";} ?>>%02d:00\n", $start, $start, $start;
        $start++;
    }
:>
</select>
</font></td></tr>

<tr><td align=right bgcolor="<colh>"><font face="Helvetica,Arial"><b>Room</b></font></td>
<td bgcolor="<cold>"><font face="Helvetica,Arial"><select name=room>
<option value="CCA III"<? if ($row['room']=="CCA III") { echo "selected";} ?>>CCA III
<option value="CCA IV"<? if ($row['room']=="CCA IV") { echo " selected";} ?>>CCA IV
</select></font></td></tr>

<row_textarea	name=abstract
		title="<b>Abstract</b>"
		value="<? echo $row['abstract']; ?>"
		rows=7
		>
<row_textarea	name=comment
		title="<b>Comment</b>"
		value="<? echo $row['comment']; ?>"
		rows=7
		>
<row_radiobox	name=visible
		title="<b>Visible</b>"
		checked_0="<? if ($row['visible']==0) { echo "checked";} ?>"
		checked_1="<? if ($row['visible']==1) { echo "checked";} ?>"
		>

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

<row_submit>

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

</page>

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