[Mapbender-commits] r1761 - trunk/mapbender/http/php

Mon Oct 29 07:07:35 EDT 2007

Author: christoph
Date: 2007-10-29 07:07:35 -0400 (Mon, 29 Oct 2007)
New Revision: 1761

Modified:
   trunk/mapbender/http/php/mod_wfs_edit.php
Log:
added wfs conf description and title, replacing abstract

Modified: trunk/mapbender/http/php/mod_wfs_edit.php
===================================================================

--- trunk/mapbender/http/php/mod_wfs_edit.php	2007-10-26 15:22:11 UTC (rev 1760)
+++ trunk/mapbender/http/php/mod_wfs_edit.php	2007-10-29 11:07:35 UTC (rev 1761)
@@ -18,6 +18,7 @@
 # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 
 require(dirname(__FILE__)."/../../conf/mapbender.conf");
+session_start();
 ?>
 <html>
 <head>
@@ -59,6 +60,7 @@
 
         $sql = "UPDATE wfs_conf SET ";
         $sql .= "wfs_conf_abstract = '".$_REQUEST["wfs_conf_abstract"]."',";
+        $sql .= "wfs_conf_description = '".$_REQUEST["wfs_conf_description"]."',";
         $sql .= "g_label = '".$_REQUEST["g_label"]."',";
         $sql .= "g_label_id = '".$_REQUEST["g_label_id"]."',";
         $sql .= "g_button = '".$_REQUEST["g_button"]."',";
@@ -140,8 +142,10 @@
 
 /* select wfs */
 
-$sql = "SELECT * FROM wfs_conf";
-$res = db_query($sql);
+$sql = "SELECT * FROM wfs_conf, wfs WHERE wfs.wfs_owner = $1 AND wfs_conf.fkey_wfs_id = wfs.wfs_id";
+$v = array($_SESSION['mb_user_id']);
+$t = array('i');
+$res = db_prep_query($sql,$v,$t);
 echo "<select size='10' name='gaz' onchange='submit()'>";
 $cnt = 0;
 while($row = db_fetch_array($res)){
@@ -173,7 +177,8 @@
         if($row = db_fetch_array($res)){
                 echo "<table>";
                 echo "<tr><td>GazetterID:</td><td>".$row["wfs_conf_id"]."</td></tr>" ;
-                echo "<tr><td>Abstract:</td><td><input type='text' name='wfs_conf_abstract' value='".$row["wfs_conf_abstract"]."'></td></tr>" ;
+                echo "<tr><td>Title:</td><td><input type='text' name='wfs_conf_abstract' value='".$row["wfs_conf_abstract"]."'></td></tr>" ;
+                echo "<tr><td>Description:</td><td><input type='text' name='wfs_conf_description' value='".$row["wfs_conf_description"]."'></td></tr>" ;
                 echo "<tr><td>Label:</td><td><input type='text' name='g_label' value='".$row["g_label"]."'></td></tr>" ;
                 echo "<tr><td>Label_id:</td><td><input type='text' name='g_label_id' value='".$row["g_label_id"]."'></td></tr>" ;
                 echo "<tr><td>Button:</td><td><input type='text' name='g_button' value='".$row["g_button"]."'></td></tr>" ;

