Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void checkPlayer(Player p){
- try{
- ResultSet res = s.executeQuery("SELECT * FROM `coins` WHERE `player_name` = '" + p.getName() + "';");
- int coins = 0;
- res.next();
- if(res.getString("player_name") == null) {
- coins = 0;
- p.sendMessage("Coins " + coins);
- addPlayer(p);
- } else {
- coins = res.getInt("coins");
- p.sendMessage("coins " + coins);
- s.executeUpdate("INSERT INTO `coins` (`player_name`,`coins`) VALUES ('"+p.getName()+ "','"+ coins+1 +"');");
- p.sendMessage("coins " + coins+1);
- }
- }
- catch (SQLException e) {
- p.sendMessage("Fehler beim auslesen!");
- e.printStackTrace();
- addPlayer(p);
- }
- }
- public static void addPlayer(Player p){
- try {
- s.executeUpdate("INSERT INTO `coins` (`player_name`,`coins`) VALUES ('"+p.getName()+ "','1');");
- p.sendMessage("Willkommen");
- return;
- } catch (SQLException e) {
- e.printStackTrace();
- p.sendMessage("Fehler beim hinzufügen!");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement