Script/Naxxramas: Fixed "A Spore Loser", texts and timers for Loatheb encounter.

Creds to Warpten, thanks.

3 files changed, 13 insertions, 0 deletions

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');