Advertisement
Guest User

Untitled

a guest
May 6th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.68 KB | None | 0 0
  1. ERORR:
  2. [17:45:39] [Server thread/ERROR]: Error occurred while enabling BookOnlinePlayers v1.0 (Is it up to date?)
  3. java.lang.NullPointerException
  4. at me.drbooker.bookplayersonline.mysql.MySQL.update(MySQL.java:49) ~[?:?]
  5. at me.drbooker.bookplayersonline.Main.ConnectMySQL(Main.java:46) ~[?:?]
  6. at me.drbooker.bookplayersonline.Main.onEnable(Main.java:19) ~[?:?]
  7. at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:271) ~[spigot.jar:git-Spigot-3fb9445-fbb47e8]
  8. at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  9. at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  10. at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugin(CraftServer.java:376) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  11. at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugins(CraftServer.java:326) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  12. at org.bukkit.craftbukkit.v1_11_R1.CraftServer.reload(CraftServer.java:750) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  13. at org.bukkit.Bukkit.reload(Bukkit.java:540) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  14. at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  15. at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  16. at org.bukkit.craftbukkit.v1_11_R1.CraftServer.dispatchCommand(CraftServer.java:650) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  17. at net.minecraft.server.v1_11_R1.PlayerConnection.handleCommand(PlayerConnection.java:1354) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  18. at net.minecraft.server.v1_11_R1.PlayerConnection.a(PlayerConnection.java:1189) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  19. at net.minecraft.server.v1_11_R1.PacketPlayInChat.a(PacketPlayInChat.java:45) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  20. at net.minecraft.server.v1_11_R1.PacketPlayInChat.a(PacketPlayInChat.java:1) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  21. at net.minecraft.server.v1_11_R1.PlayerConnectionUtils$1.run(SourceFile:13) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  22. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_131]
  23. at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_131]
  24. at net.minecraft.server.v1_11_R1.SystemUtils.a(SourceFile:46) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  25. at net.minecraft.server.v1_11_R1.MinecraftServer.D(MinecraftServer.java:747) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  26. at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:399) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  27. at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:678) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  28. at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:576) [spigot.jar:git-Spigot-3fb9445-fbb47e8]
  29. at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
  30.  
  31. Main:
  32. package me.drbooker.bookplayersonline;
  33.  
  34. import org.bukkit.Bukkit;
  35. import org.bukkit.plugin.Plugin;
  36. import org.bukkit.plugin.java.JavaPlugin;
  37.  
  38. import me.drbooker.bookplayersonline.mysql.MySQL;
  39. import me.drbooker.bookplayersonline.mysql.SQLPlayers;
  40.  
  41. public class Main extends JavaPlugin {
  42.  
  43. public static Plugin pl;
  44. public static MySQL mysql;
  45.  
  46. @Override
  47. public void onEnable() {
  48. pl = this;
  49.  
  50. ConnectMySQL();
  51.  
  52. saveDefaultConfig();
  53. Bukkit.getScheduler().scheduleSyncRepeatingTask(this, new Runnable() {
  54. @Override
  55. public void run() {
  56. SQLPlayers.setPlayers(Main.getInst().getConfig().getString("server"), Bukkit.getOnlinePlayers().size());
  57. }
  58. }, 0, 1200L);
  59. }
  60.  
  61. @Override
  62. public void onDisable() {
  63. pl = null;
  64. }
  65.  
  66. public static Plugin getInst() {
  67. return pl;
  68. }
  69.  
  70. private void ConnectMySQL() {
  71. mysql = new MySQL("localhost", "baza", "nick", "haslo");
  72. mysql.update("CREATE TABLE IF NOT EXISTS BookSerwery (ID INT NOT NULL AUTO_INCREMENT, SERWER VARCHAR(16), PLAYERS INT NOT NULL, PRIMARY KEY (ID), UNIQUE (SERWER));");
  73. }
  74. }
  75.  
  76. MySQL:
  77. package me.drbooker.bookplayersonline.mysql;
  78.  
  79. import java.sql.Connection;
  80. import java.sql.DriverManager;
  81. import java.sql.ResultSet;
  82. import java.sql.SQLException;
  83. import java.sql.Statement;
  84.  
  85. public class MySQL {
  86.  
  87. private String HOST = "localhost";
  88. private String DATABASE = "baza";
  89. private String USER = "user";
  90. private String PASSWORD = "password";
  91.  
  92. private Connection con;
  93.  
  94. public MySQL(String host, String database, String user, String password) {
  95. this.HOST = host;
  96. this.DATABASE = database;
  97. this.USER = user;
  98. this.PASSWORD = password;
  99.  
  100. connect();
  101. }
  102.  
  103. public void connect() {
  104. try {
  105. con = DriverManager.getConnection("jdbc:mysql://" + HOST + ":3306/" + DATABASE + "?autoReconnect=true", USER, PASSWORD);
  106. System.out.println("[MySQL] Polaczono z baza MySQL.");
  107. } catch (SQLException e) {
  108. System.out.println("[MySQL] Polaczenie z baza MySQL nie powiodlo sie! Blad: " + e.getMessage());
  109. }
  110. }
  111.  
  112. public void close() {
  113. try {
  114. if(con != null) {
  115. con.close();
  116. System.out.println("[MySQL] Rozlaczenie z baza MySQL zakonczylo sie pomyslnie!");
  117. }
  118. } catch (SQLException e) {
  119. System.out.println("[MySQL] Rozlaczanie z baza MySQL nie powiodlo sie! Blad: " + e.getMessage());
  120. }
  121. }
  122.  
  123. public void update(String qry) {
  124. try {
  125. Statement st = con.createStatement();
  126. st.executeUpdate(qry);
  127. st.close();
  128. } catch (SQLException e) {
  129. connect();
  130. System.err.println(e);
  131. }
  132. }
  133.  
  134. public ResultSet query(String qry) {
  135. ResultSet rs = null;
  136.  
  137. try {
  138. Statement st = con.createStatement();
  139. rs = st.executeQuery(qry);
  140. } catch (SQLException e) {
  141. connect();
  142. System.err.println(e);
  143. }
  144. return rs;
  145. }
  146. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement