diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_08_01_world.sql | 130 |
1 files changed, 130 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_08_01_world.sql b/sql/updates/world/master/2022_12_08_01_world.sql new file mode 100644 index 00000000000..0d174055ea0 --- /dev/null +++ b/sql/updates/world/master/2022_12_08_01_world.sql @@ -0,0 +1,130 @@ +SET @CGUID := 396571; +SET @OGUID := 249568; +SET @EVENT := 26; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 32823, 0, 139, 2268, '0', 0, 0, 0, 0, 2243.179931640625, -5314.08984375, 83.017333984375, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Light's Hope Chapel - Difficulty: 0) (Auras: ) +(@CGUID+1, 32823, 0, 139, 2268, '0', 0, 0, 0, 0, 2302.56005859375, -5274.5400390625, 82.50003814697265625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Light's Hope Chapel - Difficulty: 0) (Auras: ) +(@CGUID+2, 34653, 0, 139, 2268, '0', 0, 0, 0, 0, 2251.3701171875, -5312.31005859375, 82.59723663330078125, 0.349065840244293212, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Light's Hope Chapel - Difficulty: 0) +(@CGUID+3, 34654, 0, 139, 2268, '0', 0, 0, 0, 0, 2299.669921875, -5283.85986328125, 82.21863555908203125, 4.450589656829833984, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Light's Hope Chapel - Difficulty: 0) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+51; +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, 179968, 0, 139, 2268, '0', 0, 0, 2247.2099609375, -5309.259765625, 82.46700286865234375, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+1, 179968, 0, 139, 2268, '0', 0, 0, 2245.18994140625, -5308.6201171875, 82.26219940185546875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+2, 179968, 0, 139, 2268, '0', 0, 0, 2249.75, -5315.27978515625, 82.22650146484375, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+3, 179968, 0, 139, 2268, '0', 0, 0, 2249.72998046875, -5312.919921875, 82.62619781494140625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+4, 179968, 0, 139, 2268, '0', 0, 0, 2246.969970703125, -5319.31005859375, 82.2173004150390625, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+5, 179968, 0, 139, 2268, '0', 0, 0, 2240.760009765625, -5318.2900390625, 82.52359771728515625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+6, 179968, 0, 139, 2268, '0', 0, 0, 2238.52001953125, -5311.89990234375, 82.51039886474609375, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+7, 179968, 0, 139, 2268, '0', 0, 0, 2297.89990234375, -5272.35009765625, 82.053802490234375, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+8, 179968, 0, 139, 2268, '0', 0, 0, 2300.139892578125, -5278.740234375, 81.8144989013671875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+9, 179968, 0, 139, 2268, '0', 0, 0, 2298.8701171875, -5276.89990234375, 81.85070037841796875, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+10, 179968, 0, 139, 2268, '0', 0, 0, 2240.43994140625, -5309.759765625, 82.44439697265625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+11, 179968, 0, 139, 2268, '0', 0, 0, 2239.489990234375, -5316.4501953125, 82.64929962158203125, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+12, 179968, 0, 139, 2268, '0', 0, 0, 2244.320068359375, -5319.759765625, 82.258697509765625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+13, 179968, 0, 139, 2268, '0', 0, 0, 2303.699951171875, -5280.2099609375, 81.98960113525390625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+14, 179968, 0, 139, 2268, '0', 0, 0, 2309.1298828125, -5275.72998046875, 82.6024017333984375, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+15, 179968, 0, 139, 2268, '0', 0, 0, 2306.590087890625, -5269.7099609375, 83.05899810791015625, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+16, 179968, 0, 139, 2268, '0', 0, 0, 2299.820068359375, -5270.22021484375, 82.63719940185546875, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+17, 179968, 0, 139, 2268, '0', 0, 0, 2306.35009765625, -5279.759765625, 82.03350067138671875, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+18, 179968, 0, 139, 2268, '0', 0, 0, 2304.570068359375, -5269.06982421875, 83.00350189208984375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+19, 179968, 0, 139, 2268, '0', 0, 0, 2309.110107421875, -5273.3798828125, 82.8177032470703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+20, 180353, 0, 139, 2268, '0', 0, 0, 2246.199951171875, -5308.77978515625, 82.2917022705078125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+21, 180353, 0, 139, 2268, '0', 0, 0, 2249.7900390625, -5314.0400390625, 82.43979644775390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+22, 180353, 0, 139, 2268, '0', 0, 0, 2239.22998046875, -5310.669921875, 82.43060302734375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+23, 180353, 0, 139, 2268, '0', 0, 0, 2245.77001953125, -5319.509765625, 82.3385009765625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+24, 180353, 0, 139, 2268, '0', 0, 0, 2299.25, -5277.830078125, 81.821197509765625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+25, 180353, 0, 139, 2268, '0', 0, 0, 2239.8701171875, -5317.3798828125, 82.60590362548828125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+26, 180353, 0, 139, 2268, '0', 0, 0, 2298.610107421875, -5271.1298828125, 82.3610992431640625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+27, 180353, 0, 139, 2268, '0', 0, 0, 2309.169921875, -5274.490234375, 82.7239990234375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+28, 180353, 0, 139, 2268, '0', 0, 0, 2305.580078125, -5269.22998046875, 83.04509735107421875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+29, 180353, 0, 139, 2268, '0', 0, 0, 2305.14990234375, -5279.9599609375, 81.98960113525390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+30, 195164, 0, 139, 2268, '0', 0, 0, 2247.199951171875, -5309.33984375, 83.1009979248046875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+31, 195164, 0, 139, 2268, '0', 0, 0, 2249.699951171875, -5313.0400390625, 83.257598876953125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+32, 195164, 0, 139, 2268, '0', 0, 0, 2300.010009765625, -5278.580078125, 82.45999908447265625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+33, 195164, 0, 139, 2268, '0', 0, 0, 2240.77001953125, -5318.33984375, 83.174896240234375, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+34, 195164, 0, 139, 2268, '0', 0, 0, 2244.360107421875, -5319.7998046875, 82.90650177001953125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+35, 195164, 0, 139, 2268, '0', 0, 0, 2247.199951171875, -5319.2900390625, 82.856201171875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+36, 195164, 0, 139, 2268, '0', 0, 0, 2298.860107421875, -5276.77001953125, 82.49859619140625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+37, 195164, 0, 139, 2268, '0', 0, 0, 2249.68994140625, -5315.509765625, 82.83609771728515625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+38, 195164, 0, 139, 2268, '0', 0, 0, 2239.6201171875, -5316.52978515625, 83.2913970947265625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+39, 195164, 0, 139, 2268, '0', 0, 0, 2240.47998046875, -5309.93017578125, 83.08589935302734375, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+40, 195164, 0, 139, 2268, '0', 0, 0, 2238.679931640625, -5312.06982421875, 83.16190338134765625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+41, 195164, 0, 139, 2268, '0', 0, 0, 2245.199951171875, -5308.81005859375, 82.9225006103515625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+42, 195164, 0, 139, 2268, '0', 0, 0, 2297.919921875, -5272.31005859375, 82.703399658203125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+43, 195164, 0, 139, 2268, '0', 0, 0, 2304.43994140625, -5269.0498046875, 83.64260101318359375, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+44, 195164, 0, 139, 2268, '0', 0, 0, 2306.43994140625, -5279.52978515625, 82.67780303955078125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+45, 195164, 0, 139, 2268, '0', 0, 0, 2306.43994140625, -5269.580078125, 83.6999969482421875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+46, 195164, 0, 139, 2268, '0', 0, 0, 2308.929931640625, -5275.75, 83.22080230712890625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+47, 195164, 0, 139, 2268, '0', 0, 0, 2308.93994140625, -5273.27978515625, 83.4586029052734375, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+48, 195164, 0, 139, 2268, '0', 0, 0, 2303.60009765625, -5280.02978515625, 82.62529754638671875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+49, 195164, 0, 139, 2268, '0', 0, 0, 2299.7099609375, -5270.169921875, 83.27459716796875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+50, 195664, 0, 139, 2268, '0', 0, 0, 2243.179931640625, -5314.08984375, 82.93399810791015625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Light's Hope Chapel - Difficulty: 0) +(@OGUID+51, 195664, 0, 139, 2268, '0', 0, 0, 2302.56005859375, -5274.5400390625, 82.4167022705078125, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Light's Hope Chapel - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+51; +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), +(@EVENT, @OGUID+28), +(@EVENT, @OGUID+29), +(@EVENT, @OGUID+30), +(@EVENT, @OGUID+31), +(@EVENT, @OGUID+32), +(@EVENT, @OGUID+33), +(@EVENT, @OGUID+34), +(@EVENT, @OGUID+35), +(@EVENT, @OGUID+36), +(@EVENT, @OGUID+37), +(@EVENT, @OGUID+38), +(@EVENT, @OGUID+39), +(@EVENT, @OGUID+40), +(@EVENT, @OGUID+41), +(@EVENT, @OGUID+42), +(@EVENT, @OGUID+43), +(@EVENT, @OGUID+44), +(@EVENT, @OGUID+45), +(@EVENT, @OGUID+46), +(@EVENT, @OGUID+47), +(@EVENT, @OGUID+48), +(@EVENT, @OGUID+49), +(@EVENT, @OGUID+50), +(@EVENT, @OGUID+51); |