aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authortkrokli <tkrokli@users.noreply.github.com>2016-11-03 06:50:03 +0100
committerjoschiwald <joschiwald.trinity@gmail.com>2017-12-10 17:29:54 +0100
commitb74eba72f67304096de75173667339485e8d6ef8 (patch)
tree9dd51a5ad7293666d9ad403a627db4e10a9bd6c9 /sql/updates
parenteee5a4f2483f5ad6eec79371aa0478c1a87d29c1 (diff)
Core/Scripts: Archmage Arugal event script (#17922)
Implement boss script for Archmage Arugal - add yells used in boss event to DB - use proper spells instead of only melee fighting - add DataType in shadowfang_keep.h - add event scheduling in the script By Riztazz Closes issue #17916 (cherry picked from commit 2b26894eb1eaf8572f61d303882878659692cdd3)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2017_12_10_01_world_2016_11_03_01_world_335.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_12_10_01_world_2016_11_03_01_world_335.sql b/sql/updates/world/master/2017_12_10_01_world_2016_11_03_01_world_335.sql
new file mode 100644
index 00000000000..058c388799e
--- /dev/null
+++ b/sql/updates/world/master/2017_12_10_01_world_2016_11_03_01_world_335.sql
@@ -0,0 +1,12 @@
+-- Archmage Arugal, NPC entry 4275
+SET @Arugal := 4275;
+
+UPDATE `creature_template` SET `ScriptName` = 'boss_archmage_arugal' WHERE `entry`= @Arugal;
+
+UPDATE `creature_text` SET `comment`= 'Archmage Arugal - Fenrus the Devourer dies' WHERE `CreatureID`= @Arugal AND `GroupID`= 0;
+
+DELETE FROM `creature_text` WHERE `CreatureID` = @Arugal AND `GroupID` IN (1,2,3);
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`, `comment`) VALUES
+(@Arugal,1,0,'You, too, shall serve!', 14,0,100,0,0,0,6115,0,'Archmage Arugal - Aggro'),
+(@Arugal,2,0,'Release your rage!', 14,0,100,0,0,0,6535,0,'Archmage Arugal - Transforms player into a Worgen'),
+(@Arugal,3,0,'Another falls!', 14,0,100,0,0,0,6116,0,'Archmage Arugal - Killing a player');