#include <infodrom.style>

<page func="Infodrom Oldenburg" title="Events">
<calendar_init -4>

<?
  if ($_GET[id] > 0) {
    $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 events WHERE oid = %d", $_GET[id]);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

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

      $date = explode (" ", $row['start']);
      $date = explode ("-", $date[0]);
      $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);

      $days = explode (" ", $row['delta']);
      $days = $days[0] + 1;

    }
  } else {
    $date = "dd.mm.yyyy";
    $days = 1;
  }
?>

<form method=post action="update.php">
<input type=hidden name=id value="<? echo $_GET[id]; ?>">
<b>Name:</b> <input name=name size=60 maxlength=80 value="<? echo $row['name']; ?>"><br>
<b>City:</b> <input name=city size=60 maxlength=80 value="<? echo $row['city']; ?>"><br>
<b>Country:</b> <input name=country size=60 maxlength=30 value="<? echo $row['country']; ?>"><br>

<b>Date:</b> <input name=date id=date size=10 maxlength=10 value="<? echo $date; ?>"> <calendar "date"><br>
<b>Days:</b> <input name=days size=5 maxlength=2 value="<? echo $days; ?>"><br>

<b>Conference:</b> <input name=conference type=checkbox value=1 <? if ($row['conference']==1) { echo "checked";} ?>><br>
<b>Exhibition:</b> <input name=exhibition type=checkbox value=1 <? if ($row['exhibition']==1) { echo "checked";} ?>><br>

<b>URL:</b> <input name=url size=60 maxlength=120 value="<? echo $row['url']; ?>"><br>
<b>Debian URL:</b> <input name=deburl size=60 maxlength=120 value="<? echo $row['deburl']; ?>"><br>
<b>Local URL:</b> <input name=localurl size=60 maxlength=120 value="<? echo $row['localurl']; ?>"><br>
<b>Comment:</b> <br><textarea name=comment rows=5 cols=67><? echo $row['comment']; ?></textarea><p>

<b>Cancelled:</b> <input name=cancelled type=checkbox value=1 <? if ($row['cancelled']==1) { echo "checked";} ?>><br>
<? if ($_GET[id] > 0) { ?>
<b>Delete:</b> <input name=delete type=checkbox value=1><br>
<? } ?>
<p><center><input type=submit class=button value="<? echo $_GET[id]>0?"Update":"Insert"; ?>"></center><p>
</form>

<p><?
  if ($_GET[id] > 0) {
    if (strlen($row['url']) || strlen($row['deburl']) || strlen($row['localurl'])) {
      echo ("<h3>URLs</h3><ul>");

      if ($row['url']) {
	printf ("<li> <a href=\"%s\">Event</a> (%s)", $row['url'], $row['url']);
      }
      if ($row['deburl']) {
	printf ("<li> <a href=\"%s\">Debian</a> (%s)", $row['deburl'], $row['deburl']);
      }
      if ($row['localurl']) {
	printf ("<li> <a href=\"%s\">Infodrom</a> (%s)", $row['localurl'], $row['localurl']);
      }

      echo ("</ul>");
    }
    if ($row['comment']) {
      echo ("<h3>Comments</h3><ul>");
      echo ("<p>".$row['comment']);
    }
  }
?>

</page>

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