Advertisement
Guest User

Untitled

a guest
Aug 12th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.80 KB | None | 0 0
  1. public class Commands implements CommandExecutor {
  2. public boolean onCommand(CommandSender sender, Command cmd, String commandLabel, String[] args){
  3. if(cmd.getName().equalsIgnoreCase("homiecraft")){
  4. Player player = (Player) sender;
  5. String pName = player.getName();
  6.  
  7. Connection c = null;
  8.  
  9.  
  10. try {
  11. String sqlHost = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.host");
  12. String sqlPort = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.port");
  13. String sqlDb = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.db");
  14. String sqlUser = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.user");
  15. String sqlPw = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.pw");
  16.  
  17. if(!(args.length == 0)){
  18. if(args[0].equalsIgnoreCase("register")){
  19. pro.homiecraft.MySql MySql = new pro.homiecraft.MySql(sqlHost, sqlPort, sqlDb, sqlUser, sqlPw);
  20. c = MySql.open();
  21. Statement statement = c.createStatement();
  22. ResultSet res = statement.executeQuery("SELECT * FROM users WHERE minecraft = '" + pName + "';");
  23. res.next();
  24.  
  25. if(res.getString("minecraft") == null){
  26. String UserName = args[1];
  27. String Pw = args[2];
  28. String EMail = args[3];
  29.  
  30. statement.executeUpdate("INSERT INTO users ('minecraft', 'username', 'password', 'email') VALUES('" + pName + "', '" + UserName + "', '" + Pw + "', '" + EMail + "');");
  31. //player.sendMessage("[HomieCraft] You have now registered as: " + UserName + " Password: " + Pw + " Email: " + EMail);
  32. }else{
  33. player.sendMessage("[HomieCraft] You have allready registered! You can login at http://homiecraft.pro");
  34. }
  35. }else{
  36. player.sendMessage("[HomieCraft] Usage:");
  37. player.sendMessage("/homiecraft register <UserName> <Password> <email>");
  38. }
  39. }else{
  40. player.sendMessage("[HomieCraft] Usage:");
  41. player.sendMessage("/homiecraft register <UserName> <Password> <email>");
  42. }
  43. } catch (SQLException e) {
  44. // TODO Auto-generated catch block
  45. e.printStackTrace();
  46. }
  47. }
  48. return false;
  49. }
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement