Back to 'npc_text_locale' Return to world Go to 'outdoorpvp_template'
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 ExtendedCost.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| entry | int | unsigned | PRI | NO | 0 | ||
| slot | smallint | signed | MUL | NO | 0 | ||
| item | int | signed | PRI | NO | 0 | ||
| maxcount | tinyint | unsigned | NO | 0 | |||
| incrtime | int | unsigned | NO | 0 | |||
| ExtendedCost | int | unsigned | PRI | NO | 0 | ||
| VerifiedBuild | int | signed | YES | NULL |
This is the entry of the NPC that you wish to create a vendor list for.
Position of the item when the vendor window opens (order from top-left to bottom.right of the window with values 0 and then 1,2,3,etc).
Refers to to the item_template.entry of the item being sold.
The maximum number of copies of the item the vendor has available to be sold before incrtime is up. If 0, then it is an unlimited number of copies.
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 the items BuyCount.
The value here corresponds to an ItemExtendedCost ID 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.
This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.
Back to 'npc_text_locale' Return to world Go to 'outdoorpvp_template'