From 6ddd1b53fa49d4c1a9f5d82fb69e352b43e0656d Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Wed, 27 Feb 2008 10:54:19 +0000
Subject: [PATCH] Redirect to the details after approving a newspaper

---
 src/Infodrom/zeitungen/update.wml | 19 +++++++++++++------
 1 file changed, 13 insertions(+), 6 deletions(-)

diff --git a/src/Infodrom/zeitungen/update.wml b/src/Infodrom/zeitungen/update.wml
index 36bc6cf..f2d6bfb 100644
--- a/src/Infodrom/zeitungen/update.wml
+++ b/src/Infodrom/zeitungen/update.wml
@@ -2,14 +2,24 @@
 #include <phptools.inc>
 #include "zeitungen.inc"
 
-<page func="Infodrom Oldenburg" title="Zeitungen">
-
-<sql_prepare>
 <?
   $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;
@@ -29,9 +39,6 @@
 		  addslashes ($_POST[type]))
 	. " WHERE oid = $_POST[oid]";
     }
-  } elseif (isset($_GET["approve"]) && is_numeric($_GET["approve"])) {
-      $query = sprintf ("UPDATE zeitungen SET deleted = false WHERE oid = %d", $_GET["approve"]);
-      printf ('<p><a href="edit.php?oid=%d">Edit</a></p>', $_GET["approve"]);
   } elseif (isset($_GET["delete"]) && is_numeric($_GET["delete"])) {
       $query = sprintf ("UPDATE zeitungen SET deleted = true WHERE oid = %d", $_GET["delete"]);
   } else {
-- 
2.20.1