';
?>
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 only owner user *****************************************************************************/
$sql_user = "SELECT * FROM mb_user WHERE mb_user_owner = $1 ORDER BY mb_user_name";
$v = array($logged_user_id);
$t = array('i');
$res_user = db_prep_query($sql_user,$v,$t);
while($row = db_fetch_array($res_user)){
$user_id[$cnt_user] = $row["mb_user_id"];
$user_name[$cnt_user] = $row["mb_user_name"];
$user_email[$cnt_user] = $row["mb_user_email"];
$cnt_user++;
}
/*get only owner user from selected gui************************************************************/
$sql_gui_mb_user = "SELECT mb_user.mb_user_id, mb_user.mb_user_name, mb_user.mb_user_email, gui_mb_user.fkey_gui_id FROM gui_mb_user ";
$sql_gui_mb_user .= "INNER JOIN mb_user ON gui_mb_user.fkey_mb_user_id = mb_user.mb_user_id ";
$sql_gui_mb_user .= "WHERE gui_mb_user.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_mb_user .= " AND mb_user.mb_user_owner = $2 ";
array_push($v,$logged_user_id);
array_push($t,'i');
$sql_gui_mb_user .= " ORDER BY mb_user.mb_user_name";
$res_gui_mb_user = db_prep_query($sql_gui_mb_user,$v,$t);
while($row = db_fetch_array($res_gui_mb_user)){
$user_id_gui[$cnt_gui_user] = $row["mb_user_id"];
$user_name_gui[$cnt_gui_user] = $row["mb_user_name"];
$user_email_gui[$cnt_gui_user] = $row["mb_user_email"];
$cnt_gui_user++;
}
/*INSERT HTML*/
echo "";
?>