#include <infodrom.style>

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

<?
  if ($oid > 0) {
    $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 = "SELECT * FROM ticker WHERE oid = '$oid'";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
    }
  } else {
    $row['releasedate'] = date ("Y-m-j H:i");
  }
  $date = explode (" ", $row['releasedate']);
  $date = explode ("-", $date[0]);
  $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);

  $ticker['ticker-chip'] = "CHIP Online";
  $ticker['ticker-firstlinux'] = "FirstLinux";
  $ticker['ticker-gnn'] = "Golem Network News";
  $ticker['ticker-heise'] = "Heise Newsticker";
  $ticker['ticker-linuxcommunity'] = "Linux-Community";
  $ticker['ticker-linuxde'] = "Linux.de";
  $ticker['ticker-linuxmag'] = "Linux-Magazin";
  $ticker['ticker-linuxpr'] = "LinuxPR";
  $ticker['ticker-linuxtoday'] = "Linux Today";
  $ticker['ticker-lwn'] = "Linux Weekly News";
  $ticker['ticker-prolinux'] = "Pro Linux";
  $ticker['ticker-slashdot'] = "Slashdot";
  $ticker['ticker-zdnet'] = "ZDNet";
?>

<h3 align=center><font face="Helvetica,Arial"><? echo $row['subject']; ?></font></h3>
<h3 align=center><font face="Helvetica,Arial"> - <? echo $ticker[$row['ticker']]; ?> - </font></h3>

<font face="Helvetica,Arial">
<b><? echo $date; ?></b><p>
<b><? printf ("Jump to <a href=\"http://www.infodrom.ffis.de/ticker/?ups=%d\">%s</a>", $oid, $row['url']); ?></b><p>

<? echo $row['body']; ?>

<p><b><? printf ("<a href=\"edit.php3?oid=%d\">Edit</a>", $oid); ?></b><p>

</font>
</page>

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