private Main plugin;

    public StatsManager(Main plugin) {
        this.plugin = plugin;
    }

    public boolean inList(Player player) {
        String uuid = player.getUniqueId().toString();
        ResultSet resultSet = plugin.getMySQLMainClass().getResult("SELECT * FROM PlayerStats WHERE UUID='" + uuid + "'");
        try {
            assert resultSet != null;
            return resultSet.next();
        }catch(SQLException e) {
            e.printStackTrace();
        }
        return false;
    }

    public void addPlayer(Player player) {
        String uuid = player.getUniqueId().toString();
        plugin.getMySQLMainClass().update("INSERT INTO PlayerStats (UUID, PlayerName, Kills, Deaths) VALUES ('" + uuid + "', '" + player.getName() + "', '0', '0')");
    }

    public Integer getKills(Player player) {
        if(inList(player)) {
            String uuid = player.getUniqueId().toString();
            ResultSet resultSet = plugin.getMySQLMainClass().getResult("SELECT * FROM PlayerStats WHERE UUID='" + uuid + "'");
            try{
                while(resultSet.next()) {
                    return resultSet.getInt("Kills");
                }
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }else{
            addPlayer(player);
        }
        return null;
    }

    public Integer getDeath(Player player) {
        if(inList(player)) {
            String uuid = player.getUniqueId().toString();
            ResultSet resultSet = plugin.getMySQLMainClass().getResult("SELECT * FROM PlayerStats WHERE UUID='" + uuid + "'");
            try{
                while(resultSet.next()) {
                    return resultSet.getInt("Deaths");
                }
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }else{
            addPlayer(player);
        }
        return null;
    }

    public void addKills(Player player, int kills) {
        String uuid = player.getUniqueId().toString();
        if(kills < 0) {
            kills = 0;
        }
        int amount = kills + getKills(player);
        if(inList(player)) {
            plugin.getMySQLMainClass().update("UPDATE PlayerStats SET Kills='" + amount + "' WHERE UUID='" + uuid + "'");
        }else{
            addPlayer(player);
        }
    }

    public void addDeaths(Player player, int deaths) {
        String uuid = player.getUniqueId().toString();
        if(deaths < 0) {
            deaths = 0;
        }
        int amount = deaths + getDeath(player);
        if(inList(player)) {
            plugin.getMySQLMainClass().update("UPDATE PlayerStats SET Deaths='" + amount + "' WHERE UUID='" + uuid + "'");
        }else{
            addPlayer(player);
        }
    }

    public void setKills(Player player, int kills) {
        String uuid = player.getUniqueId().toString();
        if(kills < 0) {
            kills = 0;
        }
        if(inList(player)) {
            plugin.getMySQLMainClass().update("UPDATE PlayerStats SET Kills='" + kills + "', WHERE UUID='" + uuid + "'");
        }else{
            addPlayer(player);
        }
    }

    public void setDeaths(Player player, int deaths) {
        String uuid = player.getUniqueId().toString();
        if(deaths < 0) {
            deaths = 0;
        }
        if(inList(player)) {
            plugin.getMySQLMainClass().update("UPDATE PlayerStats SET Deaths='" + deaths + "', WHERE UUID='" + uuid + "'");
        }else{
            addPlayer(player);
        }
    }