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