'; ?> Edit Metadata just save GUI description elseif ($mySave == '2') { $sql = array(); $v = array(); $t = array(); if ($SYS_DBTYPE == "pgsql") { $sql[0] = "SET AUTOCOMMIT=1"; $v[0] = array(); $t[0] = array(); } else { $sql[0] = "SET AUTOCOMMIT=0"; $v[0] = array(); $t[0] = array(); } $sql[1] = "BEGIN"; $v[1] = array(); $t[1] = array(); $sql[2] = "UPDATE gui SET gui_description = $1 WHERE gui_id = $2"; $v[2] = array($guiDesc, $guiId); $t[2] = array("s", "s"); } for ($i = 0; $i < count($sql); $i++) { $res = db_prep_query($sql[$i], $v[$i], $t[$i]); if(!$res){break;} } if($res){ $res = db_query( "COMMIT"); $res = db_query( "SET AUTOCOMMIT=1"); } else{ $res = db_query( "ROLLBACK"); $res = db_query( "SET AUTOCOMMIT=1"); } if(isset($sql_vars)){//sicherstellen das keine Element_Vars gel�scht wurden while($row = db_fetch_array($res_vars)){ $securesql = "INSERT INTO gui_element_vars (fkey_gui_id, "; $securesql .= "fkey_e_id, var_name, var_value, context,type) "; $securesql .= "VALUES ($1, $2, $3, $4, $5, $6)"; $v = array($guiList1, $e_id, $row["var_name"], $row["var_value"], $row["context"], $row["type"]); $t = array("s", "s", "s", "s", "s", "s"); //echo $securesql."
"; $secureinsert = db_prep_query($securesql, $v, $t); } } if(!$res){break;} } if(isset($myDelete) && $myDelete == '1'){ $sql = "DELETE FROM gui_element WHERE e_id = $1 AND fkey_gui_id = $2"; $v = array($e_id, $guiList1); $t = array("s", "s"); $res = db_prep_query($sql, $v, $t); $e_id = ""; $e_pos = ""; $e_public = ""; $e_comment = ""; $e_element = ""; $e_src = ""; $e_attributes = ""; $e_left = ""; $e_top = ""; $e_width = ""; $e_height = ""; $e_z_index = ""; $e_more_styles = ""; $e_content = ""; $e_closetag = ""; $e_js_file = ""; $e_mb_mod = ""; $e_target = ""; $e_requires = ""; } if(isset($myShow) && $myShow == '1'){ $_SESSION["mb_user_myGui"] = $guiList1; echo ""; } if(isset($all) && $all == '1'){ $sql = "SELECT * FROM gui_element WHERE fkey_gui_id = $1"; $v = array($guiList2); $t = array("s"); $res = db_prep_query($sql, $v, $t); $cnt = 0; while(db_fetch_row($res)){ $sql_del = "DELETE FROM gui_element WHERE fkey_gui_id = $1 AND e_id = $2"; $v = array($guiList1, db_result($res,$cnt,"e_id")); $t = array("s", "s"); $res_del = db_prep_query($sql_del, $v, $t); if(db_result($res,$cnt,"e_left") == ""){$myleft = 'NULL';} else{$myleft = db_result($res,$cnt,"e_left");} if(db_result($res,$cnt,"e_top") == ""){$mytop = 'NULL';} else{$mytop = db_result($res,$cnt,"e_top");} if(db_result($res,$cnt,"e_width") == ""){$mywidth = 'NULL';} else{$mywidth = db_result($res,$cnt,"e_width");} if(db_result($res,$cnt,"e_height") == ""){$myheight = 'NULL';} else{$myheight = db_result($res,$cnt,"e_height");} if(db_result($res,$cnt,"e_z_index") == ""){$my_z_index = 'NULL';} else{$my_z_index = db_result($res,$cnt,"e_z_index");} $sql_ins = "INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, "; $sql_ins .= "e_comment, e_element, e_src, e_attributes, e_left, e_top, "; $sql_ins .= "e_width, e_height, e_z_index, e_more_styles, e_content, "; $sql_ins .= "e_closetag, e_js_file, e_mb_mod, e_target, e_requires) "; $sql_ins .= "VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, "; $sql_ins .= "$10, $11, $12, $13, $14, $15, $16, $17, $18, $19);"; $v = array($guiList1, db_result($res,$cnt,"e_id"), db_result($res,$cnt,"e_pos"), db_result($res,$cnt,"e_public"), db_escape_string(db_result($res,$cnt,"e_comment")), db_result($res,$cnt,"e_element"), db_result($res,$cnt,"e_src"), db_escape_string(db_result($res,$cnt,"e_attributes")), $myleft, $mytop, $mywidth, $myheight, $my_z_index, db_result($res,$cnt,"e_more_styles"), db_escape_string(db_result($res,$cnt,"e_content")), db_result($res,$cnt,"e_closetag"), db_result($res,$cnt,"e_js_file"), db_result($res,$cnt,"e_mb_mod"), db_result($res,$cnt,"e_target"), db_result($res,$cnt,"e_requires")); $t = array("s", "s", "s", "s", "s", "s", "s", "s", "i", "i", "i", "i", "i", "s", "s", "s", "s", "s", "s", "s"); $res_ins = db_prep_query($sql_ins, $v, $t); if(!$res_ins){echo db_error($con); } $cnt++; } $sql = "SELECT * FROM gui_element_vars WHERE fkey_gui_id = $1"; $v = array($guiList2); $t = array("s"); $res = db_prep_query($sql, $v, $t); $cnt = 0; while(db_fetch_row($res)){ $sql_ins2 = "INSERT INTO gui_element_vars (fkey_gui_id, fkey_e_id, "; $sql_ins2 .= "var_name, var_value, context, type) VALUES ("; $sql_ins2 .= "$1, $2, $3, $4, $5, $6);"; $v = array($guiList1, db_result($res,$cnt,"fkey_e_id"), db_result($res,$cnt,"var_name"), db_escape_string(db_result($res,$cnt,"var_value")), db_escape_string(db_result($res,$cnt,"context")), db_result($res,$cnt,"type")); $t = array("s", "s", "s", "s", "s", "s"); $res_ins2 = db_prep_query($sql_ins2, $v, $t); if(!$res_ins2){echo db_error($connect); } $cnt++; } } # end echo ""; ?> getGuisByOwner($_SESSION["mb_user_id"],true); $permguis = $admin->getGuisByPermission($_SESSION["mb_user_id"],true); echo "
\n"; $sql = "SELECT * from gui WHERE gui.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 .= ")"; //echo $sql; $res = db_prep_query($sql, $v, $t); $count=0; while(db_fetch_row($res)){ $gui_id_own[$count]=db_result($res,$count,"gui_id"); $gui_name_own[$count]=db_result($res,$count,"gui_name"); $gui_description_own[$count]=db_result($res,$count,"gui_description"); $count++; } $sql = "SELECT * from gui WHERE gui.gui_id IN ("; $v = $permguis; $t = array(); for ($i = 1; $i <= count($permguis); $i++){ if ($i > 1) { $sql .= ","; } $sql .= "$" . $i; array_push($t, "s"); } $sql .= ")"; $res = db_prep_query($sql, $v, $t); $count=0; while($row = db_fetch_array($res)){ $gui_id_perm[$count]= $row["gui_id"]; $gui_name_perm[$count]=$row["gui_name"]; $gui_description_perm[$count]=$row["gui_description"]; $count++; } #Gui to edit if(!isset($guiList1)){ echo "
GUI:
\n"; echo "\n"; for ($i=0; $i\n"; echo "\n"; } echo "\n"; } else{ echo "
"; echo "Edit Elements: ".$guiList1; // set guiDesc and guiId if guiList1 has just been selected if (!$guiDesc) { $Desc = "guiDesc_" . $guiList1; $guiDesc = $$Desc; } if (!$guiId) { $Id = "guiId_" . $guiList1; $guiId = $$Id; } echo "  (" . $guiDesc; echo " ) \n"; echo "
\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; } #Depot if(isset($guiList1)){ echo "\n"; if($guiList1 != $guiList2){echo "\n";} } #Elements if(isset($guiList2)){ if($guiList1 == $guiList2){ echo "
Edit Element:
\n"; } else{ echo "
Templates
\n"; } $sql = "SELECT * FROM gui_element WHERE fkey_gui_id = $1 ORDER BY e_id"; $v = array($guiList2); $t = array("s"); $res = db_prep_query($sql, $v, $t); $cnt = 0; echo "
\n\n"; while(db_fetch_row($res)){ echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; $cnt++; } echo "
"; if(db_result($res,$cnt,"e_public") == 1){echo "
on
";} echo "		"; echo ""; echo db_result($res,$cnt,"e_id"); echo "\n".db_result($res,$cnt,"e_comment")."
\n
\n"; } #Formular: echo "\n"; if(isset($myElement)){ $sql = "SELECT * FROM gui_element WHERE fkey_gui_id = $1 AND e_id = $2"; $v = array($guiList2, $myElement); $t = array("s", "s"); $res = db_prep_query($sql, $v, $t); if(db_fetch_row($res)){ echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo "
ID:
Position:
ON/OFF:
Comment:
HTML-TAG:
SRC:
Attributes:
Left:
Top:
Width:
Height:
Z-INDEX:
Styles:
Content:
Close-TAG:
JavaScript:
Modul:
Target:
Requires:
"; } else if(isset($guiList1)){ echo "ID: \n"; echo "Position: \n"; echo "Public: \n"; echo "Comment: \n"; echo "HTML-TAG: \n"; echo "SRC: \n"; echo "Attributes: \n"; echo "Left: \n"; echo "Top: \n"; echo "Width: \n"; echo "Height: \n"; echo "Z-INDEX: \n"; echo "Styles: \n"; echo "Content: \n"; echo "Close-TAG: \n"; echo "JavaScript: \n"; echo "Modul: \n"; echo "Target: \n"; echo "Requires: \n"; } echo "\n"; ?>