DB/Gameobject: StormPeaks Missing Brewfest spawns

closes #30426 by Foldor1

1 files changed, 32 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_11_12_02_world.sql b/sql/updates/world/3.3.5/2024_11_12_02_world.sql
new file mode 100644
index 00000000000..cc5e493a1c8
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_11_12_02_world.sql
@@ -0,0 +1,32 @@
+--
+SET @OGUID := 48195; -- Need 23
+SET @EVENT := 24;
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+32;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 195266, 571, 67, 4428, 1, 1, 6653.6044921875, -203.622772216796875, 954.6893310546875, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frosthold - Difficulty: 0) CreateObject1
+(@OGUID+1, 195266, 571, 67, 4428, 1, 1, 6663.80712890625, -184.669891357421875, 958.21551513671875, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frosthold - Difficulty: 0) CreateObject1
+(@OGUID+2, 195266, 571, 67, 4428, 1, 1, 6654.4990234375, -190.976272583007812, 956.8074951171875, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frosthold - Difficulty: 0) CreateObject1
+(@OGUID+3, 195256, 571, 67, 4429, 1, 1, 7850.470703125, -793.32989501953125, 1183.955078125, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Grom'arsh Crash-Site - Difficulty: 0) CreateObject1
+(@OGUID+4, 195256, 571, 67, 4429, 1, 1, 7879.49853515625, -759.57012939453125, 1175.3660888671875, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Grom'arsh Crash-Site - Difficulty: 0) CreateObject1
+(@OGUID+5, 195256, 571, 67, 4429, 1, 1, 7856.44189453125, -742.138916015625, 1177.6876220703125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Grom'arsh Crash-Site - Difficulty: 0) CreateObject1
+(@OGUID+6, 195259, 571, 67, 4429, 1, 1, 7856.078125, -735.815673828125, 1178.389404296875, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Grom'arsh Crash-Site - Difficulty: 0) CreateObject1
+(@OGUID+7, 195256, 571, 67, 4441, 1, 1, 7816.5849609375, -2769.4921875, 1188.7803955078125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+8, 195256, 571, 67, 4441, 1, 1, 7791.91650390625, -2804.66845703125, 1216.7884521484375, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+9, 195259, 571, 67, 4441, 1, 1, 7795.13720703125, -2808.116455078125, 1217.7559814453125, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+10, 195256, 571, 67, 4441, 1, 1, 7776.33837890625, -2838.651123046875, 1217.1214599609375, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+11, 195256, 571, 67, 4441, 1, 1, 7825.24072265625, -2903.61279296875, 1240.8853759765625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+12, 195266, 571, 67, 4441, 1, 1, 7801.470703125, -2961.203125, 1263.813232421875, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+13, 195257, 571, 67, 4441, 1, 1, 7797.767578125, -2957.82763671875, 1261.513671875, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+14, 195266, 571, 67, 4441, 1, 1, 7799.6337890625, -2964.865966796875, 1264.69921875, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+15, 195257, 571, 67, 4441, 1, 1, 7806.43212890625, -2962.62890625, 1261.4276123046875, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+16, 195260, 571, 67, 4441, 1, 1, 7809.75341796875, -2956.811279296875, 1259.6474609375, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+17, 195263, 571, 67, 4441, 1, 1, 7802.56689453125, -2958.5283203125, 1264.48193359375, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 0), -- Hanging, Square, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+18, 195256, 571, 67, 4441, 1, 1, 7819.58251953125, -2965.007080078125, 1257.747314453125, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+19, 195256, 571, 67, 4441, 1, 1, 7784.9697265625, -2964.5390625, 1259, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+20, 195256, 571, 67, 4441, 1, 1, 7794.875, -2944.564208984375, 1257.248291015625, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+21, 195259, 571, 67, 4441, 1, 1, 7817.0693359375, -2963.26904296875, 1259.724609375, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+(@OGUID+22, 195256, 571, 67, 4441, 1, 1, 7807.439453125, -2977.43408203125, 1258.9766845703125, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 0); -- Standing, Exterior, Medium - Brewfest (Area: Camp Tunka'lo - Difficulty: 0) CreateObject1
+
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+32 AND `eventEntry`=@EVENT;
+INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+32;