';
?>
Add WMS from Catalog
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 (";
for($i=0; $i0){ $sql_gui .= ",";}
$sql_gui .= "'".$arrayGuis[$i]."'";
}
$sql_gui.= ") ORDER BY gui_name";
$res_gui = db_query($sql_gui);
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 (";
for($i=0; $i0){ $sql_gui_wms .= ",";}
$sql_gui_wms .= "'".$arrayGuis[$i]."'";
}
$sql_gui_wms.= ") ORDER BY fkey_wms_id";
$res_gui_wms = db_query($sql_gui_wms);
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_title, wms_abstract, wms_getcapabilities,wms_version FROM wms WHERE wms_id IN (";
for($i=0; $i0){ $sql_wms .= ",";}
$sql_wms .= "'".$fkey_wms_id[$i]."'";
}
#$sql_wms.= ") ORDER BY wms_id";
$sql_wms.= ") ORDER BY wms_title";
$res_wms = db_query($sql_wms);
while($row = db_fetch_array($res_wms)){
$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 "
";
?>