diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2025_04_16_08_world.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_04_16_08_world.sql b/sql/updates/world/cata_classic/2025_04_16_08_world.sql new file mode 100644 index 00000000000..1d119d6c306 --- /dev/null +++ b/sql/updates/world/cata_classic/2025_04_16_08_world.sql @@ -0,0 +1,33 @@ +SET @OGUID := 2990014; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+24; +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, 214441, 571, 65, 4184, '0', '0', 0, 3608.315185546875, 186.423614501953125, -109.469322204589843, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 60192), -- Instance Portal (Raid 4 Difficulties) (Area: Path of the Titans - Difficulty: 0) CreateObject1 +(@OGUID+1, 214536, 571, 65, 4184, '0', '0', 0, 3442.697998046875, 261.048614501953125, -108.852462768554687, 0.109779156744480133, 0, 0, 0.054862022399902343, 0.998493909835815429, 120, 255, 1, 60192), -- Instance Portal (Raid 10/25 No Heroic) (Area: Path of the Titans - Difficulty: 0) CreateObject1 +(@OGUID+2, 214523, 571, 65, 4188, '0', '0', 0, 3659.790771484375, -1280.93408203125, 243.8188018798828125, 0.802832186222076416, 0, 0, 0.390722274780273437, 0.920508623123168945, 120, 255, 1, 60192), -- Instance Portal (Raid 10/25 No Heroic) (Area: The Carrion Fields - Difficulty: 0) CreateObject1 +(@OGUID+3, 214523, 571, 65, 4188, '0', '0', 0, 3679.76904296875, -1258.7117919921875, 243.743896484375, 3.983556032180786132, 0, 0, -0.91268825531005859, 0.408656537532806396, 120, 255, 1, 60192), -- Instance Portal (Raid 10/25 No Heroic) (Area: The Carrion Fields - Difficulty: 0) CreateObject1 +(@OGUID+4, 214523, 571, 65, 4188, '0', '0', 0, 3680.865478515625, -1279.7569580078125, 243.800567626953125, 2.420278310775756835, 0, 0, 0.935665130615234375, 0.352889209985733032, 120, 255, 1, 60192), -- Instance Portal (Raid 10/25 No Heroic) (Area: The Carrion Fields - Difficulty: 0) CreateObject1 +(@OGUID+5, 214523, 571, 65, 4188, '0', '0', 0, 3658.665771484375, -1259.453125, 243.7371673583984375, 5.510808467864990234, 0, 0, -0.37666034698486328, 0.926351428031921386, 120, 255, 1, 60192), -- Instance Portal (Raid 10/25 No Heroic) (Area: The Carrion Fields - Difficulty: 0) CreateObject1 +(@OGUID+6, 381414, 571, 495, 0, '0', '0', 0, 1234.9896240234375, -4860.0537109375, 41.24821090698242187, 3.454191207885742187, 0, 0, -0.98781013488769531, 0.155663534998893737, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+7, 381416, 571, 495, 0, '0', '0', 0, 1233.796875, -4860.28125, 218.2938079833984375, 0.288675248622894287, 0, 0, 0.14383697509765625, 0.989601373672485351, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+8, 381416, 571, 394, 0, '0', '0', 0, 4774.55126953125, -2021.1007080078125, 230.6461639404296875, 4.716822147369384765, 0, 0, -0.70553779602050781, 0.70867234468460083, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+9, 381417, 571, 66, 0, '0', '0', 0, 6971.3046875, -4401.05224609375, 444.913970947265625, 3.928673505783081054, 0, 0, -0.92355728149414062, 0.383460521697998046, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+10, 381417, 571, 66, 4375, '0', '0', 0, 6700.95849609375, -4661.88525390625, 444.127410888671875, 0.76585012674331665, 0, 0, 0.373635292053222656, 0.92757570743560791, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: Gundrak - Difficulty: 0) CreateObject1 +(@OGUID+11, 214502, 571, 67, 4445, '0', '0', 0, 9189.9677734375, -1391.21875, 1110.215087890625, 2.37534642219543457, 0, 0, 0.927501678466796875, 0.37381899356842041, 120, 255, 1, 60192), -- Instance Portal (Party + Heroic) (Area: Ulduar - Difficulty: 0) CreateObject1 +(@OGUID+12, 214517, 571, 67, 4445, '0', '0', 0, 8921.5947265625, -967.00177001953125, 1039.16259765625, 4.760039806365966796, 0, 0, -0.69006061553955078, 0.723751604557037353, 120, 255, 1, 60192), -- Instance Portal (Party + Heroic) (Area: Ulduar - Difficulty: 0) CreateObject1 +(@OGUID+13, 214524, 571, 67, 4445, '0', '0', 0, 9364.2587890625, -1115.046875, 1245.248046875, 0, 0, 0, 0, 1, 120, 255, 1, 60192), -- Instance Portal (Raid 10/25 No Heroic) (Area: Ulduar - Difficulty: 0) CreateObject1 +(@OGUID+14, 214525, 571, 210, 4658, '0', '0', 0, 8515.2109375, 740.24481201171875, 558.5455322265625, 4.721260547637939453, 0, 0, -0.70396327972412109, 0.710236310958862304, 120, 255, 1, 60192), -- Instance Portal (Raid 4 Difficulties) (Area: Argent Tournament Grounds - Difficulty: 0) CreateObject1 +(@OGUID+15, 381400, 571, 210, 4658, '0', '0', 0, 8564.9638671875, 792.16839599609375, 558.55181884765625, 0, 0, 0, 0, 1, 120, 255, 1, 60192), -- Instance Portal ToC Dungeon (Party + Heroic) (Area: Argent Tournament Grounds - Difficulty: 0) CreateObject1 +(@OGUID+16, 214539, 571, 210, 4519, '0', '0', 0, 5778.9140625, 2066.111083984375, 636.21966552734375, 0.451657503843307495, 0, 0, 0.223914146423339843, 0.974608898162841796, 120, 255, 1, 60192), -- Instance Portal (Raid 4 Difficulties) (Area: The Court of Bones - Difficulty: 0) CreateObject1 +(@OGUID+17, 381414, 571, 210, 4522, '0', '0', 0, 5675.2412109375, 1998.107666015625, 798.041259765625, 2.247296094894409179, 0, 0, 0.901683807373046875, 0.432395994663238525, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: Icecrown Citadel - Difficulty: 0) CreateObject1 +(@OGUID+18, 381414, 571, 210, 4522, '0', '0', 0, 5586.41845703125, 2005.595458984375, 798.041259765625, 0.694440603256225585, 0, 0, 0.340285301208496093, 0.940322279930114746, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: Icecrown Citadel - Difficulty: 0) CreateObject1 +(@OGUID+19, 381417, 571, 210, 4522, '0', '0', 0, 5627.88525390625, 1963.49658203125, 803.0205078125, 1.486795425415039062, 0, 0, 0.676793098449707031, 0.736173272132873535, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: Icecrown Citadel - Difficulty: 0) CreateObject1 +(@OGUID+20, 381415, 571, 65, 4163, '0', '0', 0, 3670.163330078125, 2174.109375, 36.07420730590820312, 5.46730804443359375, 0, 0, -0.39671802520751953, 0.91794055700302124, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: Icemist Village - Difficulty: 0) CreateObject1 +(@OGUID+21, 214516, 571, 65, 4164, '0', '0', 0, 3640.241455078125, 2029.015625, 2.593230724334716796, 1.183689117431640625, 0, 0, 0.557892799377441406, 0.829913020133972167, 120, 255, 1, 60192), -- Instance Portal (Party + Heroic) (Area: The Pit of Narjun - Difficulty: 0) CreateObject1 +(@OGUID+22, 214523, 571, 3537, 4024, '0', '0', 0, 3870.302978515625, 6984.1640625, 154.2642974853515625, 2.65942549705505371, 0, 0, 0.971079826354980468, 0.23875504732131958, 120, 255, 1, 60192), -- Instance Portal (Raid 10/25 No Heroic) (Area: Coldarra - Difficulty: 0) CreateObject1 +(@OGUID+23, 381416, 571, 3537, 4024, '0', '0', 0, 3869.944580078125, 6984.1240234375, 108.6140365600585937, 0.048577312380075454, 0, 0, 0.024286270141601562, 0.999705016613006591, 120, 255, 1, 60192), -- Instance Portal LKC (Party + Heroic) (Area: Coldarra - Difficulty: 0) CreateObject1 +(@OGUID+24, 381416, 571, 3537, 4024, '0', '0', 0, 3900.703125, 6985.35791015625, 69.4878387451171875, 3.172844171524047851, 0, 0, -0.9998779296875, 0.015625, 120, 255, 1, 60192); -- Instance Portal LKC (Party + Heroic) (Area: Coldarra - Difficulty: 0) CreateObject1 + +DELETE FROM `gameobject_template` WHERE `entry`=214524; +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(214524, 31, 74868, 'Instance Portal (Raid 10/25 No Heroic)', '', '', '', 8, 2, 216, 217, 216, 217, 0, 0, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60192); -- Instance Portal (Raid 10/25 No Heroic) |