'; ?>
nestedSets
= $1 AND fkey_gui_id = $2"; $v = array($left, $guiList); $t = array("i", "s"); db_prep_query($sql, $v, $t); #echo $sql . " 1: ".$left." 2:".$guiList."
"; $sql = "UPDATE gui_treegde SET lft=lft+2 WHERE lft >= $1 AND fkey_gui_id = $2"; $v = array($left, $guiList); $t = array("i", "s"); db_prep_query($sql, $v, $t); #echo $sql . " 1: ".$left." 2:".$guiList."
"; $sql = "INSERT INTO gui_treegde(fkey_gui_id, fkey_layer_id, lft,rgt, "; $sql .= "my_layer_title, layer, wms_id) VALUES($1, $2, $3, $4, $5, $6, $7)"; #echo $sql . "
"; $v = array($guiList, $temp[0], $left, ($left+1), $name, $temp[1], $wmsList); $t = array("s", "s", "i", "i", "s", "s", "s"); db_prep_query($sql, $v, $t); /* if($layer == ""){ $left = $left + 1; $sql = "UPDATE gui_treegde SET rgt=rgt+2 WHERE rgt >=". $left." AND fkey_gui_id = '".$guiList."'"; db_query($sql); $sql = "UPDATE gui_treegde SET lft=lft+2 WHERE lft >=".$left." AND fkey_gui_id = '".$guiList."'"; db_query($sql); #hier ist noch was falsch $sql = "INSERT INTO gui_treegde(fkey_gui_id,my_layer_title,lft,rgt,layer) VALUES('".$guiList."','new',".$left.",".($left+1).",'new')"; #echo $sql . "
"; db_query($sql); } */ } if(isset($action) && $action == "delete"){ if($left){ $sql = "SELECT rgt FROM gui_treegde WHERE lft = $1 AND fkey_gui_id = $2"; $v = array($left, $guiList); $t = array("i", "s"); $res = db_prep_query($sql, $v, $t); $right = db_result($res,0,"rgt"); $sql = "DELETE FROM gui_treegde WHERE lft BETWEEN $1 and $2 AND fkey_gui_id = $3"; $v = array($left, $right, $guiList); $t = array("i", "i", "s"); db_prep_query($sql, $v, $t); $sql = "UPDATE gui_treegde SET lft=lft-$1 WHERE lft > $2 AND fkey_gui_id = $3"; $v = array($right-$left+1, $right, $guiList); $t = array("i", "i", "s"); db_prep_query($sql, $v, $t); #echo $sql . " r:".$right." l:".$left." 2:".$guiList."
"; $sql = "UPDATE gui_treegde SET rgt=rgt-$1 WHERE rgt > $2 AND fkey_gui_id = $3"; $v = array($right-$left+1, $right, $guiList); $t = array("i", "i", "s"); #echo $sql . " r:".$right." l:".$left." 2:".$guiList."
"; db_prep_query($sql, $v, $t); } } if(isset($action) && $action == "update"){ $temp = explode("###", $layer); $sql = "UPDATE gui_treegde SET "; $sql .= "my_layer_title = $1, "; $sql .= "fkey_layer_id = $2, "; $sql .= "layer = $3, "; $sql .= "wms_id = $4"; $sql .= " WHERE lft = $5 AND fkey_gui_id = $6"; $v = array($name, $temp[0], $temp[1], $wmsList, $left, $guiList); $t = array("s", "s", "s", "s", "i", "s"); db_prep_query($sql, $v, $t); } if(isset($action) && $action == "add"){ $temp = explode("###", $layer); $sql_val = "SELECT * FROM gui_treegde WHERE lft = $1 AND fkey_gui_id = $2"; $v = array($left, $guiList); $t = array("i", "s"); $res_val = db_prep_query($sql_val, $v, $t); $sql = "UPDATE gui_treegde SET "; $sql .= "fkey_layer_id = $1, layer = $2, wms_id = $3 "; $sql .= "WHERE lft = $4 AND fkey_gui_id = $5"; $v = array(); $t = array("s", "s", "s", "i", "s"); if (db_result($res_val, 0, "fkey_layer_id") != '') { array_push($v, db_result($res_val, 0, "fkey_layer_id") . "," . $temp[0]); } else { array_push($v, $temp[0]); } if (db_result($res_val, 0, "layer") != '') { array_push($v, db_result($res_val, 0, "layer") . "," . $temp[1]); } else { array_push($v, $temp[1]); } if (db_result($res_val, 0, "wms_id") != '') { array_push($v, db_result($res_val, 0, "wms_id") . "," . $wmsList); } else { array_push($v, $wmsList); } array_push($v, $left); array_push($v, $guiList); db_prep_query($sql, $v, $t); } ?>
Create your own tree for your GUI. Include the element treeconfGDE to see this tree
Find detailed infos in the (
Mapbender Wiki
)
1. Select the GUI you want to create the new tree for
2. Select an element in the folder view
"; } else{ echo "
"; } ?>
getGuisByOwner($_SESSION["mb_user_id"],true); $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); $cnt = 0; echo "
"; echo "
GUI ...
"; while($row = db_fetch_array($res)){ echo "
".$row["gui_name"]."
"; $cnt++; } echo "
"; echo "
"; #echo "
Beschriftung:
"; echo "
Labeling:
"; echo "
"; echo "
"; ?>
WMS:
WMS ...
"; echo $row["wms_title"]; echo ""; $cnt++; } } else{echo "
no gui selected
";} echo"
"; echo"
"; #echo"
Ordner oder Ebene:
"; echo"
Folder or Layer:
"; echo"
"; echo"
"; #echo"
Ordner
"; echo"
Folder
"; if(isset($wmsList) && $wmsList != ""){ $sql_l = "SELECT gui_layer.fkey_layer_id, layer.layer_name, layer.layer_title FROM gui_layer "; $sql_l .= "LEFT JOIN layer ON gui_layer.fkey_layer_id = layer.layer_id "; $sql_l .= "WHERE gui_layer.gui_layer_wms_id = $1 AND layer.layer_parent = '0' AND gui_layer.fkey_gui_id = $2"; $sql_l .= " ORDER BY layer.layer_title"; $v = array($wmsList, $guiList); $t = array("i", "s"); $res_l = db_prep_query($sql_l, $v, $t); $cnt = 0; while($row = db_fetch_array($res_l)){ echo "
"; echo $row["layer_title"]; echo "
"; $cnt++; } } ?>
Position:
hinter"; echo "
behind
"; echo "
in
"; echo"
"; #echo"
Hinter bzw. in Element Nr.:
"; echo"
Insert behind or
in element with number:
"; echo "
"; ?>