aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authortkrokli <tkrokli@users.noreply.github.com>2016-11-03 06:50:03 +0100
committerGitHub <noreply@github.com>2016-11-03 06:50:03 +0100
commit2b26894eb1eaf8572f61d303882878659692cdd3 (patch)
tree4583498228ddc0f5cba63f33d188387a46ba2773 /sql
parenta94b8c83e2456c710e8428df4932ab4b3ef4d44e (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
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2016_11_03_01_world_335.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_11_03_01_world_335.sql b/sql/updates/world/3.3.5/2016_11_03_01_world_335.sql
new file mode 100644
index 00000000000..da07ba6f52c
--- /dev/null
+++ b/sql/updates/world/3.3.5/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 `entry`= @Arugal AND `groupid`= 0;
+
+DELETE FROM `creature_text` WHERE `entry` = @Arugal AND `groupid` IN (1,2,3);
+INSERT INTO `creature_text` (`entry`,`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');