用户工具

站点工具


数据库:characters数据库:auctionhouse

这是本文档旧的修订版!


auctionhouse 表


<-返回:Characters 数据库

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.

表结构

FieldTypeAttributesKeyNullDefaultextraComment
idINTUNSIGNEDPRINO
gmlevelTINYINTUNSIGNED NO
RealmIDINTSIGNEDPRINO-1
commentVARCHAR(255)SIGNED YES' '

字段说明


id

Unique identifier for every auction.

houseid

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.

数据库/characters数据库/auctionhouse.1695520665.txt.gz · 最后更改: 2023/09/24 09:57 由 admin

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki