npc_vendor
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 |
mediumint(8) | unsigned | PRI | NO | 0 | |
smallint(6) | signed |
| NO | 0 | |
mediumint(8) | signed | PRI | NO | 0 | |
tinyint(3) | unsigned |
| NO | 0 | |
int(10) | unsigned |
| NO | 0 | |
mediumint(8) | unsigned | PRI | NO | 0 |
6.x.x version
Field | Type | Attributes | Key | Null | Default |
|---|---|---|---|---|---|
mediumint(8) | unsigned | PRI | NO | 0 | |
smallint(6) | signed | MUL | NO | 0 | |
mediumint(8) | signed | PRI | NO | 0 | |
mediumint(8) | unsigned |
| NO | 0 | |
int(10) | unsigned |
| NO | 0 | |
mediumint(8) | unsigned | PRI | NO | 0 | |
tinyint(3) | unsigned | PRI | NO | 1 | |
int(10) | unsigned |
| NO | 0 | |
tinyint(3) | unsigned |
| NO | 0 | |
smallint(5) | signed |
| YES | 0 |
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.