From 411b0c32a0a6031423d4a21590635fc8a4925c59 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 4 Feb 2017 16:24:19 +0100 Subject: DB/Creature: Greatfather Aldrimus Closes #7605 (cherrypicked from 9edad9fc1b1a94cc8428194b59e0b960d56f86cc) --- .../world/master/2019_07_13_01_world_2017_02_04_03_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/master/2019_07_13_01_world_2017_02_04_03_world.sql (limited to 'sql') 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"); -- cgit v1.2.3