auctionhouse

Contains all information about the currently ongoing auctions in the auction houses. It controls what items are put up for auction and who put it up, who is the highest bidder, etc.

This table is used by Trinity while running and not a table that you would usually edit.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
id	int	unsigned	PRI	NO	0
houseid	tinyint	unsigned		NO	7
itemguid	int	unsigned	UNI	NO	0
itemowner	int	unsigned		NO	0
buyoutprice	int	unsigned		NO	0
time	int	unsigned		NO	0
buyguid	int	unsigned		NO	0
lastbid	int	unsigned		NO	0
startbid	int	unsigned		NO	0
deposit	int	unsigned		NO	0
Flags	tinyint	unsigned		NO	0

Description of fields

id

Unique identifier for every auction.  

houseid

The Auctionhouse where this auction was created. Referes to AuctionHouse ID. Options are :

• 2: Alliance Auction House
• 6: Horde Auction House
• 7: Blackwater Auction House  

itemguid

The item guid of the item that is up for auction.  

itemowner

The character guid of the owner of the item up for auction.  

buyoutprice

The buyout price of the item in copper. Divide by 100 to get silver and by 100 again to get gold.  

time

The time when the auction will end, measured in Unix time (number of seconds from 00:00 Jan 1, 1970).  

buyguid

The character guid of the highest bidder.  

lastbid

The amount of money in copper of the last bid put on the item.  

startbid

The amount of money in copper of the starting bid.  

deposit

The amount of money in copper spent on the deposit.  

Flags

Value	Flag	Name	Comment
0	0x0	AUCTION_ENTRY_FLAG_NONE
1	0x1	AUCTION_ENTRY_FLAG_GM_LOG_BUYER	write transaction to gm log file for buyer (optimization flag - avoids querying database for offline player permissions)