';
?>
Administration
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 groups **********************************************************************************/
$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 all 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 ";
$sql_gui_group .= "ORDER BY mb_group.mb_group_name";
if(!$selected_gui){$v = array($gui_id_array[0]);}
if($selected_gui){$v = array($selected_gui);}
$t = array('s');
$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 "";
?>