private static final boolean deletePackage(int accid, int packageid, int chrId) { Connection con = DatabaseConnection.getConnection(); try { PreparedStatement ps = con.prepareStatement( "DELETE from hiredmerch where accountid = ? OR packageid = ? OR characterid = ?"); ps.setInt(1, accid); ps.setInt(2, packageid); ps.setInt(3, chrId); ps.executeUpdate(); ps.close(); ItemLoader.HIRED_MERCHANT.saveItems(null, packageid); return true; } catch (SQLException e) { } return false; }
private static final MerchItemPackage loadItemFrom_Database(int accountid) { Connection con = DatabaseConnection.getConnection(); try { PreparedStatement ps = con.prepareStatement("SELECT * from hiredmerch where accountid = ?"); ps.setInt(1, accountid); ResultSet rs = ps.executeQuery(); if (!rs.next()) { ps.close(); rs.close(); return null; } int packageid = rs.getInt("PackageId"); MerchItemPackage pack = new MerchItemPackage(); pack.setPackageid(packageid); pack.setMesos(rs.getInt("Mesos")); pack.setSavedTime(rs.getLong("time")); ps.close(); rs.close(); Map<Long, Pair<Item, MapleInventoryType>> items = ItemLoader.HIRED_MERCHANT.loadItems(false, packageid); if (items != null) { List iters = new ArrayList(); for (Pair z : items.values()) { iters.add(z.left); } pack.setItems(iters); } return pack; } catch (SQLException e) { e.printStackTrace(); } return null; }