String name, prefix, chatcolor, scoreboardteam;
    Integer ranking;
    static AsynchronRank asynchronRank;

    public GroupManager(final String name, final String prefix, final String chatcolor, final String scoreboardteam, final Integer ranking) {
        this.name = name;
        this.prefix = prefix;
        this.chatcolor = chatcolor;
        this.scoreboardteam = scoreboardteam;
        this.ranking = ranking;
    }

    public void init() {
        RankManager.getRanks().put(name, this);
    }

    public void create() {
        asynchronRank.execute("INSERT INTO ranks(name, prefix, chatcolor, ranking, team) VALUES ('" + name + "','" + prefix + "','" + chatcolor + "','" + ranking + "','" + scoreboardteam + "')");
    }

    public void delete() {
        asynchronRank.execute("DELETE FROM ranks WHERE name='" + name + "'");
        asynchronRank.execute("UPDATE users SET rank='User' WHERE rank='" + name + "'");
    }

    public void update() {
        asynchronRank.execute("DELETE FROM ranks WHERE name='" + name + "'");
        asynchronRank.execute("INSERT INTO ranks(name, prefix, chatcolor, ranking, team) VALUES ('" + name + "','" + prefix + "','" + chatcolor + "','" + ranking + "','" + scoreboardteam + "')");
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPrefix() {
        return prefix;
    }

    public void setPrefix(String prefix) {
        this.prefix = prefix;
    }

    public String getChatcolor() {
        return chatcolor;
    }

    public void setChatcolor(String chatcolor) {
        this.chatcolor = chatcolor;
    }

    public String getScoreboardteam() {
        return scoreboardteam;
    }

    public void setScoreboardteam(String scoreboardteam) {
        this.scoreboardteam = scoreboardteam;
    }

    public Integer getRanking() {
        return ranking;
    }

    public void setRanking(Integer ranking) {
        this.ranking = ranking;
    }

}