$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ $color = "<coln>";
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
$date = explode (" ", $row['created']);
$date = explode ("-", $date[0]);
$date = sprintf ("%d.%d.%d %02d:%02d", $date[2], $date[1], $date[0], $time[0], $time[1]);
+ $color = $color == "<cold>"?"<coln>" : "<cold>";
if ($row['public'] == 0) {
- printf ("<tr><td align=\"right\">%s</td><td align=\"center\">%s</td><td><a href=\"show.php?id=%s\">%s</a></td></tr>",
+ printf ("<tr bgcolor=\"#%s\"><td align=\"right\">%s</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']);
} else {
if ($row['category'] === 'absurd')
$pubbase = 'http://www.infodrom.org/~joey/absurd/';
else
$pubbase = 'http://www.infodrom.org/~joey/log/';
- printf ("<tr><td align=\"right\">%s</td><td align=\"center\">%s</td><td><a href=\"show.php?id=%s\">%s</a>"
+ printf ("<tr bgcolor=\"#%s\"><td align=\"right\">%s</td><td align=\"center\">%s</td><td><a href=\"show.php?id=%s\">%s</a>"
." (<a href=\"%s?%s\">pub</a>)</td></tr>",
+ $color,
$date, $row['category'], $row['id'], $row['teaser'], $pubbase, $row['id']);
}
}
<page func="Infodrom Oldenburg" title="Logbook">
-<table width=100% class=font border=0 cellspacing=3 bgcolor="#<cold>">\
+<table width=100% class="font height" border=0 cellspacing=3 bgcolor="#<cold>">\
<tr bgcolor=#<colh>>\
<th width=10%>Datum</th>\
<th width=10%>Category</th>\
$query .= sprintf (" OFFSET %d\n", $_GET["offset"]);
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ $color = "<coln>";
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
$date = explode (" ", $row['created']);
$date = explode ("-", $date[0]);
$date = sprintf ("%d.%d.%d %02d:%02d", $date[2], $date[1], $date[0], $time[0], $time[1]);
- printf ("<tr><td align=\"right\">%s</td><td align=\"center\">%s</td><td><a href=\"show.php?id=%s\">%s</a></td></tr>",
+ $color = $color == "<cold>"?"<coln>" : "<cold>";
+ printf ("<tr bgcolor=#%s><td align=\"right\">%s</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']);
}
$query = "SELECT id,teaser,category,created FROM logbook WHERE public=1 ORDER BY created DESC";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ $color = "<coln>";
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
$date = explode (" ", $row['created']);
$date = explode ("-", $date[0]);
$date = sprintf ("%d.%d.%d %02d:%02d", $date[2], $date[1], $date[0], $time[0], $time[1]);
- printf ("<tr><td align=\"right\">%s</td><td align=\"center\">%s</td><td><a href=\"show.php?id=%s\">%s</a>"
+ $color = $color == "<cold>"?"<coln>" : "<cold>";
+ printf ("<tr bgcolor=\"#%s\"><td align=\"right\">%s</td><td align=\"center\">%s</td><td><a href=\"show.php?id=%s\">%s</a>"
." (<a href=\"http://www.infodrom.org/~joey/log/?%s\">pub</a>)</td></tr>",
+ $color,
$date, $row['category'], $row['id'], $row['teaser'], $row['id']);
}
?>