';
?>
Edit GUI Permissions
0){
for($i=0; $i0){
for($i=0; $i0){ $sql_gui .= ",";}
$sql_gui .= "$".($i + 1);
array_push($v, $arrayGuis[$i]);
array_push($t, 's');
}
$sql_gui.= ") ORDER BY gui_name";
$res_gui = db_prep_query($sql_gui,$v,$t);
while($row = db_fetch_array($res_gui)){
$gui_id_array[$cnt_gui] = $row["gui_id"];
$gui_name[$cnt_gui] = $row["gui_name"];
$cnt_gui++;
}
/*get all group **********************************************************************************************/
$sql_group = "SELECT * FROM mb_group ORDER BY mb_group_name";
$res_group = db_query($sql_group);
while($row = db_fetch_array($res_group)){
$group_id[$cnt_group] = $row["mb_group_id"];
$group_name[$cnt_group] = $row["mb_group_name"];
$cnt_group++;
}
/*get allocated gui from selected_group******************************************************************************/
$arrayGuis=mb_getGUIs($logged_user_id);
$v = array();
$t = array();
$sql_group_mb_gui = "SELECT gui.gui_id, gui.gui_name, gui_mb_group.fkey_mb_group_id FROM gui_mb_group ";
$sql_group_mb_gui .= "INNER JOIN gui ON gui_mb_group.fkey_gui_id = gui.gui_id ";
$sql_group_mb_gui .= "WHERE gui_mb_group.fkey_mb_group_id = $1 ";
if(!$selected_group){array_push($v,$group_id[0]);}
if($selected_group){array_push($v,$selected_group);}
array_push($t,'i');
$sql_group_mb_gui .= " AND gui.gui_id IN (";
$c = 2;
for($i=0; $i0){ $sql_group_mb_gui .= ",";}
$sql_group_mb_gui .= "$".$c;
array_push($v,$arrayGuis[$i]);
array_push($t,'s');
$c++;
}
$sql_group_mb_gui .= ") ORDER BY gui.gui_name";
$res_group_mb_gui = db_prep_query($sql_group_mb_gui,$v,$t);
while($row = db_fetch_array($res_group_mb_gui)){
$gui_id_group[$cnt_gui_group] = $row["gui_id"];
$gui_name_group[$cnt_gui_group] = $row["gui_name"];
$cnt_gui_group++;
}
/*INSERT HTML*/
echo "";
?>