aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-02-04 16:24:19 +0100
committerKillyana <morphone1@gmail.com>2017-02-04 16:24:19 +0100
commit9edad9fc1b1a94cc8428194b59e0b960d56f86cc (patch)
treebb5ff50e583ef1f1566cffcae8ee304a57c46d68
parentbc95fce93f5f3d0057f6d766567cbd6c341737b8 (diff)
DB/Creature: Greatfather Aldrimus
Closes #7605
-rw-r--r--sql/updates/world/3.3.5/2017_02_04_03_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_02_04_03_world.sql b/sql/updates/world/3.3.5/2017_02_04_03_world.sql
new file mode 100644
index 00000000000..8666746a41c
--- /dev/null
+++ b/sql/updates/world/3.3.5/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`,`autocast`,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");