#include <infodrom.style>
#include <linux.style>
#include <quote.style>
#include <db.style>
<define-tag maxticker>10</define-tag>

<?
  $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!");

  if (isset($_GET[id]) && $_GET[id] > 0) {
    $query = sprintf ("SELECT url FROM linuxticker WHERE oid = %d", $_GET[id]);
    $sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      $url = sprintf ("Location: %s", $row['url']);
      header ($url);
    }
  }
?>

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

<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td width=75% 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";

  $format = "<h3>%s</h3>"
	   ."<p><font size=\"-1\">%s, %s</font>"
	   ."<p>%s";

  if ($_GET[oid] > 0) {
    $query = sprintf ("SELECT * FROM linuxticker WHERE oid = %d", $_GET[oid]);
    $sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      $date = explode (" ", $row['releasedate']);
      $date = explode ("-", $date[0]);
      $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
      $ticker = $tick[$row['ticker']];

      $body = str_replace("\n\n", "<p>", $row['body']);

      printf ($format, $row['subject'], $date, $ticker, $body);

      if (strlen ($row['url']) > 0) {
        printf ("<p><a href=\"%s\">Read more on %s</a>", $row['url'], $ticker);
      }
    }
  }
?>

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

<p><titlebox title="Linux News">
<table width=100% cellpadding=2 cellspacing=0 border=0>
<tr><td><ifont><font size=-1>

<?
  $query = sprintf ("SELECT subject,oid,releasedate,ticker FROM linuxticker "
	 . "WHERE deleted = 0 AND releasedate < now() AND oid <> %d "
	 . "ORDER BY releasedate DESC "
	 . "LIMIT <maxticker> ", $_GET[oid]);
  $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) [<a href=\"shownews.php?oid=%d\">read</a>]<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>

<?
  }

?>

</font></ifont></td></tr></table>
</titlebox><p>


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

</page>

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