'; ?> Load WMS from Catalog getGuisByOwner($_SESSION["mb_user_id"],true); // insert values here if(isset($catID) && isset($guiID_)){ $sql_ins = "INSERT INTO gui_cat (fkey_gui_id,fkey_cat_id) "; $sql_ins .= "VALUES ($1,$2)"; $v = array($guiList,$catID); $t = array('s','i'); db_prep_query($sql_ins,$v,$t); } echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
"; if (count($ownguis)>0){ echo"GUI"; echo"
"; $sql = "SELECT * FROM gui WHERE gui_id IN ("; $v = $ownguis; $t = array(); for ($i = 1; $i <= count($ownguis); $i++){ if ($i > 1) { $sql .= ","; } $sql .= "$".$i; array_push($t, "s"); } $sql .= ") ORDER BY gui_name"; $res = db_prep_query($sql, $v, $t); $count=0; echo"

"; echo "
"; echo "Catalog"; echo "
"; if(isset($guiList) && $guiList!=""){ $sql = "SELECT DISTINCT cat_id, cat_title FROM gui_cat "; $sql .= "JOIN gui ON gui_cat.fkey_gui_id = gui.gui_id JOIN cat ON gui_cat.fkey_cat_id=cat.cat_id "; $sql .= "AND gui_cat.fkey_gui_id=gui.gui_id WHERE gui.gui_name = $1"; $v = array($guiList); $t = array('s'); $res = db_prep_query($sql,$v,$t); $count=0; echo"

"; }else{ echo"

"; } echo "

"; echo"
Load Catalog
"; $sql = "SELECT DISTINCT cat.cat_id,cat.cat_title,cat.cat_abstract,cat.cat_owner FROM gui_cat JOIN cat ON "; $sql .= "cat.cat_id = gui_cat.fkey_cat_id WHERE gui_cat.fkey_gui_id IN("; $v = $arrayGUIs; $t = array(); for ($i = 1; $i <= count($arrayGUIs); $i++){ if ($i > 1) { $sql .= ","; } $sql .= "$" . $i; array_push($t, "s"); } $sql .= ") ORDER BY cat.cat_title"; $res = db_prep_query($sql, $v, $t); echo ""; if(isset($catID)){ echo "
FROM:
"; $sql = "SELECT * from gui_cat WHERE fkey_cat_id = $1 ORDER BY fkey_gui_id"; $v = array($catID); $t = array("s"); $res = db_prep_query($sql, $v, $t); echo ""; } echo "
"; }else{ echo "There are no GUIs available for this user. Please create a GUI first."; } echo "
" . $wms_getcapabilities . "
"; ?>