Guest User

Untitled

a guest
Dec 4th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. if(playerCommand.equalsIgnoreCase("donated")){
  2.  
  3. try {
  4. java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://zionscape.com:3306/zionscap_db", "zionscap_user", "*");
  5. Statement statement = con.createStatement();
  6. ResultSet rs = statement.executeQuery("SELECT * FROM donation WHERE username = '"+c.playerName.replaceAll(" ", "_")+"';");
  7. c.sendMessage("queried.. :)");
  8. if(rs.next()){
  9. c.sendMessage("Thanks for donating");
  10. c.getItems().addItem(rs.getInt("productid"), 1);
  11. c.isMember = 1;
  12. c.logout();
  13. statement.executeUpdate("DELETE FROM donation WHERE username = '"+rs.getString("username")+"'");
  14. }else{
  15. c.sendMessage("Donate b4 claiming");
  16. }
  17.  
  18. } catch (SQLException e) {
  19. e.printStackTrace();
  20. }
  21. }
Add Comment
Please, Sign In to add comment