diff options
| -rw-r--r-- | sql/updates/world/master/2023_02_20_04_world.sql | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_02_20_04_world.sql b/sql/updates/world/master/2023_02_20_04_world.sql new file mode 100644 index 00000000000..393c48978b4 --- /dev/null +++ b/sql/updates/world/master/2023_02_20_04_world.sql @@ -0,0 +1,66 @@ +SET @OGUID := 3000607; +SET @EVENT := 8; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+27; +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, 181016, 34, 717, 717, '1', 0, 0, 75.0347747802734375, 4.980967998504638671, -25.6062335968017578, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+1, 181016, 34, 717, 717, '1', 0, 0, 75.0807342529296875, -3.46844291687011718, -25.6062335968017578, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+2, 181016, 34, 717, 717, '1', 0, 0, 124.8732223510742187, -3.53060889244079589, -25.6062335968017578, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+3, 181016, 34, 717, 717, '1', 0, 0, 124.9492034912109375, 5.040185928344726562, -25.6062335968017578, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+4, 181016, 34, 717, 717, '1', 0, 0, 133.4145050048828125, -3.47149205207824707, -25.6062335968017578, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+5, 181016, 34, 717, 717, '1', 0, 0, 133.368682861328125, 4.94775390625, -25.6062335968017578, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+6, 181016, 34, 717, 717, '1', 0, 0, 111.367950439453125, -88.3172607421875, -33.9395637512207031, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+7, 181016, 34, 717, 717, '1', 0, 0, 147.2406158447265625, 89.62396240234375, -33.9395637512207031, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+8, 181016, 34, 717, 717, '1', 0, 0, 116.36749267578125, -90.6798171997070312, -33.9395637512207031, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+9, 181016, 34, 717, 717, '1', 0, 0, 141.8401336669921875, 92.261383056640625, -33.9395637512207031, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 7200, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+10, 181018, 34, 717, 717, '1', 0, 0, 95.9949493408203125, 6.155707836151123046, -25.2080059051513671, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+11, 181018, 34, 717, 717, '1', 0, 0, 95.93645477294921875, -4.61641597747802734, -25.1972179412841796, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+12, 181018, 34, 717, 717, '1', 0, 0, 139.4825592041015625, -4.63111400604248046, -25.2104682922363281, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+13, 181018, 34, 717, 717, '1', 0, 0, 134.490753173828125, 9.605150222778320312, -25.1972179412841796, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+14, 181018, 34, 717, 717, '1', 0, 0, 123.55029296875, -7.77634286880493164, -25.1972160339355468, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+15, 181018, 34, 717, 717, '1', 0, 0, 118.8793106079101562, -4.63945913314819335, -25.2098541259765625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+16, 181018, 34, 717, 717, '1', 0, 0, 123.7063980102539062, 9.523133277893066406, -25.0326118469238281, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+17, 181018, 34, 717, 717, '1', 0, 0, 117.762359619140625, 6.045464038848876953, -24.9732646942138671, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+18, 181018, 34, 717, 717, '1', 0, 0, 140.0503387451171875, 6.163999080657958984, -25.1972179412841796, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+19, 181018, 34, 717, 717, '1', 0, 0, 134.4687347412109375, -8.19999599456787109, -24.9982643127441406, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+20, 181018, 34, 717, 717, '1', 0, 0, 137.0919036865234375, 54.82421493530273437, -33.5295143127441406, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+21, 181018, 34, 717, 717, '1', 0, 0, 131.7865753173828125, -55.2373390197753906, -33.537628173828125, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+22, 181018, 34, 717, 717, '1', 0, 0, 126.530853271484375, 56.84122467041015625, -33.4548606872558593, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+23, 181018, 34, 717, 717, '1', 0, 0, 121.1558685302734375, -53.6179161071777343, -33.5352783203125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+24, 181018, 34, 717, 717, '1', 0, 0, 115.260986328125, -73.350830078125, -33.5295143127441406, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+25, 181018, 34, 717, 717, '1', 0, 0, 125.4581985473632812, -77.0105743408203125, -33.5379219055175781, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+26, 181018, 34, 717, 717, '1', 0, 0, 133.3552703857421875, 79.84642791748046875, -33.4236106872558593, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 7200, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) +(@OGUID+27, 181018, 34, 717, 717, '1', 0, 0, 143.1554107666015625, 75.4530029296875, -33.5304145812988281, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 7200, 255, 1, 48069); -- Hanging, Tall/Thin, Medium - Val (Area: The Stockade - Difficulty: Normal) + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+27; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(@EVENT, @OGUID+0), +(@EVENT, @OGUID+1), +(@EVENT, @OGUID+2), +(@EVENT, @OGUID+3), +(@EVENT, @OGUID+4), +(@EVENT, @OGUID+5), +(@EVENT, @OGUID+6), +(@EVENT, @OGUID+7), +(@EVENT, @OGUID+8), +(@EVENT, @OGUID+9), +(@EVENT, @OGUID+10), +(@EVENT, @OGUID+11), +(@EVENT, @OGUID+12), +(@EVENT, @OGUID+13), +(@EVENT, @OGUID+14), +(@EVENT, @OGUID+15), +(@EVENT, @OGUID+16), +(@EVENT, @OGUID+17), +(@EVENT, @OGUID+18), +(@EVENT, @OGUID+19), +(@EVENT, @OGUID+20), +(@EVENT, @OGUID+21), +(@EVENT, @OGUID+22), +(@EVENT, @OGUID+23), +(@EVENT, @OGUID+24), +(@EVENT, @OGUID+25), +(@EVENT, @OGUID+26), +(@EVENT, @OGUID+27); |