|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'auction' table for MaNGOSThree
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.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | '0' | Unique identifier for every auction. | |
| houseid | int(11) unsigned | NO | '0' | The AuctionHouseId [See AuctionHouse.dbc] | ||
| itemguid | int(11) unsigned | NO | '0' | The GUID of the item that is up for auction. [See item_instance.guid] | ||
| item_template | int(11) unsigned | NO | '0' | The entry of the item up for auction. See (item_template.entry) | ||
| item_count | int(11) unsigned | NO | '0' | The stack count of the item | ||
| item_randompropertyid | int(11) | NO | '0' | A link to the Item's RandomProperty Id [See item_template.Randompropertyid]. | ||
| itemowner | int(11) unsigned | NO | '0' | The GUID of the owner of the item up for auction. [See character.guid] | ||
| buyoutprice | bigint(40) | NO | '0' | The buyout price of the item in copper. | ||
| time | bigint(40) unsigned | NO | '0' | The time when this auction will end, measured in Unix time. | ||
| moneyTime | bigint(40) unsigned | NO | '0' | |||
| buyguid | int(11) unsigned | NO | '0' | The GUID of the highest bidder. See (character.guid) | ||
| lastbid | bigint(40) | NO | '0' | The amount of copper of the last bid made on the item. | ||
| startbid | bigint(40) | NO | '0' | The amount of copper of the starting bid made on the item. | ||
| deposit | bigint(40) | NO | '0' | The amount of copper spent on the deposit. |
Description of the fields
id int(11) unsigned
Unique identifier for every auction.
houseid int(11) unsigned
The AuctionHouseId [See AuctionHouse.dbc]
itemguid int(11) unsigned
The GUID of the item that is up for auction. [See item_instance.guid]
item_template int(11) unsigned
The entry of the item up for auction. See (item_template.entry)
item_count int(11) unsigned
The stack count of the item
item_randompropertyid int(11)
A link to the Item's RandomProperty Id [See item_template.Randompropertyid].
itemowner int(11) unsigned
The GUID of the owner of the item up for auction. [See character.guid]
buyoutprice bigint(40)
The buyout price of the item in copper. Divide by 100 to get silver and by 100 again to get gold.
time bigint(40) unsigned
The time when this auction will end, measured in Unix time (number of seconds from 00:00 Jan 1, 1970).
moneyTime bigint(40) unsigned
buyguid int(11) unsigned
The GUID of the highest bidder. See (character.guid)
lastbid bigint(40)
The amount of copper of the last bid made on the item.
startbid bigint(40)
The amount of copper of the starting bid made on the item.
deposit bigint(40)
The amount of copper spent on the deposit.
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now