public void dataCountStore() {
Connection con = null;
int listId;
try {
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement =
con.prepareStatement(
"UPDATE merchant_buylists SET currentCount=? WHERE item_id=? AND shop_id=?");
for (L2TradeList list : _lists.values()) {
if (list.hasLimitedStockItem()) {
listId = list.getListId();
for (L2TradeItem item : list.getItems()) {
long currentCount;
if (item.hasLimitedStock()
&& (currentCount = item.getCurrentCount()) < item.getMaxCount()) {
statement.setLong(1, currentCount);
statement.setInt(2, item.getItemId());
statement.setInt(3, listId);
statement.executeUpdate();
statement.clearParameters();
}
}
}
}
statement.close();
} catch (Exception e) {
_log.log(Level.SEVERE, "TradeController: Could not store Count Item: " + e.getMessage(), e);
} finally {
L2DatabaseFactory.close(con);
}
}
private TradeController() {
_lists.clear();
Connection con = null;
/*
* Initialize Shop buylist
*/
try {
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement1 =
con.prepareStatement("SELECT shop_id, npc_id FROM merchant_shopids");
ResultSet rset1 = statement1.executeQuery();
int itemId, price, maxCount, currentCount, time;
long saveTimer;
PreparedStatement statement =
con.prepareStatement(
"SELECT item_id, price, shop_id, "
+ L2DatabaseFactory.getInstance().safetyString("order")
+ ", count, currentCount, time, savetimer FROM merchant_buylists WHERE shop_id=? ORDER BY "
+ L2DatabaseFactory.getInstance().safetyString("order")
+ " ASC");
while (rset1.next()) {
statement.setString(1, String.valueOf(rset1.getInt("shop_id")));
ResultSet rset = statement.executeQuery();
statement.clearParameters();
int shopId = rset1.getInt("shop_id");
L2TradeList buy1 = new L2TradeList(shopId);
while (rset.next()) {
itemId = rset.getInt("item_id");
price = rset.getInt("price");
maxCount = rset.getInt("count");
currentCount = rset.getInt("currentCount");
time = rset.getInt("time");
saveTimer = rset.getLong("saveTimer");
L2TradeItem item = new L2TradeItem(shopId, itemId);
if (ItemTable.getInstance().getTemplate(itemId) == null) {
_log.warning(
"Skipping itemId: "
+ itemId
+ " on buylistId: "
+ buy1.getListId()
+ ", missing data for that item.");
continue;
}
if (price <= -1) {
price = ItemTable.getInstance().getTemplate(itemId).getReferencePrice();
}
if (Config.DEBUG) {
// debug
double diff =
((double) (price))
/ ItemTable.getInstance().getTemplate(itemId).getReferencePrice();
if (diff < 0.8 || diff > 1.2) {
_log.severe(
"PRICING DEBUG: TradeListId: "
+ buy1.getListId()
+ " - ItemId: "
+ itemId
+ " ("
+ ItemTable.getInstance().getTemplate(itemId).getName()
+ ") diff: "
+ diff
+ " - Price: "
+ price
+ " - Reference: "
+ ItemTable.getInstance().getTemplate(itemId).getReferencePrice());
}
}
item.setPrice(price);
item.setRestoreDelay(time);
item.setNextRestoreTime(saveTimer);
item.setMaxCount(maxCount);
if (currentCount > -1) {
item.setCurrentCount(currentCount);
} else {
item.setCurrentCount(maxCount);
}
buy1.addItem(item);
}
buy1.setNpcId(rset1.getString("npc_id"));
_lists.put(buy1.getListId(), buy1);
_nextListId = Math.max(_nextListId, buy1.getListId() + 1);
rset.close();
}
statement.close();
rset1.close();
statement1.close();
_log.info("TradeController: Loaded " + _lists.size() + " Buylists.");
} catch (Exception e) {
// problem with initializing spawn, go to next one
_log.log(
Level.WARNING,
"TradeController: Buylists could not be initialized: " + e.getMessage(),
e);
} finally {
L2DatabaseFactory.close(con);
}
/*
* If enabled, initialize the custom buylist
*/
if (Config.CUSTOM_MERCHANT_TABLES) {
try {
int initialSize = _lists.size();
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement1 =
con.prepareStatement("SELECT shop_id, npc_id FROM custom_merchant_shopids");
ResultSet rset1 = statement1.executeQuery();
int itemId, price, maxCount, currentCount, time;
long saveTimer;
PreparedStatement statement =
con.prepareStatement(
"SELECT item_id, price, shop_id, "
+ L2DatabaseFactory.getInstance().safetyString("order")
+ ", count, currentCount, time, savetimer FROM custom_merchant_buylists WHERE shop_id=? ORDER BY "
+ L2DatabaseFactory.getInstance().safetyString("order")
+ " ASC");
while (rset1.next()) {
statement.setString(1, String.valueOf(rset1.getInt("shop_id")));
ResultSet rset = statement.executeQuery();
statement.clearParameters();
int shopId = rset1.getInt("shop_id");
L2TradeList buy1 = new L2TradeList(shopId);
while (rset.next()) {
itemId = rset.getInt("item_id");
price = rset.getInt("price");
maxCount = rset.getInt("count");
currentCount = rset.getInt("currentCount");
time = rset.getInt("time");
saveTimer = rset.getLong("saveTimer");
L2TradeItem item = new L2TradeItem(shopId, itemId);
if (ItemTable.getInstance().getTemplate(itemId) == null) {
_log.warning(
"Skipping itemId: "
+ itemId
+ " on buylistId: "
+ buy1.getListId()
+ ", missing data for that item.");
continue;
}
if (price <= -1) {
price = ItemTable.getInstance().getTemplate(itemId).getReferencePrice();
}
if (Config.DEBUG) {
// debug
double diff =
((double) (price))
/ ItemTable.getInstance().getTemplate(itemId).getReferencePrice();
if (diff < 0.8 || diff > 1.2) {
_log.severe(
"PRICING DEBUG: TradeListId: "
+ buy1.getListId()
+ " - ItemId: "
+ itemId
+ " ("
+ ItemTable.getInstance().getTemplate(itemId).getName()
+ ") diff: "
+ diff
+ " - Price: "
+ price
+ " - Reference: "
+ ItemTable.getInstance().getTemplate(itemId).getReferencePrice());
}
}
item.setPrice(price);
item.setRestoreDelay(time);
item.setNextRestoreTime(saveTimer);
item.setMaxCount(maxCount);
if (currentCount > -1) {
item.setCurrentCount(currentCount);
} else {
item.setCurrentCount(maxCount);
}
buy1.addItem(item);
}
buy1.setNpcId(rset1.getString("npc_id"));
_lists.put(buy1.getListId(), buy1);
_nextListId = Math.max(_nextListId, buy1.getListId() + 1);
rset.close();
}
statement.close();
rset1.close();
statement1.close();
_log.info("TradeController: Loaded " + (_lists.size() - initialSize) + " Custom Buylists.");
} catch (Exception e) {
// problem with initializing spawn, go to next one
_log.log(
Level.WARNING,
"TradeController: Buylists could not be initialized: " + e.getMessage(),
e);
} finally {
L2DatabaseFactory.close(con);
}
}
}