From 37462b1f785af2afc44e683850695f1da54f7cd2 Mon Sep 17 00:00:00 2001 From: Rushor Date: Mon, 16 Mar 2015 18:34:35 +0100 Subject: DB/Creature: Darnell by @Exodius and @Killyana closes #13761 --- sql/updates/world/2015_03_16_06_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2015_03_16_06_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_03_16_06_world.sql b/sql/updates/world/2015_03_16_06_world.sql new file mode 100644 index 00000000000..b36f8c6e2d6 --- /dev/null +++ b/sql/updates/world/2015_03_16_06_world.sql @@ -0,0 +1,13 @@ +-- +SET @GUID := 286259; -- Set by TC +DELETE FROM `creature` WHERE `guid`=@GUID; +INSERT INTO `creature` (`guid`, `id`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES +(@GUID, 49425, 1, 1, 1962.828, 1417.599, 67.46286, 3.560472, 120); + +DELETE FROM `creature_template_addon` WHERE `entry`=49425; +INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`, `auras`) VALUES +(49425, 65536, 0, "49415"); + +DELETE FROM `spell_area` WHERE spell=49417 AND AREA=154; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `racemask`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(49417, 154, 24970, 24971, 16, 1, 66, 11); -- cgit v1.2.3