diff options
| -rw-r--r-- | sql/updates/world/master/2017_06_28_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_06_28_00_world.sql b/sql/updates/world/master/2017_06_28_00_world.sql new file mode 100644 index 00000000000..7fefdf703c8 --- /dev/null +++ b/sql/updates/world/master/2017_06_28_00_world.sql @@ -0,0 +1,8 @@ +-- +-- Cenarion Emissary Jademoon +SET @CGUID = 452574; +DELETE FROM `creature` WHERE `guid`=@CGUID; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID, 15187, 0, 1, 169, -8338.65, 286.271, 156.916, 5.11218, 120, 0, 0); +UPDATE `creature` SET `PhaseGroup`=0 WHERE `PhaseGroup`=169; +UPDATE `creature` SET `PhaseId`=169 WHERE `PhaseId`=1; |