Advertisement
Guest User

Untitled

a guest
Apr 30th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. public static void checkPlayer(Player p){
  2.  
  3. try{
  4. ResultSet res = s.executeQuery("SELECT * FROM `coins` WHERE `player_name` = '" + p.getName() + "';");
  5. int coins = 0;
  6. res.next();
  7. if(res.getString("player_name") == null) {
  8. coins = 0;
  9. p.sendMessage("Coins " + coins);
  10. addPlayer(p);
  11. } else {
  12. coins = res.getInt("coins");
  13. p.sendMessage("coins " + coins);
  14.  
  15. s.executeUpdate("INSERT INTO `coins` (`player_name`,`coins`) VALUES ('"+p.getName()+ "','"+ coins+1 +"');");
  16.  
  17. p.sendMessage("coins " + coins+1);
  18. }
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25.  
  26. }
  27. catch (SQLException e) {
  28. p.sendMessage("Fehler beim auslesen!");
  29. e.printStackTrace();
  30. addPlayer(p);
  31.  
  32. }
  33. }
  34. public static void addPlayer(Player p){
  35.  
  36. try {
  37. s.executeUpdate("INSERT INTO `coins` (`player_name`,`coins`) VALUES ('"+p.getName()+ "','1');");
  38. p.sendMessage("Willkommen");
  39.  
  40. return;
  41.  
  42. } catch (SQLException e) {
  43.  
  44. e.printStackTrace();
  45. p.sendMessage("Fehler beim hinzufügen!");
  46. }
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement