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

    $query = "SELECT id,subject,author,releasedate,teaser,body FROM news "
           . "WHERE deleted = 0 AND releasedate < now() AND teaser <> '' "
           . "ORDER BY releasedate DESC,insertd DESC LIMIT 10";
    $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
# end: