Paylaşım Siteden Kayıt Alan Sunucular İçin İşe Yarar Plugin (Source Code)

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;


import com.mysql.jdbc.Connection;

public class MySQL {

    public Connection conn = null;
    public String user;
    public String password;
    public String ip;
    public String db;
    public String url;
    public boolean isConnect=false;

    public MySQL(String ip, String user, String password, String db) {
        this.ip = ip;
        this.user = user;
        this.password = password;
        this.db = db;
        this.url = "jdbc:mysql://" + ip + ":3306/" + db+"?autoReconnect=true";
        try {
            conn = (Connection) DriverManager.getConnection(this.url,this.user, this.password);
            isConnect=true;
        } catch (SQLException e) {
        }
    }


    public String sqlConnectionTest(){
        String returnstring="";
        try {
            ResultSet rs = this.getConn().createStatement().executeQuery("select id from ghostdb limit 1"); // kendi authme tablonunza göre düzenleyiniz
            rs.beforeFirst();
            rs.next();
            returnstring=returnstring+"-SQL Test Success";
        } catch (Exception e1) {
            returnstring=returnstring+"-SQL Test Error";
            try {
                try {
                    conn.close();
                    returnstring=returnstring+"-Close Success";
                } catch (Exception e) {
                    returnstring=returnstring+"-Close Error";
                }
                this.conn=null;
                this.conn = (Connection) DriverManager.getConnection(this.url,this.user, this.password);
                isConnect=true;
                returnstring=    returnstring+"-New Conection Success";
            } catch (Exception e23) {
                returnstring=    returnstring+"-Error !!!!!!!";
            }
        }
        return returnstring;
    }

    public Connection getConn() {
        return this.conn;
    }

    public ResultSet getResultSet(String query) {
        try {
            ResultSet rs = this.getConn().createStatement().executeQuery(query);
            return rs;
        } catch (SQLException e) {
            this.sqlConnectionTest();
            return null;
        }
    }

    public boolean ExecuteSql(String query) {
        try {
            this.getConn().createStatement().executeUpdate(query);
            return true;
        } catch (SQLException e) {
            this.sqlConnectionTest();
            return false;
        }
    }
}

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.concurrent.TimeUnit;

import net.md_5.bungee.api.ChatColor;
import net.md_5.bungee.api.CommandSender;
import net.md_5.bungee.api.ProxyServer;
import net.md_5.bungee.api.config.ServerInfo;
import net.md_5.bungee.api.connection.ProxiedPlayer;
import net.md_5.bungee.api.plugin.Plugin;

public class Main extends Plugin {
    public String db = "sql db";
    public String host = "sql ip";
    public String user = "sql kullanıcı adı";
    public String password = "sql şifresi";
    public static MySQL SqlServer;
    public static Main plugin;
    public static int lastSqlId = 0;
    public static HashMap<String, Integer> userWhiteLists = new HashMap<String, Integer>();

    @Override
    public void onEnable() {
        plugin = this;
        SqlServer = new MySQL(host, user, password, db); // sql server
        getLogger().info("Naaber Müdüür");
        getProxy().getPluginManager().registerListener(this, new AntiBot()); // anti bot sınıfını listener olarak kaydediyoruz

        getProxy().getScheduler().schedule(this, new Runnable() {
            @Override
            public void run() {
                getLogger().info(SqlServer.sqlConnectionTest());
            }
        }, 1, 300, TimeUnit.SECONDS);

        getProxy().getScheduler().schedule(this, new Runnable() {
            @Override
            public void run() {
                updateWhiteList.update();
            }
        }, 1, 15, TimeUnit.SECONDS);
    }
}

public class AntiBot implements Listener {
    @SuppressWarnings("deprecation")
    @EventHandler(priority=Byte.MIN_VALUE)
    public void onServwereeConnect(LoginEvent e) {
        if (Main.userWhiteLists.get(e.getConnection().getName().toLowerCase())==null) {
            e.setCancelReason("Giriş yapabilmek için\n\nwww.HyperionMC.com Adresinden kayıt olmalısın.\n\nKayıt olduysan 30 saniye bekleyip tekrar giriş yap.");
            e.setCancelled(true);
            Main.plugin.getLogger().info(e.getConnection().getName()+" §cAtıldı.");
        }
    }
}

public class updateWhiteList {
    public static void update() {
        ResultSet rs = Main.SqlServer.getResultSet("select id,user from ghostdb where id > " + Main.lastSqlId+" ORDER BY id ASC LIMIT 25000"); // kendinize göre düzenleyiniz. Tek seferde 25 bin kayıtlı kişinin ismini çeker.
        try {
            while (rs.next()) {
                int playerID=rs.getInt("id"); // id = uniq user id stünü
                String playerName=rs.getString("user").toLowerCase(); // user = kullanıcı adı stünü
                if (playerID>Main.lastSqlId) {
                    Main.lastSqlId=playerID;
                }
                Main.userWhiteLists.put(playerName, playerID);
                Main.plugin.getLogger().info("§eEklendi: "+playerName+ " - "+playerID);
            }
        } catch (Exception e) {
        }
    }

}