#include <infocon.style>
#include <phptools.inc>

<page func="Information & Consulting" title="Logbook">

<teaserlink>
<?
  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 = "SELECT oid,* FROM logbook WHERE id = '$_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['created']);
      $time = explode (":", $date[1]);
      $date = explode ("-", $date[0]);
      $date = sprintf ("%d.%d.%d %02d:%02d", $date[2], $date[1], $date[0], $time[0], $time[1]);
    }
  }

printf ("<h3>%s</h3>", $row['teaser']);
printf ("<p>Date: %s", $date);
printf ("<br>Category: %s", $row['category']);
if ($row['public'] > 0) {
  printf (' &mdash; <a href="http://infocon.infodrom.org//logbook/%s-%d.html">public link</a>',
    teaserlink($row['teaser']), $row['id']);
}
echo "</p>";

printf ("%s", str_replace ("\\\n", "",
	        str_replace ("\r", "",
		  $row['body'])));

?>

</page>

# Local variables:
# mode: text
# end: