<?php # $Id$ # http://www.mapbender.org/index.php/Administration # Copyright (C) 2002 CCGIS # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2, or (at your option) # any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. require_once(dirname(__FILE__)."/../php/mb_validateSession.php"); ?> <html> <head> <?php echo '<meta http-equiv="Content-Type" content="text/html; charset='.CHARSET.'">'; ?> <title>Edit Gazetteer</title> <script language="JavaScript" type="text/javascript"> function validate(){ for(var i=0; i<document.forms[0].length; i++){ if(document.forms[0].elements[i].type == 'checkbox'){ if(document.forms[0].elements[i].checked){ document.forms[0].elements[i].value = 1; } else{ document.forms[0].elements[i].value = 0; } document.forms[0].elements[i].checked = true; } } return true; } </script> </head> <body> Gazetteer Configuration<br> <form method='POST' onsubmit='return validate()'> <?php /* save gazetteer properties */ $con = db_connect($DBSERVER,$OWNER,$PW); db_select_db(DB,$con); if(isset($_REQUEST["save"])){ $sql = "UPDATE gazetteer SET "; $sql .= "gazetteer_abstract = $1, "; $sql .= "g_label = $2, "; $sql .= "g_label_id = $3, "; $sql .= "g_button = $4, "; $sql .= "g_button_id = $5, "; $sql .= "g_style = $6, "; $sql .= "g_buffer = $7 "; $sql .= "WHERE gazetteer_id = $8;"; $v = array($_REQUEST["gazetteer_abstract"], $_REQUEST["g_label"], $_REQUEST["g_label_id"], $_REQUEST["g_button"], $_REQUEST["g_button_id"], $_REQUEST["g_style"], $_REQUEST["g_buffer"], $_REQUEST["fkey_gazetteer_id"]); $t = array("s", "s", "s", "s", "s", "s", "s", "i"); $res = db_prep_query($sql, $v, $t); for ($i = 0; $i < count($_REQUEST["f_id"]); $i++){ $sql = "UPDATE gazetteer_element SET "; $sql .= "f_search = $1, "; $sql .= "f_pos = $2, "; $sql .= "f_style_id = $3, "; $sql .= "f_label = $4, "; $sql .= "f_label_id = $5, "; $sql .= "f_show = $6, "; $sql .= "f_respos = $7 "; $sql .= "WHERE fkey_gazetteer_id = $8 AND f_id = $9;"; $v = array($_REQUEST["f_search"][$i], $_REQUEST["f_pos"][$i], $_REQUEST["f_style_id"][$i], $_REQUEST["f_label"][$i], $_REQUEST["f_label_id"][$i], $_REQUEST["f_show"][$i], $_REQUEST["f_respos"][$i], $_REQUEST["fkey_gazetteer_id"], $_REQUEST["f_id"][$i]); $t = array("s", "s", "s", "s", "s", "s", "s", "i", "i"); $res = db_prep_query($sql, $v, $t); } } /* end save gazetteer properties */ /* select wfs */ /* end select wfs */ /* configure elements */ if(isset($_REQUEST["fkey_gazetteer_id"])){ $sql = "SELECT * FROM gazetteer WHERE gazetteer_id = $1"; $v = array($_REQUEST["fkey_gazetteer_id"]); $t = array("i"); $res = db_prep_query($sql, $v, $t); if($row = db_fetch_array($res)){ echo "<table>"; echo "<tr><td>ID:</td><td>".$row["gazetteer_id"]."</td></tr>" ; echo "<tr><td>Abstract:</td><td><input type='text' name='gazetteer_abstract' value='".$row["gazetteer_abstract"]."'></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>" ; echo "<tr><td>Button_id:</td><td><input type='text' name='g_button_id' value='".$row["g_button_id"]."'></td></tr>" ; echo "<tr><td>Style:</td><td><textarea cols=30 rows=5 name='g_style'>".$row["g_style"]."</textarea></td></tr>" ; echo "<tr><td>Buffer:</td><td><input type='text' size='4' name='g_buffer' value='".$row["g_buffer"]."'></td></tr>" ; echo "</table>"; } /* set element options */ $sql = "SELECT * FROM gazetteer_element "; $sql .= "JOIN wfs_element ON gazetteer_element.f_id = wfs_element.element_id "; $sql .= "WHERE fkey_gazetteer_id = $1"; $v = array($_REQUEST["fkey_gazetteer_id"]); $t = array("i"); $res = db_prep_query($sql, $v, $t); echo "<table border='1'>"; echo "<tr>"; echo "<td>ID</td>"; echo "<td>name</td>"; echo "<td>type</td>"; echo "<td>search</td>"; echo "<td>pos</td>"; echo "<td>style_id</td>"; echo "<td>label</td>"; echo "<td>label_id</td>"; echo "<td>show</td>"; echo "<td>position</td>"; echo "</tr>"; $cnt = 0; while($row = db_fetch_array($res)){ echo "<tr>"; echo "<td><input type='text' size='4' name='f_id[]' value='".$row["gazetteer_element.f_id"]."' readonly></td>"; echo "<td>".$row["wfs_element.element_name"]."</td>"; echo "<td>".$row["wfs_element.element_type"]."</td>"; echo "<td><input name='f_search[]' type='checkbox'"; if($row["gazetteer_element.f_search"] == 1){ echo " checked"; } echo "></td>"; echo "<td><input name='f_pos[]' type='text' size='2' value='".$row["gazetteer_element.f_pos"]."'></td>"; echo "<td><input name='f_style_id[]' type='text' size='2' value='".$row["gazetteer_element.f_style_id"]."'></td>"; echo "<td><input name='f_label[]' type='text' size='10' value='".$row["gazetteer_element.f_label"]."'></td>"; echo "<td><input name='f_label_id[]' type='text' size='2' value='".$row["gazetteer_element.f_label_id"]."'></td>"; echo "<td><input name='f_show[]' type='checkbox'"; if($row["gazetteer_element.f_show"] == 1){ echo " checked"; } echo "></td>"; echo "<td><input name='f_respos[]' type='text' size='4' value='".$row["gazetteer_element.f_respos"]."'></td>"; echo "</tr>"; $cnt++; } echo "</table>"; echo "<input type='submit' name='save' value='save'>"; } /* end configure elements */ ?> </form> </body>