';
?>
Edit User Owner
0 && count($selected_gui)>0){
for($i=0; $i0){
for($i=0; $igetGuisByOwner($_SESSION["mb_user_id"],true);
if (count($ownguis)>0){
$v = array();
$t = array();
$sql_gui = "SELECT * FROM gui WHERE gui_id IN (";
for($i=0; $i0){ $sql_gui .= ",";}
$sql_gui .= "$".($i+1);
array_push($v,$ownguis[$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 user **********************************************************************************************/
$sql_user = "SELECT * FROM mb_user ORDER BY mb_user_name";
$res_user = db_query($sql_user);
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 all 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";
$sql_gui_mb_user .= " AND gui_mb_user.mb_user_type = 'owner' ORDER BY mb_user.mb_user_name";
if(!$selected_gui){$v = array($gui_id_array[0]);}
if($selected_gui){$v = array($selected_gui);}
$t = array('s');
$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 "";
}else{
echo "There are no guis available for this user.
";
}
?>