From fda99b2972aed2b98642f8974e34c5b18f7f3676 Mon Sep 17 00:00:00 2001
From: Wyreth <32145860+Wyreth@users.noreply.github.com>
Date: Sun, 29 Oct 2017 06:02:39 +0100
Subject: 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)
---
 sql/updates/world/3.3.5/2017_10_29_00_world.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2017_10_29_00_world.sql

(limited to 'sql')

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");
-- 
cgit v1.2.3