diff options
| -rw-r--r-- | sql/updates/world/master/2025_06_01_01_world.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_06_01_01_world.sql b/sql/updates/world/master/2025_06_01_01_world.sql new file mode 100644 index 00000000000..3f8760f8e31 --- /dev/null +++ b/sql/updates/world/master/2025_06_01_01_world.sql @@ -0,0 +1,21 @@ +-- Using legacy MoP range for Mejis future plan to move MoP guids +SET @OGUID := 400716; + +UPDATE `gameobject_template_addon` SET `faction`=35, `flags`=0x2000 WHERE `entry` IN (214513, 214885); -- Instance Portal (Party + Heroic + Challenge) + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+12; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 212899, 870, 5785, 5974, '0', 0, 0, 957.32293701171875, -2475.732666015625, 180.5042877197265625, 1.256758451461791992, 0, 0, 0.587834358215332031, 0.808981299400329589, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Jade Temple Grounds - Difficulty: 0) CreateObject1 +(@OGUID+1, 212899, 960, 5956, 5956, '1,2,8,23,24', 0, 0, 955.66143798828125, -2480.83154296875, 180.7587738037109375, 4.409494400024414062, 0, 0, -0.80569362640380859, 0.59233248233795166, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Temple of the Jade Serpent - Difficulty: 0) CreateObject1 +(@OGUID+2, 211640, 870, 5805, 0, '0', 0, 0, -718.04168701171875, 1262.0504150390625, 136.468170166015625, 0, 0, 0, 0, 1, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+3, 211640, 961, 5963, 5963, '1,2,8,24', 0, 0, -730.61285400390625, 1261.21533203125, 116.6681671142578125, 1.865166425704956054, 0, 0, 0.80316162109375, 0.59576117992401123, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Stormstout Brewery - Difficulty: Normal) CreateObject2 +(@OGUID+4, 212899, 870, 5840, 6394, '0', 0, 0, 698.7274169921875, 2079.701416015625, 374.694183349609375, 3.203973054885864257, 0, 0, -0.99951362609863281, 0.031185083091259002, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Serpent's Spine - Difficulty: 0) CreateObject1 +(@OGUID+5, 212899, 962, 5976, 5976, '1,2,8,24', 0, 0, 958.94964599609375, 2161.86279296875, 296.105560302734375, 1.611702203750610351, 0, 0, 0.7214202880859375, 0.692497491836547851, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Gate of the Setting Sun - Difficulty: 0) CreateObject1 +(@OGUID+6, 212899, 962, 5976, 5976, '1,2,8,24', 0, 0, 721.64581298828125, 2097.7587890625, 403.980682373046875, 1.611702203750610351, 0, 0, 0.7214202880859375, 0.692497491836547851, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Gate of the Setting Sun - Difficulty: 0) CreateObject1 +(@OGUID+7, 214885, 870, 5840, 6751, '0', 0, 0, 1400.6771240234375, 427.92535400390625, 479.027557373046875, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Big Blossom Excavation - Difficulty: 0) CreateObject1 +(@OGUID+8, 214885, 994, 6182, 6470, '1,2,8,24', 0, 0, -3969.458251953125, -2525.845458984375, 29.84488868713378906, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: The Gilded Foyer - Difficulty: 0) CreateObject1 +(@OGUID+9, 212899, 870, 5841, 0, '0', 0, 0, 3642.8125, 2544.4072265625, 769.94964599609375, 3.544227123260498046, 0, 0, -0.97980403900146484, 0.199960112571716308, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+10, 212899, 959, 5918, 5918, '1,2,8,24', 0, 0, 3649.040771484375, 2548.056396484375, 766.96856689453125, 0.461546212434768676, 0, 0, 0.228730201721191406, 0.973489880561828613, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Shado-Pan Monastery - Difficulty: 0) CreateObject1 +(@OGUID+11, 212899, 870, 5842, 6195, '0', 0, 0, 1441.5538330078125, 5088.6162109375, 140.2492218017578125, 3.555192470550537109, 0, 0, -0.97869300842285156, 0.205328941345214843, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic + Challenge) (Area: Sik'vess - Difficulty: 0) CreateObject1 +(@OGUID+12, 214513, 1011, 6214, 6413, '1,2,8', 0, 0, 1447.43408203125, 5093.1396484375, 144.0469970703125, 0.711747825145721435, 0, 0, 0.348409652709960937, 0.937342405319213867, 7200, 255, 1, 61122); -- Instance Portal (Party + Heroic + Challenge) (Area: Hollowed Out Tree - Difficulty: 0) CreateObject1 |