';
?>
Add User to 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 allocated gui from logged_user******************************************************************************/
$sql_logged_user_mb_gui = "SELECT gui.gui_id, gui.gui_name, gui_mb_user.fkey_mb_user_id FROM gui_mb_user ";
$sql_logged_user_mb_gui .= "INNER JOIN gui ON gui_mb_user.fkey_gui_id = gui.gui_id ";
$sql_logged_user_mb_gui .= "WHERE gui_mb_user.fkey_mb_user_id = $1";
$sql_logged_user_mb_gui .= " ORDER BY gui.gui_name";
$v = array($logged_user_id);
$t = array('i');
$res_logged_user_mb_all_gui = db_prep_query($sql_logged_user_mb_gui,$v,$t);
while($roe = db_fetch_array($res_logged_user_mb_all_gui)){
$gui_id_logged_user[$cnt_gui_logged_user] = $row["gui_id"];
$gui_name_logged_user[$cnt_gui_logged_user] = $row["gui_name"];
$cnt_gui_logged_user++;
}
/*get allocated gui from selected_user******************************************************************************/
$v = array();
$t = array();
$c = 2;
$sql_user_mb_gui = "SELECT gui.gui_id, gui.gui_name, gui_mb_user.fkey_mb_user_id FROM gui_mb_user ";
$sql_user_mb_gui .= "INNER JOIN gui ON gui_mb_user.fkey_gui_id = gui.gui_id ";
$sql_user_mb_gui .= "WHERE gui_mb_user.fkey_mb_user_id = $1";
if(!$selected_user){array_push($v,$user_id[0]);}
if($selected_user){array_push($v,$selected_user);}
array_push($t,'i');
$sql_user_mb_gui .= " AND gui.gui_id IN(";
for($i=0; $i0){ $sql_user_mb_gui .= ",";}
$sql_user_mb_gui .= "$".$c;
array_push($v,$arrayGuis[$i]);
array_push($t,'s');
$c++;
}
$sql_user_mb_gui .= ") ORDER BY gui.gui_name";
$res_user_mb_gui = db_prep_query($sql_user_mb_gui,$v,$t);
while($row = db_fetch_array($res_user_mb_gui)){
$gui_id_user[$cnt_gui_user] = $row["gui_id"];
$gui_name_user[$cnt_gui_user] = $row["gui_name"];
$cnt_gui_user++;
}
/*INSERT HTML*/
echo "";
?>