DB/SpellItemEnchantment: Difference between revisions

From wowdev
Jump to navigation Jump to search
No edit summary
Line 7: Line 7:
==Structure==
==Structure==
  '''Column Field Type Notes'''  
  '''Column Field Type Notes'''  
1 ID Integer   
  ID Integer   
   
   
   3.*:
   3.*:
   charges Integer see [http://www.wowhead.com/?spell=14795#comments Venomhide Poison].
   charges Integer see [http://www.wowhead.com/?spell=14795#comments Venomhide Poison].
   
   
2 iRefID_[[SpellDispellType.dbc|SpellDispellType]]_1 Integer Enchantment Type of effect 1  
  iRefID_[[SpellDispelType.dbc|SpellDispelType]]_1 Integer Enchantment Type of effect 1  
3 iRefID_[[SpellDispellType.dbc|SpellDispellType]]_2 Integer Enchantment Type of effect 2  
  iRefID_[[SpellDispelType.dbc|SpellDispelType]]_2 Integer Enchantment Type of effect 2  
4 iRefID_[[SpellDispellType.dbc|SpellDispellType]]_3 Integer Enchantment Type of effect 3  
  iRefID_[[SpellDispelType.dbc|SpellDispelType]]_3 Integer Enchantment Type of effect 3  
5 amount1 Integer Amount of damage/armor/apply/spell for effect 1  
  amount1 Integer Amount of damage/armor/apply/spell for effect 1  
6 amount2 Integer Amount of damage/armor/apply/spell for effect 2  
  amount2 Integer Amount of damage/armor/apply/spell for effect 2  
7 amount3 Integer Amount of damage/armor/apply/spell for effect 3  
  amount3 Integer Amount of damage/armor/apply/spell for effect 3  
8 dupe1 Integer Unknown, seems to duplicate amount1 (Theory: Perhaps a range, from amount1 to dupe1)  
  dupe1 Integer Unknown, seems to duplicate amount1 (Theory: Perhaps a range, from amount1 to dupe1)  
9 dupe2 Integer Unknown, seems to duplicate amount2 (Theory: Perhaps a range, from amount2 to dupe2)  
  dupe2 Integer Unknown, seems to duplicate amount2 (Theory: Perhaps a range, from amount2 to dupe2)  
10 dupe3 Integer Unknown, seems to duplicate amount3 (Theory: Perhaps a range, from amount3 to dupe3)  
  dupe3 Integer Unknown, seems to duplicate amount3 (Theory: Perhaps a range, from amount3 to dupe3)  
11 iRefID_[[Spell.dbc|Spell]]_1 or [[Stat Types]]_1 Integer if type1 == 5, then Stat Types, else [[Spell.dbc]]  
  iRefID_[[Spell.dbc|Spell]]_1 or [[Stat Types]]_1 Integer if type1 == 5, then Stat Types, else [[Spell.dbc]]  
12 iRefID_[[Spell.dbc|Spell]]_2 or [[Stat Types]]_2 Integer if type2 == 5, then Stat Types, else [[Spell.dbc]]  
  iRefID_[[Spell.dbc|Spell]]_2 or [[Stat Types]]_2 Integer if type2 == 5, then Stat Types, else [[Spell.dbc]]  
13 iRefID_[[Spell.dbc|Spell]]_3 or [[Stat Types]]_3 Integer if type3 == 5, then Stat Types, else [[Spell.dbc]]  
  iRefID_[[Spell.dbc|Spell]]_3 or [[Stat Types]]_3 Integer if type3 == 5, then Stat Types, else [[Spell.dbc]]  
14-22 sRefName String + [[Loc]] The name of the enchantment  
  sRefName String + [[Loc]] The name of the enchantment  
23 iRefID_[[ItemVisuals.dbc|ItemVisuals]] Integer The glow to add to the items that has this enchant  
  iRefID_[[ItemVisuals.dbc|ItemVisuals]] Integer The glow to add to the items that has this enchant  
24 Unknown Integer
  Unknown Integer
25 iRefID_[[ItemCache.wdb|ItemCache]] Integer Reference to the Gem that has this ability (Added in 2.0.0.5610)  
  iRefID_[[ItemCache.wdb|ItemCache]] Integer Reference to the Gem that has this ability (Added in 2.0.0.5610)  
26 iRefID_[[SpellItemEnchantmentCondition.dbc|SpellItemEnchantmentCondition]] Integer Conditions for the effect to take place (Added in 2.0.0.5610)  
  iRefID_[[SpellItemEnchantmentCondition.dbc|SpellItemEnchantmentCondition]] Integer Conditions for the effect to take place (Added in 2.0.0.5610)  
   
   
   3.*:
   3.*:

Revision as of 00:03, 6 February 2009

Header Info

Records..................1919
Fields.....................26
Record Size...............104
String Block Size.......31981

Structure

Column	Field 					Type 		Notes 
 	ID 					Integer  

  3.*:
 	charges 				Integer 	see Venomhide Poison.

 	iRefID_SpellDispelType_1 					Integer 	Enchantment Type of effect 1 
 	iRefID_SpellDispelType_2 					Integer 	Enchantment Type of effect 2 
 	iRefID_SpellDispelType_3					Integer 	Enchantment Type of effect 3 
 	amount1 				Integer 	Amount of damage/armor/apply/spell for effect 1 
 	amount2 				Integer 	Amount of damage/armor/apply/spell for effect 2 
 	amount3 				Integer 	Amount of damage/armor/apply/spell for effect 3 
 	dupe1 					Integer 	Unknown, seems to duplicate amount1 (Theory: Perhaps a range, from amount1 to dupe1) 
 	dupe2 					Integer 	Unknown, seems to duplicate amount2 (Theory: Perhaps a range, from amount2 to dupe2) 
 	dupe3 					Integer 	Unknown, seems to duplicate amount3 (Theory: Perhaps a range, from amount3 to dupe3) 
 	iRefID_Spell_1 or Stat Types_1 		Integer 	if type1 == 5, then Stat Types, else Spell.dbc 
 	iRefID_Spell_2 or Stat Types_2 		Integer 	if type2 == 5, then Stat Types, else Spell.dbc 
 	iRefID_Spell_3 or Stat Types_3 		Integer 	if type3 == 5, then Stat Types, else Spell.dbc 
 	sRefName 				String + Loc	The name of the enchantment 
 	iRefID_ItemVisuals 			Integer 	The glow to add to the items that has this enchant 
 	Unknown 				Integer 	
 	iRefID_ItemCache 			Integer 	Reference to the Gem that has this ability (Added in 2.0.0.5610) 
 	iRefID_SpellItemEnchantmentCondition 	Integer 	Conditions for the effect to take place (Added in 2.0.0.5610) 

  3.*:
 	iRefID_SkillLine					Integer 	A required profession.
 	SkillLevel 				Integer 	And the level for that profession.

--schlumpf_ 17:53, 4 September 2008 (CEST)