From d8ad0f511030c214ee5c0050e47d6ea0b14b974c Mon Sep 17 00:00:00 2001 From: Aokromes Date: Tue, 17 Feb 2015 20:37:30 +0100 Subject: DB/Misc: Adition to Fervor of the Frostborn By Killyana --- sql/updates/world/2015_02_17_03_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2015_02_17_03_world.sql diff --git a/sql/updates/world/2015_02_17_03_world.sql b/sql/updates/world/2015_02_17_03_world.sql new file mode 100644 index 00000000000..5ef13948b75 --- /dev/null +++ b/sql/updates/world/2015_02_17_03_world.sql @@ -0,0 +1,12 @@ +-- +SET @CGUID := 49137; +DELETE FROM `creature` WHERE `guid` IN (@CGUID); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID, 30142, 571, 1, 1, 8392.7, -1970.14, 1461.84, 0.0948219, 600, 0, 0); + +SET @OGUID := 5501; +DELETE FROM `gameobject` WHERE `guid`= @OGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `rotation2`, `rotation3`, `animprogress`, `state`) VALUES +(@OGUID, 192243, 571, 1, 1, 8531.9, -1971.44, 1467.57, -0.837757, 300, -0.406736, 0.913546, 100, 1); + +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=29730; -- cgit v1.2.3