aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorWyreth <32145860+Wyreth@users.noreply.github.com>2017-10-29 06:02:39 +0100
committerfunjoker <funjoker109@gmail.com>2021-01-21 22:30:40 +0100
commit45dbce6d78e08a149537d08108408947b0cbca53 (patch)
tree1e730f9ce36d6f9cfef03f60efb50e00a02ed97e /sql/updates
parent8eaf992f3ecf55feb16d093f0cfaa1828d3b1e7c (diff)
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) (cherry picked from commit fda99b2972aed2b98642f8974e34c5b18f7f3676)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2021_01_16_06_world_2017_10_29_00_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_16_06_world_2017_10_29_00_world.sql b/sql/updates/world/master/2021_01_16_06_world_2017_10_29_00_world.sql
new file mode 100644
index 00000000000..7f2f287a1ad
--- /dev/null
+++ b/sql/updates/world/master/2021_01_16_06_world_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");