From cae19692ab2b627b292cdeed59069d5f6fa3be30 Mon Sep 17 00:00:00 2001 From: Kittnz Date: Thu, 2 Jun 2016 19:39:37 +0200 Subject: Fix SQL name --- sql/updates/world/3.3.5/2016_06_02_00_world.sql | 20 ++++++++++++++++++++ sql/updates/world/3.3.5/9999_99_99_99_world.sql | 20 -------------------- 2 files changed, 20 insertions(+), 20 deletions(-) create mode 100644 sql/updates/world/3.3.5/2016_06_02_00_world.sql delete mode 100644 sql/updates/world/3.3.5/9999_99_99_99_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2016_06_02_00_world.sql b/sql/updates/world/3.3.5/2016_06_02_00_world.sql new file mode 100644 index 00000000000..b192efa6814 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_06_02_00_world.sql @@ -0,0 +1,20 @@ +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 10m normal +(67627,'spell_jormungars_burning_spray'), -- Burning Spray 25m normal +(67628,'spell_jormungars_burning_spray'), -- Burning Spray 10m heroic +(67629,'spell_jormungars_burning_spray'), -- Burning Spray 25m heroic +(66901,'spell_jormungars_paralytic_spray'), -- Paralytic Spray 10m normal +(67615,'spell_jormungars_paralytic_spray'), -- Paralytic Spray 25m normal +(67616,'spell_jormungars_paralytic_spray'), -- Paralytic Spray 10m heroic +(67617,'spell_jormungars_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 +(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'); 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 deleted file mode 100644 index b192efa6814..00000000000 --- a/sql/updates/world/3.3.5/9999_99_99_99_world.sql +++ /dev/null @@ -1,20 +0,0 @@ -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 10m normal -(67627,'spell_jormungars_burning_spray'), -- Burning Spray 25m normal -(67628,'spell_jormungars_burning_spray'), -- Burning Spray 10m heroic -(67629,'spell_jormungars_burning_spray'), -- Burning Spray 25m heroic -(66901,'spell_jormungars_paralytic_spray'), -- Paralytic Spray 10m normal -(67615,'spell_jormungars_paralytic_spray'), -- Paralytic Spray 25m normal -(67616,'spell_jormungars_paralytic_spray'), -- Paralytic Spray 10m heroic -(67617,'spell_jormungars_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 -(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