Datenbank 'world'
access_requirement
achievement_criteria_data
achievement_dbc
achievement_reward
achievement_reward_locale
areatrigger_involvedrelation
areatrigger_scripts
areatrigger_tavern
areatrigger_teleport
battleground_template
battlemaster_entry
broadcast_text
broadcast_text_locale
command
conditions
creature
creature_addon
creature_classlevelstats
creature_equip_template
creature_formations
creature_loot_template
creature_model_info
creature_onkill_reputation
creature_questender
creature_questitem
creature_queststarter
creature_summon_groups
creature_template
creature_template_locale
creature_template_addon
creature_text
creature_text_locale
disables
disenchant_loot_template
event_scripts
exploration_basexp
fishing_loot_template
gameobject
gameobject_addon
gameobject_loot_template
gameobject_questender
gameobject_questitem
gameobject_queststarter
gameobject_template
gameobject_template_locale
game_event
game_event_arena_seasons
game_event_battleground_holiday
game_event_condition
game_event_creature
game_event_creature_quest
game_event_gameobject
game_event_gameobject_quest
game_event_model_equip
game_event_npcflag
game_event_npc_vendor
game_event_pool
game_event_prerequisite
game_event_quest_condition
game_event_seasonal_questrelation
game_tele
game_weather
gossip_menu
gossip_menu_option
graveyard_zone
instance_encounters
instance_template
item_enchantment_template
item_loot_template
item_set_names
item_template
lfg_dungeon_rewards
lfg_dungeon_template
linked_respawn
locales_gossip_menu_option
locales_item
locales_item_set_names
locales_npc_text
locales_page_text
locales_points_of_interest
locales_quest
mail_level_reward
mail_loot_template
milling_loot_template
npc_spellclick_spells
npc_text
npc_trainer
npc_vendor
outdoorpvp_template
page_text
pet_levelstats
pet_name_generation
pickpocketing_loot_template
playercreateinfo
playercreateinfo_action
playercreateinfo_item
playercreateinfo_skills
playercreateinfo_spell_custom
player_classlevelstats
player_factionchange_achievement
player_factionchange_items
player_factionchange_quests
player_factionchange_reputations
player_factionchange_spells
player_factionchange_titles
player_levelstats
player_xp_for_level
points_of_interest
pool_creature
pool_gameobject
pool_pool
pool_quest
pool_template
prospecting_loot_template
quest_poi
quest_offer_reward
quest_poi_points
quest_request_items
quest_template
quest_template_addon
reference_loot_template
reputation_reward_rate
reputation_spillover_template
script_waypoint
skill_discovery_template
skill_extra_item_template
skill_fishing_base_level
skill_perfect_item_template
skinning_loot_template
smart_scripts
spelldifficulty_dbc
spell_area
spell_bonus_data
spell_custom_attr
spell_dbc
spell_enchant_proc_data
spell_group
spell_group_stack_rules
spell_learn_spell
spell_linked_spell
spell_loot_template
spell_pet_auras
spell_proc
spell_proc_event
spell_ranks
spell_required
spell_scripts
spell_script_names
spell_target_position
spell_threat
transports
trinity_string
updates
updates_include
vehicle_accessory
vehicle_template_accessory
version
warden_checks
waypoints
waypoint_data
waypoint_scripts
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'world'

Tabelle: 'item_template'

Table Structure

Holds information on every item that exists in the game. All items are created from their template stored in this table.

(See additional information in the ItemPrototype.h file.)

FieldTypeAttributesKeyNullDefaultComment
entrymediumint(8)vorzeichenlosPRInein0

classtinyint(3)vorzeichenlosnein0
subclasstinyint(3)vorzeichenlosnein0
SoundOverrideSubclasstinyint(3)vorzeichenbehaftetnein

-1

namevarchar(255)vorzeichenbehaftetneinNULL
displayidmediumint(8)vorzeichenlosnein0
Qualitytinyint(3)vorzeichenlosnein

0

Flagsbigint(20)vorzeichenbehaftetnein0
FlagsExtraint(10)vorzeichenlosnein0
BuyCounttinyint(3)vorzeichenlosNO

1
BuyPricebigint(20)vorzeichenbehaftetnein0
SellPriceint(10)vorzeichenlosnein0
InventoryTypetinyint(3)vorzeichenlos

NO

0
AllowableClassint(11)vorzeichenbehaftetnein-1
AllowableRaceint(11)vorzeichenbehaftetnein-1
ItemLevelsmallint(5)vorzeichenlos

nein0
RequiredLeveltinyint(3)vorzeichenlosnein0
RequiredSkillsmallint(5)vorzeichenlosnein0
RequiredSkillRanksmallint(5)

vorzeichenlosnein0
requiredspellmediumint(8)vorzeichenlosnein0
requiredhonorrankmediumint(8)vorzeichenlosnein0
RequiredCityRankmediumint(8)vorzeichenlosnein0
RequiredReputationFactionsmallint(5)vorzeichenlosnein0
RequiredReputationRanksmallint(5)vorzeichenlosnein0

maxcountint(11)vorzeichenbehaftetnein0
stackableint(11)vorzeichenbehaftetnein1
ContainerSlotssmallint(5)vorzeichenlosnein0

StatsCounttinyint(3)vorzeichenlosnein0
stat_type1tinyint(3)vorzeichenlosnein0
stat_value1smallint(6)vorzeichenbehaftetnein

0

stat_type2tinyint(3)vorzeichenlosnein0
stat_value2smallint(6)vorzeichenbehaftetnein0
stat_type3tinyint(3)vorzeichenlos

NO

0
stat_value3smallint(6)vorzeichenbehaftetnein0
stat_type4tinyint(3)vorzeichenlosnein0
stat_value4smallint(6)vorzeichenbehaftet

nein0
stat_type5tinyint(3)vorzeichenlosnein0
stat_value5smallint(6)vorzeichenbehaftetnein0
stat_type6tinyint(3)vorzeichenlos

nein0
stat_value6smallint(6)vorzeichenbehaftetnein0
stat_type7tinyint(3)vorzeichenlosnein0
stat_value7smallint(6)

vorzeichenbehaftet

nein0
stat_type8tinyint(3)vorzeichenlosnein0
stat_value8smallint(6)vorzeichenbehaftetnein0
stat_type9tinyint(3)

vorzeichenlosnein0
stat_value9smallint(6)vorzeichenbehaftetnein0
stat_type10tinyint(3)vorzeichenlosnein0
stat_value10

smallint(6)

vorzeichenbehaftetnein0
ScalingStatDistributionsmallint(6)vorzeichenbehaftetnein0
ScalingStatValueint(6)vorzeichenlosnein0
dmg_min1floatvorzeichenbehaftetnein0
dmg_max1floatvorzeichenbehaftetnein0
dmg_type1tinyint(3)vorzeichenlosnein0
dmg_min2floatvorzeichenbehaftetnein0
dmg_max2floatvorzeichenbehaftetnein0
dmg_type2tinyint(3)vorzeichenlosnein0

armor

smallint(5)vorzeichenlosnein0
holy_restinyint(3)vorzeichenlosnein0
fire_restinyint(3)vorzeichenlosnein0

nature_res

tinyint(3)vorzeichenlosnein0
frost_restinyint(3)vorzeichenlosnein0
shadow_restinyint(3)vorzeichenlosnein0

arcane_restinyint(3)vorzeichenlosnein0
delaysmallint(5)vorzeichenlosnein1000
ammo_typetinyint(3)vorzeichenlosnein0

RangedModRangefloatvorzeichenbehaftetnein0
spellid_1mediumint(8)vorzeichenbehaftetnein0
spelltrigger_1tinyint(3)vorzeichenlosnein

0

spellcharges_1smallint(6)vorzeichenbehaftetnein0
spellppmRate_1floatvorzeichenbehaftetnein0
spellcooldown_1int(11)vorzeichenbehaftet

NO

-1
spellcategory_1smallint(5)vorzeichenlosnein0
spellcategorycooldown_1int(11)vorzeichenbehaftetnein-1
spellid_2mediumint(8)vorzeichenbehaftet

nein0
spelltrigger_2tinyint(3)vorzeichenlosnein0
spellcharges_2smallint(6)vorzeichenbehaftetnein0
spellppmRate_2float

vorzeichenbehaftet

nein0
spellcooldown_2int(11)vorzeichenbehaftetnein-1

spellcategory_2smallint(5)vorzeichenlosnein0
spellcategorycooldown_2int(11)vorzeichenbehaftetnein-1
spellid_3mediumint(8)vorzeichenbehaftetnein0
spelltrigger_3tinyint(3)vorzeichenlosnein0
spellcharges_3smallint(6)vorzeichenbehaftetnein0
spellppmRate_3floatvorzeichenbehaftetnein0
spellcooldown_3int(11)vorzeichenbehaftetnein-1
spellcategory_3smallint(5)vorzeichenlosnein0
spellcategorycooldown_3int(11)vorzeichenbehaftetnein-1
spellid_4mediumint(8)vorzeichenbehaftetnein0

spelltrigger_4tinyint(3)vorzeichenlosnein0
spellcharges_4smallint(6)vorzeichenbehaftetnein0
spellppmRate_4floatvorzeichenbehaftetnein0
spellcooldown_4int(11)vorzeichenbehaftetnein-1
spellcategory_4smallint(5)vorzeichenlosnein0
spellcategorycooldown_4int(11)vorzeichenbehaftet

nein-1
spellid_5mediumint(8)vorzeichenbehaftetnein0
spelltrigger_5tinyint(3)vorzeichenlosnein0
spellcharges_5smallint(6)

vorzeichenbehaftet

nein0
spellppmRate_5floatvorzeichenbehaftetnein0
spellcooldown_5int(11)vorzeichenbehaftetnein-1
spellcategory_5

smallint(5)

vorzeichenlosnein0
spellcategorycooldown_5int(11)vorzeichenbehaftetnein-1
bondingtinyint(3)vorzeichenlosnein0
descriptionvarchar(255)vorzeichenbehaftetneinNULL
PageTextmediumint(8)vorzeichenlosnein0
LanguageIDtinyint(3)vorzeichenlosnein0
PageMaterialtinyint(3)vorzeichenlosnein0
startquestmediumint(8)vorzeichenlosnein0
lockidmediumint(8)vorzeichenlosnein0
Materialtinyint(4)vorzeichenbehaftetnein0
sheathtinyint(3)vorzeichenlosnein0
RandomPropertymediumint(8)vorzeichenbehaftetnein0

RandomSuffixmediumint(8)vorzeichenlosnein0
blockmediumint(8)vorzeichenlosnein0
itemsetmediumint(8)vorzeichenlosnein0

MaxDurabilitysmallint(5)vorzeichenlosnein0
areamediumint(8)vorzeichenlosnein0
Mapsmallint(6)vorzeichenbehaftetnein

0

BagFamilymediumint(9)vorzeichenbehaftetnein0
TotemCategorymediumint(9)vorzeichenbehaftetnein0
socketColor_1tinyint(4)vorzeichenbehaftet

NO

0
socketContent_1mediumint(9)vorzeichenbehaftetnein0
socketColor_2tinyint(4)vorzeichenbehaftetnein0
socketContent_2mediumint(9)vorzeichenbehaftet

nein0
socketColor_3tinyint(4)vorzeichenbehaftetnein0
socketContent_3mediumint(9)vorzeichenbehaftetnein0
socketBonusmediumint(9)

vorzeichenbehaftet

nein0
GemPropertiesmediumint(9)vorzeichenbehaftetnein0
RequiredDisenchantSkillsmallint(6)vorzeichenbehaftetnein-1
ArmorDamageModifierfloatvorzeichenbehaftetnein0
durationint(10)vorzeichenlosnein0Duration in seconds
ItemLimitCategorysmallint(6)vorzeichenbehaftetnein0
HolidayIdint(11)vorzeichenlosnein0
ScriptNamevarchar(64)vorzeichenbehaftetneinNULL
DisenchantIDmediumint(8)vorzeichenlosnein0
FoodTypetinyint(3)vorzeichenlosnein0
minMoneyLootint(10)vorzeichenlosnein0
maxMoneyLootint(10)vorzeichenlosnein0

flagsCustomint(10)vorzeichenlosnein0
VerifiedBuild (WDBVerified)smallint(5)vorzeichenbehaftetYES1
Field Descriptions

entry

The unique ID of the item.

class

ID

Name

0Consumable
1Container
2Weapon
3Gem
4Armor
5Reagent
6Projectile
7Trade Goods

8Generic(OBSOLETE)
9Recipe
10Money(OBSOLETE)
11Quiver
12Quest
13Key
14Permanent(OBSOLETE)
15Miscellaneous
16Glyph

subclass

The following table lists all available subclass and class combinations and the subclass name.

Class ID

Subclass ID

Subclass Name

Comments

00ConsumableUsability in combat is decided by the spell asvorzeichenbehaftet.
01Potion
02Elixir
03Flask

04Scroll
05Food & Drink
06Item Enhancement
07Bandage
08Other
10Bag

11Soul Bag
12Herb Bag
13Enchanting Bag
14Engineering Bag
15Gem Bag
16

Mining Bag

17Leatherworking Bag
18Inscription Bag
20AxeOne handed
21AxeTwo handed
22Bow
23

Gun

24MaceOne handed
25MaceTwo handed
26Polearm
27SwordOne handed
28SwordTwo handed
29

Obsolete
210Staff
211Exotic
212Exotic
213Fist Weapon
214Miscellaneous(Blacksmith Hammer, Mining Pick, etc.)

2

15Dagger
216Thrown
217Spear
218Crossbow
219Wand
220Fishing Pole

3

0Red
31Blue
32Yellow
33Purple
34Green
35Orange

3

6Meta
37Simple
38Prismatic
40Miscellaneous
41Cloth
42Leather
43Mail
44Plate
45Buckler(OBSOLETE)
46Shield
47Libram
48Idol

49Totem
410Sigil
50Reagent
60Wand(OBSOLETE)
61Bolt(OBSOLETE)
62Arrow

6

3Bullet
64Thrown(OBSOLETE)
70Trade Goods
71Parts
72Explosives
73Devices

74Jewelcrafting
75Cloth
76Leather
77Metal & Stone
78Meat
79Herb

710Elemental
711Other
712Enchanting
713Materials
714Armor Enchantment
715Weapon Enchantment
8

0

Generic(OBSOLETE)
90Book
91Leatherworking
92Tailoring
93Engineering
94Blacksmithing

9

5Cooking
96Alchemy
97First Aid
98Enchanting
99Fishing
910Jewelcrafting

100Money(OBSOLETE)
110Quiver(OBSOLETE)
111Quiver(OBSOLETE)
112QuiverCan hold arrows
113Ammo PouchCan hold bullets
120

Quest

130Key
131Lockpick
140Permanent
150Junk
151Reagent
152

Pet

153Holiday
154Other
155Mount
161Warrior
162Paladin
163Hunter
16

4

Rogue
165Priest
166Death Knight
167Shaman
168Mage
169Warlock
1611Druid

SoundOverrideSubclass

Weapons have special sounds on impact. This column is used to override these sounds by specifying another subclass.

For example an item with misc subclass can sound like a stave on impact by overriding the subclass here.

name

The name of the item.

displayid

The model ID of the item. Each model has its own icon asvorzeichenbehaftet so this field controls both the model appearance and the icon.

Quality

The quality of the item.

ID

Farbe

Qualität

0GrauEinfach
1WeißNormal
2GrünUngewöhnlich
3BlauSelten
4ViolettEpisch
5OrangeLegendär
6Rot (tatsächlich Gold)Artefakt
7GoldErbstück

Flags

Bitmask field that contains flags that the item has on it. As all other such fields, just add the flags together to combine them. Possible flags are listed below.

Flag

Comments

10x01UNK1
20x02Conjured item
40x04Openable (can be opened by right-click)
80x08Makes green "Heroic" text appear on item
160x010Deprecated Item
320x020Item can not be destroyed, except by using spell (item can be reagent for spell)
640x040UNK2
1280x080No default 30 seconds cooldown when equipped
2560x0100UNK3
5120x0200Wrapper : Item can wrap other items
10240x0400UNK4
20480x0800Item is party loot and can be looted by all
40960x01000Item is refundable
81920x02000Charter (Arena or Guild)
163840x04000UNK5 // comment in code : Only readable items have this (but not all)
327680x08000UNK6
655360x010000UNK7
1310720x020000UNK8
2621440x040000

Item can be prospected

5242880x080000Unique equipped (player can only have one equipped at the same time)
10485760x0100000UNK9
20971520x0200000Item can be used during arena match

4194304

0x0400000Throwable (for tooltip ingame)
83886080x0800000Item can be used in shapeshift forms
167772160x01000000UNK10
335544320x02000000Profession recipes: can only be looted if you meet requirements and don't already know it
671088640x04000000Item cannot be used in arena
1342177280x08000000Bind to Account
2684354560x010000000Spell is cast with triggered flag
5368709120x020000000Millable
10737418240x040000000UNK11
21474836480x080000000Bind on Pickup tradeable

FlagsExtra

Flag

Comments

10x01Horde Only
20x02Alliance Only
40x04When item uses ExtendedCost in npc_vendor, gold is also required
256

0x0100Makes need roll for this item disabled
5120x0200NEED_ROLL_DISABLED
163840x04000HAS_NORMAL_PRICE
1310720x020000BNET_ACCOUNT_BOUND
20971520x0200000CANNOT_BE_TRANSMOG
41943040x0400000CANNOT_TRANSMOG
83886080x0800000CAN_TRANSMOG

BuyCount

The size of the item stack when sold by vendors. Also if a vendor has limited copies of this item available, everytime the vendor list is refreshed (See npc_vendor.incrtime), the number of copies increases by this number.

BuyPrice

The price required to pay to buy this item from a vendor, in copper.

SellPrice

The price that the vendor will pay you for the item when you sell it and if it is possible to be sold, in copper. Put in 0 if the item cannot be sold to a vendor.

InventoryType

In what slot the item can be equipped.

ID

Slot Name

ID

Slot Name

0Non equipable15Ranged (Bows)
1Head

16Back
2Neck17Two-Hand
3Shoulder18Bag
4Shirt19Tabard
5Chest20Robe
6Waist21Main hand
7

Legs

22Off hand
8Feet23Holdable (Tome)
9Wrists24Ammo
10Hands25Thrown
11Finger26Ranged right (Wands, Guns)
12Trinket27Quiver

13Weapon28Relic
14Shield

AllowableClass

Bitmask controlling which classes can use this item. Add ids together to combine class possibilities. Use -1 if all classes can use it.

See the ChrClasses DBC file for the IDs of the classes.

AllowableRace

Bitmask controlling which races can use this item. Add ids together to combine race possibilities. Use -1 for all races.

See the ChrRaces DBC file for the IDs of the races.

ItemLevel

Base item level.

RequiredLevel

The level that a player must be to equip the item.

RequiredSkill

The skill required to use this item. See the SkillLine DBC file for IDs which can be used here.

RequiredSkillRank

The required skill rank the player needs to have to use this item.

requiredspell

The required spell that the player needs to have to use this item.

requiredhonorrank

The honor rank the player needs to have to use this item.

RequiredCityRank

field-no-description|22

RequiredReputationFaction

The faction template ID of the faction that the player has to have a certain ranking with. If this value is 0, the faction of the seller of the item is used.

See the Faction DBC file for the IDs of all of the factions.

RequiredReputationRank

The rank the player has to have with the faction from RequiredReputationFaction.

ID

Rank

0Hated
1Hostile
2

Unfriendly

3Neutral
4Friendly
5Honored
6Revered
7Exalted

maxcount

Maximum number of copies of this item a player can have. Use 0 for infinite.

stackable

The number of copies of this item that can be stacked in the same slot.

ContainerSlots

If the item is a bag, this field controls the number of slots the bag has.

StatsCount

When an item has entries in stat_type, this must be updated to display those entries
(Unknown how this works)

stat_type

The type of stat to modify.

ID

Stat Type

0ITEM_MOD_MANA
1ITEM_MOD_HEALTH
3ITEM_MOD_AGILITY
4ITEM_MOD_STRENGTH
5ITEM_MOD_INTELLECT
6ITEM_MOD_SPIRIT

7

ITEM_MOD_STAMINA
12ITEM_MOD_DEFENSE_SKILL_RATING
13ITEM_MOD_DODGE_RATING
14ITEM_MOD_PARRY_RATING
15ITEM_MOD_BLOCK_RATING
16ITEM_MOD_HIT_MELEE_RATING
17ITEM_MOD_HIT_RANGED_RATING
18ITEM_MOD_HIT_SPELL_RATING
19ITEM_MOD_CRIT_MELEE_RATING
20ITEM_MOD_CRIT_RANGED_RATING
21ITEM_MOD_CRIT_SPELL_RATING
22ITEM_MOD_HIT_TAKEN_MELEE_RATING
23ITEM_MOD_HIT_TAKEN_RANGED_RATING
24ITEM_MOD_HIT_TAKEN_SPELL_RATING
25ITEM_MOD_CRIT_TAKEN_MELEE_RATING
26ITEM_MOD_CRIT_TAKEN_RANGED_RATING
27ITEM_MOD_CRIT_TAKEN_SPELL_RATING
28ITEM_MOD_HASTE_MELEE_RATING

29

ITEM_MOD_HASTE_RANGED_RATING
30ITEM_MOD_HASTE_SPELL_RATING
31ITEM_MOD_HIT_RATING
32ITEM_MOD_CRIT_RATING
33ITEM_MOD_HIT_TAKEN_RATING
34ITEM_MOD_CRIT_TAKEN_RATING
35ITEM_MOD_RESILIENCE_RATING
36ITEM_MOD_HASTE_RATING
37ITEM_MOD_EXPERTISE_RATING

38

ITEM_MOD_ATTACK_POWER
39ITEM_MOD_RANGED_ATTACK_POWER
40ITEM_MOD_FERAL_ATTACK_POWER (not used as of 3.3)
41ITEM_MOD_SPELL_HEALING_DONE
42ITEM_MOD_SPELL_DAMAGE_DONE
43ITEM_MOD_MANA_REGENERATION
44ITEM_MOD_ARMOR_PENETRATION_RATING
45ITEM_MOD_SPELL_POWER
46ITEM_MOD_ HEALTH_REGEN

47

ITEM_MOD_SPELL_PENETRATION
48ITEM_MOD_BLOCK_VALUE

stat_value

The value to change the stat type to.

ScalingStatDistribution

Similar to Static Stats these are the Stats that grow along with the users level (mainly heirloom leveling gear)
use like static stats

ScalingStatValue

Final (level 80) value of the scaling-stat

dmg_min

The minimum damage of the item.

dmg_max

The maximum damage of the item.

dmg_type

The damage type that the item uses.

ID

Damage Type

0Physical
1Holy
2Fire
3Nature
4Frost
5Shadow
6Arcane

armor

The armor value of the item.

holy_res

Holy resistance.

fire_res

Fire resistance.

nature_res

Nature resistance.

frost_res

Frost resistance.

shadow_res

Shadow resistance.

arcane_res

Arcane resistance.

delay

The time in milliseconds between successive hits.

ammo_type

The type of ammunition the item uses. Arrows = 2; Bullets = 3

RangedModRange

RangeModifier for bows/guns/crossbows:

Default range is somewhere between 0.3 and 0.4 yards,

all blizzard ranged weapons have RangedModRange100

spellid

The spell ID of the spell that the item can cast or trigger.

spelltrigger

The type of trigger for the spell.

ID

Trigger Type

0Use
1On Equip
2Chance on Hit
4Soulstone
5Use with no delay
6Learn Spell ID

spellcharges

The number of times that the item can cast the spell. If 0, then infinite charges are possible. If negative, then after the number of charges is depleted, the item is deleted as well. If positive, then the item is not deleted after all the charges are spent.

spellppmRate

The proc per minute rate controlling how often the spell is triggered (if #spelltrigger == 2).

spellcooldown

The cooldown in milliseconds for the specific spell controlling how often the spell can be used. Use -1 to use the default spell cooldown. Note: this is not the "internal cooldown" of procs commonly found on items such as trinkets with "Chance on hit" effects.

spellcategory

The category that the spell is in.

spellcategorycooldown

The cooldown time in milliseconds that is applied to all other spells in the category that the triggered spell is also in. Use -1 to use the default spell cooldown.

bonding

Der Bindungstyp des Gegenstandes. Im Fall einer Bindung bindet der Gegenstand an den Besitzer, aber wenn in Flags 134217728 gesetzt ist, dann an den Account. Das gilt jedoch nicht für Questgegenstände.

ID

Bonding Type

0bindet nie
1bindet beim Aufheben
2bindet beim Anlegen
3bindet bei Benutzung
4Questgegenstand - bindet bei Erhalt
5Questgegenstand - bindet nie

description

The description that appears in orange letters at the bottom of the item tooltip.

PageText

The ID referring to the text that the item will show (if it is a book or a letter, etc). The item will have a magnifying glass cursor in the game and will show the text when right-clicked. See page_text.entry

LanguageID

The language that the item text is written in.

See the Languages DBC file for the IDs of all of the languages.

PageMaterial

The background texture that appears in the page text window.

See the PageTextMaterial DBC file for the IDs of all of the material types.

startquest

The ID of the quest that this item will start if right-clicked. See quest_template.id

lockid

The lock entry ID that this item (which serves as a key) is tied to. This field is used in key-door mechanics.

See the Lock DBC file.

Material

The material that the item is made of. The value here affects the sound that the item makes when moved. Use -1 for consumable items like food, reagents, etc.

ID

Material

Comment
-1ConsumablesFood, reagents, etc...
0Not Defined
1Metal
2Wood
3Liquid
4Jewelry
5Chain
6Plate
7Cloth
8

Leather

sheath

Controls how the item is put away on the character. Press the 'Z' hotkey to sheath and unsheathe your weapons.

ID

Type

Position

1Two Handed WeaponDiagonally across the back pointing downwards.
2StaffDiagonally across the back pointing upwards.
3One HandedOn the left-hand side of the character's waist.

4

ShieldOn the middle of the character's back.
5Enchanter's Rod
6Off handOn the right-hand side of the character's waist.

RandomProperty

The number in this field points to item_enchantment_template.entry and ties in an item's chance at having a random property attached to it when it shows up for the first time. This field and the RandomSuffix field CANNOT both have non-zero values. Either one is filled, or the other. Also, the primary source for the number in this field are WDBs.

RandomSuffix

The number in this field points to item_enchantment_template.entry and ties in an item's chance at having a random suffix attached to it when it shows up for the first time. This field and the RandomProperty field CANNOT both have non-zero values. Either one is filled, or the other. Also, the primary source for the number in this field are WDBs.

block

If the item is a shield, the block chance of the shield.

itemset

The ID of the item set that this item belongs to. To save you some time, you CAN NOT make up new item sets. Item sets are defined in the ItemSet DBC file.

MaxDurability

The maximum durability of this item.

area

The ID of the zone in which this item can be used.

Map

The ID of the map in which this item can be used.

BagFamily

If the item is a bag, this field is a bitmask controlling what types of items can be put in this bag. You can combine different types by adding up the bit numbers.

ID

Bag Family Mask

0None
1Arrows
2Bullets
4Soul Shards
8

Leatherworking Supplies

16Inscription Supplies
32Herbs
64Enchanting Supplies
128Engineering Supplies
256Keys
512Gems
1024Mining Supplies
2048Soulbound Equipment
4096Vanity Pets
8192

Currency Tokens

16384Quest Items

TotemCategory

Corresponds to the ID in the TotemCategory DBC file.

IDName
1Skinning Knife (OLD)
2Earth Totem
3Air Totem
4Fire Totem
5

Water Totem

6Runed Copper Rod
7Runed Silver Rod
8Runed Golden Rod
9Runed Truesilver Rod
10Runed Arcanite Rod
11Mining Pick (OLD)
12Philosopher's Stone
13Blacksmith Hammer (OLD)
14Arclight Spanner
15

Gyromatic Micro-Adjustor
21Master Totem
41Runed Fel Iron Rod
62Runed Adamantite Rod
63Runed Eternium Rod
81Hollow Quill
101Runed Azurite Rod
121Virtuoso Inking Set
141Drums
161Gnomish Army Knife

162

Blacksmith Hammer
165Mining Pick
166Skinning Knife
167Hammer Pick
168Bladed Pickaxe
169Flint and Tinder
189Runed Cobalt Rod
190Runed Titanium Rod

socketColor

The color of the socket that can be placed in this item.

ID

Color

1Meta
2Red
4Yellow
8Blue

socketContent

Amount of Gems of SocketColor1

socketBonus

commonly used socket bonus IDs

ID

Effect

3312+8 Strength
3313+8 Agility

3305

+12 Stamina
3353+8 Intellect
2872+9 Healing
3753+9 Spell Power
3877+16 Attack Power

GemProperties

The value here corresponds to the ID in GemProperties.dbc/

RequiredDisenchantSkill

The required proficiency in disenchanting that the player needs to have to be able to disenchant this item.

ArmorDamageModifier

field-no-description|76

duration

The duration of the item in seconds ingame time.
Set ITEM_FLAGS_CU_DURATION_REAL_TIME in flagsCustom for real time. In that case the item duration will tick even if player is offline.

ItemLimitCategory

field-no-description|78

HolidayId

See the Holidays DBC file for the IDs of all of the holidays.

ScriptName

The name of the script that the item should use. There is no 'internalitemhandler' or 'internalitemhanler' script so trinity will ignore any such values in this field.

DisenchantID

The disenchant loot template ID. See disenchant_loot_template.entry

FoodType

If this item is a food type item, this field defines what type of food it is for hunters who want to feed their pets. It controls in what diet this food item falls in.

NOTE: Raw meat and fish is not the same as regular meat and fish. It seems that the last two types of diets include grey "poor" types of food that players have no use for but some pets seem to be able to eat. Also, those food types appeared in TBC so most likely only TBC pets will have those types of diets.

ID

Type

1Meat
2Fish
3Cheese
4

Bread

5Fungus
6Fruit
7Raw Meat
8Raw Fish

minMoneyLoot

If the item is a container that can contain money, then this field defines the minimum coinage held in this container, in copper.

maxMoneyLoot

If the item is a container that can contain money, then this field defines the maximum coinage held in this container, in copper.

flagsCustom

Flag

Name

Comment

1ITEM_FLAGS_CU_DURATION_REAL_TIMEItem duration will tick even if player is offline
2ITEM_FLAGS_CU_IGNORE_QUEST_STATUSNo quest status will be checked when this item drops
4ITEM_FLAGS_CU_FOLLOW_LOOT_RULESItem will always follow group/master/need before greed looting rules

VerifiedBuild

(WDBVerified) Set by TrinityCore developers.


Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
WoW Portal MPOG TOP WoW Servers NET Private Server
Gametoor Top 100 Arena Top G Top of Games Oxigen Top 100 List
Facebook YouTube
Impressum