svn commit: r89 - trunk/mapbender/http/javascripts/mod_addWMS.php

[arnulf at osgeo.org]

Author: arnulf
Date: 2006-04-19 11:48:30+0000
New Revision: 89

Modified:
   trunk/mapbender/http/javascripts/mod_addWMS.php   (contents, props changed)

Log:
code cleaned, added prepared statements

Modified: trunk/mapbender/http/javascripts/mod_addWMS.php
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/javascripts/mod_addWMS.php?view=diff&rev=89&p1=trunk/mapbender/http/javascripts/mod_addWMS.php&p2=trunk/mapbender/http/javascripts/mod_addWMS.php&r1=88&r2=89
==============================================================================
--- trunk/mapbender/http/javascripts/mod_addWMS.php	(original)
+++ trunk/mapbender/http/javascripts/mod_addWMS.php	2006-04-19 11:48:30+0000
@@ -1,6 +1,6 @@
 <?php
-#$Id: mod_addWMS.php,v 1.8 2005/09/13 18:16:42 bjoern_heuser Exp $
-#$Header: /cvsroot/mapbender/mapbender/http/javascripts/mod_addWMS.php,v 1.8 2005/09/13 18:16:42 bjoern_heuser Exp $
+# $Id$
+# http://www.mapbender.org/index.php/AddWMS
 # Copyright (C) 2002 CCGIS 
 #
 # This program is free software; you can redistribute it and/or modify
@@ -17,18 +17,19 @@
 # along with this program; if not, write to the Free Software
 # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 
-
 $gui_id = $_REQUEST["gui_id"];
 require_once("../../conf/mapbender.conf");
 $con = db_connect($DBSERVER,$OWNER,$PW);
 db_select_db(DB,$con);
-$sql = "SELECT e_requires, e_target FROM gui_element WHERE e_id = 'addWMS' AND fkey_gui_id = '".$gui_id."'";
-$res = db_query($sql);
+$sql = "SELECT e_requires, e_target FROM gui_element WHERE e_id = 'addWMS' AND fkey_gui_id = $1 ";
+$v = array($gui_id);
+$t = array("s");
+$res = db_prep_query($sql, $v, $t);
 $cnt = 0;
-while($row = db_fetch_array($res)){ 
-   $e_target = $row["e_target"];
-   $e_require = $row["e_requires"];
-   $cnt++;
+while($row = db_fetch_array($res)){
+	$e_target = $row["e_target"];
+	$e_require = $row["e_requires"];
+	$cnt++;
 }
 if($cnt > 1){ echo "alert('addWMS: ID not unique!');";}
 echo "var mod_addWMS_data = '".$e_require."';";
@@ -38,16 +39,16 @@
 ?>
 
 function mod_addWMS(){
-   var load = prompt("Capabilities - URL:","");
-   if(load){
-      mod_addWMS_load(load);    
-   }
+	var load = prompt("Capabilities - URL:","");
+	if(load){
+		mod_addWMS_load(load);    
+	}
 }
 function mod_addWMS_load(caps){
-   window.frames[mod_addWMS_data].document.location.href = "../php/mod_createJSObjFromXML.php?caps=" + escape(caps);
+	window.frames[mod_addWMS_data].document.location.href = "../php/mod_createJSObjFromXML.php?caps=" + escape(caps);
 }
 function mod_addWMS_refresh(){
-   mb_mapObjaddWMS(mod_addWMS_target2);
-   window.frames[mod_addWMS_target1].document.location.reload();
-   zoom(mod_addWMS_target2, true, 1.0); // div-tags have to be created
+	mb_mapObjaddWMS(mod_addWMS_target2);
+	window.frames[mod_addWMS_target1].document.location.reload();
+	zoom(mod_addWMS_target2, true, 1.0);
 }
\ No newline at end of file