Vinetos

Requetes

May 24th, 2015
274
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. @EventHandler
  2. public void onJoin(PostLoginEvent e){
  3. ProxiedPlayer p = e.getPlayer();
  4. //Avant qu'il se connecte au serveur de base
  5. System.out.println("PostLoginEvent");
  6. //MySQl
  7. PreparedStatement sts;
  8. if(exist(p)){
  9. //S'il existe
  10. }else{
  11. //S'il n'existe pas
  12. try {
  13. sts = MySQL.getConnection().prepareStatement("INSERT INTO players (uuid) VALUES(?)");
  14. sts.setString(1, p.getUniqueId().toString());
  15. sts.executeUpdate();
  16. sts.close();
  17. } catch (SQLException e1) {
  18. e1.printStackTrace();
  19. }
  20. }
  21.  
  22. }
  23.  
  24. private boolean exist(ProxiedPlayer p){
  25. PreparedStatement sts;
  26. String retour = null;
  27. try {
  28. sts = MySQL.getConnection().prepareStatement("SELECT count(*) FROM players WHERE uuid = ?");
  29. sts.setString(1, p.getUniqueId().toString());
  30. retour = MySQL.getResult(sts.executeQuery(), 1).toString().replaceAll("[\\[\\]]", "");
  31. sts.close();
  32. } catch (SQLException e1) {
  33. e1.printStackTrace();
  34. }
  35.  
  36. Integer infos = Integer.parseInt(retour);
  37. if(infos == 0){
  38. return false;
  39. }else{
  40. return true;
  41. }
Advertisement
Add Comment
Please, Sign In to add comment