AzerothCore
Posts (Latest 10 updated) :
Read all

auctionhouse

<-Back-to:Characters

The `auctionhouse` table

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(10)

unsigned

PRI

NO

0

 

 

auctioneerguid

int(10)

unsigned

 

NO

0

 

 

itemguid

int(10)

unsigned

UNI

NO

0

 

 

itemowner

int(10)

unsigned

 

NO

0

 

 

buyoutprice

int(10)

unsigned

 

NO

0

 

 

time

int(10)

unsigned

 

NO

0

 

 

buyguid

int(10)

unsigned

 

NO

0

 

 

lastbid

int(10)

unsigned

 

NO

0

 

 

startbid

int(10)

unsigned

 

NO

0

 

 

deposit

int(10)

unsigned

 

NO

0

 

 

Description of the fields

id

Unique identifier for every auction.

auctioneerguid

The GUID of the creature where the auction item was added. See creature.guid

itemguid

The GUID of the item that is up for auction. See item_instance.guid

itemowner

The GUID of the owner of the item up for auction. See characters.guid

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 GUID of the highest bidder. See characters.guid

lastbid

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

startbid

The amount of copper of the starting bid.

deposit

The amount of copper spent on the deposit.