String name;
    String uuid;

    public RangManager(String name) {
        this.name = name;
        this.uuid = UUIDFetcher.getUUID(name);
    }

    public boolean exist() {
        try {
            Main.getNickMySQL();
            ResultSet rs = MySQL.Query("SELECT * FROM `Rang` WHERE `UUID`='" + this.uuid + "'");
            if (rs.next()) {
                return rs.getString("UUID") != null;
            } else {
                return false;
            }
        } catch (Exception var2) {
            System.err.println(var2);
            var2.printStackTrace();
            return false;
        }
    }

    public void createPlayer(String rang, long end) {
        if (!this.exist()) {
            long current = System.currentTimeMillis();
            long e = current + end * 60L * 60L * 24L * 1000L;
            if (end == -1L) {
                Main.getNickMySQL();
                MySQL.update("INSERT INTO `Rang` (`NAME`, `UUID`, `RANG`, `END`) VALUES ('" + this.name + "', '" + this.uuid + "', '" + rang + "', '" + end + "')");
            } else {
                Main.getNickMySQL();
                MySQL.update("INSERT INTO `Rang` (`NAME`, `UUID`, `RANG`, `END`) VALUES ('" + this.name + "', '" + this.uuid + "', '" + rang + "', '" + e + "')");
            }
        }

    }

    public void check() {
        long current = System.currentTimeMillis();
        long end = Long.valueOf(this.getEnd());
        if (end <= current && end != -1L) {
            this.setRang("default", -1L);
        }

    }

    public void setRang(String rang, long end) {
        if (Bukkit.getPlayer(this.name) != null) {
            if (this.exist()) {
                CloudPlayer c = CloudAPI.getInstance().getOnlinePlayer(UUID.fromString(this.uuid));
                c.getPermissionEntity().getGroups().clear();
                c.getPermissionEntity().getGroups().add(new GroupEntityData(rang, -1L));
                CloudAPI.getInstance().updatePlayer(c);
                long current = System.currentTimeMillis();
                long e = current + end * 60L * 60L * 24L * 1000L;
                if (end == -1L) {
                    e = -1L;
                }

                if (end == -1L) {
                    Main.getNickMySQL();
                    MySQL.update("UPDATE `Rang` SET `END`='" + end + "' WHERE `UUID`='" + this.uuid + "'");
                    Main.getNickMySQL();
                    MySQL.update("UPDATE `Rang` SET `RANG`='" + rang + "' WHERE `UUID`='" + this.uuid + "'");
                } else {
                    Main.getNickMySQL();
                    MySQL.update("UPDATE `Rang` SET `END`='" + e + "' WHERE `UUID`='" + this.uuid + "'");
                    Main.getNickMySQL();
                    MySQL.update("UPDATE `Rang` SET `RANG`='" + rang + "' WHERE `UUID`='" + this.uuid + "'");
                }
            } else {
                this.createPlayer(rang, end);
                this.setRang(rang, end);
            }

        }
    }

    public String getEnd() {
        String c = "";

        try {
            Main.getNickMySQL();

            for(ResultSet rs = MySQL.Query("SELECT * FROM `Rang` WHERE `UUID`='" + this.uuid + "'"); rs.next(); c = rs.getString("END")) {
                ;
            }
        } catch (Exception var3) {
            System.err.println(var3);
            var3.printStackTrace();
        }

        return c;
    }

    public String getRang() {
        String c = "";

        try {
            Main.getNickMySQL();

            for(ResultSet rs = MySQL.Query("SELECT * FROM `Rang` WHERE `UUID`='" + this.uuid + "'"); rs.next(); c = rs.getString("RANG")) {
                ;
            }
        } catch (Exception var3) {
            System.err.println(var3);
            var3.printStackTrace();
        }

        return c;
    }

    public String getRemainingTime() {
        String remainingTime = "";
        long current = System.currentTimeMillis();
        long end = Long.valueOf(this.getEnd());
        long difference = end - current;
        if (end == -1L) {
            return "§cPermanent";
        } else {
            int Sekunden = 0;
            int Minuten = 0;
            int Stunden = 0;

            int Tage;
            for(Tage = 0; difference >= 1000L; ++Sekunden) {
                difference -= 1000L;
            }

            while(Sekunden >= 60) {
                Sekunden -= 60;
                ++Minuten;
            }

            while(Minuten >= 60) {
                Minuten -= 60;
                ++Stunden;
            }

            while(Stunden >= 24) {
                Stunden -= 24;
                ++Tage;
            }

            remainingTime = "§e" + Tage + " §7Tag§8(§7e§8) §e" + Stunden + " §7Stunde§8(§7n§8) §e" + Minuten + " §7Minute§8(§7n§8) ";
            return remainingTime;
        }
    }