Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. public void saveAccount(TPlayer tPlayer) {
  2. try {
  3. PreparedStatement stm = plugin.getMySQL().getConnection()
  4. .prepareStatement("SELECT `uuid` FROM `accounts` WHERE `uuid`=?;");
  5. stm.setString(1, tPlayer.getUuid());
  6. ResultSet rs = stm.executeQuery();
  7. if (rs.next()) {
  8. PreparedStatement update = plugin.getMySQL().getConnection().prepareStatement(
  9. "UPDATE `accounts` SET `ip`=?, `name`=?, `league`=?, `coins`=?, `xp`=?, `group`=?, `expire`=? WHERE `uuid`=?;");
  10. update.setString(1, tPlayer.getIp());
  11. update.setString(2, tPlayer.getName());
  12. update.setString(3, tPlayer.getLeague().name());
  13. update.setInt(4, tPlayer.getCoins());
  14. update.setInt(5, tPlayer.getXP());
  15. update.setString(6, tPlayer.getGroup().name());
  16. update.setString(7, tPlayer.getExpire());
  17. update.setString(8, tPlayer.getUuid());
  18. update.executeUpdate();
  19. update.close();
  20. profiles.remove(tPlayer.getName());
  21. }
  22. rs.close();
  23. stm.close();
  24. saveGamePlayer(tPlayer);
  25. } catch (SQLException e) {
  26. e.printStackTrace();
  27. }
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement