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

<page title="Infodrom News" stylesheet="news.css" alternates="news.rdf|Infodrom~News">

<?
  $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 ($_GET[id] > 0) {
    $query = sprintf ("SELECT * FROM news WHERE id = %d", $_GET[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]);

        echo ("<div class=\"news\">");
        printf ("<h3 class=\"headline\">%s</h3>", $row['subject']);
        printf ("<div class=\"newsbody\">Von <a href=\"mailto:%s\">%s</a>, %s</div>", $row['email'], $row['author'], $date);
        printf ("<div class=\"newsbody\"><strong>%s</strong></div>\n", $row['teaser']);
        echo ("<div class=\"newsbody\">");

	echo str_replace(array("\r", "\\\n", "\n\n"),
			 array('', '', '<p>'),
			 $row['body']);
        echo ("</div></div>");
      }
    }
  } 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]);

      # if (!strncmp($row['body'], 'http://', 7))
      if (!strcmp(substr($row['body'],0,7), 'http://'))
	$url = $row['body'];
      else
	$url = sprintf ("shownews.php?id=%d", $row['id']);

      echo ("<div class=\"newsbox\">");

      if (strlen ($row['body']) > 0)
        printf ("<h3 class=\"newstitle\"><a href=\"%s\">%s</a></h3>", $url, $row['subject']);
      else
        printf ("<h3 class=\"newstitle\">%s</h3>", $row['subject']);

      printf ("<div class=\"newsauthor\">By: %s, %s</div>", $row['author'], $date);
      printf ("<div class=\"newscontent\">%s", $row['teaser']);

      if (strlen ($row['body']) > 0)
        printf (" <a href=\"%s\"><phpmehr></a>", $url);

      echo ("</div>");
      echo ("</div>");
    }
  }
?>
<div style="padding-top: 0.5em"></div>

</page>

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