Guest User

Untitled

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