De Norganna's AddOns

Contenido 1 Auc-Db.Lua Format 1.1 Scans, sales and bids structure 1.2 Scans section 1.3 Sales section 1.4 Bids section 1.5 Names section

Auc-Db.Lua Format

Note: This information is a bit dated, for the current structure, see http://forums.norganna.org/discussion/11589/aucdb-database-structure-update/#Item_4 .

AucDbData = {
    scans = { ... },
    sales = { ... },
    bids  = { ... },
    names = { ... },
}

Scans, sales and bids structure

The basic structure of these three sections is:

{
    [realm] = {
        [timestamp] = "datastring",
        ...,
    },
    ...,
}

The realm string is a hyphen "-" separated list of server name and faction.

The timestamp is an integer in the time_t format.

It can be converted into a readable time format in a spreadsheet program with this formula

=(((the timestamp here/60)/60)/24)+DATE(1970,1,1)+(-7/24)

(-7/24) is the GMT offset, -7 is mountain standard time (Denver). Edit this accordingly. Then format the cell to show a date

The datastring is a colon ":" separated, semicolon ";" delimited serialized string that contains data for each section as described in the specific sections below.

Scans section

The scans section is a series of data for observed scans.

The datastring provided as per the above basic structure contains the fields:

• itemId
• itemSuffix
• itemEnchant
• itemFactor
• itemSeed
• stackSize
• sellerName
• minBid
• buyoutPrice
• curBid
• timeLeft

Sales section

The sales section is a series of data for observed sales (sales you make as a seller) by watching for "auction sold" messages in the mail.

... more to follow

Bids section

The bids section is a series of data for observed bids (when you make a bid on an item) by watching for bidding at the auction house.

The datastring provided as per the above basic structure contains the fields (same as scans but with 2 additional fields appended):

• itemId
• itemSuffix
• itemEnchant
• itemFactor
• itemSeed
• stackSize
• sellerName
• minBid
• buyoutPrice
• curBid
• timeLeft
• bidType
• bidAmount

Names section

The names section contains the full in-game names for observed items.

It comprises the following structure:

{
    [itemsig] = "itemname",
    ...,
}

The itemsig is a colon ":" separated serialized string containing the following fields:

• itemId
• itemSuffix
• The number zero "0" as a place holder for the itemEnchant (which has no effect on the item name)

The itemname string is simply the name for the item in the current locale, for display purposes.