From 0912df258d722f867c8ebe8fc77310f4fd1ce38c Mon Sep 17 00:00:00 2001 From: Keader Date: Sun, 17 Apr 2016 15:10:13 -0300 Subject: Core/Scripts Improve Jormungars fight --- sql/updates/world/3.3.5/9999_99_99_99_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/3.3.5/9999_99_99_99_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/9999_99_99_99_world.sql b/sql/updates/world/3.3.5/9999_99_99_99_world.sql new file mode 100644 index 00000000000..6e708e4a6c4 --- /dev/null +++ b/sql/updates/world/3.3.5/9999_99_99_99_world.sql @@ -0,0 +1,19 @@ +DELETE FROM `spell_script_names` where `ScriptName` IN ('spell_burning_spray','spell_paralytic_spray','spell_jormungars_paralytic_toxin'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(66902,'spell_burning_spray'), -- Burning Spray 10m normal +(67627,'spell_burning_spray'), -- Burning Spray 25m normal +(67628,'spell_burning_spray'), -- Burning Spray 10m heroic +(67629,'spell_burning_spray'), -- Burning Spray 25m heroic +(66901,'spell_paralytic_spray'), -- Paralytic Spray 10m normal +(67615,'spell_paralytic_spray'), -- Paralytic Spray 25m normal +(67616,'spell_paralytic_spray'), -- Paralytic Spray 10m heroic +(67617,'spell_paralytic_spray'), -- Paralytic Spray 25m heroic +(66823,'spell_jormungars_paralytic_toxin'), -- Paralytic Toxin 10m normal +(67618,'spell_jormungars_paralytic_toxin'), -- Paralytic Toxin 25m normal +(67619,'spell_jormungars_paralytic_toxin'), -- Paralytic Toxin 10m heroic +(67620,'spell_jormungars_paralytic_toxin'); -- Paralytic Toxin 25m heroic + +-- 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`, `comment`) VALUES +(35144, 1, 0, 'You have been infected with a Paralytic Toxin!', 42, 0, 0, 0, 0, 0, 'Acidmaw - Special Attack'); -- cgit v1.2.3