DB/Gameobject: Grizzly Hills Missing Brewfest spawns

closes #30433 by Foldor1

1 files changed, 132 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_11_12_07_world.sql b/sql/updates/world/3.3.5/2024_11_12_07_world.sql
new file mode 100644
index 00000000000..26b4cadf39d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_11_12_07_world.sql
@@ -0,0 +1,132 @@
+--
+SET @OGUID := 93212; -- Need 123
+SET @EVENT := 24;
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+122;
+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, 195259, 571, 394, 4159, 1, 1, 4588.76904296875, -4259.3974609375, 183.012725830078125, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+1, 195256, 571, 394, 4159, 1, 1, 4578.9130859375, -4263.68212890625, 182.0264434814453125, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+2, 195256, 571, 394, 4159, 1, 1, 4549.17822265625, -4253.70751953125, 170.7494049072265625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+3, 195256, 571, 394, 4159, 1, 1, 4585.376953125, -4225.4306640625, 178.0588226318359375, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+4, 195256, 571, 394, 4159, 1, 1, 4574.1748046875, -4252.90234375, 182.207916259765625, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+5, 195256, 571, 394, 4159, 1, 1, 4554.02978515625, -4232.88720703125, 170.6884307861328125, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+6, 195255, 571, 394, 4159, 1, 1, 4524.68408203125, -4252.0185546875, 177.024627685546875, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+7, 195266, 571, 394, 4159, 1, 1, 4551.2802734375, -4238.45703125, 173.6894989013671875, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+8, 195266, 571, 394, 4159, 1, 1, 4596.6259765625, -4237.6162109375, 181.892181396484375, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+9, 195259, 571, 394, 4159, 1, 1, 4608.650390625, -4233.8955078125, 181.3111572265625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+10, 195256, 571, 394, 4159, 1, 1, 4544.07275390625, -4208.38623046875, 170.67333984375, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+11, 195256, 571, 394, 4159, 1, 1, 4604.29931640625, -4216.10986328125, 178.7165374755859375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+12, 195259, 571, 394, 4159, 1, 1, 4583.4599609375, -4214.486328125, 178.7119903564453125, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+13, 195259, 571, 394, 4159, 1, 1, 4516.88134765625, -4237.6982421875, 172.096099853515625, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+14, 195259, 571, 394, 4159, 1, 1, 4525.02587890625, -4220.74462890625, 171.4342803955078125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+15, 195256, 571, 394, 4159, 1, 1, 4531.97900390625, -4176.56103515625, 173.4835968017578125, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+16, 195256, 571, 394, 4159, 1, 1, 4550.19091796875, -4182.83642578125, 173.4988555908203125, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+17, 195259, 571, 394, 4159, 1, 1, 4545.50537109375, -4198.65283203125, 174.6675567626953125, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+18, 195255, 571, 394, 4159, 1, 1, 4532.3466796875, -4148.5302734375, 182.7989044189453125, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+19, 195259, 571, 394, 4159, 1, 1, 4530.67822265625, -4141.923828125, 175.909332275390625, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+20, 195259, 571, 394, 4159, 1, 1, 4524.59814453125, -4165.27978515625, 174.0964508056640625, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+21, 195259, 571, 394, 4159, 1, 1, 4456.92236328125, -4314.45556640625, 160.9202117919921875, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Westfall Brigade Encampment - Difficulty: 0) CreateObject1
+(@OGUID+22, 195256, 571, 394, 4211, 1, 1, 3883.56591796875, -4522.05712890625, 217.3779754638671875, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Solstice Village - Difficulty: 0) CreateObject1
+(@OGUID+23, 195255, 571, 394, 4211, 1, 1, 3881.885986328125, -4516.8974609375, 223.729248046875, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+24, 195259, 571, 394, 4211, 1, 1, 3876.389892578125, -4523.8134765625, 218.0924530029296875, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+25, 195256, 571, 394, 4211, 1, 1, 3866.0244140625, -4531.32470703125, 209.7258758544921875, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+26, 195264, 571, 394, 4211, 1, 1, 3877.072509765625, -4546.67822265625, 210.9720001220703125, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+27, 195260, 571, 394, 4211, 1, 1, 3873.443115234375, -4541.18505859375, 210.1432647705078125, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+28, 195264, 571, 394, 4211, 1, 1, 3874.092529296875, -4541.466796875, 210.1389007568359375, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+29, 195273, 571, 394, 4211, 1, 1, 3876.380126953125, -4541.03125, 209.7021484375, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+30, 195260, 571, 394, 4211, 1, 1, 3876.73779296875, -4547.53125, 210.96728515625, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+31, 195273, 571, 394, 4211, 1, 1, 3865.14501953125, -4556.1748046875, 211.0864410400390625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+32, 195256, 571, 394, 4211, 1, 1, 3871.14501953125, -4567.24462890625, 207.544708251953125, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+33, 195260, 571, 394, 4211, 1, 1, 3862.3212890625, -4549.05517578125, 211.58984375, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+34, 195256, 571, 394, 4211, 1, 1, 3844.86767578125, -4517.59375, 210.5048370361328125, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+35, 195256, 571, 394, 4211, 1, 1, 3848.001708984375, -4506.845703125, 207.78558349609375, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+36, 195256, 571, 394, 4211, 1, 1, 3854.529541015625, -4499.98291015625, 208.038604736328125, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+37, 195273, 571, 394, 4211, 1, 1, 3858.30078125, -4564.548828125, 210.174102783203125, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+38, 195273, 571, 394, 4211, 1, 1, 3854.253173828125, -4497.0986328125, 208.4462890625, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+39, 195273, 571, 394, 4211, 1, 1, 3845.2626953125, -4506.48291015625, 208.087860107421875, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+40, 195256, 571, 394, 4211, 1, 1, 3847.24560546875, -4556.36474609375, 210.1267852783203125, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+41, 195256, 571, 394, 4211, 1, 1, 3835.150146484375, -4527.1494140625, 210.6371307373046875, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+42, 195264, 571, 394, 4211, 1, 1, 3838.455810546875, -4544.68408203125, 209.2908935546875, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Camp Oneqwah - Difficulty: 0) CreateObject1
+(@OGUID+43, 195256, 571, 394, 4229, 1, 1, 3818.5986328125, -5155.80908203125, 119.0596237182617187, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Prospector's Point - Difficulty: 0) CreateObject1
+(@OGUID+44, 195257, 571, 394, 4229, 1, 1, 3822.3515625, -5152.14404296875, 122.9666213989257812, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Prospector's Point - Difficulty: 0) CreateObject1
+(@OGUID+45, 195257, 571, 394, 4229, 1, 1, 3814.752685546875, -5158.24462890625, 123.3370208740234375, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Prospector's Point - Difficulty: 0) CreateObject1
+(@OGUID+46, 195256, 571, 394, 4204, 1, 1, 3432.5625, -2829.0361328125, 201.703643798828125, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+47, 195256, 571, 394, 4204, 1, 1, 3413.370361328125, -2812.23095703125, 200.457550048828125, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+48, 195266, 571, 394, 4204, 1, 1, 3396.490234375, -2809.564697265625, 207.413726806640625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+49, 195266, 571, 394, 4204, 1, 1, 3407.77783203125, -2803.8828125, 205.8443145751953125, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+50, 195253, 571, 394, 4204, 1, 1, 3415.611572265625, -2804.817626953125, 207.874542236328125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+51, 195257, 571, 394, 4204, 1, 1, 3421.742431640625, -2795.542236328125, 203.7708282470703125, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+52, 195259, 571, 394, 4204, 1, 1, 3454.6015625, -2802.049072265625, 202.4846343994140625, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+53, 195253, 571, 394, 4204, 1, 1, 3426.070068359375, -2797.111328125, 207.8059844970703125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+54, 195257, 571, 394, 4204, 1, 1, 3416.353759765625, -2799.534912109375, 203.6573638916015625, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+55, 195256, 571, 394, 4204, 1, 1, 3457.1279296875, -2785.356689453125, 201.2522735595703125, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Amberpine Lodge - Difficulty: 0) CreateObject1
+(@OGUID+56, 195253, 571, 394, 4206, 1, 1, 3248.33447265625, -2376.1298828125, 125.8162994384765625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+57, 195255, 571, 394, 4206, 1, 1, 3300.6015625, -2378.8994140625, 117.8946762084960937, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+58, 195255, 571, 394, 4206, 1, 1, 3282.833251953125, -2368.123291015625, 117.8988037109375, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+59, 195253, 571, 394, 4206, 1, 1, 3272.99169921875, -2376.118408203125, 126.1800537109375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+60, 195255, 571, 394, 4206, 1, 1, 3311.09326171875, -2361.425048828125, 117.9167327880859375, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+61, 195255, 571, 394, 4206, 1, 1, 3293.471435546875, -2350.23779296875, 117.6906509399414062, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+62, 195256, 571, 394, 4206, 1, 1, 3302.054443359375, -2350.771240234375, 108.88916015625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+63, 195253, 571, 394, 4206, 1, 1, 3313.639892578125, -2339.25927734375, 135.3806304931640625, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+64, 195256, 571, 394, 4206, 1, 1, 3316.352783203125, -2328.825439453125, 111.091400146484375, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+65, 195253, 571, 394, 4206, 1, 1, 3220.80810546875, -2360.81640625, 129.0979461669921875, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+66, 195260, 571, 394, 4206, 1, 1, 3313.64697265625, -2337.28125, 112.4452133178710937, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+67, 195253, 571, 394, 4206, 1, 1, 3207.483154296875, -2339.074462890625, 129.03857421875, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+68, 195253, 571, 394, 4206, 1, 1, 3194.915283203125, -2304.802978515625, 131.448150634765625, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+69, 195256, 571, 394, 4206, 1, 1, 3225.8291015625, -2298.3994140625, 107.2934036254882812, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+70, 195260, 571, 394, 4206, 1, 1, 3201.634033203125, -2297.766845703125, 109.0517196655273437, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Conquest Hold  - Difficulty: 0) CreateObject1
+(@OGUID+71, 195263, 571, 394, 4206, 1, 1, 3194.85546875, -2292.01611328125, 108.0623779296875, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 0), -- Hanging, Square, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+72, 195256, 571, 394, 4206, 1, 1, 3184.45751953125, -2253.97314453125, 114.862762451171875, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+73, 195256, 571, 394, 4206, 1, 1, 3237.112060546875, -2271.501708984375, 113.9171981811523437, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+74, 195266, 571, 394, 4206, 1, 1, 3270.23046875, -2299.0166015625, 105.3504867553710937, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+75, 195253, 571, 394, 4206, 1, 1, 3191.101806640625, -2279.25439453125, 131.501220703125, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+76, 195255, 571, 394, 4206, 1, 1, 3193.161376953125, -2253.91259765625, 117.8537979125976562, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+77, 195263, 571, 394, 4206, 1, 1, 3264.849853515625, -2273.001220703125, 109.3768386840820312, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 0), -- Hanging, Square, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject
+(@OGUID+78, 195256, 571, 394, 4206, 1, 1, 3267.522705078125, -2271.92529296875, 114.2197036743164062, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+79, 195260, 571, 394, 4206, 1, 1, 3240.246826171875, -2236.566162109375, 117.1561431884765625, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+80, 195259, 571, 394, 4206, 1, 1, 3263.252685546875, -2264.286865234375, 115.017852783203125, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+81, 195263, 571, 394, 4206, 1, 1, 3272.4453125, -2284.549560546875, 109.6323165893554687, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 0), -- Hanging, Square, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+82, 195259, 571, 394, 4206, 1, 1, 3259.02099609375, -2267.587158203125, 114.3780288696289062, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+83, 195256, 571, 394, 4206, 1, 1, 3248.891845703125, -2223.040283203125, 116.8296966552734375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+84, 195266, 571, 394, 4206, 1, 1, 3253.43408203125, -2199.932373046875, 127.3123626708984375, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+85, 195266, 571, 394, 4206, 1, 1, 3272.255126953125, -2192.747802734375, 127.4287490844726562, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+86, 195256, 571, 394, 4206, 1, 1, 3268.58544921875, -2230.66064453125, 116.8296966552734375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+87, 195256, 571, 394, 4206, 1, 1, 3286.429443359375, -2201.52294921875, 117.3725967407226562, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+88, 195266, 571, 394, 4206, 1, 1, 3280.344970703125, -2211.23193359375, 127.408203125, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+89, 195253, 571, 394, 4206, 1, 1, 3325.67529296875, -2187.1416015625, 134.12451171875, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+90, 195255, 571, 394, 4206, 1, 1, 3336.53369140625, -2207.365478515625, 120.0340728759765625, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+91, 195256, 571, 394, 4206, 1, 1, 3344.211669921875, -2203.409912109375, 119.4522705078125, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+92, 195256, 571, 394, 4206, 1, 1, 3308.39501953125, -2221.642333984375, 115.8079681396484375, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+93, 195256, 571, 394, 4206, 1, 1, 3352.523193359375, -2221.0791015625, 119.4522705078125, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+94, 195255, 571, 394, 4206, 1, 1, 3346.118408203125, -2225.081787109375, 119.375030517578125, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+95, 195253, 571, 394, 4206, 1, 1, 3351.66796875, -2245.885498046875, 137.426025390625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+96, 195256, 571, 394, 4206, 1, 1, 3294.6728515625, -2261.470458984375, 111.9283218383789062, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+97, 195253, 571, 394, 4206, 1, 1, 3342.093994140625, -2281.307373046875, 137.6797637939453125, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+98, 195256, 571, 394, 4206, 1, 1, 3323.304443359375, -2296.871826171875, 110.109283447265625, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+99, 195253, 571, 394, 4206, 1, 1, 3331.026611328125, -2305.594970703125, 137.53759765625, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+100, 195263, 571, 394, 4206, 1, 1, 3281.507568359375, -2289.552978515625, 109.7591781616210937, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 0), -- Hanging, Square, Medium - Brewfest (Area: Conquest Hold - Difficulty: 0) CreateObject1
+(@OGUID+101, 195256, 571, 394, 4242, 1, 1, 2538.16455078125, -1999.589599609375, 8.439572334289550781, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+102, 195256, 571, 394, 4242, 1, 1, 2549.787353515625, -1992.144775390625, 8.439572334289550781, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+103, 195256, 571, 394, 4242, 1, 1, 2493.72705078125, -1921.8819580078125, 10.72952842712402343, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+104, 195256, 571, 394, 4242, 1, 1, 2546.96533203125, -1915.29345703125, 2.871465921401977539, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+105, 195256, 571, 394, 4242, 1, 1, 2547.7998046875, -1930.666259765625, 3.251395940780639648, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+106, 195256, 571, 394, 4242, 1, 1, 2503.9619140625, -1936.4486083984375, 10.39561176300048828, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+107, 195253, 571, 394, 4242, 1, 1, 2495.748046875, -1930.49267578125, 18.890869140625, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+108, 195256, 571, 394, 4242, 1, 1, 2485.73681640625, -1895.5426025390625, 10.02251052856445312, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+109, 195256, 571, 394, 4242, 1, 1, 2485.413330078125, -1882.3096923828125, 9.955285072326660156, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+110, 195253, 571, 394, 4242, 1, 1, 2482.12109375, -1838.0968017578125, 19.10610771179199218, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+111, 195253, 571, 394, 4242, 1, 1, 2493.71923828125, -1840.646240234375, 18.18875885009765625, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+112, 195256, 571, 394, 4242, 1, 1, 2546.4873046875, -1837.44384765625, 10.57294368743896484, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+113, 195253, 571, 394, 4242, 1, 1, 2510.754150390625, -1823.16259765625, 18.16746330261230468, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+114, 195256, 571, 394, 4242, 1, 1, 2438.87548828125, -1853.4410400390625, 1.204813957214355468, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+115, 195256, 571, 394, 4242, 1, 1, 2444.650634765625, -1838.691162109375, 1.022343039512634277, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+116, 195256, 571, 394, 4242, 1, 1, 2497.920166015625, -1838.302978515625, 10.55218505859375, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+117, 195253, 571, 394, 4242, 1, 1, 2502.159423828125, -1831.97314453125, 18.18279266357421875, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+118, 195256, 571, 394, 4242, 1, 1, 2491.8291015625, -1845.1595458984375, 10.70640087127685546, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+119, 195256, 571, 394, 4242, 1, 1, 2559.23046875, -1828.40283203125, 10.51216411590576171, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+120, 195253, 571, 394, 4242, 1, 1, 2508.89111328125, -1811.1556396484375, 18.57204437255859375, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+121, 195256, 571, 394, 4242, 1, 1, 2600.052734375, -1802.4447021484375, 10.64246273040771484, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+(@OGUID+122, 195256, 571, 394, 4242, 1, 1, 2595.77978515625, -1789.1341552734375, 10.64246177673339843, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 0); -- Standing, Exterior, Medium - Brewfest (Area: Venture Bay - Difficulty: 0) CreateObject1
+
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+122 AND `eventEntry`=@EVENT;
+INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+122;