Java tutorial
/* * This program 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. * * This program 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 <http://www.gnu.org/licenses/>. */ package com.l2jfree.gameserver.model.entity; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Calendar; import java.util.Map; import javolution.util.FastMap; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import com.l2jfree.L2DatabaseFactory; import com.l2jfree.gameserver.ThreadPoolManager; import com.l2jfree.gameserver.datatables.ClanTable; import com.l2jfree.gameserver.gameobjects.L2Player; import com.l2jfree.gameserver.gameobjects.itemcontainer.PlayerInventory; import com.l2jfree.gameserver.idfactory.IdFactory; import com.l2jfree.gameserver.instancemanager.AuctionManager; import com.l2jfree.gameserver.instancemanager.ClanHallManager; import com.l2jfree.gameserver.model.clan.L2Clan; import com.l2jfree.gameserver.model.world.L2World; import com.l2jfree.gameserver.network.SystemMessageId; public class Auction { protected static Log _log = LogFactory.getLog(Auction.class); private int _id = 0; private long _endDate; private int _highestBidderId = 0; private String _highestBidderName = ""; private int _highestBidderMaxBid = 0; private int _itemId = 0; private String _itemName = ""; private int _itemObjectId = 0; private final int _itemQuantity = 0; private String _itemType = ""; private int _sellerId = 0; private String _sellerClanName = ""; private String _sellerName = ""; private int _currentBid = 0; private int _startingBid = 0; private final Map<Integer, Bidder> _bidders = new FastMap<Integer, Bidder>(); private static final String[] ItemTypeName = { "ClanHall" }; public static enum ItemTypeEnum { ClanHall } public class Bidder { private final String _name; private final String _clanName; private int _bid; private final Calendar _timeBid; public Bidder(String name, String clanName, int bid, long timeBid) { _name = name; _clanName = clanName; _bid = bid; _timeBid = Calendar.getInstance(); _timeBid.setTimeInMillis(timeBid); } public String getName() { return _name; } public String getClanName() { return _clanName; } public int getBid() { return _bid; } public Calendar getTimeBid() { return _timeBid; } public void setTimeBid(long timeBid) { _timeBid.setTimeInMillis(timeBid); } public void setBid(int bid) { _bid = bid; } } /** Task Sheduler for endAuction */ public class AutoEndTask implements Runnable { @Override public void run() { endAuction(); } } /** Constructor */ public Auction(int auctionId) { _id = auctionId; load(); startAutoTask(); } public Auction(int itemId, L2Clan Clan, long delay, int bid, String name) { _id = itemId; _endDate = System.currentTimeMillis() + delay; _itemId = itemId; _itemName = name; _itemType = "ClanHall"; _sellerId = Clan.getLeaderId(); _sellerName = Clan.getLeaderName(); _sellerClanName = Clan.getName(); _startingBid = bid; } /** Load auctions */ private void load() { Connection con = null; try { PreparedStatement statement; ResultSet rs; con = L2DatabaseFactory.getInstance().getConnection(con); statement = con.prepareStatement("SELECT * FROM auction WHERE id = ?"); statement.setInt(1, getId()); rs = statement.executeQuery(); while (rs.next()) { _currentBid = rs.getInt("currentBid"); _endDate = rs.getLong("endDate"); _itemId = rs.getInt("itemId"); _itemName = rs.getString("itemName"); _itemObjectId = rs.getInt("itemObjectId"); _itemType = rs.getString("itemType"); _sellerId = rs.getInt("sellerId"); _sellerClanName = rs.getString("sellerClanName"); _sellerName = rs.getString("sellerName"); _startingBid = rs.getInt("startingBid"); } statement.close(); loadBid(); } catch (Exception e) { _log.error("Exception: Auction.load(): ", e); } finally { L2DatabaseFactory.close(con); } } /** Load bidders **/ private void loadBid() { _highestBidderId = 0; _highestBidderName = ""; _highestBidderMaxBid = 0; Connection con = null; try { PreparedStatement statement; ResultSet rs; con = L2DatabaseFactory.getInstance().getConnection(con); statement = con.prepareStatement( "SELECT bidderId, bidderName, maxBid, clan_name, time_bid FROM auction_bid WHERE auctionId = ? ORDER BY maxBid DESC"); statement.setInt(1, getId()); rs = statement.executeQuery(); while (rs.next()) { if (rs.isFirst()) { _highestBidderId = rs.getInt("bidderId"); _highestBidderName = rs.getString("bidderName"); _highestBidderMaxBid = rs.getInt("maxBid"); } _bidders.put(rs.getInt("bidderId"), new Bidder(rs.getString("bidderName"), rs.getString("clan_name"), rs.getInt("maxBid"), rs.getLong("time_bid"))); } statement.close(); } catch (Exception e) { _log.error("Exception: Auction.loadBid(): ", e); } finally { L2DatabaseFactory.close(con); } } /** Task Manage */ private void startAutoTask() { long currentTime = System.currentTimeMillis(); long taskDelay = 0; if (_endDate <= currentTime) { _endDate = currentTime + 7 * 24 * 60 * 60 * 1000; saveAuctionDate(); } else { taskDelay = _endDate - currentTime; } ThreadPoolManager.getInstance().scheduleGeneral(new AutoEndTask(), taskDelay); } public static String getItemTypeName(ItemTypeEnum value) { return ItemTypeName[value.ordinal()]; } /** Save Auction Data End */ private void saveAuctionDate() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement = con.prepareStatement("UPDATE auction SET endDate = ? WHERE id = ?"); statement.setLong(1, _endDate); statement.setInt(2, _id); statement.execute(); statement.close(); } catch (Exception e) { _log.fatal("Exception: saveAuctionDate(): " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** Set a bid */ public synchronized void setBid(L2Player bidder, int bid) { int requiredAdena = bid; if (getHighestBidderName().equals(bidder.getClan().getLeaderName())) requiredAdena = bid - getHighestBidderMaxBid(); if ((getHighestBidderId() > 0 && bid > getHighestBidderMaxBid()) || (getHighestBidderId() == 0 && bid >= getStartingBid())) { if (takeItem(bidder, PlayerInventory.ADENA_ID, requiredAdena)) { updateInDB(bidder, bid); bidder.getClan().setAuctionBiddedAt(_id, true); return; } } if ((bid < getStartingBid()) || (bid <= getHighestBidderMaxBid())) bidder.sendPacket(SystemMessageId.BID_PRICE_MUST_BE_HIGHER); } /** Return Item in WHC * @param Clan * @param itemId * @param quantity * @param penalty */ private void returnItem(String Clan, int itemId, int quantity, boolean penalty) { if (penalty) quantity *= 0.9; //take 10% tax fee if needed ClanTable.getInstance().getClanByName(Clan).getWarehouse().addItem("Outbidded", PlayerInventory.ADENA_ID, quantity, null, null); } /** Take Item in WHC * @param bidder * @param itemId * @param quantity */ private boolean takeItem(L2Player bidder, int itemId, int quantity) { if (bidder.getClan() != null && bidder.getClan().getWarehouse().getAdena() >= quantity) { bidder.getClan().getWarehouse().destroyItemByItemId("Auction", PlayerInventory.ADENA_ID, quantity, bidder, bidder); return true; } bidder.sendPacket(SystemMessageId.NOT_ENOUGH_ADENA_IN_CWH); return false; } /** Update auction in DB */ private void updateInDB(L2Player bidder, int bid) { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement; if (getBidders().get(bidder.getClanId()) != null) { statement = con.prepareStatement( "UPDATE auction_bid SET bidderId=?, bidderName=?, maxBid=?, time_bid=? WHERE auctionId=? AND bidderId=?"); statement.setInt(1, bidder.getClanId()); statement.setString(2, bidder.getClan().getLeaderName()); statement.setInt(3, bid); statement.setLong(4, System.currentTimeMillis()); statement.setInt(5, getId()); statement.setInt(6, bidder.getClanId()); statement.execute(); statement.close(); } else { statement = con.prepareStatement( "INSERT INTO auction_bid (id, auctionId, bidderId, bidderName, maxBid, clan_name, time_bid) VALUES (?, ?, ?, ?, ?, ?, ?)"); statement.setInt(1, IdFactory.getInstance().getNextId()); statement.setInt(2, getId()); statement.setInt(3, bidder.getClanId()); statement.setString(4, bidder.getName()); statement.setInt(5, bid); statement.setString(6, bidder.getClan().getName()); statement.setLong(7, System.currentTimeMillis()); statement.execute(); statement.close(); L2Player highest = L2World.getInstance().getPlayer(_highestBidderName); if (highest != null) highest.sendMessage("You have been out bidded"); } _highestBidderId = bidder.getClanId(); _highestBidderMaxBid = bid; _highestBidderName = bidder.getClan().getLeaderName(); if (_bidders.get(_highestBidderId) == null) { _bidders.put(_highestBidderId, new Bidder(_highestBidderName, bidder.getClan().getName(), bid, System.currentTimeMillis())); } else { _bidders.get(_highestBidderId).setBid(bid); _bidders.get(_highestBidderId).setTimeBid(System.currentTimeMillis()); } bidder.sendPacket(SystemMessageId.BID_IN_CLANHALL_AUCTION); } catch (Exception e) { _log.fatal("Exception: Auction.updateInDB(L2Player bidder, int bid): ", e); } finally { L2DatabaseFactory.close(con); } } /** Remove bids */ private void removeBids() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement; statement = con.prepareStatement("DELETE FROM auction_bid WHERE auctionId=?"); statement.setInt(1, getId()); statement.execute(); statement.close(); } catch (Exception e) { _log.fatal("Exception: Auction.deleteFromDB(): " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } for (Bidder b : _bidders.values()) { if (ClanTable.getInstance().getClanByName(b.getClanName()).getHasHideout() == 0) returnItem(b.getClanName(), PlayerInventory.ADENA_ID, b.getBid(), true); // 10 % tax else { L2Player bidder = L2World.getInstance().getPlayer(b.getName()); if (bidder != null) bidder.sendMessage("Congratulations! You have won a ClanHall!"); } ClanTable.getInstance().getClanByName(b.getClanName()).setAuctionBiddedAt(0, true); } _bidders.clear(); } /** Remove auctions */ public void deleteAuctionFromDB() { AuctionManager.getInstance().getAuctions().remove(this); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement; statement = con.prepareStatement("DELETE FROM auction WHERE itemId=?"); statement.setInt(1, _itemId); statement.execute(); statement.close(); } catch (Exception e) { _log.fatal("Exception: Auction.deleteFromDB(): " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** End of auction */ public void endAuction() { if (ClanHallManager.loaded()) { if (_highestBidderId == 0 && _sellerId == 0) { startAutoTask(); return; } if (_highestBidderId == 0 && _sellerId > 0) { /** If seller haven't sell ClanHall, auction removed, * THIS MUST BE CONFIRMED */ int aucId = AuctionManager.getInstance().getAuctionIndex(_id); AuctionManager.getInstance().getAuctions().remove(aucId); return; } if (_sellerId > 0) { returnItem(_sellerClanName, PlayerInventory.ADENA_ID, _highestBidderMaxBid, true); returnItem(_sellerClanName, PlayerInventory.ADENA_ID, ClanHallManager.getInstance().getClanHallById(_itemId).getLease(), false); } deleteAuctionFromDB(); L2Clan Clan = ClanTable.getInstance().getClanByName(_bidders.get(_highestBidderId).getClanName()); _bidders.remove(_highestBidderId); Clan.setAuctionBiddedAt(0, true); removeBids(); ClanHallManager.getInstance().setOwner(_itemId, Clan); } else { /** Task waiting ClanHallManager is loaded every 3s */ ThreadPoolManager.getInstance().scheduleGeneral(new AutoEndTask(), 3000); } } /** Cancel bid */ public synchronized void cancelBid(int bidder) { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement; statement = con.prepareStatement("DELETE FROM auction_bid WHERE auctionId=? AND bidderId=?"); statement.setInt(1, getId()); statement.setInt(2, bidder); statement.execute(); statement.close(); } catch (Exception e) { _log.fatal("Exception: Auction.cancelBid(String bidder): " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } returnItem(_bidders.get(bidder).getClanName(), PlayerInventory.ADENA_ID, _bidders.get(bidder).getBid(), true); ClanTable.getInstance().getClanByName(_bidders.get(bidder).getClanName()).setAuctionBiddedAt(0, true); _bidders.clear(); loadBid(); } /** Cancel auction */ public void cancelAuction() { deleteAuctionFromDB(); removeBids(); } /** Confirm an auction */ public void confirmAuction() { AuctionManager.getInstance().getAuctions().add(this); Connection con = null; try { PreparedStatement statement; con = L2DatabaseFactory.getInstance().getConnection(con); statement = con.prepareStatement( "INSERT INTO auction (id, sellerId, sellerName, sellerClanName, itemType, itemId, itemObjectId, itemName, itemQuantity, startingBid, currentBid, endDate) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)"); statement.setInt(1, getId()); statement.setInt(2, _sellerId); statement.setString(3, _sellerName); statement.setString(4, _sellerClanName); statement.setString(5, _itemType); statement.setInt(6, _itemId); statement.setInt(7, _itemObjectId); statement.setString(8, _itemName); statement.setInt(9, _itemQuantity); statement.setInt(10, _startingBid); statement.setInt(11, _currentBid); statement.setLong(12, _endDate); statement.execute(); statement.close(); loadBid(); } catch (Exception e) { _log.fatal("Exception: Auction.load(): " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** Get var auction */ public final int getId() { return _id; } public final int getCurrentBid() { return _currentBid; } public final long getEndDate() { return _endDate; } public final int getHighestBidderId() { return _highestBidderId; } public final String getHighestBidderName() { return _highestBidderName; } public final int getHighestBidderMaxBid() { return _highestBidderMaxBid; } public final int getItemId() { return _itemId; } public final String getItemName() { return _itemName; } public final int getItemObjectId() { return _itemObjectId; } public final int getItemQuantity() { return _itemQuantity; } public final String getItemType() { return _itemType; } public final int getSellerId() { return _sellerId; } public final String getSellerName() { return _sellerName; } public final String getSellerClanName() { return _sellerClanName; } public final int getStartingBid() { return _startingBid; } public final Map<Integer, Bidder> getBidders() { return _bidders; } }