1 #include <infodrom.style>
3 <page func="Infodrom Oldenburg" title="Logbook">
5 <table width=100% class="font height" border=0 cellspacing=3 bgcolor="#<cold>">\
7 <th width=20%>Datum</th>\
8 <th width=15%>Category</th>\
9 <th width=65%>Titel</th></tr>
13 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
14 or die("Unable to connect to SQL server");
16 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
18 $query = "SELECT id,teaser,category,created FROM logbook ORDER BY created DESC LIMIT $limit";
19 if (isset ($_GET["offset"]))
20 $query .= sprintf (" OFFSET %d\n", $_GET["offset"]);
21 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
24 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
25 $row = pg_fetch_array ($sth, $nr);
26 $date = explode (" ", $row['created']);
27 $time = explode (":", $date[1]);
28 $date = explode ("-", $date[0]);
29 $date = sprintf ("%d.%d.%d %02d:%02d", $date[2], $date[1], $date[0], $time[0], $time[1]);
31 $color = $color == "<cold>"?"<coln>" : "<cold>";
32 printf ("<tr bgcolor=\"#%s\"><td align=\"right\">%s</td><td align=\"center\">%s</td>"
33 ."<td><a href=\"show.php?id=%s\">%s</a></td></tr>",
35 $date, $row['category'], $row['id'], $row['teaser']);
40 if ($nr >= pg_NumRows ($sth)) {
41 printf ("<p><a href=\"index.php?offset=%d\">next</a></p>\n", $_GET["offset"]+$limit);