diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2021-11-01 18:09:24 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-21 00:12:30 +0100 |
| commit | d013a8251f096755523fb5eaafa95fb191556926 (patch) | |
| tree | 75ab2a6746eef5370c91683b34fbb45a928073ec /sql/updates | |
| parent | 66eeb6c3e59828ba2fb4949c4eb866b055b72246 (diff) | |
Scripts/Misc: Replace some of AddItem / CreateItem with spells (#27160)
(cherry picked from commit ed38206031f25fec73282044293238c9573a89d9)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2022_03_20_27_world_2021_11_01_01_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_20_27_world_2021_11_01_01_world.sql b/sql/updates/world/master/2022_03_20_27_world_2021_11_01_01_world.sql new file mode 100644 index 00000000000..5085276905e --- /dev/null +++ b/sql/updates/world/master/2022_03_20_27_world_2021_11_01_01_world.sql @@ -0,0 +1,8 @@ +-- +UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 49591; +UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 70055; + +DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (49591,70055); +INSERT INTO `serverside_spell_effect` (`SpellID`,`Effect`,`EffectItemType`,`ImplicitTarget1`) VALUES +(49591,24,37888,25), +(70055,24,49278,25); |