Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • auction


    antz
     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 MaNGOSTwo

    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 int(11) 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 int(11) NO '0'   The amount of copper of the last bid made on the item.
    startbid int(11) NO '0'   The amount of copper of the starting bid made on the item.
    deposit int(11) 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 int(11)

    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 int(11)

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

    startbid int(11)

    The amount of copper of the starting bid made on the item.

    deposit int(11)

    The amount of copper spent on the deposit.


    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz


    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use