';
?>
Add WMS from Catalog
get("mb_user_name");
$logged_user_id=Mapbender::session()->get("mb_user_id");
$logged_gui_id=Mapbender::session()->get("mb_user_gui");
/*get infos from gui_element ********************************************************************************************/
$sql_target = "SELECT e_requires, e_target FROM gui_element WHERE e_id = 'addWMS' AND fkey_gui_id = $1";
$v = array($logged_gui_id);
$t = array('s');
$res_target = db_prep_query($sql_target, $v, $t);
$cnt_target = 0;
while($row = db_fetch_array($res_target)){
$e_target = $row["e_target"];
$e_require = $row["e_requires"];
$cnt_target++;
}
if($cnt_target > 1){
echo "alert('addWMS: ID not unique!');";
}
echo "";
/*get infos from gui_element ********************************************************************************************/
/*get allocated gui ********************************************************************************************/
$arrayGuis=mb_getGUIs($logged_user_id);
$sql_gui = "SELECT * FROM gui WHERE gui_id IN (";
$v = $arrayGuis;
$t = array();
for ($i = 1; $i <= count($arrayGuis); $i++){
if ($i > 1) {
$sql_gui .= ",";
}
$sql_gui .= "$" . $i;
array_push($t, "s");
}
$sql_gui.= ") ORDER BY gui_name";
$res_gui = db_prep_query($sql_gui, $v, $t);
while($row = db_fetch_array($res_gui)){
$gui_id[$cnt_gui] = $row["gui_id"];
$gui_name[$cnt_gui] = $row["gui_name"];
$cnt_gui++;
}
/*get allocated gui ********************************************************************************************/
/*get allocated wms from allocated gui ********************************************************************************************/
$sql_gui_wms = "SELECT DISTINCT fkey_wms_id FROM gui_wms WHERE fkey_gui_id IN (";
$v = $arrayGuis;
$t = array();
for ($i = 1; $i <= count($arrayGuis); $i++){
if ($i > 1) {
$sql_gui_wms .= ",";
}
$sql_gui_wms .= "$".$i;
array_push($t, "s");
}
$sql_gui_wms.= ") ORDER BY fkey_wms_id";
$res_gui_wms = db_prep_query($sql_gui_wms, $v, $t);
while($row = db_fetch_array($res_gui_wms)){
$fkey_gui_id[$cnt_gui_wms] = $row["fkey_gui_id"];
$fkey_wms_id[$cnt_gui_wms] = $row["fkey_wms_id"];
$cnt_gui_wms++;
}
/*get allocated wms from allocated gui ********************************************************************************************/
/*get allocated wms-Abstract and wms-Capabilities from allocated gui ********************************************************************************************/
$sql_wms = "SELECT DISTINCT wms_id, wms_title, wms_abstract, wms_getcapabilities,wms_version FROM wms WHERE wms_id IN (";
$v = $fkey_wms_id;
$t = array();
for ($i = 1; $i <= count($fkey_wms_id); $i++){
if ($i > 1) {
$sql_wms .= ",";
}
$sql_wms .= "$" . $i;
array_push($t, "s");
}
#$sql_wms.= ") ORDER BY wms_id";
$sql_wms.= ") ORDER BY wms_title";
$res_wms = db_prep_query($sql_wms, $v, $t);
while($row = db_fetch_array($res_wms)){
$wms_id[$cnt_wms] = $row["wms_id"];
$wms_title[$cnt_wms] = $row["wms_title"];
$wms_abstract[$cnt_wms] = $row["wms_abstract"];
$wms_getcapabilities[$cnt_wms] = $row["wms_getcapabilities"];
$wms_version[$cnt_wms] = $row["wms_version"];
$cnt_wms++;
}
/*get allocated wms-Abstract and wms-Capabilities from allocated gui ********************************************************************************************/
/*INSERT HTML*/
#echo "";
echo "";
echo " ";
echo "WMS-Title | WMS-Abstract | ";
echo "
";
echo " ";
for($i=0; $i<$cnt_wms; $i++){
echo "";
echo "".$wms_title[$i]." | ";
echo "".$wms_abstract[$i]." | ";
echo "
";
}
echo " ";
echo "
";
?>