diff options
| author | Killyana <morphone1@gmail.com> | 2020-04-19 21:23:49 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-01 20:05:49 +0100 |
| commit | 61236ece9af46c4318dbb3474034207fe246b17e (patch) | |
| tree | d5eff49a4d8542e0d3e29dbddc32583a22088047 | |
| parent | ad2e5aabc4d0d706bc06aa83364eac83c47392a4 (diff) | |
DB/GameObject: Spawn a missing Everfrost Shard and fix the rotation for other spawns
(cherry picked from commit 19f67356d7cbf7e2777c543bf177e0ee0c49a4e6)
| -rw-r--r-- | sql/updates/world/master/2022_01_01_29_world_2020_04_19_02_world.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_29_world_2020_04_19_02_world.sql b/sql/updates/world/master/2022_01_01_29_world_2020_04_19_02_world.sql new file mode 100644 index 00000000000..dbbaab72f68 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_29_world_2020_04_19_02_world.sql @@ -0,0 +1,26 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN (9488,20923, 20920, 20919, 20921, 20918, 20922, 20924, 20925, 20926); +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 +(9488, 192186, 571, 67, 4455, '0', 171, 7299.982, -2056.776, 760.9175, 3.129811, 0.3363314, 0.04759979, -0.9404612, 0.0121777, 180, 255, 1, 12340), -- 192186 (Area: 4455 - Difficulty: 0) +(20923, 192192, 571, 67, 4455, '0', 171, 7314.04, -2044.864, 759.9833, 1.099423, -0.2230496, -0.1706619, 0.4941998, 0.8227332, 180, 255, 1, 12340), -- 192192 (Area: 4455 - Difficulty: 0) +(20920, 192189, 571, 67, 4455, '0', 171, 7313.608, -2054.12, 761.2607, 0.7116861, 0.01181412, 0.1117296, 0.3414249, 0.9331698, 180, 255, 1, 12340), -- 192189 (Area: 4455 - Difficulty: 0) +(20919, 192188, 571, 67, 4455, '0', 171, 7313.108, -2054.224, 760.5995, 2.816149, -0.3206506, 0.3725376, 0.8260374, 0.2757918, 180, 255, 1, 12340), -- 192188 (Area: 4455 - Difficulty: 0) +(20921, 192190, 571, 67, 4455, '0', 171, 7309.421, -2060.014, 761.2607, 0.5045644, 0.3025804, 0.2811918, 0.1502008, 0.8982294, 180, 255, 1, 12340), -- 192190 (Area: 4455 - Difficulty: 0) +(20918, 192187, 571, 67, 4455, '0', 171, 7306.375, -2060.064, 760.9175, -3.114883, 0.1825423, -0.1813145, 0.9660988, 0.02136614, 180, 255, 1, 12340), -- 192187 (Area: 4455 - Difficulty: 0) +(20922, 192191, 571, 67, 4455, '0', 171, 7320.774, -2041.834, 760.5995, 2.816149, -0.3206506, 0.3725376, 0.8260374, 0.2757918, 180, 255, 1, 12340), -- 192191 (Area: 4455 - Difficulty: 0) +(20924, 192193, 571, 67, 4455, '0', 171, 7325.573, -2044.473, 760.7373, -0.8043898, 0.05699968, 0.307972, -0.3514671, 0.8822557, 180, 255, 1, 12340), -- 192193 (Area: 4455 - Difficulty: 0) +(20925, 192194, 571, 67, 4455, '0', 171, 7320.686, -2053.649, 761.3393, -0.8043898, 0.05699968, 0.307972, -0.3514671, 0.8822557, 180, 255, 1, 12340), -- 192194 (Area: 4455 - Difficulty: 0) +(20926, 192195, 571, 67, 4455, '0', 171, 7321.002, -2054.295, 760.8995, -1.401235, 0.1287899, -0.01092052, -0.6453352, 0.7528853, 180, 255, 1, 12340); -- 192195 (Area: 4455 - Difficulty: 0) + +DELETE FROM `gameobject_addon` WHERE `guid` IN (9488,20923, 20920, 20919, 20921, 20918, 20922, 20924, 20925, 20926); +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`) VALUES +(9488, 0, 0, 0.9930685, -0.1175375), -- 192186 +(20923, 0, 0, 0.9930685, -0.1175375), -- 192192 +(20920, 0, 0, 0.9930685, -0.1175375), -- 192189 +(20919, 0, 0, 0.9930685, -0.1175375), -- 192188 +(20921, 0, 0, 0.9930685, -0.1175375), -- 192190 +(20918, 0, 0, 0.9930685, -0.1175375), -- 192187 +(20922, 0, 0, 0.9930685, -0.1175375), -- 192191 +(20924, 0, 0, 0.9930685, -0.1175375), -- 192193 +(20925, 0, 0, 0.9930685, -0.1175375), -- 192194 +(20926, 0, 0, 0.9930685, -0.1175375); -- 192195 |