';
?>
mod_wfs_gazetteer
1){
for($i=0; $i < $cnt_confs; $i++){
$res = db_prep_query($sql,$v2[$i],$t);
if($row = db_fetch_array($res)){
$g_label[$v2[$i]] = $row["g_label"];
$g_label_id[$v2[$i]] = $row["g_label_id"];
$g_style[$v2[$i]] = $row["g_style"];
$g_button[$v2[$i]] = $row["g_button"];
$g_button_id[$v2[$i]] = $row["g_button_id"];
$g_buffer[$v2[$i]] = $row["g_buffer"];
$g_res_style[$v2[$i]] = $row["g_res_style"];
$g_use_wzgraphics[$v2[$i]] = $row["g_use_wzgraphics"];
$wfs_id[$v2[$i]] = $row["fkey_wfs_id"];
$featuretype_id[$v2[$i]] = $row["fkey_featuretype_id"];
$wfs_getfeature[$v2[$i]] = $row["wfs_getfeature"];
}
}
echo "";
//display select box for different wfs_confs
echo "";
$sql = "SELECT * FROM wfs_featuretype ";
$sql .= "WHERE fkey_wfs_id = $1 AND featuretype_id = $2";
//if first value of select box is active and there was not yet a selection of another value, take index 0 for the
//following steps
if(!isset($_REQUEST["selected_conf"])){
$v = array($wfs_id[$v2[0]],$featuretype_id[$v2[0]]);
$t = array('i','i');
$res = db_prep_query($sql,$v,$t);
if($row = db_fetch_array($res)){
$featuretype_name = $row["featuretype_name"];
$featuretype_srs = $row["featuretype_srs"];
}
else{
die("Please add the wfs_conf to the src-Parameter");
}
echo "";
/* wfs_conf_element */
$sql = "SELECT * FROM wfs_conf_element ";
$sql .= "JOIN wfs_element ON wfs_conf_element.f_id = wfs_element.element_id ";
$sql .= "WHERE wfs_conf_element.fkey_wfs_conf_id = $1 ";
$sql .= "AND wfs_conf_element.f_search = 1 ORDER BY wfs_conf_element.f_search;";
$v1 = array($_REQUEST["wfs_conf"]);
$t = array('i');
//split array $v1 (comma-separated) to get all chosen wfs_confs
$v2 = split(",", $v1[0]);
$res = db_prep_query($sql,$v2[0],$t);
echo '";
}
//if value of select box changed through new selection, do the following
else{
//set $i as selected_conf value
$i = $_REQUEST["selected_conf"];
$v = array($wfs_id[$i],$featuretype_id[$i]);
$t = array('i','i');
$res = db_prep_query($sql,$v,$t);
if($row = db_fetch_array($res)){
$featuretype_name = $row["featuretype_name"];
$featuretype_srs = $row["featuretype_srs"];
}
else{
die("Please add the wfs_conf to the src-Parameter");
}
echo "";
/* wfs_conf_element */
$sql = "SELECT * FROM wfs_conf_element ";
$sql .= "JOIN wfs_element ON wfs_conf_element.f_id = wfs_element.element_id ";
$sql .= "WHERE wfs_conf_element.fkey_wfs_conf_id = $1 ";
$sql .= "AND wfs_conf_element.f_search = 1 ORDER BY wfs_conf_element.f_search;";
#$v1 = array($_REQUEST["wfs_conf"]);
$t = array('i');
//split array $v1 (comma-separated) to get all chosen wfs_confs
#$v2 = split(",", $v1[0]);
$res = db_prep_query($sql,$i,$t);
echo '";
}
}
//do this if there is 1 wfs_conf
elseif($cnt_confs>0 && $cnt_confs==1){
$res = db_prep_query($sql,$v1,$t);
if($row = db_fetch_array($res)){
$g_label = $row["g_label"];
$g_label_id = $row["g_label_id"];
$g_style = $row["g_style"];
$g_button = $row["g_button"];
$g_button_id = $row["g_button_id"];
$g_buffer = $row["g_buffer"];
$g_res_style = $row["g_res_style"];
$g_use_wzgraphics = $row["g_use_wzgraphics"];
$wfs_id = $row["fkey_wfs_id"];
$featuretype_id = $row["fkey_featuretype_id"];
$wfs_getfeature = $row["wfs_getfeature"];
}
$sql = "SELECT * FROM wfs_featuretype ";
$sql .= "WHERE fkey_wfs_id = $1 AND featuretype_id = $2";
//get wfs_id & featuretype_id as array
$v = array($wfs_id,$featuretype_id);
$t = array('i','i');
$res = db_prep_query($sql,$v,$t);
if($row = db_fetch_array($res)){
$featuretype_name = $row["featuretype_name"];
$featuretype_srs = $row["featuretype_srs"];
}
else{
die("Please add the wfs_conf to the src-Parameter");
}
echo "";
/* wfs_conf_element */
$sql = "SELECT * FROM wfs_conf_element ";
$sql .= "JOIN wfs_element ON wfs_conf_element.f_id = wfs_element.element_id ";
$sql .= "WHERE wfs_conf_element.fkey_wfs_conf_id = $1 ";
$sql .= "AND wfs_conf_element.f_search = 1 ORDER BY wfs_conf_element.f_search;";
$v = array($_REQUEST["wfs_conf"]);
$t = array('i');
$res = db_prep_query($sql,$v,$t);
echo '";
}
//do this if wfs_conf is missing
else{
die("Please add the wfs_conf to the src-Parameter!");
}
?>