From 6fc9c4132a2a4d640e165381ff8ed41c76b1fd9b Mon Sep 17 00:00:00 2001 From: Barbz Date: Mon, 18 May 2020 19:13:14 +0200 Subject: refactor: npc_vendor table html to markdown + extra info - Add info about GM mode that I just discovered - Fix links - Remake html table into markdown for maintanability --- docs/npc_vendor.md | 96 +++++++++++++++--------------------------------------- 1 file changed, 26 insertions(+), 70 deletions(-) (limited to 'docs') diff --git a/docs/npc_vendor.md b/docs/npc_vendor.md index 4721933..abc4048 100644 --- a/docs/npc_vendor.md +++ b/docs/npc_vendor.md @@ -2,78 +2,34 @@ [<-Back-to:World](database-world.md) +**General information** + +This table holds the vendor data for all NPCs that sell items or currencies. + +The price (in gold) for each item or currency is defined in its item template related entry as [BuyPrice](item_template#buyprice). +Special costs (honor, tokens etc...) are defined in this table in the column [ExtendedCost](#extendedcost). + +If you open the vendor's window in GM mode, you will see all the items sold by the vendor. If you disable GM mode, you will see the items sold like a normal player (ex: only for your own faction, only for your own class etc...). + + **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](item_template#item_template-BuyPrice) or as [ExtendedCost](npc_vendor#npc_vendor-ExtendedCost). - - -------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

+| Field | Type | Attributes | Key | Null | Default | +|-------------------|--------------|------------|-----|------|---------| +| [entry][1] | mediumint(8) | unsigned | PRI | NO | 0 | +| [slot][2] | smallint(6) | signed | | NO | 0 | +| [item][3] | mediumint(8) | signed | PRI | NO | 0 | +| [maxcount][4] | tinyint(3) | unsigned | | NO | 0 | +| [incrtime][5] | int(10) | unsigned | | NO | 0 | +| [ExtendedCost][6] | mediumint(8) | unsigned | PRI | NO | 0 | + +[1]: #entry +[2]: #slot +[3]: #item +[4]: #maxcount +[5]: #incrtime +[6]: #extendedcost + **Field Descriptions** -- cgit From 88a197bf09fe2ba4e191ffc45d4cee29b258475c Mon Sep 17 00:00:00 2001 From: Barbz Date: Mon, 18 May 2020 19:17:01 +0200 Subject: Update npc_vendor.md --- docs/npc_vendor.md | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'docs') diff --git a/docs/npc_vendor.md b/docs/npc_vendor.md index abc4048..2480536 100644 --- a/docs/npc_vendor.md +++ b/docs/npc_vendor.md @@ -2,17 +2,17 @@ [<-Back-to:World](database-world.md) -**General information** +## General information This table holds the vendor data for all NPCs that sell items or currencies. -The price (in gold) for each item or currency is defined in its item template related entry as [BuyPrice](item_template#buyprice). +The price (in gold) for each item or currency is defined in its item template related entry as [item_template.BuyPrice](item_template#buyprice). Special costs (honor, tokens etc...) are defined in this table in the column [ExtendedCost](#extendedcost). If you open the vendor's window in GM mode, you will see all the items sold by the vendor. If you disable GM mode, you will see the items sold like a normal player (ex: only for your own faction, only for your own class etc...). -**Table Structure** +## Table Structure | Field | Type | Attributes | Key | Null | Default | |-------------------|--------------|------------|-----|------|---------| @@ -31,11 +31,11 @@ If you open the vendor's window in GM mode, you will see all the items sold by t [6]: #extendedcost -**Field Descriptions** +## Field Descriptions ### entry -The ID of the creature. See [creature\_template.entry](creature_template#creature_template-entry). +The ID of the creature. See [creature\_template.entry](creature_template#entry). ### slot @@ -43,7 +43,7 @@ Position of the item when the vendor window opens. The image below explains how ### item -The item ID. See  [item\_template.entry](item_template#item_template-entry). +The item ID. See  [item\_template.entry](item_template#entry). ### maxcount @@ -51,8 +51,8 @@ The maximum number of items carried by the vendor at any time. If you want the v ### 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](item_template#item_template-BuyCount) . +Combined with [maxcount](#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](item_template#buycount) . ### ExtendedCost -The value here corresponds to the ID in [ItemExtendedCost.dbc](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. +The value here corresponds to the ID in [ItemExtendedCost.dbc](NO_LINK_YET) 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. -- cgit From 222ad5c81c8f21cdb9cb82adaf8a071aee917cb4 Mon Sep 17 00:00:00 2001 From: Barbz Date: Mon, 18 May 2020 19:18:57 +0200 Subject: Update npc_vendor.md --- docs/npc_vendor.md | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'docs') diff --git a/docs/npc_vendor.md b/docs/npc_vendor.md index 2480536..5b48096 100644 --- a/docs/npc_vendor.md +++ b/docs/npc_vendor.md @@ -6,9 +6,13 @@ This table holds the vendor data for all NPCs that sell items or currencies. +### Prices + The price (in gold) for each item or currency is defined in its item template related entry as [item_template.BuyPrice](item_template#buyprice). Special costs (honor, tokens etc...) are defined in this table in the column [ExtendedCost](#extendedcost). +### GM mode + If you open the vendor's window in GM mode, you will see all the items sold by the vendor. If you disable GM mode, you will see the items sold like a normal player (ex: only for your own faction, only for your own class etc...). -- cgit From 2ada73eaa1bd825858665582e6b11836e4f33b6a Mon Sep 17 00:00:00 2001 From: Barbz Date: Mon, 18 May 2020 23:51:12 +0200 Subject: Update npc_vendor.md --- docs/npc_vendor.md | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'docs') diff --git a/docs/npc_vendor.md b/docs/npc_vendor.md index 5b48096..d426565 100644 --- a/docs/npc_vendor.md +++ b/docs/npc_vendor.md @@ -43,7 +43,8 @@ The ID of the creature. See [creature\_template.entry](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... +Position of the item when the vendor window opens. It starts from 0 to x, from top to bottom, and from left to right. +*Note: if you have a list of items at slot 0, and you edit one of them to be at slot 1 or any number, that item will always be at the end because all the other items are in slot 0.* ### item -- cgit