public class CloudPlayer {
    @Getter
    @Setter
    private String name;
    @Getter
    @Setter
    private String ip;
    @Getter
    @Setter
    private String teamspeakuid;
    @Getter
    @Setter
    private String skinValue;
    @Getter
    @Setter
    private String skinSignature;
    @Getter
    @Setter
    private Bungeecord bungeecord;
    @Getter
    @Setter
    private Rank rank;
    @Getter
    @Setter
    private long rankEnd;
    @Getter
    @Setter
    private Server server;
    @Getter
    @Setter
    private UUID watchingReplay = null;
    @Getter
    @Setter
    private UUID currentGameId = null;
    @Getter
    @Setter
    private long lastLogin;
    @Getter
    @Setter
    private long firstLogin;
    @Getter
    @Setter
    private String[] banData;
    @Getter
    @Setter
    private String[] muteData;
    @Getter
    @Setter
    private List<String> friends = new CopyOnWriteArrayList<String>();
    @Getter
    @Setter
    private List<String> requests = new CopyOnWriteArrayList<String>();
    @Getter
    @Setter
    private int version = 0;
    @Getter
    @Setter
    private Channel admClientChannel;
    @Getter
    @Setter
    private int friendAdd;
    @Getter
    @Setter
    private int friendFollow;
    @Getter
    @Setter
    private int friendMessages;
    @Getter
    @Setter
    private int privateMessages;
    @Getter
    @Setter
    private int partyInvites;
    @Getter
    @Setter
    private int playerVisibility;
    @Getter
    @Setter
    private int spped;
    @Getter
    @Setter
    private int doubleJump;
    @Getter
    @Setter
    private double locX;
    @Getter
    @Setter
    private double locY;
    @Getter
    @Setter
    private double locZ;
    @Getter
    @Setter
    private float yaw;
    @Getter
    @Setter
    private float pitch;
    @Getter
    @Setter
    private long joinTime;
    @Getter
    @Setter
    private long onlineTime;
    @Getter
    @Setter
    private long reportTimeout = -1;
    @Getter
    @Setter
    private ConcurrentHashMap<String, Long> globalStats = new ConcurrentHashMap();
    @Getter
    @Setter
    private ConcurrentHashMap<String, Long> monthlyStats = new ConcurrentHashMap();
    @Getter
    @Setter
    private ConcurrentHashMap<String, Long> dailyStats = new ConcurrentHashMap();
    @Getter
    @Setter
    private ConcurrentHashMap<String, Long> globalRanking = new ConcurrentHashMap();
    @Getter
    @Setter
    private ConcurrentHashMap<String, Long> monthlyRanking = new ConcurrentHashMap();
    @Getter
    @Setter
    private ConcurrentHashMap<String, Long> dailyRanking = new ConcurrentHashMap();
    @Getter
    @Setter
    private int coins;
    @Getter
    @Setter
    private String permissions;
    @Getter
    @Setter
    private CloudPlayer lastMessageReceiver;
    @Getter
    @Setter
    private Party party;
    @Getter
    @Setter
    private Server lastSendedServer;
    @Getter
    @Setter
    private boolean fullLoaded = false;
    @Getter
    @Setter
    private int forumUserID = -1;
    @Getter
    @Setter
    private int banPoints;
    @Getter
    @Setter
    private int mutePoints;
    @Getter
    @Setter
    private ConcurrentHashMap<String, String> playerDB = new ConcurrentHashMap();
    @Getter
    @Setter
    private String nickName;
    @Getter
    @Setter
    private long nickTimeout;
    @Getter
    @Setter
    private PacketHolder nickPacket;
    @Getter
    @Setter
    private boolean notify = true;
    @Getter
    @Setter
    private NickHistory nickHistory;

    public CloudPlayer(String name, String ip, Rank rank, long lastLogin, long firstLogin, String teamspeakuid, long rankEnd, List<String> friends, List<String> requests, int coins, String permissions) {
        this.name = name;
        this.ip = ip;
        this.rank = rank;
        this.lastLogin = lastLogin;
        this.firstLogin = firstLogin;
        this.teamspeakuid = teamspeakuid;
        this.rankEnd = rankEnd;
        this.bungeecord = null;
        this.coins = coins;
        this.permissions = permissions;
        if (permissions == null) {
            this.permissions = "";
        }
        this.setFriendAdd(1);
        this.setFriendFollow(1);
        this.setFriendMessages(1);
        this.setPrivateMessages(1);
        this.setSpped(1);
        this.setDoubleJump(1);
        if (friends != null) {
            this.friends.addAll(friends.stream().collect(Collectors.toList()));
        }
        if (requests != null) {
            this.requests.addAll(requests.stream().collect(Collectors.toList()));
        }
        this.setLocX(0.5);
        this.setLocY(100.5);
        this.setLocZ(0.5);
        this.setYaw(90.0f);
        this.setPitch(-8.0f);
    }

    public void addCoins(int coins) {
        this.coins += coins;
        this.sendMessage(String.valueOf(CloudServer.getPrefix()) + "§aDu hast §e" + coins + " Coins §aerhalten!");
        this.updateToDatabase(false);
        this.sendSettings();
    }

    public void removeCoins(int coins) {
        int newValue = this.getCoins();
        if ((newValue -= coins) < 0) {
            newValue = 0;
        }
        this.setCoins(newValue);
        this.updateToDatabase(false);
        this.sendSettings();
    }

    public void joinBungeecord(Bungeecord bungeecord) {
        if (this.getBungeecord() != null) {
            this.getBungeecord().getCloudPlayers().remove(this.getName().toLowerCase());
        }
        this.bungeecord = bungeecord;
        this.getBungeecord().getCloudPlayers().add(this.getName().toLowerCase());
        if (this.getOnlineTime() >= 15) {
            this.getBungeecord().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.ALLOW_CHAT_PACKET, new AllowChatPacket(this.getName())));
        }
    }

    public void switchServer(Server server) {
        this.server = server;
        new Thread(() -> {
            CloudServer.getFriendManager().handleServerSwitch(this);
            this.sendSettings();
        }
        ).start();
    }

    public void watchReplay(UUID replay) {
        for (Server s : CloudServer.getServerManager().getServers()) {
            if (!s.getName().startsWith("replay-")) continue;
            this.connectToServer(s.getName());
            break;
        }
        if (this.lastSendedServer != null && this.lastSendedServer.getName().startsWith("replay-")) {
            this.watchingReplay = replay;
        } else {
            this.sendMessage("§cEin Error trat auf, als wir dich auf den Replay-Server senden wollten.");
        }
    }

    public void sendMessage(String message) {
        this.sendMessages(new String[]{message});
    }

    public void sendMessages(String[] messages) {
        if (this.bungeecord != null) {
            this.getBungeecord().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.MESSAGE_PACKET, new de.piet.cloudsystem.packets.types.MessagePacket(this.getName(), messages)));
            if (this.getAdmClientChannel() != null) {
                this.getAdmClientChannel().writeAndFlush(CloudServer.getAdmPacketHelper().preparePacket(de.piet.cloud.admcpackets.PacketType.MESSAGE_PACKET, new MessagePacket(messages)));
            }
        }
    }

    public void updateFriendInv() {
        this.sendSettings();
    }

    public void sendSettings() {
        if (this.isOnline() && this.getServer() != null) {
            this.getServer().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.PLAYER_LOGIN_PACKET, new PlayerLoginPacket(this.getName(), true)));
        }
        if (this.getServer().isCloudServer() && (this.getServer().getServerTemplate().getName().equalsIgnoreCase("lobby") || this.getServer().getServerTemplate().getName().equalsIgnoreCase("silent"))) {
            this.getServer().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.PLAYER_LOBBY_DATA_PACKET, this.getPlayerDataPacket()));
        }
    }

    public PlayerLobbyDataPacket getPlayerDataPacket() {
        long hours = 0;
        if (this.getOnlineTime() > 60) {
            hours = this.getOnlineTime() / 60;
        }
        return new PlayerLobbyDataPacket(this.getName(), CloudServer.getFriendManager().getFriendsArray(this), CloudServer.getFriendManager().getRequestArrays(this), this.getFriendAdd(), this.getFriendFollow(), this.getFriendMessages(), this.getPrivateMessages(), this.getPartyInvites(), this.getPlayerVisibility(), this.getSpped(), this.getDoubleJump(), this.getLocX(), this.getLocY(), this.getLocZ(), this.getYaw(), this.getPitch(), this.getCoins(), 0, hours);
    }

    public void connectToServer(String serverName) {
        if (this.bungeecord != null) {
            Server server = CloudServer.getServerManager().getServerByName(serverName);
            if (server == null) {
                this.sendMessage(String.valueOf(CloudServer.getPrefix()) + "§cDer Server existiert nicht!");
                return;
            }
            if (server.isCloudServer() && server.getTemplateName().equalsIgnoreCase("silent") && !this.getRank().isHigherEqualsLevel(Rank.VIP)) {
                this.sendMessage(String.valueOf(CloudServer.getPrefix()) + "§cDu hast keine Berechtigung um diesen Server zu betreten!");
                return;
            }
            if (this.getParty() != null && this.getParty().getLeader() == this) {
                this.getParty().handleServerSwitch(server);
            }
            if (server.getOnlinePlayers() >= server.getMaxPlayers() && server.getServerState() == ServerState.LOBBY && !this.getRank().isHigherEqualsLevel(Rank.IRON)) {
                MessageGroup messageGroup = new MessageGroup(this);
                messageGroup.addMessage("§7Der Server §6" + serverName + " §7ist §cvoll!");
                messageGroup.addMessage("§4Kaufe dir einen Rang, um volle Server betreten zu k\u00f6nnen!");
                messageGroup.addMessage("§ahttp://shop.twerion.net");
                messageGroup.send();
                return;
            }
            if (server.isNicknameEnabled() && this.getNickName() != null) {
                this.sendMessage("§8[§aNick§8] §bDu bleibst weiterhin genickt: §a" + this.getNickName());
                NickNameManager.nickPlayer(this, null, null, server);
            }
            this.lastSendedServer = server;
            server.sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.PLAYER_RANK_PACKET, new PlayerRankPacket(this.getName().toLowerCase(), this.getRank().getRankName(), this.getPlayerPermissions(server))));
            this.getBungeecord().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.SERVER_CONNECT, new ConnectPacket(this.getName(), serverName)));
        }
    }

    public long getDailyStatValue(String key) {
        if (this.dailyStats.containsKey(key)) {
            return this.dailyStats.get(key);
        }
        return 0;
    }

    public long getMonthlyStatsValue(String key) {
        if (this.monthlyStats.containsKey(key)) {
            return this.monthlyStats.get(key);
        }
        return 0;
    }

    public long getGlobalStatValue(String key) {
        if (this.globalStats.containsKey(key)) {
            return this.globalStats.get(key);
        }
        return 0;
    }

    public void kickPlayer(String reason) {
        if (this.bungeecord != null) {
            this.getBungeecord().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.KICK_PACKET, new KickPacket(this.getName(), reason)));
        }
    }

    public boolean isOnline() {
        if (this.getBungeecord() != null) {
            return true;
        }
        return false;
    }

    public void updatePlayTime(long leaveTime, boolean update) {
        if (this.joinTime != 0 && leaveTime > this.joinTime) {
            long diff = leaveTime - this.joinTime;
            if ((diff /= 1000) > 60) {
                long minutes = diff / 60;
                if (minutes <= 0) {
                    return;
                }
                this.onlineTime += minutes;
                if (update) {
                    this.updateToDatabase(false);
                }
                long minuteMillis = minutes * 60;
                long setTime = System.currentTimeMillis();
                if (diff > minuteMillis) {
                    long joinDiff = (diff - minuteMillis) * 1000;
                    setTime -= joinDiff;
                }
                this.setJoinTime(setTime);
            }
        }
    }

    public List<String> getPlayerPermissions(Server server) {
        List<String> permissions = new ArrayList<>();
        if (getServer() != null) {
            if (PermissionManager.getPermissionsMap().containsKey(getRank().getRankName().toLowerCase())) {
                for (String[] permissionArray : PermissionManager.getPermissionsMap().get(getRank().getRankName().toLowerCase())) {
                    String permission = permissionArray[0];
                    String serverGroup = permissionArray[1];
                    if (serverGroup == null || (server.getServerGroup() != null && serverGroup.equalsIgnoreCase(server.getServerGroup()))) {
                        permissions.add(permission);
                    }
                }
            }
            if (PermissionManager.getPermissionsMap().containsKey(Rank.SPIELER.getRankName().toLowerCase()) && getRank() != Rank.ADMIN) {
                for (String[] permissionArray : PermissionManager.getPermissionsMap().get(Rank.SPIELER.getRankName().toLowerCase())) {
                    String permission = permissionArray[0];
                    String serverGroup = permissionArray[1];
                    if (serverGroup == null || (server.getServerGroup() != null && serverGroup.equalsIgnoreCase(server.getServerGroup()))) {
                        permissions.add(permission);
                    }
                }
            }
            if (!getPermissions().isEmpty()) {
                for (String permissionData : getPermissions().split("@")) {
                    String[] splitData = permissionData.split(";");
                    String permission = splitData[0];
                    String serverGroup = splitData[1];
                    if (serverGroup.equalsIgnoreCase("nogroup") || (server.getServerGroup() != null && serverGroup.equalsIgnoreCase(server.getServerGroup()))) {
                        permissions.add(permission);
                    }
                }
            }
        }
        return permissions;
    }


    public void setRank(Rank rank, long rankEnd) {
        int oldRankID = this.getRank().getForumGroupID();
        Rank oldRank = this.getRank();
        this.rank = rank;
        this.rankEnd = rankEnd;
        if (oldRank.isTeam() && rank.isTeam()) {
            UserManager.updateRank(this);
        } else if (!oldRank.isTeam() && rank.isTeam()) {
            UserManager.createUser(this);
        } else if (oldRank.isTeam() && !rank.isTeam()) {
            UserManager.removeUser(this);
        }
        if (this.getServer() != null) {
            List<String> permissions = this.getPlayerPermissions(this.server);
            this.getServer().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.PLAYER_RANK_PACKET, new PlayerRankPacket(this.getName(), this.getRank().getRankName(), permissions)));
            this.sendSettings();
        }
        if (rank == Rank.SPIELER) {
            CloudServer.getPlayerManager().getPlayersWithRank().remove(this.getName().toLowerCase());
        } else if (!CloudServer.getPlayerManager().getPlayersWithRank().contains(this.getName().toLowerCase())) {
            CloudServer.getPlayerManager().getPlayersWithRank().add(this.getName().toLowerCase());
        }
        ArrayList<String[]> rankData = new ArrayList<String[]>();
        rankData.add(new String[]{this.getName().toLowerCase(), this.getRank().getRankName()});
        de.piet.cloudsystem.packets.types.PacketHolder initPacket = CloudServer.getPacketHelper().preparePacket(PacketType.BUNGEE_RANK_PACKET, new BungeeRankPacket(rankData));
        for (Bungeecord bungeecord : CloudServer.getBungeecordManager().getBungeecords()) {
            bungeecord.sendPacket(initPacket);
        }
        this.updateToDatabase(false);
        if (!CloudServer.isBetaMode()) {
            new Thread(() -> {
                if (this.getForumUserID() != -1) {
                    try {
                        InputStream removeGroups = new URL("http://fapi.twerion.net/api.php?action=editUser&hash=ToBiIsTdErGeIlStEaUfDeRwElT0815&user=" + this.getName() + "&remove_groups=" + oldRankID).openStream();
                        removeGroups.close();
                        InputStream addGroups = new URL("http://fapi.twerion.net/api.php?action=editUser&hash=ToBiIsTdErGeIlStEaUfDeRwElT0815&user=" + this.getName() + "&add_groups=" + this.getRank().getForumGroupID()).openStream();
                        addGroups.close();
                    } catch (IOException e) {
                        e.printStackTrace();
                        System.out.println(e.getLocalizedMessage());
                    }
                }
                this.checkTeamspeakGroups();
            }
            ).start();
        }
        if (!this.isOnline()) {
            return;
        }
        MessageGroup messageGroup = new MessageGroup(this);
        messageGroup.addMessage(String.valueOf(CloudServer.getPrefix()) + "§aDein Rang wurde zu " + rank.getRankColor() + rank.getRankName() + " §age\u00e4ndert!");
        if (rankEnd == 0) {
            messageGroup.addMessage(String.valueOf(CloudServer.getPrefix()) + "§aAblauf des Rangs: §eNie");
        } else {
            CloudServer.getTimeManager();
            messageGroup.addMessage(String.valueOf(CloudServer.getPrefix()) + "§aAblauf des Rangs: §e(" + TimeManager.getEndeAnzeige(rankEnd) + ")");
        }
        messageGroup.send();
    }

    public boolean addPermission(String permission, String serverGroup) {
        String permissionData = null;
        permissionData = serverGroup != null ? String.valueOf(permission.toLowerCase()) + ";" + serverGroup.toLowerCase() : String.valueOf(permission.toLowerCase()) + ";" + "nogroup";
        if (!this.getPermissions().contains(permissionData)) {
            this.permissions = this.getPermissions().isEmpty() ? String.valueOf(this.permissions) + permissionData : String.valueOf(this.permissions) + "@" + permissionData;
            if (this.getServer() != null) {
                this.getServer().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.PLAYER_RANK_PACKET, new PlayerRankPacket(this.getName(), this.getRank().getRankName(), this.getPlayerPermissions(this.getServer()))));
            }
            this.updateToDatabase(false);
            return true;
        }
        return false;
    }

    public void removePermission(String permission, String serverGroup) {
        String removeData = serverGroup != null ? String.valueOf(permission.toLowerCase()) + ";" + serverGroup.toLowerCase() : String.valueOf(permission.toLowerCase()) + ";" + "nogroup";
        String newData = "";
        String[] arrstring = this.getPermissions().split("@");
        int n = arrstring.length;
        int n2 = 0;
        while (n2 < n) {
            String permissionData = arrstring[n2];
            if (!permissionData.equalsIgnoreCase(removeData)) {
                newData = newData.isEmpty() ? String.valueOf(newData) + permissionData : String.valueOf(newData) + "@" + permissionData;
            }
            ++n2;
        }
        this.permissions = newData;
        if (this.getServer() != null) {
            this.getServer().sendPacket(CloudServer.getPacketHelper().preparePacket(PacketType.PLAYER_RANK_PACKET, new PlayerRankPacket(this.getName(), this.getRank().getRankName(), this.getPlayerPermissions(this.getServer()))));
        }
        this.updateToDatabase(false);
    }

    public void checkTeamspeakGroups() {
        if (this.getTeamspeakuid().equals("noid")) {
            return;
        }
        TS3Api ts3Api = CloudServer.getTeamspeakBot().getTs3Api();
        ClientInfo clientInfo = ts3Api.getClientByUId(this.getTeamspeakuid());
        if (clientInfo != null) {
            CloudServer.getTeamspeakManager().checkUserGroups(clientInfo.getId(), ts3Api, clientInfo, this);
        }
    }

    public String statsToString(ConcurrentHashMap<String, Long> statsMap) {
        String saveString = "";
        int current = 0;
        for (String saveKey : statsMap.keySet()) {
            long value = statsMap.get(saveKey);
            saveString = String.valueOf(saveString) + saveKey + ";" + value;
            if (current != statsMap.size() - 1) {
                saveString = String.valueOf(saveString) + "!";
            }
            ++current;
        }
        return saveString;
    }

    public void statsFromString(String statsString, ConcurrentHashMap destination) {
        if (statsString.contains("!")) {
            String[] data;
            String[] arrstring = data = statsString.split("!");
            int n = arrstring.length;
            int n2 = 0;
            while (n2 < n) {
                String getData = arrstring[n2];
                String[] statsData = getData.split(";");
                destination.put(statsData[0], Long.valueOf(statsData[1]));
                ++n2;
            }
        } else {
            String[] data = statsString.split(";");
            destination.put(data[0], Long.valueOf(data[1]));
        }
    }

    public String getSaveArray(String[] array) {
        return String.valueOf(array[0]) + "§" + array[1];
    }

    public String[] fromSaveArray(String data) {
        return data.split("§");
    }

    public void updateToDatabase(boolean insert) {
        if (!this.fullLoaded) {
            System.out.println(String.valueOf(this.name) + " is not full loaded!");
            return;
        }
        CloudServer.getDatabaseQueue().addToQueue(this, insert);
    }

    public void saveUser(boolean insert) {
        block31:
        {
            Connection connection = null;
            try {
                try {
                    connection = CloudServer.getSqlPool().getConnection();
                    if (insert) {
                        PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO spieler (name, ip, rank, rankend, firstlogin, lastlogin, teamspeakuid, playedTime, clanName, clanInvites) VALUES (?,?,?,?,?,?,?,?,?,?)");
                        preparedStatement.setObject(1, this.getName());
                        preparedStatement.setObject(2, this.getIp());
                        preparedStatement.setObject(3, this.getRank().getRankName());
                        preparedStatement.setObject(4, this.getRankEnd());
                        preparedStatement.setObject(5, this.getFirstLogin());
                        preparedStatement.setObject(6, this.getLastLogin());
                        preparedStatement.setObject(7, this.getTeamspeakuid());
                        preparedStatement.setObject(8, 0);
                        preparedStatement.setObject(9, null);
                        preparedStatement.setObject(10, null);
                        preparedStatement.execute();
                        preparedStatement.closeOnCompletion();
                        break block31;
                    }
                    PreparedStatement preparedStatement = connection.prepareStatement("UPDATE spieler SET ip = ?, rank = ?, lastlogin = ?, teamspeakuid = ?, rankend = ?, ban = ?, mute = ?, friends = ?, requests = ?, skinValue = ?, skinSignature = ?, premium = ?, password = ?, friendAdd = ?, friendFollow = ?, friendMessages = ?, privateMessages = ?, partyInvites = ?, playerVisibility = ?, speed = ?, doubleJump = ?, premium = ?, globalStats = ?, monthlyStats = ?, dailyStats = ?, coins = ?, gems = ?, playedTime = ?, permissions = ?, banPoints = ?, mutePoints = ?, forumUserID = ?, clanName = ?, clanInvites = ? WHERE name = ?");
                    preparedStatement.setObject(1, this.getIp());
                    preparedStatement.setObject(2, this.getRank().getRankName());
                    preparedStatement.setObject(3, this.getLastLogin());
                    preparedStatement.setObject(4, this.getTeamspeakuid());
                    preparedStatement.setObject(5, this.getRankEnd());
                    if (this.banData == null) {
                        preparedStatement.setObject(6, null);
                    } else {
                        preparedStatement.setObject(6, this.getSaveArray(this.banData));
                    }
                    if (this.muteData == null) {
                        preparedStatement.setObject(7, null);
                    } else {
                        preparedStatement.setObject(7, this.getSaveArray(this.muteData));
                    }
                    if (this.friends.size() > 0) {
                        preparedStatement.setObject(8, CloudServer.getFriendManager().toSaveString(this.getFriends()));
                    } else {
                        preparedStatement.setObject(8, null);
                    }
                    if (this.requests.size() > 0) {
                        preparedStatement.setObject(9, CloudServer.getFriendManager().toSaveString(this.getRequests()));
                    } else {
                        preparedStatement.setObject(9, null);
                    }
                    preparedStatement.setObject(10, this.getSkinValue());
                    preparedStatement.setObject(11, this.getSkinSignature());

                    preparedStatement.setObject(12, 1);

                    preparedStatement.setObject(13, null);
                    preparedStatement.setObject(14, this.getFriendAdd());
                    preparedStatement.setObject(15, this.getFriendFollow());
                    preparedStatement.setObject(16, this.getFriendMessages());
                    preparedStatement.setObject(17, this.getPrivateMessages());
                    preparedStatement.setObject(18, this.getPartyInvites());
                    preparedStatement.setObject(19, this.getPlayerVisibility());
                    preparedStatement.setObject(20, this.getSpped());
                    preparedStatement.setObject(21, this.getDoubleJump());

                    preparedStatement.setObject(22, 1);

                    String globalStats = this.statsToString(this.getGlobalStats());
                    String monthlyStats = this.statsToString(this.getMonthlyStats());
                    String dailyStats = this.statsToString(this.getDailyStats());
                    if (!globalStats.equals("")) {
                        preparedStatement.setObject(23, globalStats);
                    } else {
                        preparedStatement.setObject(23, null);
                    }
                    if (!monthlyStats.equals("")) {
                        preparedStatement.setObject(24, monthlyStats);
                    } else {
                        preparedStatement.setObject(24, null);
                    }
                    if (!dailyStats.equals("")) {
                        preparedStatement.setObject(25, dailyStats);
                    } else {
                        preparedStatement.setObject(25, null);
                    }
                    preparedStatement.setObject(26, this.getCoins());
                    preparedStatement.setObject(27, 0);
                    preparedStatement.setObject(28, this.getOnlineTime());
                    preparedStatement.setObject(29, this.getPermissions());
                    preparedStatement.setObject(30, this.getBanPoints());
                    preparedStatement.setObject(31, this.getMutePoints());
                    preparedStatement.setObject(32, this.getForumUserID());
                    preparedStatement.setObject(33, null);
                    preparedStatement.setObject(34, null);
                    preparedStatement.setObject(35, this.getName());
                    preparedStatement.execute();
                    preparedStatement.closeOnCompletion();
                } catch (SQLException exc) {
                    exc.printStackTrace();
                    System.out.println(exc.getLocalizedMessage());
                    if (connection == null) break block31;
                    try {
                        connection.close();
                    } catch (SQLException dexc) {
                        dexc.printStackTrace();
                        System.out.println(dexc.getLocalizedMessage());
                    }
                }
            } finally {
                if (connection != null) {
                    try {
                        connection.close();
                    } catch (SQLException exc) {
                        exc.printStackTrace();
                        System.out.println(exc.getLocalizedMessage());
                    }
                }
            }
        }
    }

    public void removeNickHistory() {
        NickHistory nickHistory = this.nickHistory;
        nickHistory.setEnded(System.currentTimeMillis());
        NickNameManager.getNickHistories().remove(this.nickHistory);
        NickNameManager.getNickHistories().add(nickHistory);
        NickNameManager.addToDatabase(nickHistory);
        this.nickHistory = null;
    }
}