public List<Pair<Item, String>> loadGifts() { List<Pair<Item, String>> gifts = new ArrayList<>(); Connection con = DatabaseConnection.getConnection(); try { PreparedStatement ps = con.prepareStatement("SELECT * FROM `gifts` WHERE `recipient` = ?"); ps.setInt(1, characterId); ResultSet rs = ps.executeQuery(); while (rs.next()) { CashItemInfo cItem = CashItemFactory.getInstance().getItem(rs.getInt("sn")); if (cItem == null) { continue; } Item item = toItem(cItem, rs.getInt("uniqueid"), rs.getString("from")); gifts.add(new Pair<>(item, rs.getString("message"))); uniqueids.add(item.getUniqueId()); List<Integer> packages = CashItemFactory.getInstance().getPackageItems(cItem.getId()); if (packages != null && packages.size() > 0) { for (int packageItem : packages) { CashItemInfo pack = CashItemFactory.getInstance().getSimpleItem(packageItem); if (pack != null) { addToInventory(toItem(pack, rs.getString("from"))); } } } else { addToInventory(item); } } rs.close(); ps.close(); ps = con.prepareStatement("DELETE FROM `gifts` WHERE `recipient` = ?"); ps.setInt(1, characterId); ps.executeUpdate(); ps.close(); save(); } catch (SQLException sqle) { } return gifts; }
public boolean onSale() { return onSale || (CashItemFactory.getInstance().getModInfo(sn) != null && CashItemFactory.getInstance().getModInfo(sn).showUp); }