/* * Copyright (C) 2004-2014 L2J Server * * This file is part of L2J Server. * * L2J Server is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * L2J Server is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . */ package com.l2jserver.gameserver.instancemanager; import java.io.File; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import java.util.Map; import java.util.concurrent.atomic.AtomicInteger; import java.util.logging.Level; import java.util.logging.Logger; import javax.xml.parsers.DocumentBuilderFactory; import org.w3c.dom.Document; import org.w3c.dom.NamedNodeMap; import org.w3c.dom.Node; import com.l2jserver.Config; import com.l2jserver.L2DatabaseFactory; import com.l2jserver.gameserver.model.itemauction.ItemAuctionInstance; /** * @author Forsaiken */ public final class ItemAuctionManager { private static final Logger _log = Logger.getLogger(ItemAuctionManager.class.getName()); private final Map _managerInstances = new HashMap<>(); private final AtomicInteger _auctionIds; protected ItemAuctionManager() { _auctionIds = new AtomicInteger(1); if (!Config.ALT_ITEM_AUCTION_ENABLED) { _log.log(Level.INFO, getClass().getSimpleName() + ": Disabled by config."); return; } try (Connection con = L2DatabaseFactory.getInstance().getConnection(); Statement statement = con.createStatement(); ResultSet rset = statement.executeQuery("SELECT auctionId FROM item_auction ORDER BY auctionId DESC LIMIT 0, 1")) { if (rset.next()) { _auctionIds.set(rset.getInt(1) + 1); } } catch (final SQLException e) { _log.log(Level.SEVERE, getClass().getSimpleName() + ": Failed loading auctions.", e); } final File file = new File(Config.DATAPACK_ROOT + "/data/ItemAuctions.xml"); if (!file.exists()) { _log.log(Level.WARNING, getClass().getSimpleName() + ": Missing ItemAuctions.xml!"); return; } final DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); factory.setValidating(false); factory.setIgnoringComments(true); try { final Document doc = factory.newDocumentBuilder().parse(file); for (Node na = doc.getFirstChild(); na != null; na = na.getNextSibling()) { if ("list".equalsIgnoreCase(na.getNodeName())) { for (Node nb = na.getFirstChild(); nb != null; nb = nb.getNextSibling()) { if ("instance".equalsIgnoreCase(nb.getNodeName())) { final NamedNodeMap nab = nb.getAttributes(); final int instanceId = Integer.parseInt(nab.getNamedItem("id").getNodeValue()); if (_managerInstances.containsKey(instanceId)) { throw new Exception("Dublicated instanceId " + instanceId); } final ItemAuctionInstance instance = new ItemAuctionInstance(instanceId, _auctionIds, nb); _managerInstances.put(instanceId, instance); } } } } _log.log(Level.INFO, getClass().getSimpleName() + ": Loaded " + _managerInstances.size() + " instance(s)."); } catch (Exception e) { _log.log(Level.SEVERE, getClass().getSimpleName() + ": Failed loading auctions from xml.", e); } } public final void shutdown() { for (ItemAuctionInstance instance : _managerInstances.values()) { instance.shutdown(); } } public final ItemAuctionInstance getManagerInstance(final int instanceId) { return _managerInstances.get(instanceId); } public final int getNextAuctionId() { return _auctionIds.getAndIncrement(); } public static final void deleteAuction(final int auctionId) { try (Connection con = L2DatabaseFactory.getInstance().getConnection()) { try (PreparedStatement statement = con.prepareStatement("DELETE FROM item_auction WHERE auctionId=?")) { statement.setInt(1, auctionId); statement.execute(); } try (PreparedStatement statement = con.prepareStatement("DELETE FROM item_auction_bid WHERE auctionId=?")) { statement.setInt(1, auctionId); statement.execute(); } } catch (SQLException e) { _log.log(Level.SEVERE, "L2ItemAuctionManagerInstance: Failed deleting auction: " + auctionId, e); } } /** * Gets the single instance of {@code ItemAuctionManager}. * @return single instance of {@code ItemAuctionManager} */ public static final ItemAuctionManager getInstance() { return SingletonHolder._instance; } private static class SingletonHolder { protected static final ItemAuctionManager _instance = new ItemAuctionManager(); } }