Scripts/Northrend: talk event for quest A Suitable Test Subject (#20462)

- When using the quest item for A Suitable Test Subject and the spell aura vanishes,
  Bloodmage Laurith should turn toward the player and whisper a line.
- This is handled via spell event for Bloodspore Ruination (45997)

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_10_29_00_world.sql b/sql/updates/world/3.3.5/2017_10_29_00_world.sql
new file mode 100644
index 00000000000..7f2f287a1ad
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_10_29_00_world.sql
@@ -0,0 +1,10 @@
+-- quest: A Suitable Test Subject (11719)
+DELETE FROM `spell_script_names` WHERE `ScriptName`="spell_q11719_bloodspore_ruination_45997";
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(45997, "spell_q11719_bloodspore_ruination_45997");
+
+UPDATE `creature_template` SET `ScriptName`="npc_bloodmage_laurith" WHERE `entry`=25381;
+
+DELETE FROM `creature_text` WHERE `CreatureID`=25381;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(25381, 0, 0, "How positively awful! You were totally incapacitated? Weak? Hot flashes?", 15, 0, 100, 21, 0, 0, 24992, 0, "Bloodmage Laurith");