';
?>
Add Permission for Filtered GUI to Filtered Group
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 owner group *********************************************************************************/
$sql_group = "SELECT * FROM mb_group WHERE mb_group_owner = $1 ORDER BY mb_group_name";
$v = array($logged_user_id);
$t = array('i');
$res_group = db_prep_query($sql_group,$v,$t);
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 .= " 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){
if($group_id[0] > 0){
array_push($v,$group_id[0]);
array_push($t,'i');
}
else{
array_push($v, "NULL");
array_push($t,'i');
}
}
else 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 "";
?>