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

<page title="Infodrom Zeitungen">

#<colorbox bgcolor=ab82ff>
<h3 align=center>Infodrom Zeitungen</h3>
#</colorbox>

#<h3>Infodrom Zeitungen<br><?
#  if ($class == "woche") {
#    echo ("- Wochenzeitungen -");
#  } elseif ($class == "monat") {
#    echo ("- Monatszeitungen -");
#  } elseif ($class == "comp") {
#    echo ("- Computerzeitungen -");
#  } elseif ($class == "misc") {
#    echo ("- Sonstiges -");
#  } elseif ($class == "search") {
#    echo ("- Informationsstände -");
#  } else {
#    echo ("- Tageszeitungen</h3>");
#    # Just in case some attacker tries to set it to something else
#    $class = "tag";
#  }
#?></h3>

<?
  $type = array();
  if ($_GET['class'] == "all") {
    $type['utag'] = "&Uuml;berregionale Tageszeitungen";
    $type['tag'] = "Tageszeitungen";
    $type['uwoche'] = "&Uuml;berregionale Wochenzeitungen";
    $type['woche'] = "Wochenzeitungen";
    $type['monat'] = "Monatsmagazine";
    $type['comp'] = "Computerzeitungen";
    $type['misc'] = "Sonstige Ver&ouml;ffentlichungen";
    $type['search'] = "Weitere Informationsst&auml;nde";
  } elseif ($_GET['class'] == "tag") {
    $type['utag'] = "&Uuml;berregionale Tageszeitungen";
    $type['tag'] = "Tageszeitungen";
  } elseif ($_GET['class'] == "woche") {
    $type['uwoche'] = "&Uuml;berregionale Wochenzeitungen";
    $type['woche'] = "Wochenzeitungen";
  } elseif ($_GET['class'] == "monat") {
    $type['monat'] = "Monatsmagazine";
  } elseif ($_GET['class'] == "comp") {
    $type['comp'] = "Computerzeitungen";
  } elseif ($_GET['class'] == "misc") {
    $type['misc'] = "Sonstige Ver&ouml;ffentlichungen";
  } elseif ($_GET['class'] == "search") {
    $type['search'] = "Weitere Informationsst&auml;nde";
  } else {
    $type['tag'] = "Tageszeitungen";
  }

  $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['class'] == "tag")
    echo ('<p><a href="http://www.zeitungsliste.de/tag/tageszeitung.html">'.
          '<img src="zlistbtn.gif" border=0 width=88 height=31 alt="Zeitungen im Netz"></a></p>');
  elseif ($_GET['class'] == "search")
    echo ('<p><a href="http://www.zeitungsliste.de/">'.
          '<img src="zlistbtn.gif" border=0 width=88 height=31 alt="Zeitungen im Netz"></a></p>');

  for (reset ($type); $key = key ($type); next ($type))
  {
    $query = "SELECT * FROM zeitungen WHERE type = '$key' AND deleted IS false ORDER BY name";
    $sth = pg_exec ($dbh, $query) or die("Problem mit der Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      printf ("<h3 class=\"bar\">%s</h3><ul>", $type[$key]);
      $now = date("U");
      for ($rc=0; $rc < pg_NumRows ($sth); $rc++) {
	$row = pg_fetch_array ($sth, $rc);
	printf ("<li> <a href=\"%s\">%s</a>, %s",
		$row['url'],
		$row['name'],
		$row['city']);
	$timestamp=$row['changed'];
	$datearray=explode(" ", $timestamp);
	$dateonly=explode("-",$datearray[0]);
	$zdate = mktime (0,0,0,$dateonly[1],$dateonly[2],$dateonly[0]);
	$days = ceil(($now - $zdate) / 86400);
	if ($days <= 7) {
	  echo "<em><img src=\"<root_prefix>gifs/new.gif\" width=\"36\" height=\"12\" align=\"middle\" alt=\"*new*\"></em>";
	}
	printf ("<br>%s<br>URL: <code>%s</code><p>",
		$row['description'],
		$row['url']);
      }
      echo "</ul><p>";
    }
  }
?>

</page>

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