'; ?> 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) "; $sql_ins .= "VALUES ($1,$2,$3,$4,$5,$6,$7,$8)"; $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"]); $t = array('s','i','i','s','s','s','s','i'); db_prep_query($sql_ins,$v,$t); $cnt++; } $sql = "SELECT * FROM gui_layer WHERE fkey_gui_id = '".$guiID."' AND gui_layer_wms_id = ".$wmsID; $res = db_query($sql); $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) "; $sql_ins .= "VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)"; $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"]); $t = array('s','i','i','i','i','i','i','i','i','i','i'); 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 ("; for($i=0; $i0){ $sql .= ",";} $sql .= "'".$ownguis[$i]."'"; } $sql .= ") ORDER BY gui_name"; $res = db_query($sql); $count=0; echo"

"; echo "		"; echo"WMS"; echo"
"; if(isset($guiList) && $guiList!=""){ $sql = "SELECT DISTINCT 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("; for($i=0; $i0){$sql .= ",";} $sql .= "'".$arrayGUIs[$i]."'"; } $sql .= ") ORDER BY wms.wms_title"; $res = db_query($sql); echo ""; if(isset($wmsID)){ echo "
FROM:
"; $sql = "SELECT * from gui_wms WHERE fkey_wms_id ='".$wmsID."' ORDER BY fkey_gui_id"; $res = db_query($sql); echo ""; } echo ""; }else{ echo "There are no guis available for this user. Please create a gui first."; } echo "
" . $wms_getcapabilities . "
"; ?>