From f850baeb30e2532d2fb52fbd49368f313b73fe04 Mon Sep 17 00:00:00 2001 From: kaelima Date: Mon, 9 Jan 2012 10:07:46 +0100 Subject: Script/Naxxramas: Fixed "A Spore Loser", texts and timers for Loatheb encounter. Creds to Warpten, thanks. --- sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql | 5 +++++ sql/updates/world/2012_01_09_00_world_creature_text.sql | 5 +++++ sql/updates/world/2012_01_09_00_world_spell_script_names.sql | 3 +++ 3 files changed, 13 insertions(+) create mode 100644 sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql create mode 100644 sql/updates/world/2012_01_09_00_world_creature_text.sql create mode 100644 sql/updates/world/2012_01_09_00_world_spell_script_names.sql (limited to 'sql/updates/world') diff --git a/sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..6c2bcc86d03 --- /dev/null +++ b/sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql @@ -0,0 +1,5 @@ +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (7612,7613); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7612,7613); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(7612,11,0,0, 'achievement_spore_loser'), +(7613,11,0,0, 'achievement_spore_loser'); diff --git a/sql/updates/world/2012_01_09_00_world_creature_text.sql b/sql/updates/world/2012_01_09_00_world_creature_text.sql new file mode 100644 index 00000000000..2a70be00b12 --- /dev/null +++ b/sql/updates/world/2012_01_09_00_world_creature_text.sql @@ -0,0 +1,5 @@ +DELETE FROM `creature_text` WHERE `entry`=16011; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(16011,0,0, 'An aura of necrotic energy blocks all healing!',41,0,100,0,0,0, 'Loatheb'), +(16011,1,0, 'The aura fades away, allowing for healing once more!',41,0,100,0,0,0, 'Loatheb'), +(16011,2,0, 'The aura''s power begins to wane!',41,0,100,0,0,0, 'Loatheb'); diff --git a/sql/updates/world/2012_01_09_00_world_spell_script_names.sql b/sql/updates/world/2012_01_09_00_world_spell_script_names.sql new file mode 100644 index 00000000000..7279fc54413 --- /dev/null +++ b/sql/updates/world/2012_01_09_00_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=59481; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(59481, 'spell_loatheb_necrotic_aura_warning'); -- cgit v1.2.3