aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_12_29_03_world.sql113
1 files changed, 113 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_29_03_world.sql b/sql/updates/world/master/2022_12_29_03_world.sql
new file mode 100644
index 00000000000..e2dc68d4294
--- /dev/null
+++ b/sql/updates/world/master/2022_12_29_03_world.sql
@@ -0,0 +1,113 @@
+SET @CGUID := 396685;
+SET @OGUID := 252898;
+SET @EVENT := 2;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+1;
+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
+-- Bloodhoof Village
+(@CGUID+0, 15760, 1, 215, 222, '0', 0, 0, 0, 1, -2376.23681640625, -344.289703369140625, -8.87366199493408203, 1.2042771577835083, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213), -- Winter Reveler (Area: Bloodhoof Village - Difficulty: 0) (Auras: )
+(@CGUID+1, 15760, 1, 215, 222, '0', 0, 0, 0, 1, -2375.134033203125, -341.739593505859375, -8.87366008758544921, 4.258603572845458984, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213); -- Winter Reveler (Area: Bloodhoof Village - Difficulty: 0) (Auras: )
+
+DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+0, @CGUID+1);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+0, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26249'), -- 15760 (Winter Reveler)
+(@CGUID+1, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26250'); -- 15760 (Winter Reveler)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+40;
+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
+-- Bloodhoof Village
+(@OGUID+0, 178428, 1, 215, 222, '0', 0, 0, -2324.23388671875, -354.631072998046875, -8.9652566909790039, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 47213), -- XMasGift01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+1, 178428, 1, 215, 222, '0', 0, 0, -2324.060546875, -357.280029296875, -8.97474575042724609, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 47213), -- XMasGift01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+2, 178429, 1, 215, 222, '0', 0, 0, -2325.7236328125, -357.094940185546875, -8.90013504028320312, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 47213), -- XMasGift02 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+3, 178429, 1, 215, 222, '0', 0, 0, -2323.518310546875, -355.367889404296875, -9.00428199768066406, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 47213), -- XMasGift02 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+4, 178430, 1, 215, 222, '0', 0, 0, -2326.216064453125, -357.900360107421875, -8.88105010986328125, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 47213), -- XMasGift03 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+5, 178430, 1, 215, 222, '0', 0, 0, -2324.83251953125, -357.800384521484375, -8.93326568603515625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 47213), -- XMasGift03 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+6, 178430, 1, 215, 222, '0', 0, 0, -2325.5029296875, -354.998687744140625, -8.90624427795410156, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 47213), -- XMasGift03 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+7, 178430, 1, 215, 222, '0', 0, 0, -2322.927001953125, -356.920501708984375, -9.03592777252197265, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 47213), -- XMasGift03 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+8, 178431, 1, 215, 222, '0', 0, 0, -2326.26220703125, -356.126556396484375, -8.88197803497314453, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 47213), -- XMasGift04 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+9, 178431, 1, 215, 222, '0', 0, 0, -2323.673583984375, -356.3856201171875, -8.99519538879394531, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 47213), -- XMasGift04 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+10, 178432, 1, 215, 222, '0', 0, 0, -2324.34423828125, -355.4688720703125, -8.95843696594238281, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 47213), -- XMasGift05 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+11, 178432, 1, 215, 222, '0', 0, 0, -2326.6005859375, -357.029937744140625, -8.8701019287109375, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 47213), -- XMasGift05 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+12, 178433, 1, 215, 222, '0', 0, 0, -2325.374755859375, -356.001220703125, -8.91097164154052734, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 47213), -- XMasGift06 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+13, 178433, 1, 215, 222, '0', 0, 0, -2325.73291015625, -358.70947265625, -8.89445304870605468, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 47213), -- XMasGift06 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+14, 178433, 1, 215, 222, '0', 0, 0, -2323.73193359375, -358.0504150390625, -8.99302005767822265, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 47213), -- XMasGift06 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+15, 178437, 1, 215, 222, '0', 0, 0, -2287.0625, -427.083343505859375, 0.756004989147186279, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 47213), -- Wreath (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+16, 178437, 1, 215, 222, '0', 0, 0, -2332.822998046875, -437.090911865234375, 0.58092498779296875, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 47213), -- Wreath (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+17, 178437, 1, 215, 222, '0', 0, 0, -2301.212890625, -472.051116943359375, 0.688566029071807861, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 47213), -- Wreath (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+18, 178438, 1, 215, 222, '0', 0, 0, -2180.85595703125, -409.421875, 1.336053013801574707, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 47213), -- Lights (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+19, 178438, 1, 215, 222, '0', 0, 0, -2340.760498046875, -359.711822509765625, -0.14785699546337127, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 47213), -- Lights (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+20, 178438, 1, 215, 222, '0', 0, 0, -2400.767333984375, -390.5225830078125, 2.556106090545654296, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 47213), -- Lights (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+21, 178554, 1, 215, 222, '0', 0, 0, -2344.092041015625, -358.151031494140625, -1.95889604091644287, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 47213), -- Mistletoe (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+22, 178647, 1, 215, 222, '0', 0, 0, -2324.55712890625, -356.53289794921875, -8.94748401641845703, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 47213), -- Christmas Tree (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+23, 180844, 1, 215, 222, '0', 0, 0, -2375.9296875, -343.055023193359375, -1.67232000827789306, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 47213), -- Mistletoe (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+24, 187194, 1, 215, 222, '0', 0, 0, -2281.77001953125, -330.8590087890625, 0.345907002687454223, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+25, 187235, 1, 215, 222, '0', 0, 0, -2280.820068359375, -338.37701416015625, -9.42492961883544921, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+26, 187235, 1, 215, 222, '0', 0, 0, -2289.85009765625, -331.8699951171875, -9.42492961883544921, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+27, 187235, 1, 215, 222, '0', 0, 0, -2325.580078125, -391.287994384765625, -7.98294019699096679, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+28, 187235, 1, 215, 222, '0', 0, 0, -2333.27001953125, -386.839996337890625, -7.97006988525390625, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+29, 187235, 1, 215, 222, '0', 0, 0, -2387.830078125, -329.75201416015625, 0.278124988079071044, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+30, 187235, 1, 215, 222, '0', 0, 0, -2371.60009765625, -344.483001708984375, -8.95699024200439453, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+31, 187235, 1, 215, 222, '0', 0, 0, -2393.570068359375, -342.368988037109375, 0.27416500449180603, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+32, 187567, 1, 215, 222, '0', 0, 0, -2181, -409.81500244140625, 0.081097997725009918, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+33, 187567, 1, 215, 222, '0', 0, 0, -2401.169921875, -390.56298828125, 1.973709940910339355, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Bloodhoof Village - Difficulty: 0)
+-- Camp Sungraze
+(@OGUID+34, 187235, 1, 215, 4835, '0', 0, 0, -810.5469970703125, -490.868011474609375, -32.1660995483398437, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Camp Sungraze - Difficulty: 0)
+(@OGUID+35, 187567, 1, 215, 4835, '0', 0, 0, -784.58001708984375, -492.510009765625, -28.5219993591308593, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Camp Sungraze - Difficulty: 0)
+-- Camp Narache
+(@OGUID+36, 187235, 1, 6452, 221, '0', 0, 0, -2883.47998046875, -234.444000244140625, 60.66210174560546875, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Camp Narache - Difficulty: 0)
+(@OGUID+37, 187235, 1, 6452, 221, '0', 0, 0, -2888.5, -229.852005004882812, 60.66759872436523437, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Camp Narache - Difficulty: 0)
+(@OGUID+38, 187235, 1, 6452, 221, '0', 0, 0, -2887.320068359375, -272.4639892578125, 60.17660140991210937, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Camp Narache - Difficulty: 0)
+(@OGUID+39, 187567, 1, 6452, 221, '0', 0, 0, -2918.02001953125, -233.669998168945312, 66.12270355224609375, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Red Cloud Mesa - Difficulty: 0)
+(@OGUID+40, 187567, 1, 6452, 221, '0', 0, 0, -2893.52001953125, -276.930999755859375, 64.2855987548828125, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 47213); -- Hanging, Streamer - Xmas (Area: Camp Narache - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+1;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(@EVENT, @CGUID+0),
+(@EVENT, @CGUID+1);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+40;
+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);