Skip to content

spell_effect_mod Table

Overrides spell effect parameters (e.g., damage, radius, target) for custom tuning.


Schema Summary

Field Type Key Null Default Extra
Id smallint(5) unsigned PRI NO 0
EffectIndex int(3) unsigned PRI NO 0
Effect int(3) NO -1
EffectDieSides int(10) NO -1
EffectBaseDice int(10) NO -1
EffectDicePerLevel float NO -1
EffectRealPointsPerLevel float NO -1
EffectBasePoints int(10) NO -1
EffectAmplitude int(10) NO -1
EffectPointsPerComboPoint float NO -1
EffectChainTarget int(10) NO -1
EffectMultipleValue float NO -1
EffectMechanic int(10) NO -1
EffectImplicitTargetA int(10) NO -1
EffectImplicitTargetB int(10) NO -1
EffectRadiusIndex int(10) NO -1
EffectApplyAuraName int(10) NO -1
EffectItemType bigint(20) NO -1
EffectMiscValue int(10) NO -1
EffectTriggerSpell int(10) NO -1
Comment varchar(255) YES

Field Breakdown

  • Id - Primary Key. Spell ID. (see spell_template.entry)
  • EffectIndex - Primary Key. Which effect slot (0-2) the row modifies.
  • Effect - Replacement effect type.
  • EffectDieSides - Override for the same-named effect template field; only provided values replace client data.
  • EffectBaseDice - Override for the same-named effect template field; only provided values replace client data.
  • EffectDicePerLevel - Override for the same-named effect template field; only provided values replace client data.
  • EffectRealPointsPerLevel - Override for the same-named effect template field; only provided values replace client data.
  • EffectBasePoints - Override for the same-named effect template field; only provided values replace client data.
  • EffectAmplitude - Override for the same-named effect template field; only provided values replace client data.
  • EffectPointsPerComboPoint - Override for the same-named effect template field; only provided values replace client data.
  • EffectChainTarget - Override for the same-named effect template field; only provided values replace client data.
  • EffectMultipleValue - Override for the same-named effect template field; only provided values replace client data.
  • EffectMechanic - Override for the same-named effect template field; only provided values replace client data.
  • EffectImplicitTargetA - Override for the same-named effect template field; only provided values replace client data.
  • EffectImplicitTargetB - Override for the same-named effect template field; only provided values replace client data.
  • EffectRadiusIndex - Override for the same-named effect template field; only provided values replace client data.
  • EffectApplyAuraName - Override for the same-named effect template field; only provided values replace client data.
  • EffectItemType - Override for the same-named effect template field; only provided values replace client data.
  • EffectMiscValue - Override for the same-named effect template field; only provided values replace client data.
  • EffectTriggerSpell - Override for the same-named effect template field; only provided values replace client data.
  • Comment - Human note.