Items

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
m (Description)
m (allowableclass)
Line 228: 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===

Revision as of 00:46, 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 16777215. ;-)


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