public class TryGamesSQL extends JavaPlugin implements Listener {
    private static TryGamesSQL instance;
    public static Database database;
    private List<DataPlayer> dataPlayers = new ArrayList<DataPlayer>();

    // onEnable()
    public void onEnable() {
        System.out.println("TryGamesSQL > ON");
        instance = this;
        database = new Database("jdbc:mysql://", "localhost", "TryGamesSQL", "TryUser", "trywox98");
        database.connect();
        new ListenerManager((Plugin)this).registerListeners();
        this.registerCommands();

        for (Player p : Bukkit.getOnlinePlayers()) {
            addDataPlayer(p);
        }
        this.schedule();
    }

    // onDisable()
    public void onDisable() {
        System.out.println("TryGamesSQL > OFF");
        database.disconnect();

        for (Player p : Bukkit.getOnlinePlayers()) {
            removeDataPlayer(p);
        }
        this.schedule();
        database.disconnect();
    }

    // getInstance()
    public static TryGamesSQL getInstance() {
        return instance;
    }

    // getDataPlayer()
    public DataPlayer getDataPlayer(Player player) {
        int i = 0;
        while (i < this.dataPlayers.size()) {
            if (this.dataPlayers.get(i).getPlayer() == player) {
                return this.dataPlayers.get(i);
            }
            ++i;
        }
        return null;
    }

    // addDataPlayer
    public void addDataPlayer(Player player) {
        if (this.getDataPlayer(player) == null ) {
            this.dataPlayers.add(new DataPlayer(player));
        }
    }

    // removeDataPlayer()
    public void removeDataPlayer(Player player) {
        this.getDataPlayer(player).update();
        int i = 0;
        while (i < this.dataPlayers.size()) {
            if (this.dataPlayers.get(i).getPlayer() == player) {
                this.dataPlayers.remove(i);
            }
            ++i;
        }
    }

    // schedule() || run()
    private void schedule() {
        Bukkit.getScheduler().scheduleSyncRepeatingTask((Plugin) this, new Runnable() {

            // run()
            @Override
            public void run() {
                TryGamesSQL.database.connect();
            }
        }, 0, 144000);
    }

    // registerCommands()
    private void registerCommands() {
        this.getCommand("rank").setExecutor((CommandExecutor) new RankCMD());
    }

}