#include <infodrom.style>
#include "lt.style"
#include "edit.style"
#include "functions.inc"

<postgresconnect>
<spokendate>

<ltpage title="Project Management -- Edit Workshop">

<?
  $error = false;

  if (allowed_to_edit_workshop ($oid)) {
    $query = sprintf ("SELECT * FROM workshop WHERE oid = %d", $oid);
  } else {
    $error = true;
    echo ("<p><b>You have no permission to edit this workshop.</b></p>");
  }

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

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

      if ($row['project'] != $LINUXTAG_AUTH['project']
       && $row['person'] != $LINUXTAG_AUTH['id']) {
	echo ("<p><b>You don't own this workshop.</b></p>");
	$error = true;
      }
    } else {
      echo ("<p><b>Workshop not found.</b></p>");
      $error = true;
    }
  }

  if (!$error) {
    $date = explode (" ", $row['date_time']);
    $time = $date[1];
    $time = explode (":", $time);
    $time = sprintf ("%02d:%02d", $time[0], $time[1]);
    $date = $date[0];

    $query = sprintf ("SELECT name FROM person WHERE id = %d", $row['person']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      $row2 = pg_fetch_array ($sth, 0);
      $row['name'] = $row2['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_info	name=project
		title="<b>Project</b>"
		value="<? echo $row['project']; ?>"
		>
<?
  if ($date=="<iso-event-date_0>") {
    $date_time = "<date-event-date_0>";
  } elseif ($date=="<iso-event-date_1>") {
    $date_time = "<date-event-date_1>";
  } elseif ($date=="<iso-event-date_2>") {
    $date_time = "<date-event-date_2>";
  } elseif ($date=="<iso-event-date_3>") {
    $date_time = "<date-event-date_3>";
  } else {
    $date_time = $date;
  }
  $date_time = $date_time . ", " . $time;

  if ($row['room']=="<room-1-internal>") {
    $date_time = $date_time . ", <room-1>";
  } elseif ($row['room']=="<room-2-internal>") {
    $date_time = $date_time . ", <room-2>";
  }
?>

<row_info	name=wann_woo
		title="<b>Date</b>"
		value="<? echo $date_time; ?>"
		>
<row_input	name=title
		title="<b>Title</b>"
		value="<? echo $row['title']; ?>"
		>
<tr><td align=right bgcolor="<colh>"><font face="Helvetica,Arial"><b>Language</b></font></td>
<td bgcolor="<cold>"><font face="Helvetica,Arial"><select name=language><?
    $langs = array('undef',
                   'Deutsch', 'Deutsch (English)',
                   'English', 'English (Deutsch)');

    for ($i=0; $i<count($langs); $i++) {
      printf ("<option value=\"%s\" %s>%s\n", $langs[$i], 
          $row['language'] == $langs[$i] ? "selected":"", $langs[$i]);
    }
?></select>
</font></td></tr>
<?
  if (is_admin() && $LINUXTAG_AUTH['project'] == $row['project']) {
    $query = sprintf("SELECT name,id FROM person,junction "
	           . "WHERE person = id AND list = 0 AND junction.project = '%s' "
	          . "ORDER BY name", $row['project']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
?>
<tr><td align=right bgcolor="<colh>"><font face="Helvetica,Arial"><b>Speaker</b></font></td>
<td bgcolor="<cold>"><font face="Helvetica,Arial"><select name=speaker>
<?
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row2 = pg_fetch_array ($sth, $nr);
      if ($row['person'] == $row2['id']) {
        printf ("<option value=\"%d\" selected>%s\n", $row2['id'], $row2['name']);
      } else {
        printf ("<option value=\"%d\">%s\n", $row2['id'], $row2['name']);
      }
    }
?>
</select>
</font></td></tr>
<? } } else { ?>
<row_info	name=speaker
		title="<b>Speaker</b>"
		value="<? echo $row['name']; ?>"
		>
<? } ?>

<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_checkbox	name=visible
		title="<b>Visible</b>"
		descr="Workshop is publically visible"
		checked="<? if ($row['visible'] == 1) { echo 'checked'; } ?>"
		>

<row_submit>

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

<? } ?>

</ltpage>

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