Items

From ArcEmu-Wiki
Revision as of 18:43, 2 January 2012 by MesoX (Talk | contribs)
Jump to: navigation, search

Description

This table stores items.


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

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

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

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

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

SQL Structure

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';
Personal tools