Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(playerCommand.equalsIgnoreCase("donated")){
- try {
- java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://zionscape.com:3306/zionscap_db", "zionscap_user", "***");
- Statement statement = con.createStatement();
- ResultSet rs = statement.executeQuery("SELECT * FROM donation WHERE username = '"+c.playerName.replaceAll(" ", "_")+"';");
- c.sendMessage("queried.. :)");
- if(rs.next()){
- c.sendMessage("Thanks for donating");
- c.getItems().addItem(rs.getInt("productid"), 1);
- int itemid = rs.getInt("productid");
- switch(itemid) {
- case 13887://vesta
- c.getItems().addItem(13893, 1);
- c.getItems().addItem(13899, 1);
- c.getItems().addItem(13905, 1);
- break;
- case 13890://statius
- c.getItems().addItem(13884, 1);
- c.getItems().addItem(13896, 1);
- c.getItems().addItem(13902, 1);
- break;
- case 11724://bandos
- c.getItems().addItem(11726, 1);
- c.getItems().addItem(11728, 1);
- break;
- case 20135://torva
- c.getItems().addItem(20139, 1);
- c.getItems().addItem(20143, 1);
- break;
- case 20159://virtus
- c.getItems().addItem(20163, 1);
- c.getItems().addItem(20167, 1);
- break;
- case 11718://armadyl
- c.getItems().addItem(11720, 1);
- c.getItems().addItem(11722, 1);
- break;
- }
- c.isMember = 1;
- c.logout();
- //statement.executeUpdate("DELETE FROM donation WHERE username = '"+rs.getString("username")+"'");
- }else{
- c.sendMessage("Donate b4 claiming");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment