diff options
Diffstat (limited to 'docs/game_event_npc_vendor.md')
| -rw-r--r-- | docs/game_event_npc_vendor.md | 145 |
1 files changed, 134 insertions, 11 deletions
diff --git a/docs/game_event_npc_vendor.md b/docs/game_event_npc_vendor.md index d7c1b54..fad519c 100644 --- a/docs/game_event_npc_vendor.md +++ b/docs/game_event_npc_vendor.md @@ -1,11 +1,134 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [game_event_npc_vendor](game_event_npc_vendor) - -Column | Type | Description ---- | --- | --- -EventEntry | tinyint(4) | -Guid | mediumint(8) unsigned | -Slot | smallint(6) | -Item | mediumint(8) unsigned | -Maxcount | mediumint(8) unsigned | -Incrtime | mediumint(8) unsigned | -ExtendedCost | mediumint(8) unsigned | +# game\_event\_npc\_vendor + +`Back-to:World` + +**The \`game\_event\_npc\_vendor\` table** + +This table allows you to change the items a vendor sells, or to create a [vendor list](npc_vendor) for an NPC who does not sell items unless an event is active. + +**Structure** + +<table> +<colgroup> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +</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> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#game_event_npc_vendor-eventEntry">eventEntry</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#game_event_npc_vendor-guid">guid</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> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#game_event_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> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#game_event_npc_vendor-item">item</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> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#game_event_npc_vendor-maxcount">maxcount</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#game_event_npc_vendor-incrtime">incrtime</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#game_event_npc_vendor-ExtendedCost">ExtendedCost</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +</tbody> +</table> + +**Description of the fields** + +### eventEntry + +This is the eventEntry from the game\_event table that you wish to setup a vendor list for while the event is running. + +### guid + +This is the guid of the NPC that you wish to create a vendor list for. + +### slot + +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). + +### item + +This is an item from the item\_template table. + +### maxcount + +The maximum number of copies of the item the vendor has available to be sold before [incrtime](#game_event_npc_vendor-incrtime) is up. If 0, then it is an unlimited number of copies. + +### incrtime + +Combined with [maxcount](#game_event_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 + +### 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. |
