Information & Consulting Logbuch

infocon

logbook

", "", "") or die("Unable to connect to SQL server"); pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!"); if (isset ($_GET[category])) { $query = "SELECT * FROM WHERE public = 1 "; $query .= sprintf ("AND category = '%s' ", addslashes($_GET[category])); $query .= "ORDER BY created DESC LIMIT 5"; } else { $query = "SELECT * FROM WHERE public = 1 " . "ORDER BY created DESC LIMIT 5"; } $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!"); echo ("\n"); echo ("\n"); echo ("\n"); printf (" %s\n", date("D, d M Y H:i:s T")); ?> Information & Consulting Logbuch Information & Consulting Logbuch http://infocon.infodrom.org/logbook/ joey@infodrom.org InfoCon ','&',"\\\n","\r"), array('<', '>', '&', '', ''), $row['body']); $date = explode (" ", $row['created']); $time = explode (":", $date[1]); $tz = substr($time[2], 2); if (strlen ($tz) == 3) { $tz .= "00"; } else { # Something's borked, so add symbolic name instead $tz = date ("T", mktime ($time[0], $time[1], $time[2], $date[1], $date[2], $date[0])); } $date = explode ("-", $date[0]); $date = date ("D, d M Y H:i:s ", mktime ($time[0], $time[1], $time[2], $date[1], $date[2], $date[0])) . $tz; $url = sprintf('%s-%d.html', teaserlink($row['teaser']), $row['id']); echo ("\n"); printf (" %s\n", $row['teaser']); printf (" http://infocon.infodrom.org/logbook/%s\n", $url); printf (" %s\n", $date); printf (" %s\n", $row['category']); printf (" %s\n", $body); echo ("\n"); } echo ("\n\n\n"); exit; } $kontaktlink = '

Zum Kontakformular

'; ?> #include ", "", "") or die("Unable to connect to SQL server"); pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!"); if (strlen ($_SERVER[QUERY_STRING])> 0 && ($_SERVER[QUERY_STRING] == "all" || strlen($_SERVER[QUERY_STRING]) == 4)) { if ($_SERVER[QUERY_STRING] == "all") { $query = "SELECT id,teaser,created FROM " . "WHERE public = 1 " . "ORDER BY created DESC"; $title = "Index of Logbook Entries"; } else { $this_year = (int)$_SERVER[QUERY_STRING]; $next_year = $this_year + 1; $query = sprintf ("SELECT id,teaser,created FROM " ."WHERE public = 1 " ."AND created >= '%d-01-01' AND created < '%d-01-01' ORDER BY created ASC", $this_year, $next_year); $title = sprintf ("Logbuch %d", $this_year); } echo ("

"); printf ("

%s

", $title); echo ("

"); echo (""); $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!"); for ($nr=0; $nr < pg_NumRows ($sth); $nr++) { $row = pg_fetch_array ($sth, $nr); $date = explode (" ", $row['created']); $time = explode (":", $date[1]); $date = explode ("-", $date[0]); $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]); $url = sprintf('%s-%d.html', teaserlink($row['teaser']), $row['id']); printf ("", $date, $url, $row['teaser']); } echo ("

"); echo $kontaktlink; } else { if (strlen ($_SERVER[QUERY_STRING]) > 0) { $query = sprintf ("SELECT * FROM " ."WHERE public = 1 AND id = '%s'", addslashes ($_SERVER[QUERY_STRING])); } else { $query = "SELECT * FROM WHERE public = 1 " . "ORDER BY created DESC LIMIT 8"; } $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!"); for ($nr=0; $nr < pg_NumRows ($sth); $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]); $url = sprintf('%s-%d.html', teaserlink($row['teaser']), $row['id']); echo ("

"); printf ("

%s

", $url, $row['teaser']); if (strlen ($_SERVER[QUERY_STRING]) > 0) echo $adv_entry; printf ("

", str_replace ("\\\n", "", str_replace ("\r", "", $row['body']))); echo ("\n

"); echo ("

"); printf ("%s | %s | permanent link", $date, $row['category'], $url); echo ("

"); echo ("

"); if ($nr == 0 || $nr == 4 || $nr == 7) echo $adv_index; if (strlen ($_SERVER[QUERY_STRING]) > 0) echo $kontaktlink; } } ?> # Local variables: # mode: text # mode: auto-fill # end: