diff options
| author | offl <offl@users.noreply.github.com> | 2020-12-25 00:41:16 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-05 15:28:47 +0100 |
| commit | 14c7344251ff95fe05fb719d356158c39e414cad (patch) | |
| tree | 223f76bd4ea2f4e400cf9906822f1063147646da | |
| parent | 9ca9baa0d1a42580e14a56018fff2174deab1235 (diff) | |
DB/Quest: Update 'Ebon Blade Prisoners' (12982)
(cherry picked from commit 2094bc538034cb3e3b8f4920161592e67a89585e)
| -rw-r--r-- | sql/updates/world/master/2022_03_05_16_world_2020_12_24_00_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_16_world_2020_12_24_00_world.sql b/sql/updates/world/master/2022_03_05_16_world_2020_12_24_00_world.sql new file mode 100644 index 00000000000..d79e100a230 --- /dev/null +++ b/sql/updates/world/master/2022_03_05_16_world_2020_12_24_00_world.sql @@ -0,0 +1,17 @@ +-- +UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 56204; -- Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Human +UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 56210; -- Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Night Elf +UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 56213; -- Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Orc +UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 56215; -- Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Troll + +DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (56204,56210,56213,56215); +INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `Effect`, `EffectTriggerSpell`, `ImplicitTarget1`) VALUES +(56204, 0, 140, 56207, 25), +(56210, 0, 140, 56209, 25), +(56213, 0, 140, 56212, 25), +(56215, 0, 140, 56214, 25); + +UPDATE `smart_scripts` SET `action_type` = 11, `action_param1` = 56204, `comment` = "Ebon Blade Prisoner - On Link - Cast 'Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Human'" WHERE `entryorguid` = 30186 AND `source_type` = 0 AND `id` = 3; +UPDATE `smart_scripts` SET `action_type` = 11, `action_param1` = 56210, `comment` = "Ebon Blade Prisoner - On Link - Cast 'Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Night Elf'" WHERE `entryorguid` = 30194 AND `source_type` = 0 AND `id` = 3; +UPDATE `smart_scripts` SET `action_type` = 11, `action_param1` = 56213, `comment` = "Ebon Blade Prisoner - On Link - Cast 'Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Orc'" WHERE `entryorguid` = 30195 AND `source_type` = 0 AND `id` = 3; +UPDATE `smart_scripts` SET `action_type` = 11, `action_param1` = 56215, `comment` = "Ebon Blade Prisoner - On Link - Cast 'Ebon Blade Prisoners: Force Cast Summon Ebon Blade Knight - Troll'" WHERE `entryorguid` = 30196 AND `source_type` = 0 AND `id` = 3; |