diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2017-10-23 23:14:38 +0200 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-13 22:04:52 +0100 |
| commit | b933b7c5d6bdff84a7b0a56bbeb3bccc8095e1ef (patch) | |
| tree | 6ce34eb24ee4f2c4e138ccd946ed2b7e4b8bebb7 | |
| parent | aa907238a4bba28b4e57e30b4d15f501e57e2a98 (diff) | |
DB/Gameobject: Add Missing bonfire in Amani Catacombs
Closes #20688
(cherry picked from commit 93b1e9977c23e3e62163bb67fabad97524e5297b)
| -rw-r--r-- | sql/updates/world/master/2021_01_09_09_world_2017_10_23_05_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_09_09_world_2017_10_23_05_world.sql b/sql/updates/world/master/2021_01_09_09_world_2017_10_23_05_world.sql new file mode 100644 index 00000000000..f43a64444da --- /dev/null +++ b/sql/updates/world/master/2021_01_09_09_world_2017_10_23_05_world.sql @@ -0,0 +1,8 @@ +-- +SET @OGUID:=970; +DELETE FROM `gameobject` WHERE `guid`=@OGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID, 192612, 530, 3433, 3509, '0', 0, 7567.479, -7359.604, 161.8884, 3.159062, 0, 0, -0.9999619, 0.008734641, 120, 255, 1, 14545); -- 192612 +DELETE FROM `gameobject_addon` WHERE `guid`=@OGUID; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`) VALUES +(@OGUID, 0, 0, 0.9999619, -0.00872653); -- 192612 |