#include <infodrom.style>
#include "ticker.inc"

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

<table width=100% border=0 cellspacing=0 cellpadding=0>
<tr bgcolor=#<colh>>
<th width=10%><font face="Helvetica,Arial">Datum</font></th>
<th width=15%><font face="Helvetica,Arial">Quelle</font></th>
<th width=75%><font face="Helvetica,Arial">Titel</font></th>
</tr>

<?
  $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 oid,ticker,subject,releasedate FROM ticker ";
  if ($key) {
    $query .= " WHERE subject ~* '$key'";
    if ($ticker) {
      $query .= " AND ticker = '$ticker'";
    }
  } elseif ($ticker) {
      $query .= " WHERE ticker = '$ticker'";
  }
  $query .= " ORDER BY releasedate,subject";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

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

  $color = "<cold>";
  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]);
    $color = $color=="<cold>"?"<coln>":"<cold>";

    printf ("<tr bgcolor=\"#%s\"><td align=\"right\"><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>", $color, $date);
    printf ("<td align=\"center\"><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>",
	   strlen ($tick[$row['ticker']])?$tick[$row['ticker']]:"&nbsp;");
    printf ("<td><font size=\"-1\" face=\"Helvetica,Arial\"><a href=\"show.php3?oid=%d\">%s</a></font></td></tr>",
      $row['oid'], $row['subject']);
  }
?>

</table>


<h3><font face="Helvetica,Arial">Neue Anfrage</font></h3>
<listform>

</page>

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