Implement simple display for an event

diff --git a/src/Infodrom/events/show.wml b/src/Infodrom/events/show.wml
new file mode 100644 (file)
index 0000000..af08fa2
--- /dev/null
+++ b/src/Infodrom/events/show.wml
@@ -0,0 +1,87 @@
+#include <infodrom.style>
+
+<page func="Infodrom Oldenburg" title="Events">
+
+<?
+  $row = false;
+
+  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!");
+
+    $columns = 'name,city,country,start,start+delta AS stop,delta,conference,exhibition,url,deburl,localurl,cancelled';
+    $query = sprintf ("SELECT %s FROM events WHERE oid = %d", $columns, $_GET[id]);
+    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+    if (pg_NumRows ($sth) > 0) {
+      $row = pg_fetch_array ($sth, 0);
+
+      $start = explode (" ", $row['start']);
+      $start = explode ("-", $start[0]);
+      $start = sprintf ("%d.%d.%d", $start[2], $start[1], $start[0]);
+
+      $end = explode (" ", $row['stop']);
+      $end = explode ("-", $end[0]);
+      $end = sprintf ("%d.%d.%d", $end[2], $end[1], $end[0]);
+
+      $days = explode (" ", $row['delta']);
+      $days = $days[0] + 1;
+    }
+  }
+  if ($row === false) {
+    echo('<h3>Keine Veranstaltung angegeben</h3>');
+  } else {
+    printf('<h3><a href="edit.php?id=%d">%s</a></h3>', $_GET[id], $row['name']);
+    printf('<p style="margin-top: -10px; font-size: 10px; font-weight: bold;">%s, %s</p>', $row['city'], $row['country']);
+    echo('<p>');
+    if ($days > 1) {
+      printf("Datum: %s &ndash; %s<br>", $start, $end);
+      printf("Dauer: %d Tage<br>", $days);
+    } else
+      printf("Datum: %s<br>", $start);
+    if ($row['conference']==1 && $row['exhibition']==1)
+      echo("Art: Konferenz und Ausstellung<br>");
+    elseif ($row['conference']==1)
+      echo("Art: Konferenz<br>");
+    elseif ($row['exhibition']==1)
+      echo("Art: Ausstellung<br>");
+    printf('URL: <a href="%s">%s</a><br>', $row['url'], $row['url']);
+    if ($row['deburl'])
+      printf('Debian URL: <a href="%s">%s</a><br>', $row['deburl'], $row['deburl']);
+    if ($row['localurl'])
+      printf('Local URL: <a href="%s">%s</a><br>', $row['localurl'], $row['localurl']);
+    if ($row['cancelled']==1)
+      echo('abgesagt<br>');
+    if ($row['comment'])
+      echo $row['comment'];
+    echo('</p>');
+?>
+<style type="text/css">
+input {
+  border: 1px solid #1aa2fe;
+}
+input.submit {
+  display: inline;
+  border: 1px solid #aaaaaa;
+}
+input.submit:hover {
+  border: 1px solid black;
+  background-color: #bfbfbf;
+}
+</style>
+<p><form method=post action="update.php">
+<input type=hidden name=id value="<? echo $_GET[id]; ?>">
+<b>New date:</b> <input name=date size=10 maxlength=10 value="" tabindex=1> &nbsp;
+<input class=submit type=submit name=clone value="Clone">
+</form></p>
+<?
+  }
+?>
+</page>
+
+# Local variables:
+# mode: indented-text
+# mode: auto-fill
+# end: