'; ?> 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++; } if ($cnt_group > 0) { /*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 "
"; /*insert all group in selectbox********************************************************************/ echo "
GROUP:
"; echo ""; /*insert all gui in selectbox**********************************************************************/ echo "
GUI:
"; echo ""; /*Button*******************************************************************************************/ echo "
"; echo ""; echo "
"; echo ""; /*insert group_gui_dependence in selectbox*********************************************************/ echo "
SELECTED GUI:
"; echo ""; echo "
"; } else { echo "
There are no groups available for this user.
"; } ?>