Items

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
(entry)
m (Description)
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{LanguageLinks|Items|EN}}
 +
 +
{{NeedUpdate}}
 +
 
=== Description ===
 
=== Description ===
  
 
This table stores items.
 
This table stores items.
  
 +
{{Note|The max. value of the entry seem to be limited. The limit is 200000. ;-)}}
  
 
{{TocRight}}
 
{{TocRight}}
Line 8: Line 13:
 
[[Category:World Database]]
 
[[Category:World Database]]
 
[[Category:Database]]
 
[[Category:Database]]
 
  
 
=Row Breakdown=
 
=Row Breakdown=
Line 14: Line 18:
  
 
=== Field Description ===
 
=== Field Description ===
 +
  
 
===entry===
 
===entry===
 +
Item unique entry
  
  Item unique entry
 
 
 
 
 
===class and subclass===
 
===class and subclass===
 
   0 => Consumables
 
   0 => Consumables
Line 105: Line 108:
 
  16 => Glyphs
 
  16 => Glyphs
  
===name1===
 
  
  Name of the item to be displayed.
+
=== field4 ===
 +
 
 +
 
 +
=== name1 ===
 +
Name of the item to be displayed.
  
  
Line 115: Line 121:
  
  
===Quality===
+
=== quality ===
  
 
   0 = <span style="color:#9d9d9d">Poor</span>
 
   0 = <span style="color:#9d9d9d">Poor</span>
Line 127: Line 133:
  
  
===Flags===
+
=== flags ===
 +
<pre>
 +
ITEM_FLAG_SOULBOUND        = 0x1,      // not used in proto
 +
ITEM_FLAG_CONJURED        = 0x2,
 +
ITEM_FLAG_LOOTABLE        = 0x4,
 +
ITEM_FLAG_WRAPPED          = 0x8,      // not used in proto
 +
ITEM_FLAG_BROKEN          = 0x10,    // many equipable items and bags
 +
ITEM_FLAG_INDESTRUCTIBLE  = 0x20,    // can't destruct this item
 +
ITEM_FLAG_UNKNOWN_07      = 0x40,    // many consumables
 +
ITEM_FLAG_UNKNOWN_08      = 0x80,    // only 1 wand uses this
 +
ITEM_FLAG_UNKNOWN_09      = 0x100,    // some wands & relics
 +
ITEM_FLAG_WRAP_GIFT        = 0x200,
 +
ITEM_FLAG_CREATE_ITEM      = 0x400,    // probably worng
 +
ITEM_FLAG_FREE_FOR_ALL    = 0x800,    // can be looted ffa
 +
ITEM_FLAG_REFUNDABLE      = 0x1000,
 +
ITEM_FLAG_SIGNABLE        = 0x2000,  // charts
 +
ITEM_FLAG_READABLE        = 0x4000,  // may be worng
 +
ITEM_FLAG_UNKNOWN_16      = 0x8000,
 +
ITEM_FLAG_EVENT_REQ        = 0x10000,  // may be wrong
 +
ITEM_FLAG_UNKNOWN_18      = 0x20000,
 +
ITEM_FLAG_PROSPECTABLE    = 0x40000,
 +
ITEM_FLAG_UNIQUE_EQUIP    = 0x80000,
 +
ITEM_FLAG_UNKNOWN_21      = 0x100000, // not used in proto
 +
ITEM_FLAG_USEABLE_IN_ARENA = 0x200000, // useable in arenas
 +
ITEM_FLAG_THROWN          = 0x400000,
 +
ITEM_FLAG_SHAPESHIFT_OK    = 0x800000,
 +
ITEM_FLAG_UNKNOWN_25      = 0x1000000,
 +
ITEM_FLAG_UNKNOWN_26      = 0x2000000,
 +
ITEM_FLAG_UNKNOWN_27      = 0x4000000,
 +
ITEM_FLAG_ACCOUNTBOUND    = 0x8000000,
 +
ITEM_FLAG_UNKNOWN_29      = 0x10000000,
 +
ITEM_FLAG_MILLABLE        = 0x20000000,
 +
ITEM_FLAG_UNKNOWN_31      = 0x40000000,
 +
ITEM_FLAG_UNKNOWN_32      = 0x80000000
 +
</pre>
  
 +
=== flags2 ===
 +
<pre>
 +
ITEM_FLAG2_HORDE_ONLY = 0x00001,
 +
ITEM_FLAG2_ALLIANCE_ONLY = 0x00002,
 +
ITEM_FLAG2_EXT_COST_REQUIRES_GOLD = 0x00004,
 +
ITEM_FLAG2_NEED_ROLL_DISABLED = 0x00100,
 +
</pre>
  
 
===buyprice===
 
===buyprice===
 
+
Price cost if bought from a vendor (in coppper)
  Price cost if bought from a vendor (in coppper)
+
  
  
 
===sellprice===
 
===sellprice===
 
+
Price cost if sold to a vendor (in coppper)
  Price cost if sold to a vendor (in coppper)
+
  
  
Line 183: Line 228:
 
  1024 = Druid
 
  1024 = Druid
 
   128 = Mage
 
   128 = Mage
 +
 +
If you want to apply to two (2) classes, add the values.
 +
For Example,  32 + 1024 = 1056 is Deathknight and Druid.
  
 
===allowablerace===
 
===allowablerace===
Line 191: Line 239:
  
 
===itemlevel===
 
===itemlevel===
 
+
The level value of the item.
  The level value of the item.
+
  
  
 
===requiredlevel===
 
===requiredlevel===
 
+
Level required to use the item.
  Level required to use the item.
+
  
  
 
===RequiredSkill===
 
===RequiredSkill===
 
+
ID of the skill required
  ID of the skill required
+
  
 
   Blacksmithing  = 164
 
   Blacksmithing  = 164
Line 210: Line 255:
 
     Fishing      = 356
 
     Fishing      = 356
 
   Jewlcrafting    = 755
 
   Jewlcrafting    = 755
 
 
===RequiredSkillRank===
 
===RequiredSkillRank===
 
+
How high your skill in RequiredSkill must be (used for professions)
  How high your skill in RequiredSkill must be (used for professions)
+
  
  
 
===RequiredSkillSubRank===
 
===RequiredSkillSubRank===
 +
Required spell id for equip/use
  
  
Line 223: Line 267:
  
 
===RequiredFaction===
 
===RequiredFaction===
 
+
ID of faction required to use
  ID of faction required to use
+
  
  
 
===RequiredFactionStanding===
 
===RequiredFactionStanding===
 
+
Required reputation with faction to use the item
  Required reputation with faction to use the item
+
  
  
Line 240: Line 282:
  
 
===maxcount===
 
===maxcount===
 
+
Maximum items of this type allowed per stack.
  Maximum items of this type allowed per stack.
+
  
  
 
===ContainerSlots===
 
===ContainerSlots===
 
+
how many container slots does this item have, if it's bag
 +
be aware, too high number will make crash client!
  
 
===itemstatscount===
 
===itemstatscount===
 
+
How many stats the item has.  By default this is set to 10, but can be lowered manually for each item to reduce server lag slightly.
  How many stats the item has.  By default this is set to 10, but can be lowered manually for each item to reduce server lag slightly.
+
  
  
Line 303: Line 344:
  
 
===stat_value===
 
===stat_value===
 
+
How high is the stat on item
  How high is the stat on item
+
  
  
 
===ScaledStatsDistributionId===
 
===ScaledStatsDistributionId===
 
+
From ScalingStatDistribution.dbc
  From ScalingStatDistribution.dbc
+
  
  
Line 316: Line 355:
  
 
===dmg_min===
 
===dmg_min===
 
+
Minimal damage the item does (weapons)
  Minimal damage the item does (weapons)
+
  
  
 
===dmg_max===
 
===dmg_max===
 
+
Maximum damage the item does (weapons)
  Maximum damage the item does (weapons)
+
  
 
    
 
    
Line 337: Line 374:
  
 
===armor===
 
===armor===
 
+
Armor amount on item
  Armor amount on item
+
  
  
 
===*_res===
 
===*_res===
 
+
Amount of resistances the item has
  Amount of resistances the item has
+
  
  
 
===delay===
 
===delay===
 
+
Time between attacks in miliseconds
  Time between attacks in miliseconds
+
  
  
 
===ammo_type===
 
===ammo_type===
 +
Type of ammo used if ranged weapon
  
  Type of ammo used if ranged weapon
+
0 = nothing
0 = nothing
+
1 = wands
1 = wands
+
2 = bows
2 = bows
+
3 = guns
3 = guns
+
  
 
===range===
 
===range===
 
+
Range of ranged weapon
  Range of ranged weapon
+
  
  
 
===spellid_*===
 
===spellid_*===
 
+
ID of spell on item
  ID of spell on item
+
  
  
 
===spelltrigger_*===
 
===spelltrigger_*===
 +
How the spell is triggered
  
  How the spell is triggered
 
 
   1 = On Equip
 
   1 = On Equip
 
   0 = On Use
 
   0 = On Use
Line 377: Line 409:
  
 
===spellcharges_*===
 
===spellcharges_*===
 
+
Number of charges for spell (negative charges will make the item delete itself when all are used)
  Number of charges for spell (negative charges will make the item delete itself when all are used)
+
  
  
 
===spellcooldown_*===
 
===spellcooldown_*===
 
+
Cooldown for the spell
  Cooldown for the spell
+
  
  
 
===spellcategory_*===
 
===spellcategory_*===
 
  
  
Line 404: Line 433:
  
 
===description===
 
===description===
 
+
Description of the item to appear at the bottom of the tooltip.
  Description of the item to appear at the bottom of the tooltip.
+
  
  
 
===page_id===
 
===page_id===
 
+
ID of text from itempages
  ID of text from itempages
+
  
  
Line 420: Line 447:
  
 
===quest_id===
 
===quest_id===
 
+
ID of quest the item starts
  ID of quest the item starts
+
  
  
Line 431: Line 457:
  
 
===sheathID===
 
===sheathID===
 
+
Sheath type for weapons/shields
  Sheath type for weapons/shields
+
  
  
Line 439: Line 464:
  
 
===block===
 
===block===
 
+
Block amount (for shields)
  Block amount (for shields)
+
  
  
 
===itemset===
 
===itemset===
 
+
ID of item set the item belongs to
  ID of item set the item belongs to
+
  
  
 
===MaxDurability===
 
===MaxDurability===
 
+
Maximum durability on item (for equippable items)
  Maximum durability on item (for equippable items)
+
  
  
Line 457: Line 479:
  
 
===mapid===
 
===mapid===
 
 
Mapid that the item is bound to, will dissapear from inventory when you leave the map.
 
Mapid that the item is bound to, will dissapear from inventory when you leave the map.
  
Line 471: Line 492:
  
 
===socket_bonus===
 
===socket_bonus===
 
+
Bonus for having gems matching socket color Enchantment ID from SpellItemEnchantment.dbc
  Bonus for having gems matching socket color
+
  Enchantment ID from SpellItemEnchantment.dbc
+
  
 
     90 = +4 Agility
 
     90 = +4 Agility
Line 490: Line 509:
  
 
===ReqDisenchantSkill===
 
===ReqDisenchantSkill===
 
+
Minimal enchanting skill required to disenchant the item (-1 makes the item impossible to disenchant)
  Minimal enchanting skill required to disenchant the item (-1 makes the item impossible to disenchant)
+
  
  
Line 498: Line 516:
  
 
===existingduration===
 
===existingduration===
 
 
How long the item will last
 
How long the item will last
  
Line 506: Line 523:
  
 
===HolidayId===
 
===HolidayId===
 
 
=== SQL Structure ===
 
 
<pre>
 
CREATE TABLE `items` (
 
  `entry` int(255) unsigned NOT NULL default '0',
 
  `class` int(30) NOT NULL default '0',
 
  `subclass` int(30) NOT NULL default '0',
 
  `field4` int(10) NOT NULL default '-1',
 
  `name1` varchar(255) NOT NULL,
 
  `displayid` int(70) unsigned NOT NULL default '0',
 
  `quality` int(30) NOT NULL default '0',
 
  `flags` int(30) NOT NULL default '0',
 
  `buyprice` int(30) NOT NULL default '0',
 
  `sellprice` int(30) NOT NULL default '0',
 
  `inventorytype` int(30) NOT NULL default '0',
 
  `allowableclass` int(30) NOT NULL default '0',
 
  `allowablerace` int(30) NOT NULL default '0',
 
  `itemlevel` int(30) NOT NULL default '0',
 
  `requiredlevel` int(30) NOT NULL default '0',
 
  `RequiredSkill` int(30) NOT NULL default '0',
 
  `RequiredSkillRank` int(30) NOT NULL default '0',
 
  `RequiredSpell` int(30) NOT NULL default '0',
 
  `RequiredPlayerRank1` int(30) NOT NULL default '0',
 
  `RequiredPlayerRank2` int(30) NOT NULL default '0',
 
  `RequiredFaction` int(30) NOT NULL default '0',
 
  `RequiredFactionStanding` int(30) NOT NULL default '0',
 
  `Unique` int(30) NOT NULL default '0',
 
  `maxcount` int(30) NOT NULL default '0',
 
  `ContainerSlots` int(30) NOT NULL default '0',
 
  `itemstatscount` int(10) unsigned NOT NULL default '10',
 
  `stat_type1` int(30) NOT NULL default '0',
 
  `stat_value1` int(30) NOT NULL default '0',
 
  `stat_type2` int(30) NOT NULL default '0',
 
  `stat_value2` int(30) NOT NULL default '0',
 
  `stat_type3` int(30) NOT NULL default '0',
 
  `stat_value3` int(30) NOT NULL default '0',
 
  `stat_type4` int(30) NOT NULL default '0',
 
  `stat_value4` int(30) NOT NULL default '0',
 
  `stat_type5` int(30) NOT NULL default '0',
 
  `stat_value5` int(30) NOT NULL default '0',
 
  `stat_type6` int(30) NOT NULL default '0',
 
  `stat_value6` int(30) NOT NULL default '0',
 
  `stat_type7` int(30) NOT NULL default '0',
 
  `stat_value7` int(30) NOT NULL default '0',
 
  `stat_type8` int(30) NOT NULL default '0',
 
  `stat_value8` int(30) NOT NULL default '0',
 
  `stat_type9` int(30) NOT NULL default '0',
 
  `stat_value9` int(30) NOT NULL default '0',
 
  `stat_type10` int(30) NOT NULL default '0',
 
  `stat_value10` int(30) NOT NULL default '0',
 
  `ScaledStatsDistributionId` int(32) unsigned NOT NULL default '0',
 
  `ScaledStatsDistributionFlags` int(32) unsigned NOT NULL default '0',
 
  `dmg_min1` float NOT NULL default '0',
 
  `dmg_max1` float NOT NULL default '0',
 
  `dmg_type1` int(30) NOT NULL default '0',
 
  `dmg_min2` float NOT NULL default '0',
 
  `dmg_max2` float NOT NULL default '0',
 
  `dmg_type2` int(30) NOT NULL default '0',
 
  `armor` int(30) NOT NULL default '0',
 
  `holy_res` int(30) NOT NULL default '0',
 
  `fire_res` int(30) NOT NULL default '0',
 
  `nature_res` int(30) NOT NULL default '0',
 
  `frost_res` int(30) NOT NULL default '0',
 
  `shadow_res` int(30) NOT NULL default '0',
 
  `arcane_res` int(30) NOT NULL default '0',
 
  `delay` int(30) NOT NULL default '0',
 
  `ammo_type` int(30) NOT NULL default '0',
 
  `range` float NOT NULL default '0',
 
  `spellid_1` int(30) NOT NULL default '0',
 
  `spelltrigger_1` int(30) NOT NULL default '0',
 
  `spellcharges_1` int(30) NOT NULL default '0',
 
  `spellcooldown_1` int(30) NOT NULL default '0',
 
  `spellcategory_1` int(30) NOT NULL default '0',
 
  `spellcategorycooldown_1` int(30) NOT NULL default '0',
 
  `spellid_2` int(30) NOT NULL default '0',
 
  `spelltrigger_2` int(30) NOT NULL default '0',
 
  `spellcharges_2` int(30) NOT NULL default '0',
 
  `spellcooldown_2` int(30) NOT NULL default '0',
 
  `spellcategory_2` int(30) NOT NULL default '0',
 
  `spellcategorycooldown_2` int(30) NOT NULL default '0',
 
  `spellid_3` int(30) NOT NULL default '0',
 
  `spelltrigger_3` int(30) NOT NULL default '0',
 
  `spellcharges_3` int(30) NOT NULL default '0',
 
  `spellcooldown_3` int(30) NOT NULL default '0',
 
  `spellcategory_3` int(30) NOT NULL default '0',
 
  `spellcategorycooldown_3` int(30) NOT NULL default '0',
 
  `spellid_4` int(30) NOT NULL default '0',
 
  `spelltrigger_4` int(30) NOT NULL default '0',
 
  `spellcharges_4` int(30) NOT NULL default '0',
 
  `spellcooldown_4` int(30) NOT NULL default '0',
 
  `spellcategory_4` int(30) NOT NULL default '0',
 
  `spellcategorycooldown_4` int(30) NOT NULL default '0',
 
  `spellid_5` int(30) NOT NULL default '0',
 
  `spelltrigger_5` int(30) NOT NULL default '0',
 
  `spellcharges_5` int(30) NOT NULL default '0',
 
  `spellcooldown_5` int(30) NOT NULL default '0',
 
  `spellcategory_5` int(30) NOT NULL default '0',
 
  `spellcategorycooldown_5` int(30) NOT NULL default '0',
 
  `bonding` int(30) NOT NULL default '0',
 
  `description` varchar(255) NOT NULL default '',
 
  `page_id` int(30) NOT NULL default '0',
 
  `page_language` int(30) NOT NULL default '0',
 
  `page_material` int(30) NOT NULL default '0',
 
  `quest_id` int(30) NOT NULL default '0',
 
  `lock_id` int(30) NOT NULL default '0',
 
  `lock_material` int(30) NOT NULL default '0',
 
  `sheathID` int(30) NOT NULL default '0',
 
  `randomprop` int(30) NOT NULL default '0',
 
  `randomsuffix` int(30) NOT NULL default '0',
 
  `block` int(30) NOT NULL default '0',
 
  `itemset` int(30) NOT NULL default '0',
 
  `MaxDurability` int(30) NOT NULL default '0',
 
  `ZoneNameID` int(30) NOT NULL default '0',
 
  `mapid` int(30) default NULL,
 
  `bagfamily` int(30) NOT NULL default '0',
 
  `TotemCategory` int(30) default NULL,
 
  `socket_color_1` int(30) default NULL,
 
  `unk201_3` int(30) NOT NULL default '0',
 
  `socket_color_2` int(30) default NULL,
 
  `unk201_5` int(30) NOT NULL default '0',
 
  `socket_color_3` int(30) default NULL,
 
  `unk201_7` int(30) NOT NULL default '0',
 
  `socket_bonus` int(30) default NULL,
 
  `GemProperties` int(30) default NULL,
 
  `ReqDisenchantSkill` int(30) NOT NULL default '-1',
 
  `ArmorDamageModifier` int(30) NOT NULL default '0',
 
  `existingduration` int(10) unsigned NOT NULL default '0',
 
  `ItemLimitCategoryId` int(32) unsigned NOT NULL default '0',
 
  `HolidayId` int(32) unsigned NOT NULL default '0',
 
  PRIMARY KEY  (`entry`)
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item System';
 
</pre>
 

Latest revision as of 06:10, 12 May 2013

+/-
Main Page                   Other languages:   English  •   German   •   FrenchArcEmu Website     ArcEmu Forum     Bug Tracker


Ico maintenance.png Some of the content of this wikipage is not up to date and need some maintenance. Please help to improve this page and do some update.


Description

This table stores items.

Ico info.png The max. value of the entry seem to be limited. The limit is 200000. ;-)


Contents

Row Breakdown

Field Description

entry

Item unique entry

class and subclass

 0 => Consumables
     0 = Consumable
     1 = Potions
     2 = Elixirs
     3 = Flasks
     4 = Scrolls
     5 = Food & Drinks
     6 = Item Enhancements
     7 = Bandages
     8 = Other
 1 => Bags
     1 = Soul Bag
     2 = Herb Bag
     3 = Enchanting Bag
     4 = Engineering Bag
     5 = Gem Bag
     6 = Mining Bag
     7 = Leatherworking Bag
     8 = Inscription Bag
 2 => Weapons
     0 = Axe (1-handed)
     1 = Axe (2-handed)
     2 = Bow
     3 = Gun
     4 = Mace (1-handed)
     5 = Mace (2-handed)
     6 = Polearm
     7 = Sword (1-handed)
     8 = Sword (2-handed)
     9 = UNKNOWN
     10 = Staff
     11 = UNKNOWN
     12 = UNKNOWN
     13 = Fist Weapon
     14 = UNKNOWN
     15 = Daggers
     16 = Thrown
     17 = Spear (Used only for Argent Tournament Lances)
     18 = Crossbows
     19 = Wands
     20 = Fishing Poles
 3 => Gems
     0 = Red
     1 = Blue
     2 = Yellow
     3 = Purple
     4 = Green
     5 = Orange
     6 = Meta
     7 = Simple
     8 = Prismatic
 4 => Armor
     0 = Miscellaneous
     1 = Cloth
     2 = Leather
     3 = Mail
     4 = Plate
     5 = UNKNOWN
     6 = Shields
     7 = Librams
     8 = Idols
     9 = Totems
     10 = Sigils
 5 => ??? (ex: Ankh)
 6 => Projectiles
     2 = Arrows
     3 = Bullets
 7 => Trade goods
 8 => ??? (empty)
 9 => Recipes, Patterns, Plans
10 => Marks of honor, badges, etc.
11 => Quiver and ammo pounches
12 => ??? (seems to be quest items)
13 => Keys
14 => Mount
15 => Miscellaneous - Junk (gray color - poor quanity items)
     0 = Junk
     1 = Reagents
     2 = non-combat pets
     3 = Holiday items
     4 = Other
     5 = Mounts
16 => Glyphs


field4

name1

Name of the item to be displayed.


displayid

 Visual/Icon Display of the item.


quality

 0 = Poor
 1 = Common
 2 = Uncommon
 3 = Rare
 4 = Epic
 5 = Legendary
 6 = Artifact
 7 = Heirloom


flags

	ITEM_FLAG_SOULBOUND        = 0x1,      // not used in proto
	ITEM_FLAG_CONJURED         = 0x2,
	ITEM_FLAG_LOOTABLE         = 0x4,
	ITEM_FLAG_WRAPPED          = 0x8,      // not used in proto
	ITEM_FLAG_BROKEN           = 0x10,     // many equipable items and bags
	ITEM_FLAG_INDESTRUCTIBLE   = 0x20,     // can't destruct this item
	ITEM_FLAG_UNKNOWN_07       = 0x40,     // many consumables
	ITEM_FLAG_UNKNOWN_08       = 0x80,     // only 1 wand uses this
	ITEM_FLAG_UNKNOWN_09       = 0x100,    // some wands & relics
	ITEM_FLAG_WRAP_GIFT        = 0x200,
	ITEM_FLAG_CREATE_ITEM      = 0x400,    // probably worng
	ITEM_FLAG_FREE_FOR_ALL     = 0x800,    // can be looted ffa
	ITEM_FLAG_REFUNDABLE       = 0x1000,
	ITEM_FLAG_SIGNABLE         = 0x2000,   // charts
	ITEM_FLAG_READABLE         = 0x4000,   // may be worng
	ITEM_FLAG_UNKNOWN_16       = 0x8000,
	ITEM_FLAG_EVENT_REQ        = 0x10000,  // may be wrong
	ITEM_FLAG_UNKNOWN_18       = 0x20000,
	ITEM_FLAG_PROSPECTABLE     = 0x40000,
	ITEM_FLAG_UNIQUE_EQUIP     = 0x80000,
	ITEM_FLAG_UNKNOWN_21       = 0x100000, // not used in proto
	ITEM_FLAG_USEABLE_IN_ARENA = 0x200000, // useable in arenas
	ITEM_FLAG_THROWN           = 0x400000,
	ITEM_FLAG_SHAPESHIFT_OK    = 0x800000,
	ITEM_FLAG_UNKNOWN_25       = 0x1000000,
	ITEM_FLAG_UNKNOWN_26       = 0x2000000,
	ITEM_FLAG_UNKNOWN_27       = 0x4000000,
	ITEM_FLAG_ACCOUNTBOUND     = 0x8000000,
	ITEM_FLAG_UNKNOWN_29       = 0x10000000,
	ITEM_FLAG_MILLABLE         = 0x20000000,
	ITEM_FLAG_UNKNOWN_31       = 0x40000000,
	ITEM_FLAG_UNKNOWN_32       = 0x80000000

flags2

	ITEM_FLAG2_HORDE_ONLY				= 0x00001,
	ITEM_FLAG2_ALLIANCE_ONLY			= 0x00002,
	ITEM_FLAG2_EXT_COST_REQUIRES_GOLD	= 0x00004,
	ITEM_FLAG2_NEED_ROLL_DISABLED		= 0x00100,

buyprice

Price cost if bought from a vendor (in coppper)


sellprice

Price cost if sold to a vendor (in coppper)


inventorytype

 0 - Non-Equip
 1 - Head
 2 - Neck
 3 - Shoulders
 4 - Body
 5 - Chest
 6 - Waist
 7 - Legs
 8 - Feet
 9 - Wrists
10 - Hands
11 - Finger
12 - Trinket
13 - Weapon
14 - Shield
15 - Ranged
16 - Cloak
17 - Two-Hand Weapon
18 - Bag
19 - Tabard
20 - Robe
21 - Weapon-Main Hand
22 - Weapon-Off Hand
23 - Holdable
24 - Ammo
25 - Thrown
26 - Ranged(right)
27 - Quiver
28 - Relic

allowableclass

  -1 = Any Class
  32 = Deathknight
   2 = Paladin
  16 = Priest
   1 = Warrior
 256 = Warlock
   4 = Hunter
  64 = Shaman
   8 = Rogue
1024 = Druid
 128 = Mage

If you want to apply to two (2) classes, add the values.

For Example,  32 + 1024 = 1056 is Deathknight and Druid.

allowablerace

  -1 = Any Race
 690 = All Horde races
1101 = All Alliance races

itemlevel

The level value of the item.


requiredlevel

Level required to use the item.


RequiredSkill

ID of the skill required

 Blacksmithing   = 164
Leather Working  = 165
   Tailoring     = 197
  Engineering    = 202
    Fishing      = 356
 Jewlcrafting    = 755

RequiredSkillRank

How high your skill in RequiredSkill must be (used for professions)


RequiredSkillSubRank

Required spell id for equip/use


RequiredPlayerRank1 and 2

RequiredFaction

ID of faction required to use


RequiredFactionStanding

Required reputation with faction to use the item


unique

 0 = Not Unique
 1 = Unique Item
 n = Unique (n)


maxcount

Maximum items of this type allowed per stack.


ContainerSlots

how many container slots does this item have, if it's bag be aware, too high number will make crash client!

itemstatscount

How many stats the item has. By default this is set to 10, but can be lowered manually for each item to reduce server lag slightly.


Stat types

 ID Name
 0  =  POWER
 1  =  HEALTH
 2  =  UNKNOWN
 3  =  AGILITY
 4  =  STRENGTH
 5  =  INTELLECT
 6  =  SPIRIT
 7  =  STAMINA
11  =  WEAPON_SKILL_RATING
12  =  DEFENSE_RATING
13  =  DODGE_RATING
14  =  PARRY_RATING
15  =  SHIELD_BLOCK_RATING
16  =  MELEE_HIT_RATING
17  =  RANGED_HIT_RATING
18  =  SPELL_HIT_RATING
19  =  MELEE_CRITICAL_STRIKE_RATING
20  =  RANGED_CRITICAL_STRIKE_RATING
21  =  SPELL_CRITICAL_STRIKE_RATING
22  =  MELEE_HIT_AVOIDANCE_RATING
23  =  RANGED_HIT_AVOIDANCE_RATING
24  =  SPELL_HIT_AVOIDANCE_RATING
25  =  MELEE_CRITICAL_AVOIDANCE_RATING
26  =  RANGED_CRITICAL_AVOIDANCE_RATING
27  =  SPELL_CRITICAL_AVOIDANCE_RATING
28  =  MELEE_HASTE_RATING
29  =  RANGED_HASTE_RATING
30  =  SPELL_HASTE_RATING 
31  =  HIT_RATING
32  =  CRITICAL_STRIKE_RATING
33  =  HIT_AVOIDANCE_RATING
34  =  EXPERTISE_RATING
35  =  RESILIENCE_RATING
36  =  HASTE_RATING
37  =  EXPERTISE_RATING_2
38  =  ATTACK_POWER
39  =  RANGED_ATTACK_POWER
40  =  FERAL_ATTACK_POWER
41  =  SPELL_HEALING_DONE
42  =  SPELL_DAMAGE_DONE
43  =  MANA_REGENERATION
44  =  ARMOR_PENETRATION_RATING
45  =  SPELL_POWER
46  =  HEALTH_REGEN
47  =  SPELL_PENETRATION  
48  =  BLOCK_VALUE

stat_value

How high is the stat on item


ScaledStatsDistributionId

From ScalingStatDistribution.dbc


ScaledStatsDistributionFlags

dmg_min

Minimal damage the item does (weapons)


dmg_max

Maximum damage the item does (weapons)


dmg_type

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


armor

Armor amount on item


*_res

Amount of resistances the item has


delay

Time between attacks in miliseconds


ammo_type

Type of ammo used if ranged weapon

0 = nothing
1 = wands
2 = bows
3 = guns

range

Range of ranged weapon


spellid_*

ID of spell on item


spelltrigger_*

How the spell is triggered

  1 = On Equip
  0 = On Use
  2 = Chance on hit

spellcharges_*

Number of charges for spell (negative charges will make the item delete itself when all are used)


spellcooldown_*

Cooldown for the spell


spellcategory_*

spellcategorycooldown_*

bonding

  0 = Item does not bind
  1 = Item binds on pickup
  2 = Item binds on equip
  3 = Item binds on use
  4 = Quest Item
  5 = Quest Item


description

Description of the item to appear at the bottom of the tooltip.


page_id

ID of text from itempages


page_language

page_material

quest_id

ID of quest the item starts


lock_id

lock_material

sheathID

Sheath type for weapons/shields


randomprop

block

Block amount (for shields)


itemset

ID of item set the item belongs to


MaxDurability

Maximum durability on item (for equippable items)


ZoneNameID

mapid

Mapid that the item is bound to, will dissapear from inventory when you leave the map.


bagfamily

socket_color_*

 1 = Meta
 2 = Red
 4 = Yellow
 8 = Blue

socket_bonus

Bonus for having gems matching socket color Enchantment ID from SpellItemEnchantment.dbc

   90 = +4 Agility
  106 = +4 Strength
 2883 = +4 Stamina
 2869 = +4 Intellect
 2890 = +4 Spirit
 2900 = +4 Spell Power
 1583 = +4 Attack Power
 2873 = +4 Hit Rating
 2874 = +4 Critical Strike Rating


GemProperties

ReqDisenchantSkill

Minimal enchanting skill required to disenchant the item (-1 makes the item impossible to disenchant)


ArmorDamageModifier

existingduration

How long the item will last


ItemLimitCategoryId

HolidayId

Personal tools