Back to 'auctionbidders' Return to characters Go to 'banned_addons'
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.
| 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 |
Unique identifier for every auction.
The Auctionhouse where this auction was created. Referes to AuctionHouse ID. Options are :
The item guid of the item that is up for auction.
The character guid of the owner of the item up for auction.
The buyout price of the item in copper. Divide by 100 to get silver and by 100 again to get gold.
The time when the auction will end, measured in Unix time (number of seconds from 00:00 Jan 1, 1970).
The character guid of the highest bidder.
The amount of money in copper of the last bid put on the item.
The amount of money in copper of the starting bid.
The amount of money in copper spent on the deposit.
| 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) |
Back to 'auctionbidders' Return to characters Go to 'banned_addons'