diff options
Diffstat (limited to 'docs/npc_vendor.md')
| -rw-r--r-- | docs/npc_vendor.md | 137 |
1 files changed, 127 insertions, 10 deletions
diff --git a/docs/npc_vendor.md b/docs/npc_vendor.md index b2160c9..86a57b9 100644 --- a/docs/npc_vendor.md +++ b/docs/npc_vendor.md @@ -1,10 +1,127 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [npc_vendor](npc_vendor) - -Column | Type | Description ---- | --- | --- -Entry | mediumint(8) unsigned | -Slot | smallint(6) | -Item | mediumint(8) | -Maxcount | tinyint(3) unsigned | -Incrtime | int(10) unsigned | -ExtendedCost | mediumint(8) unsigned | +# 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](http://collab.kpsn.org/display/tc/item_template#item_template-BuyPrice) or as [ExtendedCost](http://collab.kpsn.org/display/tc/npc_vendor#npc_vendor-ExtendedCost). + +## 3.3.5 version + +<table style="width:100%;"> +<colgroup> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_vendor-entry">entry</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_vendor-slot">slot</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_vendor-item">item</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>signed</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_vendor-maxcount">maxcount</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_vendor-incrtime">incrtime</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_vendor-ExtendedCost">ExtendedCost</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +</tbody> +</table> + +## 6.x.x version + +| Field | Type | Attributes | Key | Null | Default | +|----------------------------------------------------|--------------|------------|-----|------|---------| +| [entry](#npc_vendor-entry) | mediumint(8) | unsigned | PRI | NO | 0 | +| [slot](#npc_vendor-slot) | smallint(6) | signed | MUL | NO | 0 | +| [item](#npc_vendor-item) | mediumint(8) | signed | PRI | NO | 0 | +| [maxcount](#npc_vendor-maxcount) | mediumint(8) | unsigned | | NO | 0 | +| [incrtime](#npc_vendor-incrtime) | int(10) | unsigned | | NO | 0 | +| [ExtendedCost](#npc_vendor-ExtendedCost) | mediumint(8) | unsigned | PRI | NO | 0 | +| [type](#npc_vendor-type) | tinyint(3) | unsigned | PRI | NO | 1 | +| [PlayerConditionID](#npc_vendor-PlayerConditionID) | int(10) | unsigned | | NO | 0 | +| [IgnoreFiltering](#npc_vendor-IgnoreFiltering) | tinyint(3) | unsigned | | NO | 0 | +| [VerifiedBuild](#npc_vendor-VerifiedBuild) | smallint(5) | signed | | YES | 0 | + + + + + +**Field Descriptions** + +### entry + +The ID of the creature. See [creature\_template.entry](http://collab.kpsn.org/display/tc/creature_template#creature_template-entry). + +### slot + +Position of the item when the vendor window opens. The image below explains how the vendor-inventory slots are numbered. To continue on past the first page just use numbers 10, 11, 12, etc... + +{height="250"} + +### item + +The item ID. See [item\_template.entry](http://collab.kpsn.org/display/tc/item_template#item_template-entry). + +### maxcount + +The maximum number of items carried by the vendor at any time. If you want the vendor to carry an unlimited number of the item then set this to **0** else set it to any positive number. In the image below the maxcount value is circled. + +{height="250"} + +### incrtime + +Combined with [maxcount](#npc_vendor-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](http://collab.kpsn.org/display/tc/item_template#item_template-BuyCount) . + +### ExtendedCost + +The value here corresponds to the ID in [ItemExtendedCost.dbc](http://collab.kpsn.org/display/tc/ItemExtendedCost) 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. |