Mangos world item template: Porovnání verzí
Z WoWResource Wiki
(založení / ToDo: doplnit!) |
m (barvy kvalit) |
||
Řádek 565: | Řádek 565: | ||
!ID !!Barva !!Kvalita | !ID !!Barva !!Kvalita | ||
|- | |- | ||
− | |0 ||Grey ||Poor | + | |0 ||style="color:grey" |'''Grey''' ||Poor |
|- | |- | ||
− | |1 ||White ||Common | + | |1 ||bgcolor="black" style="color:white" |'''White''' ||Common |
|- | |- | ||
− | |2 ||Green ||Uncommon | + | |2 ||style="color:green" |'''Green''' ||Uncommon |
|- | |- | ||
− | |3 ||Blue ||Rare | + | |3 ||style="color:blue" |'''Blue''' ||Rare |
|- | |- | ||
− | |4 ||Purple ||Epic | + | |4 ||style="color:purple" |'''Purple''' ||Epic |
|- | |- | ||
− | |5 ||Orange ||Legendary | + | |5 ||style="color:orange" |'''Orange''' ||Legendary |
|- | |- | ||
− | |6 ||Red ||Artifact | + | |6 ||style="color:red" |'''Red''' ||Artifact |
|} | |} | ||
''(doplnit)'' | ''(doplnit)'' |
Verze z 18. 10. 2010, 06:57
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 | ||
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 |
unk0
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)