#include <infodrom.style>

<page func="Infodrom Oldenburg" title="Logbook">

<table class="smallfont border" width=100% border=0 cellpadding=0 cellspacing=1>
<tr class=head>
<th width=15%>Datum</th>
<th width=15%>Category</th>
<th width=70%>Titel</th>
</tr>

<?
  $limit = 50;
  $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 id,teaser,category,created FROM logbook ORDER BY created DESC LIMIT %d", $limit+1);
  if (isset ($_GET["offset"]))
    $query .= sprintf (" OFFSET %d\n", $_GET["offset"]);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  $color = 0;
  for ($nr=0; $nr < pg_NumRows ($sth) && $nr < $limit; $nr++) {
    $row = pg_fetch_array ($sth, $nr);
    $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 ("<tr class=\"t%d\"><td align=\"right\">%s&nbsp;</td><td align=\"center\">%s</td>"
	   ."<td><a href=\"show.php?id=%s\">%s</a></td></tr>",
	   $color,
	   $date, $row['category'], $row['id'], $row['teaser']);
    $color = !$color;
  }

  echo ("</table>\n");

  if (pg_NumRows ($sth) > $nr) {
    printf ("<p><a href=\"index.php?offset=%d\">next</a></p>\n", $_GET["offset"]+$limit);
  }
?>

</page>

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