';
?>
Add Permission for Filtered Group to GUI
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 groups ********************************************************************************/
$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 owner groups from selected gui***************************************************************/
$sql_gui_group = "SELECT mb_group.mb_group_id, mb_group.mb_group_name, gui_mb_group.fkey_gui_id FROM gui_mb_group ";
$sql_gui_group .= "INNER JOIN mb_group ON gui_mb_group.fkey_mb_group_id = mb_group.mb_group_id ";
$sql_gui_group .= "WHERE gui_mb_group.fkey_gui_id = $1 ";
if(!$selected_gui){$v = array($gui_id_array[0]);}
if($selected_gui){$v = array($selected_gui);}
$t = array('s');
$sql_gui_group .= " AND mb_group.mb_group_owner = $2 ";
array_push($v,$logged_user_id);
array_push($t,'i');
$sql_gui_group .= " ORDER BY mb_group.mb_group_name";
$res_gui_group = db_prep_query($sql_gui_group,$v,$t);
while($row = db_fetch_array($res_gui_group)){
$group_id_gui[$cnt_gui_group] = $row["mb_group_id"];
$group_name_gui[$cnt_gui_group] = $row["mb_group_name"];
$cnt_gui_group++;
}
/*INSERT HTML*/
echo "";
?>