Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(playerCommand.equalsIgnoreCase("donated")){
- c.sendMessage("Thanks for donating");
- try {
- java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://zionscape.com:3306/zionscap_db", "zionscap_user", "tylernigga11");
- Statement statement = con.createStatement();
- ResultSet rs = statement.executeQuery("SELECT * FROM donation WHERE username = '"+c.playerName.replaceAll(" ", "_")+"';");
- if(rs.next()){
- c.sendMessage("Thanks for donating");
- c.getItems().addItem(rs.getInt("productid"), 1);
- c.isMember = 1;
- c.logout();
- statement.executeUpdate("DELETE FROM donation WHERE username = '"+rs.getString("username")+"'");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment