Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private ItemAuction loadAuction(int auctionId) throws SQLException
- {
- try (Connection con = DatabaseFactory.getInstance().getConnection())
- {
- PreparedStatement statement = con.prepareStatement("SELECT auctionItemId,startingTime,endingTime,auctionStateId FROM item_auction WHERE auctionId=?");
- statement.setInt(1, auctionId);
- ResultSet rset = statement.executeQuery();
- if (!rset.next())
- {
- _log.warn("ItemAuction: Auction data not found for auction: " + auctionId);
- return null;
- }
- int auctionItemId = rset.getInt(1);
- long startingTime = rset.getLong(2);
- long endingTime = rset.getLong(3);
- int auctionStateId = rset.getInt(4);
- DbUtils.close(statement, rset);
- if (startingTime >= endingTime)
- {
- _log.warn("ItemAuction: Invalid starting/ending paramaters for auction: " + auctionId);
- return null;
- }
- AuctionItem auctionItem = getAuctionItem(auctionItemId);
- if (auctionItem == null)
- {
- _log.warn("ItemAuction: AuctionItem: " + auctionItemId + ", not found for auction: " + auctionId);
- return null;
- }
- ItemAuctionState auctionState = ItemAuctionState.stateForStateId(auctionStateId);
- if (auctionState == null)
- {
- _log.warn("ItemAuction: Invalid auctionStateId: " + auctionStateId + ", for auction: " + auctionId);
- return null;
- }
- ItemAuction auction = new ItemAuction(auctionId, _instanceId, startingTime, endingTime, auctionItem, auctionState);
- statement = con.prepareStatement("SELECT playerObjId,playerBid FROM item_auction_bid WHERE auctionId=?");
- statement.setInt(1, auctionId);
- rset = statement.executeQuery();
- while (rset.next())
- {
- int charId = rset.getInt(1);
- long playerBid = rset.getLong(2);
- ItemAuctionBid bid = new ItemAuctionBid(charId, playerBid);
- auction.addBid(bid);
- }
- return auction;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement