'; ?> Load WMS from Catalog getGuisByOwner($_SESSION["mb_user_id"],true); ###INSERT if(isset($wmsID) && isset($guiID_)){ $sql_pos = "SELECT MAX(gui_wms_position) AS my_gui_wms_position FROM gui_wms WHERE fkey_gui_id = $1"; $v = array($guiList); $t = array('s'); $res_pos = db_prep_query($sql_pos,$v,$t); if(db_result($res_pos,0,"my_gui_wms_position") > -1){ $gui_wms_position = db_result($res_pos,0,"my_gui_wms_position") + 1; } else{ $gui_wms_position = 0; } $sql = "SELECT * FROM gui_wms WHERE fkey_gui_id = $1 AND fkey_wms_id = $2"; $v = array($guiID_,$wmsID); $t = array('s','i'); $res = db_prep_query($sql,$v,$t); $cnt = 0; while($row = db_fetch_array($res)){ $sql_ins = "INSERT INTO gui_wms (fkey_gui_id,fkey_wms_id,gui_wms_position,gui_wms_mapformat,"; $sql_ins .= "gui_wms_featureinfoformat,gui_wms_exceptionformat,gui_wms_epsg,gui_wms_visible,gui_wms_opacity,gui_wms_sldurl) "; $sql_ins .= "VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10)"; $v = array($guiList,$wmsID,$gui_wms_position,$row["gui_wms_mapformat"],$row["gui_wms_featureinfoformat"], $row["gui_wms_exceptionformat"],$row["gui_wms_epsg"],$row["gui_wms_visible"],$row["gui_wms_opacity"],$row["gui_wms_sldurl"]); $t = array('s','i','i','s','s','s','s','i','i','s'); db_prep_query($sql_ins,$v,$t); $cnt++; } $sql = "SELECT * FROM gui_layer WHERE fkey_gui_id = $1 AND gui_layer_wms_id = $2"; $v = array($guiID_, $wmsID); $t = array("s", "i"); $res = db_prep_query($sql, $v, $t); $cnt = 0; while($row = db_fetch_array($res)){ $sql_ins = "INSERT INTO gui_layer (fkey_gui_id,fkey_layer_id,gui_layer_wms_id,gui_layer_status,gui_layer_selectable,"; $sql_ins .= "gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,gui_layer_maxscale,gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype) "; $sql_ins .= "VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)"; $v = array($guiList,$row["fkey_layer_id"],$wmsID,$row["gui_layer_status"],$row["gui_layer_selectable"], $row["gui_layer_visible"],$row["gui_layer_queryable"],$row["gui_layer_querylayer"],$row["gui_layer_minscale"], $row["gui_layer_maxscale"],$row["gui_layer_priority"],$row["gui_layer_style"],$row["gui_layer_wfs_featuretype"]); $t = array('s','i','i','i','i','i','i','i','i','i','i','s','s'); db_prep_query($sql_ins,$v,$t); $cnt++; } } 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"WMS"; echo"
"; if(isset($guiList) && $guiList!=""){ $sql = "SELECT DISTINCT wms_id, wms.wms_abstract, wms.wms_title, gui_wms_position FROM gui_wms "; $sql .= "JOIN gui ON gui_wms.fkey_gui_id = gui.gui_id JOIN wms ON gui_wms.fkey_wms_id=wms.wms_id "; $sql .= "AND gui_wms.fkey_gui_id=gui.gui_id WHERE gui.gui_name = $1 ORDER BY gui_wms_position"; $v = array($guiList); $t = array('s'); $res = db_prep_query($sql,$v,$t); $count=0; echo"

"; }else{ echo"

"; } echo "

"; echo"
Load WMS
"; $sql = "SELECT DISTINCT wms.wms_id,wms.wms_title,wms.wms_abstract,wms.wms_owner FROM gui_wms JOIN wms ON "; $sql .= "wms.wms_id = gui_wms.fkey_wms_id WHERE gui_wms.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 wms.wms_title"; $res = db_prep_query($sql, $v, $t); echo ""; if(isset($wmsID)){ echo "
FROM:
"; $sql = "SELECT * from gui_wms WHERE fkey_wms_id = $1 ORDER BY fkey_gui_id"; $v = array($wmsID); $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 . "
"; ?>