diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_07_07_world.sql | 134 |
1 files changed, 134 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_07_07_world.sql b/sql/updates/world/master/2022_12_07_07_world.sql new file mode 100644 index 00000000000..4f9538d23a4 --- /dev/null +++ b/sql/updates/world/master/2022_12_07_07_world.sql @@ -0,0 +1,134 @@ +SET @CGUID := 396551; +SET @OGUID := 249354; +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 +-- Feathermoon Stronghold +(@CGUID+0, 32823, 1, 357, 5072, '0', 0, 0, 0, 0, -4467.9599609375, 2181.43994140625, 17.97573471069335937, 5.864306449890136718, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Feathermoon Stronghold - Difficulty: 0) (Auras: ) +(@CGUID+1, 34653, 1, 357, 5072, '0', 0, 0, 0, 0, -4461.18994140625, 2176.85009765625, 17.97493362426757812, 5.515240192413330078, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Feathermoon Stronghold - Difficulty: 0) +-- Camp Mojache +(@CGUID+2, 32823, 1, 357, 1099, '0', 0, 0, 0, 0, -4375.6962890625, 237.37847900390625, 25.49667167663574218, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Camp Mojache - Difficulty: 0) (Auras: ) +(@CGUID+3, 34654, 1, 357, 1099, '0', 0, 0, 0, 0, -4381.3837890625, 240.4479217529296875, 25.58231353759765625, 3.996803998947143554, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Camp Mojache - 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 +-- Feathermoon Stronghold +(@OGUID+0, 179968, 1, 357, 5072, '0', 0, 0, -4469.52001953125, 2186.239990234375, 17.91139984130859375, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+1, 179968, 1, 357, 5072, '0', 0, 0, -4472.27001953125, 2180.639892578125, 17.90679931640625, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+2, 179968, 1, 357, 5072, '0', 0, 0, -4471.85986328125, 2178.85009765625, 17.88450050354003906, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+3, 179968, 1, 357, 5072, '0', 0, 0, -4471.02001953125, 2185.39990234375, 17.91650009155273437, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+4, 179968, 1, 357, 5072, '0', 0, 0, -4466.72021484375, 2175.47998046875, 17.89159965515136718, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+5, 179968, 1, 357, 5072, '0', 0, 0, -4468.419921875, 2175.639892578125, 17.89159965515136718, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+6, 179968, 1, 357, 5072, '0', 0, 0, -4462.56982421875, 2184.699951171875, 17.89170074462890625, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+7, 179968, 1, 357, 5072, '0', 0, 0, -4461.89013671875, 2179.840087890625, 17.89159965515136718, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+8, 179968, 1, 357, 5072, '0', 0, 0, -4462.6298828125, 2178.449951171875, 17.89159965515136718, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+9, 179968, 1, 357, 5072, '0', 0, 0, -4463.830078125, 2185.659912109375, 17.89229965209960937, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46741), -- Haystack 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+10, 180353, 1, 357, 5072, '0', 0, 0, -4472.259765625, 2179.639892578125, 17.89760017395019531, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+11, 180353, 1, 357, 5072, '0', 0, 0, -4470.39990234375, 2186.050048828125, 17.91670036315917968, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+12, 180353, 1, 357, 5072, '0', 0, 0, -4463.16015625, 2185.219970703125, 17.89200019836425781, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+13, 180353, 1, 357, 5072, '0', 0, 0, -4462.2001953125, 2179.110107421875, 17.89159965515136718, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+14, 180353, 1, 357, 5072, '0', 0, 0, -4467.60009765625, 2175.43994140625, 17.89159965515136718, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+15, 195164, 1, 357, 5072, '0', 0, 0, -4472.2001953125, 2180.659912109375, 18.50200080871582031, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+16, 195164, 1, 357, 5072, '0', 0, 0, -4470.9501953125, 2185.320068359375, 18.51149940490722656, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+17, 195164, 1, 357, 5072, '0', 0, 0, -4462.6201171875, 2184.739990234375, 18.48760032653808593, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+18, 195164, 1, 357, 5072, '0', 0, 0, -4471.89990234375, 2178.93994140625, 18.48040008544921875, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+19, 195164, 1, 357, 5072, '0', 0, 0, -4461.990234375, 2179.840087890625, 18.48740005493164062, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+20, 195164, 1, 357, 5072, '0', 0, 0, -4469.56005859375, 2186.199951171875, 18.50729942321777343, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+21, 195164, 1, 357, 5072, '0', 0, 0, -4466.5498046875, 2175.530029296875, 18.48740005493164062, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+22, 195164, 1, 357, 5072, '0', 0, 0, -4468.43994140625, 2175.72998046875, 18.48740005493164062, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+23, 195164, 1, 357, 5072, '0', 0, 0, -4462.81005859375, 2178.3701171875, 18.48740005493164062, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+24, 195164, 1, 357, 5072, '0', 0, 0, -4463.91015625, 2185.580078125, 18.48810005187988281, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Feathermoon Stronghold - Difficulty: 0) +(@OGUID+25, 195664, 1, 357, 5072, '0', 0, 0, -4467.9599609375, 2181.43994140625, 17.89240074157714843, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Feathermoon Stronghold - Difficulty: 0) +-- Camp Mojache +(@OGUID+26, 179968, 1, 357, 1099, '0', 0, 0, -4379.38720703125, 235.013885498046875, 25.41333770751953125, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+27, 179968, 1, 357, 1099, '0', 0, 0, -4378.95166015625, 241.236114501953125, 25.41333770751953125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+28, 179968, 1, 357, 1099, '0', 0, 0, -4380.03125, 239.892364501953125, 25.41468048095703125, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+29, 179968, 1, 357, 1099, '0', 0, 0, -4378.34033203125, 233.513885498046875, 25.41333770751953125, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+30, 179968, 1, 357, 1099, '0', 0, 0, -4369.63916015625, 236.6180572509765625, 25.41333770751953125, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+31, 179968, 1, 357, 1099, '0', 0, 0, -4371.9375, 242.4305572509765625, 25.41333770751953125, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+32, 179968, 1, 357, 1099, '0', 0, 0, -4373.46728515625, 242.8368072509765625, 25.41333770751953125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+33, 179968, 1, 357, 1099, '0', 0, 0, -4369.47412109375, 238.1805572509765625, 25.41333770751953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+34, 179968, 1, 357, 1099, '0', 0, 0, -4372.30224609375, 232.3229217529296875, 25.41333770751953125, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+35, 179968, 1, 357, 1099, '0', 0, 0, -4373.94287109375, 231.8368072509765625, 25.41473579406738281, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+36, 180353, 1, 357, 1099, '0', 0, 0, -4379.0087890625, 234.0902862548828125, 25.41333770751953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+37, 180353, 1, 357, 1099, '0', 0, 0, -4379.703125, 240.7291717529296875, 25.41417121887207031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+38, 180353, 1, 357, 1099, '0', 0, 0, -4369.486328125, 237.3958282470703125, 25.41333770751953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+39, 180353, 1, 357, 1099, '0', 0, 0, -4373.10595703125, 231.9583282470703125, 25.41333770751953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+40, 180353, 1, 357, 1099, '0', 0, 0, -4372.6787109375, 242.6875, 25.41333770751953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Camp Mojache - Difficulty: 0) +(@OGUID+41, 195164, 1, 357, 1099, '0', 0, 0, -4379.33837890625, 235.0590362548828125, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+42, 195164, 1, 357, 1099, '0', 0, 0, -4373.9912109375, 231.90625, 26.1142425537109375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+43, 195164, 1, 357, 1099, '0', 0, 0, -4378.40966796875, 233.5833282470703125, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+44, 195164, 1, 357, 1099, '0', 0, 0, -4372, 242.4479217529296875, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+45, 195164, 1, 357, 1099, '0', 0, 0, -4369.77783203125, 236.4756927490234375, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+46, 195164, 1, 357, 1099, '0', 0, 0, -4369.56787109375, 238.1527862548828125, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+47, 195164, 1, 357, 1099, '0', 0, 0, -4379.93408203125, 239.84722900390625, 26.11410140991210937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+48, 195164, 1, 357, 1099, '0', 0, 0, -4372.1630859375, 232.44097900390625, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+49, 195164, 1, 357, 1099, '0', 0, 0, -4378.97412109375, 241.19097900390625, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+50, 195164, 1, 357, 1099, '0', 0, 0, -4373.5087890625, 242.7430572509765625, 26.11290931701660156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Camp Mojache - Difficulty: 0) +(@OGUID+51, 195664, 1, 357, 1099, '0', 0, 0, -4375.7001953125, 237.3780059814453125, 25.413299560546875, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Camp Mojache - 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); |