';
?>
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 (";
$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 "
";
?>