diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-02-17 20:37:30 +0100 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-02-17 20:37:30 +0100 |
| commit | d8ad0f511030c214ee5c0050e47d6ea0b14b974c (patch) | |
| tree | 09a7564b0b24ca72ff0fe3f523be95d852cf1551 | |
| parent | fe290b27e401509f814beae74cd59d9c350f7b83 (diff) | |
DB/Misc: Adition to Fervor of the Frostborn
By Killyana
| -rw-r--r-- | sql/updates/world/2015_02_17_03_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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; |