From 7f2b5f3859ca65d0fe96485d13cfd47dc69e7355 Mon Sep 17 00:00:00 2001 From: Keader Date: Sun, 17 Apr 2016 20:10:13 +0200 Subject: Core/Scripts Improve Jormungars fight (cherry picked from commit 0912df258d722f867c8ebe8fc77310f4fd1ce38c) Rename spell_snakes_spray for spell_jormungars_snakes_spray and cleanup (cherry picked from commit 2c9c8afc0f23dada7599ecede4bf3d598ab42006) Fixing the issue (cherry picked from commit 81083a8593b846e5a64f59771c4446f9f29c34c3) Changing remove aura method (cherry picked from commit b88d49be2498ce484124c1adc2bc1ab5ac2aa176) changing creature_text (tk feedback) (cherry picked from commit 9b444877dd8955ee0cfcf9bf56304220c4c276fb) Override and tkrokli again :D (cherry picked from commit 7205b4dd65bd569e4b254586f6802199de447194) Fix SQL name (cherry picked from commit cae19692ab2b627b292cdeed59069d5f6fa3be30) --- .../world/master/2017_01_11_24_world_2016_06_02_00_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql b/sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql new file mode 100644 index 00000000000..c1167d60305 --- /dev/null +++ b/sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `spell_script_names` where `ScriptName` IN ('spell_jormungars_burning_spray','spell_jormungars_paralytic_spray','spell_jormungars_paralytic_toxin','spell_jormungars_paralysis'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(66902,'spell_jormungars_burning_spray'), -- Burning Spray +(66901,'spell_jormungars_paralytic_spray'), -- Paralytic Spray +(66823,'spell_jormungars_paralytic_toxin'), -- Paralytic Toxin +(66830,'spell_jormungars_paralysis'); -- Paralysis + +-- Acidmaw missing text +DELETE FROM `creature_text` where entry = 35144 AND groupid = 1; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(35144,1,0,'You have been infected with a Paralytic Toxin!',42,0,100,0,0,0,36323,0,'Acidmaw - Special Attack'); -- cgit v1.2.3