';
?>
changeEPSG_dynamic
get("mb_user_gui");
$con = db_connect($DBSERVER,$OWNER,$PW);
db_select_db(DB,$con);
$sql = "SELECT e_target FROM gui_element WHERE e_id = 'changeEPSG' AND fkey_gui_id = $1";
$v = array($gui_id);
$t = array('s');
$res = db_prep_query($sql,$v,$t);
$cnt_gui_wms = 0;
$cnt_epsg_wms = 0;
$cnt_layer_wms = 0;
/*get allocated wms from allocated gui ***********************************************************/
$sql_gui_wms = "SELECT fkey_wms_id FROM gui_wms WHERE fkey_gui_id = $1 ORDER BY fkey_wms_id";
$v = array($gui_id);
$t = array('s');
$res_gui_wms = db_prep_query($sql_gui_wms,$v,$t);
while(db_fetch_row($res_gui_wms)){
$fkey_gui_id[$cnt_gui_wms] = db_result($res_gui_wms,$cnt_gui_wms,"fkey_gui_id");
$fkey_wms_id_1[$cnt_gui_wms] = db_result($res_gui_wms,$cnt_gui_wms,"fkey_wms_id");
$cnt_gui_wms++;
}
/*get allocated wms from allocated gui ***********************************************************/
/*get allocated layer_id from allocated gui ******************************************************/
$v = array();
$t = array();
$sql_layer_wms = "SELECT layer_id FROM layer WHERE fkey_wms_id IN (";
for($i=0; $i0){ $sql_layer_wms .= ",";}
$sql_layer_wms .= "$".($i+1);
array_push($v,$fkey_wms_id_1[$i]);
array_push($t,'i');
}
$sql_layer_wms.= ") ORDER BY layer_id";
$res_layer_wms = db_prep_query($sql_layer_wms,$v,$t);
while($row = db_fetch_array($res_layer_wms)){
$layer_id[$cnt_layer_wms] = $row["layer_id"];
$fkey_wms_id[$cnt_layer_wms] = $row["fkey_wms_id"];
$cnt_layer_wms++;
}
/*get allocated wms from allocated gui ***********************************************************/
/*get allocated epsg-code from allocated wms *****************************************************/
$v = array();
$t = array();
$sql_epsg_wms = "SELECT DISTINCT wms_srs FROM wms_srs WHERE fkey_wms_id IN (";
for($i=0; $i0){ $sql_epsg_wms .= ",";}
$sql_epsg_wms .= "$".($i+1);
array_push($v,$fkey_wms_id_1[$i]);
array_push($t,'i');
}
$sql_epsg_wms.= ") ORDER BY wms_srs";
$res_epsg_wms = db_prep_query($sql_epsg_wms,$v,$t);
while($row = db_fetch_array($res_epsg_wms)){
$fkey_wms_id_2[$cnt_epsg_wms] = $row["fkey_wms_id"];
$epsg_code[$cnt_epsg_wms] = $row["wms_srs"];
$cnt_epsg_wms++; //possible error because increment before echo statement
echo"$epsg_code[$cnt_epsg_wms]";
}
echo "";
# transform coordinates
if(isset($_REQUEST["srs"])){
require_once(dirname(__FILE__)."/../../conf/mapbender.conf");
$con = pg_connect ($con_string) or die ("Error while connecting database DBname");
$arraymapObj = mb_split("###", $_REQUEST["srs"]);
echo "";
}
else{
echo "";
}
?>
";
echo "";
/*insert EPSG in selectbox************************************************************************************/
echo"";
echo"";
echo"";
?>