Mangos world item template

Zpět na seznam tabulek world databáze.

Tabulka `item_template`

Uchovává informace o každém itemu, který existuje ve hře. Všechny itemy jsou vytvářeny podle jejich šablon uložených v této tabulce.

Struktura

Pole	Typ	Null	Key	Výchozí hodnota	Extra
entry	int(10) unsigned	NE	PRI	0
class	tinyint(3) unsigned	NE		0
subclass	tinyint(3) unsigned	NE		0
unk0	int(10)	NE		-1
name	varchar(255)	NE	MUL
displayid	int(10) unsigned	NE		0
Quality	tinyint(3) unsigned	NE		0
Flags	int(10) unsigned	NE		0
BuyCount	tinyint(3) unsigned	NE		1
BuyPrice	int(10) unsigned	NE		0
SellPrice	int(10) unsigned	NE		0
InventoryType	tinyint(3) unsigned	NE		0
AllowableClass	mediumint(9)	NE		-1
AllowableRace	mediumint(9)	NE		-1
ItemLevel	int(11) unsigned	NE		0
RequiredLevel	tinyint(3) unsigned	NE		0
RequiredSkill	int(10) unsigned	NE		0
RequiredSkillRank	int(10) unsigned	NE		0
requiredspell	int(10) unsigned	NE		0
requiredhonorrank	int(10) unsigned	NE		0
RequiredCityRank	int(10) unsigned	NE		0
RequiredReputationFaction	int(10) unsigned	NE		0
RequiredReputationRank	int(10) unsigned	NE		0
maxcount	smallint(5) unsigned	NE		0
stackable	smallint(5) unsigned	NE		0
ContainerSlots	tinyint(3) unsigned	NE		0
StatsCount	tinyint(3) unsigned	NE		0
stat_type1	tinyint(3) unsigned	NE		0
stat_value1	smallint(6)	NE		0
stat_type2	tinyint(3) unsigned	NE		0
stat_value2	smallint(6)	NE		0
stat_type3	tinyint(3) unsigned	NE		0
stat_value3	smallint(6)	NE		0
stat_type4	tinyint(3) unsigned	NE		0
stat_value4	smallint(6)	NE		0
stat_type5	tinyint(3) unsigned	NE		0
stat_value5	smallint(6)	NE		0
stat_type6	tinyint(3) unsigned	NE		0
stat_value6	smallint(6)	NE		0
stat_type7	tinyint(3) unsigned	NE		0
stat_value7	smallint(6)	NE		0
stat_type8	tinyint(3) unsigned	NE		0
stat_value8	smallint(6)	NE		0
stat_type9	tinyint(3) unsigned	NE		0
stat_value9	smallint(6)	NE		0
stat_type10	tinyint(3) unsigned	NE		0
stat_value10	smallint(6)	NE		0
ScalingStatDistribution	smallint(6)	NE		0
ScalingStatValue	smallint(6)	NE		0
dmg_min1	float	NE		0
dmg_max1	float	NE		0
dmg_type1	tinyint(3) unsigned	NE		0
dmg_min2	float	NE		0
dmg_max2	float	NE		0
dmg_type2	tinyint(3) unsigned	NE		0
dmg_min3	float	NE		0
dmg_max3	float	NE		0
dmg_type3	tinyint(3) unsigned	NE		0
dmg_min4	float	NE		0
dmg_max4	float	NE		0
dmg_type4	tinyint(3) unsigned	NE		0
dmg_min5	float	NE		0
dmg_max5	float	NE		0
dmg_type5	tinyint(3) unsigned	NE		0
armor	int(10) unsigned	NE		0
holy_res	int(10) unsigned	NE		0
fire_res	int(10) unsigned	NE		0
nature_res	int(10) unsigned	NE		0
frost_res	int(10) unsigned	NE		0
shadow_res	int(10) unsigned	NE		0
arcane_res	int(10) unsigned	NE		0
delay	int(10) unsigned	NE		1000
ammo_type	int(10) unsigned	NE		0
RangedModRange	float	NE		0
spellid_1	int(10) unsigned	NE		0
spelltrigger_1	int(10) unsigned	NE		0
spellcharges_1	int(11)	NE		0
spellppmRate_1	float	NE		0
spellcooldown_1	int(11)	NE		-1
spellcategory_1	int(10) unsigned	NE		0
spellcategorycooldown_1	int(11)	NE		-1
spellid_2	int(10) unsigned	NE		0
spelltrigger_2	int(10) unsigned	NE		0
spellcharges_2	int(11)	NE		0
spellppmRate_2	float	NE		0
spellcooldown_2	int(11)	NE		-1
spellcategory_2	int(10) unsigned	NE		0
spellcategorycooldown_2	int(11)	NE		-1
spellid_3	int(10) unsigned	NE		0
spelltrigger_3	int(10) unsigned	NE		0
spellcharges_3	int(11)	NE		0
spellppmRate_3	float	NE		0
spellcooldown_3	int(11)	NE		-1
spellcategory_3	int(10) unsigned	NE		0
spellcategorycooldown_3	int(11)	NE		-1
spellid_4	int(10) unsigned	NE		0
spelltrigger_4	int(10) unsigned	NE		0
spellcharges_4	int(11)	NE		0
spellppmRate_4	float	NE		0
spellcooldown_4	int(11)	NE		-1
spellcategory_4	int(10) unsigned	NE		0
spellcategorycooldown_4	int(11)	NE		-1
spellid_5	int(10) unsigned	NE		0
spelltrigger_5	int(10) unsigned	NE		0
spellcharges_5	int(11)	NE		0
spellppmRate_5	float	NE		0
spellcooldown_5	int(11)	NE		-1
spellcategory_5	int(10) unsigned	NE		0
spellcategorycooldown_5	int(11)	NE		-1
bonding	tinyint(3) unsigned	NE		0
description	varchar(255)	NE
PageText	int(10) unsigned	NE		0
LanguageID	int(10) unsigned	NE		0
PageMaterial	int(10) unsigned	NE		0
startquest	int(10) unsigned	NE		0
lockid	int(10) unsigned	NE		0
Material	int(11)	NE		0
sheath	int(10) unsigned	NE		0
RandomProperty	int(10) unsigned	NE		0
RandomSuffix	int(10) unsigned	NE		0
block	int(10) unsigned	NE		0
itemset	int(10) unsigned	NE		0
MaxDurability	int(10) unsigned	NE		0
area	int(10) unsigned	NE		0
Map	int(10)	NE		0
BagFamily	int(10)	NE		0
TotemCategory	int(10)	NE		0
socketColor_1	int(10)	NE		0
socketContent_1	int(10)	NE		0
socketColor_2	int(10)	NE		0
socketContent_2	int(10)	NE		0
socketColor_3	int(10)	NE		0
socketContent_3	int(10)	NE		0
socketBonus	int(10)	NE		0
GemProperties	int(10)	NE		0
RequiredDisenchantSkill	int(10)	NE		-1
ArmorDamageModifier	float	NE		0
Duration	int(11)	NE		0
ItemLimitCategory	smallint(6)	NE		0
ScriptName	varchar(100)	NE
DisenchantID	int(10) unsigned	NE		0
FoodType	tinyint(3) unsigned	NE		0
minMoneyLoot	int(11) unsigned	NE		0
maxMoneyLoot	int(11) unsigned	NE		0

Popis polí tabulky

entry

Unikátní ID itemu.

class

Třída itemu:

ID	Jméno
0	Consumable
1	Container
2	Weapon
3	Gem
4	Armor
5	Reagent
6	Projectile
7	Trade Goods
8	Generic(OBSOLETE)
9	Recipe
10	Money(OBSOLETE)
11	Quiver
12	Quest
13	Key
14	Permanent(OBSOLETE)
15	Miscellaneous

subclass

Podtřída itemu. V následující tabulce jsou uvedeny všechny dostupné kombinace tříd s podtřídami, včetně jejich názvů.

Class ID	Subclass ID	Název pro Subclass	Komentář / popis
0	0	Consumable	Usability in combat is decided by the spell assigned.
0	1	Potion
0	2	Elixir
0	3	Flask
0	4	Scroll
0	5	Food & Drink
0	6	Item Enhancement
0	7	Bandage
0	8	Other
1	0	Bag
1	1	Soul Bag
1	2	Herb Bag
1	3	Enchanting Bag
1	4	Engineering Bag
1	5	Gem Bag
1	6	Mining Bag
1	7	Leatherworking Bag
2	0	Axe	One handed
2	1	Axe	Two handed
2	2	Bow
2	3	Gun
2	4	Mace	One handed
2	5	Mace	Two handed
2	6	Polearm
2	7	Sword	One handed
2	8	Sword	Two handed
2	9	Obsolete
2	10	Staff
2	11	Exotic
2	12	Exotic
2	13	Fist Weapon
2	14	Miscellaneous	(Blacksmith Hammer, Mining Pick, etc.)
2	15	Dagger
2	16	Thrown
2	17	Spear
2	18	Crossbow
2	19	Wand
2	20	Fishing Pole
3	0	Red
3	1	Blue
3	2	Yellow
3	3	Purple
3	4	Green
3	5	Orange
3	6	Meta
3	7	Simple
3	8	Prismatic
4	0	Miscellaneous
4	1	Cloth
4	2	Leather
4	3	Mail
4	4	Plate
4	5	Buckler(OBSOLETE)
4	6	Shield
4	7	Libram
4	8	Idol
4	9	Totem
5	0	Reagent
6	0	Wand(OBSOLETE)
6	1	Bolt(OBSOLETE)
6	2	Arrow
6	3	Bullet
6	4	Thrown(OBSOLETE)
7	0	Trade Goods
7	1	Parts
7	2	Explosives
7	3	Devices
7	4	Jewelcrafting
7	5	Cloth
7	6	Leather
7	7	Metal & Stone
7	8	Meat
7	9	Herb
7	10	Elemental
7	11	Other
7	12	Enchanting
8	0	Generic(OBSOLETE)
9	0	Book
9	1	Leatherworking
9	2	Tailoring
9	3	Engineering
9	4	Blacksmithing
9	5	Cooking
9	6	Alchemy
9	7	First Aid
9	8	Enchanting
9	9	Fishing
9	10	Jewelcrafting
10	0	Money(OBSOLETE)
11	0	Quiver(OBSOLETE)
11	1	Quiver(OBSOLETE)
11	2	Quiver	Can hold arrows
11	3	Ammo Pouch	Can hold bullets
12	0	Quest
13	0	Key
13	1	Lockpick
14	0	Permanent
15	0	Junk
15	1	Reagent
15	2	Pet
15	3	Holiday
15	4	Other
15	5	Mount

name

Jméno itemu, které bude zobrazeno.

displayid

Model ID itemu. Toto pole řídí model vzhledu a ikonu itemu (každý model itemu má přidělenou vlastní ikonu).

Quality

Kvalita itemu:

ID	Barva	Kvalita
0	Grey	Poor
1	White	Common
2	Green	Uncommon
3	Blue	Rare
4	Purple	Epic
5	Orange	Legendary
6	Red	Artifact

(doplnit)