'; ?> Administration get("mb_user_name"); $logged_user_id = Mapbender::session()->get("mb_user_id"); /*handle remove, update and insert*****************************************************************/ if($insert){ if(count($selected_group)>0){ for($i=0; $i0){ for($i=0; $i0){ $sql_user_mb_group = "SELECT mb_group.mb_group_id, mb_group.mb_group_name, mb_user_mb_group.fkey_mb_user_id FROM mb_user_mb_group "; $sql_user_mb_group .= "INNER JOIN mb_group ON mb_user_mb_group.fkey_mb_group_id = mb_group.mb_group_id "; $sql_user_mb_group .= "WHERE mb_user_mb_group.fkey_mb_user_id = $1 AND (mb_user_mb_group.mb_user_mb_group_type = 1 or mb_user_mb_group.mb_user_mb_group_type IS NULL) "; $sql_user_mb_group .= "ORDER BY mb_group.mb_group_name"; if(!$selected_user){$v = array($user_id[0]);} if($selected_user){$v = array($selected_user);} $t = array('i'); $res_user_mb_group = db_prep_query($sql_user_mb_group,$v,$t); while($row = db_fetch_array($res_user_mb_group)){ $group_id_user[$cnt_group_user] = $row["mb_group_id"]; $group_name_user[$cnt_group_user] = $row["mb_group_name"]; $cnt_group_user++; } /*INSERT HTML*/ echo "
"; /*filterbox****************************************************************************************/ echo ""; //echo ""; /*insert all user in selectbox*************************************************************************************/ echo "
USER:
"; echo ""; /*insert all group in selectbox********************************************************************/ echo "
GROUP:
"; echo ""; /*Button*******************************************************************************************/ echo "
"; echo ""; echo "
"; echo ""; /*insert user_group_dependence in selectbox**************************************************/ echo "
SELECTED GROUP:
"; echo ""; echo "
"; }else{ echo "There are no other users owned by this user." ; } ?>