npc_vendor

Back-to:World

Table Structure

This table holds the vendor data for all NPCs that sell items and currency. The price for each item or currency is in its item template as BuyPrice or as ExtendedCost.

3.3.5 version

Field

Type

Attributes

Key

Null

Default

entry

mediumint(8)

unsigned

PRI

NO

0

slot

smallint(6)

signed


NO

0

item

mediumint(8)

signed

PRI

NO

0

maxcount

tinyint(3)

unsigned


NO

0

incrtime

int(10)

unsigned


NO

0

ExtendedCost

mediumint(8)

unsigned

PRI

NO

0

6.x.x version

FieldTypeAttributesKeyNullDefault
entry

mediumint(8)

unsigned

PRI

NO

0

slot

smallint(6)

signed

MUL

NO

0

item

mediumint(8)

signed

PRI

NO

0

maxcount

mediumint(8)

unsigned


NO

0

incrtime

int(10)

unsigned


NO

0

ExtendedCost

mediumint(8)

unsigned

PRI

NO

0

typetinyint(3)unsignedPRINO1
PlayerConditionIDint(10)unsigned
NO0
IgnoreFilteringtinyint(3)unsigned
NO0
VerifiedBuildsmallint(5)signed
YES0



Field Descriptions

entry

The ID of the creature. See creature_template.entry.

slot

Position of the item when the vendor window opens.

item

The item ID. See  item_template.entry.

maxcount

The maximum number of items carried by the vendor at any time.

0 = Infinite

incrtime

Combined with maxcount, this field tells how often (in seconds) the vendor list is refreshed and the limited item copies are restocked. For limited item copies, every refresh, the quantity is increased by item_template.BuyCount .

ExtendedCost

The value here corresponds to the ID in ItemExtendedCost.dbc and that ID controls the item's non monetary price, be it honor points, arena points, different types of badges or any combination of the above.