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

Flags

Bitová maska (bitmask). Pole obsahuje příznaky itemu. Kombinování příznaků se provádí sčítáním bitů. Lze přidat jakýkoliv příznak, podle tabulky příslušných bitů:

Bit příznaku	Komentář / popis
1	Soulbound
2	Conjured
4	Lootable (může být otevřen pravým kliknutím)
8	Wrapped
32	Totem
64	Aktivovatelný pravým kliknutím
256	Wrapper
1024	Gifts
2048	Item je "party loot" - může být získán všemi hráči ve stené partě
8192	Charter (Arena or Guild)
32768	Odměna za PvP
524288	Unique equipped (hráč může mít současně nasazen pouze jeden tento item)
4194304	Throwable (for tooltip ingame)
8388608	Special Use (speciální použití?)

(doplnit)