Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void refreshServers() throws SQLException {
- Connection connection;
- try {
- connection = DriverManager.getConnection("jdbc:mysql://" + databaseHost + ":" + databasePort + "/minigames-servers?password=" + databasePassword + "&user=" + databaseUser);
- Statement st = connection.createStatement();
- String sql = ("SELECT * FROM servers;");
- ResultSet rs = st.executeQuery(sql);
- while(rs.next()) {
- String NAME = rs.getString("NAME");
- String IP = rs.getString("IP");
- Integer PORT = rs.getInt("PORT");
- if(!ProxyServer.getInstance().getServers().containsValue(ProxyServer.getInstance().constructServerInfo(NAME, new InetSocketAddress(IP,PORT), "BungeeCordQuery.ADMIN", false))) {
- if(ProxyServer.getInstance().getServers().containsKey(NAME)) {
- ProxyServer.getInstance().getServers().remove(NAME);
- }
- ProxyServer.getInstance().getServers().put(NAME, ProxyServer.getInstance().constructServerInfo(NAME, new InetSocketAddress(IP,PORT), "BungeeCordQuery.ADMIN", false));
- }
- }
- connection.close();
- } catch(Exception e) {
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement