#include <infodrom.style>
#include <linux.style>
#include <quote.style>
#include <db.style>

<page title="Linux-News @ Infodrom">

<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td width=82% valign=top align=left><ifont>

<h1 align=center>Linux-News @ Infodrom</h1>

<?
  $tick['ticker-chip'] = "CHIP";
  $tick['ticker-firstlinux'] = "FirstLinux";
  $tick['ticker-gnn'] = "Golem";
  $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";
  $tick['ticker-prolinux'] = "Pro Linux";
  $tick['ticker-slashdot'] = "Slashdot";
  $tick['ticker-zdnet'] = "ZDNet";

  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
               or die("Unable to connect to SQL server");

  pg_exec ($dbh, "SET DateStyle = 'ISO'"); // ignore or die("Datenbank-Abfrage!");

  $query = "SELECT subject,oid,releasedate,ticker FROM linuxticker "
	 . "WHERE deleted = 0 AND releasedate < now() "
	 . "ORDER BY releasedate 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]);
    $ticker = $tick[$row['ticker']];

    printf ("<b>%s</b>: %s (%s) <font size=\"-1\">[<a href=\"shownews.php?id=%d\">read</a>]</font><br>", $date, $row['subject'], $ticker, $row['oid']);
?>

# Das hier ist *NUR* ein vertikaler Abstand...
<table width=100% cellpadding=2 cellspacing=0 border=0>
<tr><td>
<img src="<root_prefix>gifs/imgdot-1x1-transp.gif" width="0" height="2" alt="">
</td></tr></table>

<?
  }
?>


</ifont></td><td valign=top><img src=<root_prefix>gifs/imgdot-1x1-transp.gif width=3 height=0 alt="">
#</td><td width=25% valign=top align=right>
</td><td width=100 valign=top align=right>

#include "links.inc"

#include "newsticker.inc"

</td></tr></table>

</page>

# Local variables:
# mode: indented-text
# end: