aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-02-04 16:24:19 +0100
committerShauren <shauren.trinity@gmail.com>2019-07-21 21:06:54 +0200
commit411b0c32a0a6031423d4a21590635fc8a4925c59 (patch)
treed6a36065090ba1db15d04d86ded4329d1dc2a4a1
parent26fe9496191225c8300ac57c07e9380193ec2c54 (diff)
DB/Creature: Greatfather Aldrimus
Closes #7605 (cherrypicked from 9edad9fc1b1a94cc8428194b59e0b960d56f86cc)
-rw-r--r--sql/updates/world/master/2019_07_13_01_world_2017_02_04_03_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2019_07_13_01_world_2017_02_04_03_world.sql b/sql/updates/world/master/2019_07_13_01_world_2017_02_04_03_world.sql
new file mode 100644
index 00000000000..49119831206
--- /dev/null
+++ b/sql/updates/world/master/2019_07_13_01_world_2017_02_04_03_world.sql
@@ -0,0 +1,8 @@
+
+UPDATE `creature_template_addon` SET `auras`=32648 WHERE `entry` IN(19698);
+DELETE FROM `spell_area` WHERE `spell`=32649 AND `area`=3688;
+INSERT INTO `spell_area` (`spell`,`area`,`quest_start`, `quest_end`,`aura_spell`,`racemask`,`gender`,`flags`,quest_start_status) VALUES
+(32649,3688,10252,0,0,0,2,1,64);
+DELETE FROM `creature_template_addon` WHERE `entry`=19879;
+INSERT INTO `creature_template_addon` (`entry`,`bytes2`,`auras`) VALUES
+(19879,1,"32648");