API tools faq
paste
Advertisement
Guest User

Erreur du plugin

a guest
Dec 22nd, 2017
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.77 KB | None | 0 0
raw download clone embed print report
  1. // Erreur Console
  2.  
  3. [10:16:39 INFO]: UUID of player TheWhiteGamer666 is 0d608cf4-e07a-41b4-8f96-0929
  4. 47e175b8
  5. [10:16:39 WARN]: java.sql.SQLException: Data truncated for column 'player_uuid'
  6. at row 1
  7. [10:16:39 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
  8. ava:964)
  9. [10:16:39 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
  10. 3973)
  11. [10:16:39 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
  12. 3909)
  13. [10:16:39 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  14.  
  15. [10:16:39 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:26
  16. 80)
  17. [10:16:39 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
  18. java:2490)
  19. [10:16:39 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(Prep
  20. aredStatement.java:1858)
  21. [10:16:39 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInterna
  22. l(PreparedStatement.java:2079)
  23. [10:16:39 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInterna
  24. l(PreparedStatement.java:2013)
  25. [10:16:39 WARN]: at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(P
  26. reparedStatement.java:5104)
  27. [10:16:39 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdate(Prepar
  28. edStatement.java:1998)
  29. [10:16:39 WARN]: at fr.thewhitegamer666.bansystem.infos.PlayerInfos.updat
  30. e(PlayerInfos.java:35)
  31. [10:16:39 WARN]: at fr.thewhitegamer666.bansystem.listeners.PlayerJoin.on
  32. Join(PlayerJoin.java:17)
  33. [10:16:39 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M
  34. ethod)
  35. [10:16:39 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S
  36. ource)
  37. [10:16:39 WARN]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno
  38. wn Source)
  39. [10:16:39 WARN]: at java.lang.reflect.Method.invoke(Unknown Source)
  40. [10:16:39 WARN]: at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav
  41. aPluginLoader.java:302)
  42. [10:16:39 WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(Regist
  43. eredListener.java:62)
  44. [10:16:39 WARN]: at org.bukkit.plugin.SimplePluginManager.fireEvent(Simpl
  45. ePluginManager.java:499)
  46. [10:16:39 WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl
  47. ePluginManager.java:484)
  48. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.PlayerList.onPlayerJoin
  49. (PlayerList.java:346)
  50. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.PlayerList.a(PlayerList
  51. .java:166)
  52. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.LoginListener.b(LoginLi
  53. stener.java:159)
  54. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.LoginListener.e(LoginLi
  55. stener.java:57)
  56. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.NetworkManager.a(Networ
  57. kManager.java:233)
  58. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.ServerConnection.c(Serv
  59. erConnection.java:140)
  60. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.D(Minec
  61. raftServer.java:842)
  62. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.D(Dedic
  63. atedServer.java:405)
  64. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.C(Minec
  65. raftServer.java:678)
  66. [10:16:39 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.run(Min
  67. ecraftServer.java:576)
  68. [10:16:39 WARN]: at java.lang.Thread.run(Unknown Source)
  69.  
  70.  
  71. // Code Du BanSystem.java
  72. package fr.thewhitegamer666.bansystem;
  73.  
  74. import org.bukkit.Bukkit;
  75. import org.bukkit.plugin.java.JavaPlugin;
  76.  
  77. import fr.thewhitegamer666.bansystem.listeners.PlayerJoin;
  78. import fr.thewhitegamer666.bansystem.mysql.MySQL;
  79.  
  80. public class BanSystem extends JavaPlugin {
  81.  
  82. private static BanSystem instance;
  83. public MySQL mysql = new MySQL();
  84.  
  85. @Override
  86. public void onEnable() {
  87. instance = this;
  88. mysql.connect("localhost", 3306, "bansystem", "root", "");
  89.  
  90. Bukkit.getPluginManager().registerEvents(new PlayerJoin(), this);
  91. }
  92.  
  93.  
  94. @Override
  95. public void onDisable() {
  96. mysql.disconnect();
  97.  
  98. }
  99. public static BanSystem getInstance() {
  100. return instance;
  101. }
  102. }
  103.  
  104.  
  105. Code du player join.java
  106.  
  107. package fr.thewhitegamer666.bansystem.listeners;
  108.  
  109. import org.bukkit.entity.Player;
  110. import org.bukkit.event.EventHandler;
  111. import org.bukkit.event.Listener;
  112. import org.bukkit.event.player.PlayerJoinEvent;
  113.  
  114. import fr.thewhitegamer666.bansystem.infos.PlayerInfos;
  115.  
  116. public class PlayerJoin implements Listener {
  117.  
  118. @EventHandler
  119. public void onJoin(PlayerJoinEvent e){
  120. Player player = e.getPlayer();
  121. PlayerInfos playerInfos = new PlayerInfos();
  122.  
  123. playerInfos.update(player);
  124. }
  125.  
  126. }
  127.  
  128.  
  129. Code du playerinfo.java
  130.  
  131.  
  132. package fr.thewhitegamer666.bansystem.infos;
  133.  
  134. import com.mysql.jdbc.PreparedStatement;
  135.  
  136. import fr.thewhitegamer666.bansystem.BanSystem;
  137.  
  138. import java.sql.ResultSet;
  139. import java.sql.SQLException;
  140. import java.util.UUID;
  141.  
  142. import org.bukkit.entity.Player;
  143.  
  144. public class PlayerInfos {
  145.  
  146.  
  147.  
  148. public void update(Player player){
  149. try {
  150. PreparedStatement sts = (PreparedStatement) BanSystem.getInstance().mysql.getConnection().prepareStatement("SELECT player_name FROM player_infos WHERE player_uuid=?");
  151. sts.setString(1, player.getUniqueId().toString());
  152. ResultSet rs = sts.executeQuery();
  153.  
  154. if(rs.next()){
  155. PreparedStatement update = (PreparedStatement) BanSystem.getInstance().mysql.getConnection().prepareStatement("UPDATE player_infos SET player_name=? WHERE player_uuid=?");
  156. update.setString(1, player.getName());
  157. update.setString(2, player.getUniqueId().toString());
  158. update.executeUpdate();
  159. update.close();
  160.  
  161. System.out.println("Update : " + player.getName() + " , " + player.getUniqueId().toString()); // Facultatif
  162. } else {
  163. PreparedStatement insert = (PreparedStatement) BanSystem.getInstance().mysql.getConnection().prepareStatement("INSERT INTO player_infos (player_uuid, player_name) VALUES (?, ?)");
  164. insert.setString(1, player.getUniqueId().toString());
  165. insert.setString(2, player.getName());
  166. insert.executeUpdate();
  167. insert.close();
  168.  
  169. System.out.println("Insertion : " + player.getName() + " , " + player.getUniqueId().toString()); // Facultatif
  170. }
  171. } catch (SQLException e) {
  172. e.printStackTrace();
  173. }
  174. }
  175.  
  176. public boolean exist(String playerName){
  177. try {
  178. PreparedStatement sts = (PreparedStatement) BanSystem.getInstance().mysql.getConnection().prepareStatement("SELECT * FROM player_infos WHERE player_name=?");
  179. sts.setString(1, playerName);
  180. ResultSet rs = sts.executeQuery();
  181. return rs.next();
  182. } catch (SQLException e) {
  183. e.printStackTrace();
  184. }
  185. return false;
  186. }
  187.  
  188.  
  189. public UUID getUUID(String playerName){
  190. try {
  191. PreparedStatement sts = (PreparedStatement) BanSystem.getInstance().mysql.getConnection().prepareStatement("SELECT player_uuid FROM player_infos WHERE player_name=?");
  192. sts.setString(1, playerName);
  193. ResultSet rs = sts.executeQuery();
  194.  
  195. if(rs.next()){
  196. return UUID.fromString(rs.getString("player_uuid"));
  197. }
  198. } catch (SQLException e) {
  199. e.printStackTrace();
  200. }
  201. throw new NullPointerException("Le joueur na pas dinformations dans la table");
  202. }
  203.  
  204. }
  205.  
  206. Code du mysql.java
  207. package fr.thewhitegamer666.bansystem.mysql;
  208.  
  209. import java.sql.Connection;
  210. import java.sql.DriverManager;
  211. import java.sql.SQLException;
  212.  
  213. public class MySQL {
  214.  
  215. private Connection conn;
  216.  
  217. public void connect(String host, int port, String database, String user, String password){
  218. if(!isConnected()){
  219. try {
  220. conn = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, user, password);
  221. System.out.println("[BanSystem] Connexion etablie avec la bdd");
  222. } catch (SQLException e) {
  223. e.printStackTrace();
  224. }
  225. }
  226. }
  227. public void disconnect(){
  228. if(isConnected()){
  229. try {
  230. conn.close();
  231. } catch (SQLException e) {
  232. e.printStackTrace();
  233. }
  234. }
  235. }
  236.  
  237. public boolean isConnected(){
  238. try {
  239. if((conn == null) || (conn.isClosed()) || conn.isValid(5)){
  240. return false;
  241. }
  242. return true;
  243. } catch (SQLException e) {
  244. e.printStackTrace();
  245. }
  246. return false;
  247. }
  248. public Connection getConnection() {
  249. return conn;
  250. }
  251. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!