Cheapgamer at 23:38, 4 July 2012

2012-07-04T23:38:18Z

← Older revision		Revision as of 18:38, 4 July 2012
Line 8:		Line 8:
	<big>'''The `npc_vendor` table'''</big>		<big>'''The `npc_vendor` table'''</big>

	This table holds the vendor data for all NPCs that sell items. The price for each item is in its item template as [[~~item_template_tc2~~#BuyPrice\|BuyPrice]] or as [[~~item_template_tc2~~#ExtendedCost\|ExtendedCost]]		This table holds the vendor data for all NPCs that sell items. The price for each item is in its item template as [[item_template_SF#BuyPrice\|BuyPrice]] or as [[item_template_SF#ExtendedCost\|ExtendedCost]]


Line 80:		Line 80:
	<big>'''Description of the fields'''</big>		<big>'''Description of the fields'''</big>
	====entry====		====entry====
	The ID of the creature. See [[~~creature_template_tc2~~#entry\|creature_template.entry]]		The ID of the creature. See [[creature_template_SF#entry\|creature_template.entry]]
	====slot====		====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).		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====		====item====
	The item ID. See [[~~item_template_tc2~~#entry\|item_template.entry]]		The item ID. See [[item_template_SF#entry\|item_template.entry]]
	====maxcount====		====maxcount====
	The maximum number of copies of the item the vendor has available to be sold. If 0, then it is an unlimited number of copies.		The maximum number of copies of the item the vendor has available to be sold. If 0, then it is an unlimited number of copies.
	====incrtime====		====incrtime====
	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_tc2~~#BuyCount\|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_SF#BuyCount\|item_template.BuyCount]]
	====ExtendedCost====		====ExtendedCost====
	The value here corresponds to the ID in [[ItemExtendedCost.~~dbc_tc2~~\|ItemExtendedCost.dbc]] and that ID controls the item's non monetary price, be it honor points, arena points, different types of badges, other items or any combination of the above.		The value here corresponds to the ID in [[ItemExtendedCost.dbc_SF\|ItemExtendedCost.dbc]] and that ID controls the item's non monetary price, be it honor points, arena points, different types of badges, other items or any combination of the above.

Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `npc_vendor` table''' This table holds the vendor data for all..."

2012-07-04T23:33:48Z

Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} <big>'''The `npc_vendor` table'''</big> This table holds the vendor data for all..."

New page

{| align="right"
| __TOC__
|}
[[Category: SkyFire World database tables]]
{{Back-to:World}}

<big>'''The `npc_vendor` table'''</big>

This table holds the vendor data for all NPCs that sell items. The price for each item is in its item template as [[item_template_tc2#BuyPrice|BuyPrice]] or as [[item_template_tc2#ExtendedCost|ExtendedCost]]

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#entry|entry]]
|mediumint(8)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#slot|slot]]
|smallint(6)
|signed
|
|NO
|0
|
|
|-
|[[#item|item]]
|mediumint(8)
|signed
|PRI
|NO
|0
|
|
|-
|[[#maxcount|maxcount]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#incrtime|incrtime]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#ExtendedCost|ExtendedCost]]
|mediumint(8)
|unsigned
|PRI
|NO
|0
|
|
|}

<big>'''Description of the fields'''</big>
====entry====
The ID of the creature. See [[creature_template_tc2#entry|creature_template.entry]]
====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====
The item ID. See [[item_template_tc2#entry|item_template.entry]]
====maxcount====
The maximum number of copies of the item the vendor has available to be sold. If 0, then it is an unlimited number of copies.
====incrtime====
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_tc2#BuyCount|item_template.BuyCount]]
====ExtendedCost====
The value here corresponds to the ID in [[ItemExtendedCost.dbc_tc2|ItemExtendedCost.dbc]] and that ID controls the item's non monetary price, be it honor points, arena points, different types of badges, other items or any combination of the above.

Npc vendor SF - Revision history

Cheapgamer at 23:38, 4 July 2012

Cheapgamer: Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} '''The `npc_vendor` table''' This table holds the vendor data for all..."

Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `npc_vendor` table''' This table holds the vendor data for all..."