#include #include "../index-tools.pl" Infodrom Oldenburg - News

Infodrom Oldenburg

<: main_menu (('Infodrom','Linux','Debian','Linx','Projects','News')); :> 0) { $query = "SELECT * FROM news WHERE id = '$id'"; $sth = pg_exec ($dbh, $query); if (pg_NumRows ($sth) > 0) { $row = pg_fetch_array ($sth, 0); if ($row['deleted'] == 0) { $date = explode (" ", $row['releasedate']); $date = explode ("-", $date[0]); $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]); printf ("

%s

", $row['subject']); printf ("
Von %s, %s
", $row['email'], $row['author'], $date); printf ("%s

", $row['teaser']); echo ereg_replace ("", " ", ereg_replace ("","

", ereg_replace (" ", "", $row['body']))); } } echo "

Ältere Nachrichten

"; } else { $query = "SELECT id,subject,author,releasedate,teaser,body FROM news " . "WHERE deleted = 0 AND releasedate < now() AND teaser <> '' " . "ORDER BY releasedate DESC,insertd DESC"; $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['releasedate']); $date = explode ("-", $date[0]); $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]); printf ("%s
%s", $row['subject'], $row['teaser']); if (strlen ($row['body']) > 0) { printf (" ", $row['id']); } printf ("
(%s, %s)

", $row['author'], $date); } } ?> # Local variables: # mode: indented-text # mode: auto-fill # mode: iso-accents # end: