DB/SpellItemEnchantment: Difference between revisions

From wowdev
Jump to navigation Jump to search
No edit summary
(→‎Structure: Update structure)
Line 8: Line 8:
  '''Column Field Type Notes'''  
  '''Column Field Type Notes'''  
  1 ID Integer   
  1 ID Integer   
  2 charges Integer Mostly unused. Added 3.x?
  3.*:
  3 [[SpellDispelType.dbc]]_1 Integer Enchantment Type of effect 1  
  2 charges Integer see [http://www.wowhead.com/?spell=14795#comments Venomhide Poison].
  4 [[SpellDispelType.dbc]]_2 Integer Enchantment Type of effect 2  
  5 [[SpellDispelType.dbc]]_3 Integer Enchantment Type of effect 3  
  3 iRefID_[[SpellDispelType.dbc|SpellDispelType]]_1 Integer Enchantment Type of effect 1  
  6 minAmount1 Integer Amount of damage/armor/apply/spell for effect 1  
  4 iRefID_[[SpellDispelType.dbc|SpellDispelType]]_2 Integer Enchantment Type of effect 2  
  7 minAmount2 Integer Amount of damage/armor/apply/spell for effect 2  
  5 iRefID_[[SpellDispelType.dbc|SpellDispelType]]_3 Integer Enchantment Type of effect 3  
  8 minAmount3 Integer Amount of damage/armor/apply/spell for effect 3  
  6 amount1 Integer Amount of damage/armor/apply/spell for effect 1  
  6 maxAmount1 Integer Mostly dupe
  7 amount2 Integer Amount of damage/armor/apply/spell for effect 2  
  7 maxAmount2 Integer Mostly dupe
  8 amount3 Integer Amount of damage/armor/apply/spell for effect 3  
  8 maxAmount3 Integer Mostly dupe
  9 dupe1 Integer Unknown, seems to duplicate amount1 (Theory: Perhaps a range, from amount1 to dupe1)
  12 objectId1 Integer if type1 == 5, then [[Stat Types]], else [[Spell.dbc]]  
  10 dupe2 Integer Unknown, seems to duplicate amount2 (Theory: Perhaps a range, from amount2 to dupe2)
  13 objectId2 Integer if type2 == 5, then [[Stat Types]], else [[Spell.dbc]]  
  11 dupe3 Integer Unknown, seems to duplicate amount3 (Theory: Perhaps a range, from amount3 to dupe3)
  14 objectId2 Integer if type3 == 5, then [[Stat Types]], else [[Spell.dbc]]  
  12 iRefID_[[Spell.dbc|Spell]]_1 or [[Stat Types]]_1 Integer if type1 == 5, then Stat Types, else [[Spell.dbc]]  
  15-31 sRefName String+[[Loc]] The name of the enchantment  
  13 iRefID_[[Spell.dbc|Spell]]_2 or [[Stat Types]]_2 Integer if type2 == 5, then Stat Types, else [[Spell.dbc]]  
  32 [[ItemVisuals.dbc]] Integer The glow to add to the items that has this enchant  
  14 iRefID_[[Spell.dbc|Spell]]_3 or [[Stat Types]]_3 Integer if type3 == 5, then Stat Types, else [[Spell.dbc]]  
  33 Flags Integer
  15-31 sRefName String + [[Loc]] The name of the enchantment  
  34 [[ItemCache.wdb]] Integer Reference to the Gem that has this ability (Added in 2.0.0.5610)  
  32 iRefID_[[ItemVisuals.dbc|ItemVisuals]] Integer The glow to add to the items that has this enchant  
  35 [[SpellItemEnchantmentCondition.dbc]] Integer Conditions for the effect to take place (Added in 2.0.0.5610)  
  33 Flags Integer
  36 [[SkillLine.dbc]] Integer A required profession.
  34 iRefID_[[ItemCache.wdb|ItemCache]] Integer Reference to the Gem that has this ability (Added in 2.0.0.5610)  
  35 iRefID_[[SpellItemEnchantmentCondition.dbc|SpellItemEnchantmentCondition]] Integer Conditions for the effect to take place (Added in 2.0.0.5610)  
  3.*:
  36 iRefID_[[SkillLine.dbc|SkillLine]] Integer A required profession.
  37 SkillLevel Integer And the level for that profession.
  37 SkillLevel Integer And the level for that profession.
  38    Unkonwn
  38    requiredLevel Integer Required level to use the enchant  [http://db.mmo-champion.com/enchants/?required_level__gt=1 1]
 
--[[User:Schlumpf|schlumpf_]] 17:53, 4 September 2008 (CEST)


[[Category:DBC]]
[[Category:DBC]]

Revision as of 08:23, 4 January 2010

Header Info

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

Structure

Column	Field 					Type 		Notes 
1 	ID 					Integer  
2 	charges 				Integer 	Mostly unused. Added 3.x?
3 	SpellDispelType.dbc_1 			Integer 	Enchantment Type of effect 1 
4 	SpellDispelType.dbc_2 			Integer 	Enchantment Type of effect 2 
5 	SpellDispelType.dbc_3			Integer 	Enchantment Type of effect 3 
6 	minAmount1 				Integer 	Amount of damage/armor/apply/spell for effect 1 
7 	minAmount2 				Integer 	Amount of damage/armor/apply/spell for effect 2 
8 	minAmount3 				Integer 	Amount of damage/armor/apply/spell for effect 3 
6 	maxAmount1 				Integer 	Mostly dupe
7 	maxAmount2 				Integer 	Mostly dupe
8 	maxAmount3 				Integer 	Mostly dupe
12 	objectId1 				Integer 	if type1 == 5, then Stat Types, else Spell.dbc 
13 	objectId2 				Integer 	if type2 == 5, then Stat Types, else Spell.dbc 
14 	objectId2 				Integer 	if type3 == 5, then Stat Types, else Spell.dbc 
15-31 	sRefName 				String+Loc	The name of the enchantment 
32 	ItemVisuals.dbc 			Integer 	The glow to add to the items that has this enchant 
33 	Flags 					Integer 	
34 	ItemCache.wdb 				Integer 	Reference to the Gem that has this ability (Added in 2.0.0.5610) 
35 	SpellItemEnchantmentCondition.dbc 	Integer 	Conditions for the effect to take place (Added in 2.0.0.5610) 
36 	SkillLine.dbc				Integer 	A required profession.
37 	SkillLevel 				Integer 	And the level for that profession.
38     requiredLevel				Integer		Required level to use the enchant   1