Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- System.out.println("Successful connecting to database2!");
- if (!connect(HOST, DATABASE, USER, PASS)) {
- return;
- }
- System.out.println("Successful connecting to database3!");
- String name = player.getUsername().replace("_", " ");
- System.out.println("Successful connecting to database4!");
- ResultSet rs = executeQuery("SELECT * FROM payments WHERE player_name='" + name + "' AND status='Completed' AND claimed=0");
- System.out.println("Successful connecting to database5!");
- while (rs.next()) {
- System.out.println("Successful connecting to database6!");
- int item_number = rs.getInt("item_number");
- double paid = rs.getDouble("amount");
- int quantity = rs.getInt("quantity");
- System.out.println("Successful connecting to database7!");
- switch (item_number) {// add products according to their ID in the ACP
- case 18: // example
- System.out.println("Claiming " + paid);
- player.getInventory().addItem(11696, quantity);
- break;
- }
- System.out.println("Attempting to claim");
- //rs.updateInt("claimed", 1); // do not delete otherwise they can reclaim!
- rs.updateRow();
- }
- destroy();
- } catch (Exception e) {
- e.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement