diff options
| author | Teleqraph <nyrdeveloper@gmail.com> | 2022-11-07 22:36:27 +0100 |
|---|---|---|
| committer | ModoX <moardox@gmail.com> | 2022-11-07 22:36:27 +0100 |
| commit | 3957eda5fb68a9f4b548f3f21d6a05d0e51fa917 (patch) | |
| tree | 6f4fb22e756ca0631142275518ab548e97c78617 | |
| parent | b2361c18e5c9e60909f4e969aef2624ff26ef197 (diff) | |
DB/Silverpine: Implemented missing spell effect for 148164
* fixes Sylvanas Horse
Closes #28444
| -rw-r--r-- | sql/updates/world/master/2022_11_07_02_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_07_02_world.sql b/sql/updates/world/master/2022_11_07_02_world.sql new file mode 100644 index 00000000000..f3286f16d62 --- /dev/null +++ b/sql/updates/world/master/2022_11_07_02_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `serverside_spell_effect` WHERE `SpellID`=148164 AND `EffectIndex`=0 AND `DifficultyID`=0; +INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `DifficultyID`, `Effect`, `EffectAura`, `EffectAmplitude`, `EffectAttributes`, `EffectAuraPeriod`, `EffectBonusCoefficient`, `EffectChainAmplitude`, `EffectChainTargets`, `EffectItemType`, `EffectMechanic`, `EffectPointsPerResource`, `EffectPosFacing`, `EffectRealPointsPerLevel`, `EffectTriggerSpell`, `BonusCoefficientFromAP`, `PvpMultiplier`, `Coefficient`, `Variance`, `ResourceCoefficient`, `GroupSizeBasePointsCoefficient`, `EffectBasePoints`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectSpellClassMask4`, `ImplicitTarget1`, `ImplicitTarget2`) VALUES +(148164, 0, 0, 28, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 73595, 2986, 0, 0, 0, 0, 0, 0, 0, 0); |