#include <infodrom.style>
#include <phptools.inc>
#include "zeitungen.inc"

<?
  $date = date ("Y-m-j H:i");
  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	 or die("Unable to connect to SQL server");

  if (isset($_GET["approve"]) && is_numeric($_GET["approve"])) {
      $query = sprintf ("UPDATE zeitungen SET deleted = false WHERE oid = %d", $_GET["approve"]);
      $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

      $link = sprintf ('edit.php?oid=%d', $_GET["approve"]);
      header ("Location: $link");
      exit(0);
  }
?>
<page func="Infodrom Oldenburg" title="Zeitungen">

<sql_prepare>
<?
<:
    for $i (('name','description','url','city')) {
      printf "  \$%s=sql_prepare (\$_POST[%s]);\n", $i, $i;
    }
:>

  if ($_POST[oid] > 0) {
    if ($_POST[delete] == 1) {
      $query = sprintf ("UPDATE zeitungen SET deleted = true WHERE oid = %d", $_POST[oid]);
    } else {
      $query = "UPDATE zeitungen SET "
        . sprintf ("name='%s',url='%s',description='%s',city='%s',type='%s'",
		  addslashes ($name),
		  addslashes ($url),
		  addslashes ($description),
		  addslashes ($city),
		  addslashes ($_POST[type]))
	. " WHERE oid = $_POST[oid]";
    }
  } elseif (isset($_GET["delete"]) && is_numeric($_GET["delete"])) {
      $query = sprintf ("UPDATE zeitungen SET deleted = true WHERE oid = %d", $_GET["delete"]);
  } else {
    $query = "INSERT INTO zeitungen "
      . "(name,url,description,city,type,changed) VALUES ("
        . sprintf ("'%s','%s','%s','%s','%s','now()'",
		  addslashes ($name),
		  addslashes ($url),
		  addslashes ($description),
		  addslashes ($city),
		  addslashes ($_POST[type]))
      . ")";

  }
  //printf ("<pre>\n%s\n</pre>\n", $query);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

?>

<p>Aufgenommen/aktualisiert.</p>

<infodromlink>
</page>

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