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

<postgresconnect>
<spokendate>

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

<?
  $mon['06'] = "June";
  $mon['07'] = "July";
  $name['<room-1-internal>']="<room-1>";
  $name['<room-2-internal>']="<room-2>";
  $name['<room-3-internal>']="<room-3>";
  $error = false;

  if (!isset ($oid)) {
    echo ("<p><b>No workshop selected, uh?</b></p>");
    $error = true;
  }

  if (!$error) {
    $query = sprintf ("SELECT room,date_time,title,name,abstract,workshop.project,visible,email,id FROM workshop,person "
		     ."WHERE person = id AND workshop.oid = %d", $oid);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      if ($row['visible'] != 1 && $LINUXTAG_AUTH['project'] != $row['project']
                               && $LINUXTAG_AUTH['id'] != $row['id']) {
        echo ("<p><b>This workshop is not yet public.</b></p>");
        $error = true;
      }
    } else {
      echo ("<p><b>Workshop not found.</b></p>");
      $error = true;
    }
  }

  if (!$error) {
    $foo = explode (" ", $row['date_time']);
    $thisdate = spokendate ($foo[0]);
    $foo = explode (":", $foo[1]);
    $thistime = sprintf ("%02d:%02d", $foo[0], $foo[1]);
?>

<p><b>Date:</b> <? echo $thisdate; ?>
<br><b>Room:</b> <? echo $name[$row['room']]; ?>
<br><b>Time:</b> <? echo $thistime; ?>
<br><b>Speaker:</b> <? echo $row['name']; ?>
<br><b>Project:</b> <? echo $row['project']; ?>

<h3><? echo $row['title']; ?></h3>

<p><? echo $row['abstract']; ?>

<? } ?>

<?
  if (is_admin() || $row['id'] == $LINUXTAG_AUTH['id']) {
    printf ('<div align="center"><a href="edit_workshop.php3?oid=%d">Edit</a></div>', $oid);
  }
?>

</ltpage>

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