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);
}
