DB/Gameobject: Howling Fjord: Missing Brewfest spawns

closes #30434 by Foldor1

1 files changed, 206 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_11_12_08_world.sql b/sql/updates/world/3.3.5/2024_11_12_08_world.sql
new file mode 100644
index 00000000000..6e678b487b5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_11_12_08_world.sql
@@ -0,0 +1,206 @@
+--
+SET @OGUID := 93335; -- Need 197
+SET @EVENT := 24;
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+196;
+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, 495, 4062, 1, 1, 2127.25, -2962.01904296875, 155.307586669921875, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+1, 195256, 571, 495, 4062, 1, 1, 2117.1181640625, -2965.381591796875, 148.6168670654296875, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+2, 195266, 571, 495, 4062, 1, 1, 2122.88720703125, -2959.94287109375, 155.2806854248046875, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+3, 195266, 571, 495, 4062, 1, 1, 2124.927490234375, -2955.5634765625, 154.968414306640625, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+4, 195266, 571, 495, 4062, 1, 1, 2129.3310546875, -2957.728759765625, 155.2841796875, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+5, 195266, 571, 495, 4062, 1, 1, 2132.39404296875, -2996.244873046875, 155.843231201171875, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+6, 195256, 571, 495, 4062, 1, 1, 2142.095703125, -2984.89208984375, 148.91650390625, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+7, 195256, 571, 495, 4062, 1, 1, 2109.81591796875, -2988.44970703125, 148.3804473876953125, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+8, 195266, 571, 495, 4062, 1, 1, 2125.528564453125, -2997.119873046875, 155.7462615966796875, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+9, 195256, 571, 495, 4062, 1, 1, 2140.401123046875, -2968.3994140625, 148.33563232421875, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+10, 195266, 571, 495, 4062, 1, 1, 2128.5087890625, -2993.26904296875, 155.7663116455078125, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+11, 195266, 571, 495, 4062, 1, 1, 2129.307373046875, -3000.026123046875, 155.8247222900390625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Apothecary Camp - Difficulty: 0) CreateObject1
+(@OGUID+12, 195256, 571, 495, 4018, 1, 1, 2642.450439453125, -4384.39404296875, 283.269317626953125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+13, 195256, 571, 495, 4018, 1, 1, 2654.309814453125, -4365.0380859375, 277.507476806640625, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+14, 195256, 571, 495, 4018, 1, 1, 2620.653564453125, -4361.46142578125, 276.49017333984375, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+15, 195256, 571, 495, 4018, 1, 1, 2657.28466796875, -4403.33837890625, 283.921661376953125, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+16, 195256, 571, 495, 4018, 1, 1, 2675.205810546875, -4331.74853515625, 289.77642822265625, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+17, 195266, 571, 495, 4018, 1, 1, 2673.549072265625, -4383.2900390625, 290.49188232421875, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+18, 195259, 571, 495, 4018, 1, 1, 2653.467041015625, -4398.361328125, 284.529449462890625, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+19, 195259, 571, 495, 4018, 1, 1, 2645.27880859375, -4389.67822265625, 283.946197509765625, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+20, 195260, 571, 495, 4018, 1, 1, 2676.61669921875, -4381.39453125, 285.759613037109375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+21, 195256, 571, 495, 4018, 1, 1, 2681.397705078125, -4378.91162109375, 282.961212158203125, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+22, 195257, 571, 495, 4018, 1, 1, 2677.323486328125, -4386.642578125, 290.094268798828125, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+23, 195257, 571, 495, 4018, 1, 1, 2681.623291015625, -4397.51220703125, 285.5596923828125, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+24, 195260, 571, 495, 4018, 1, 1, 2688.802001953125, -4390.22998046875, 285.700103759765625, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+25, 195257, 571, 495, 4018, 1, 1, 2678.708251953125, -4395.55712890625, 285.5654296875, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+26, 195256, 571, 495, 4018, 1, 1, 2681.611083984375, -4385.32421875, 284.433746337890625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Camp Winterhoof - Difficulty: 0) CreateObject1
+(@OGUID+27, 195266, 571, 495, 4003, 1, 1, 2501.50537109375, -5059.52490234375, 285.9002685546875, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+28, 195256, 571, 495, 4003, 1, 1, 2462.8271484375, -5023.974609375, 283.71392822265625, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+29, 195256, 571, 495, 4003, 1, 1, 2464.11669921875, -5036.9130859375, 283.756134033203125, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+30, 195259, 571, 495, 4003, 1, 1, 2499.96435546875, -5059.01953125, 286.9637451171875, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+31, 195266, 571, 495, 4003, 1, 1, 2485.302490234375, -5048.4013671875, 296.412353515625, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+32, 195266, 571, 495, 4003, 1, 1, 2496.864013671875, -5066.93310546875, 302.693145751953125, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+33, 195256, 571, 495, 4003, 1, 1, 2476.259765625, -5072.8115234375, 283.03717041015625, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+34, 195266, 571, 495, 4003, 1, 1, 2469.69970703125, -5056.40966796875, 296.069091796875, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+35, 195259, 571, 495, 4003, 1, 1, 2474.880859375, -5069.70947265625, 286.004119873046875, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+36, 195266, 571, 495, 4003, 1, 1, 2477.305908203125, -5073.56103515625, 291.637451171875, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+37, 195259, 571, 495, 4003, 1, 1, 2491.536376953125, -5071.005859375, 298.8145751953125, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+38, 195259, 571, 495, 4003, 1, 1, 2472.168212890625, -5058.8740234375, 292.487213134765625, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+39, 195266, 571, 495, 4003, 1, 1, 2483.536376953125, -5065.3662109375, 301.697540283203125, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+40, 195259, 571, 495, 4003, 1, 1, 2472.028564453125, -5066.28125, 286.071380615234375, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+41, 195266, 571, 495, 4003, 1, 1, 2475.982421875, -5063.1513671875, 289.160797119140625, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Frostblade Peak - Difficulty: 0) CreateObject1
+(@OGUID+42, 195256, 571, 495, 4003, 1, 1, 2422.8447265625, -5074.8505859375, 272.242706298828125, 0, 0, 0, 0, 1, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Fort Wildervar - Difficulty: 0) CreateObject1
+(@OGUID+43, 195256, 571, 495, 4003, 1, 1, 2438.944580078125, -5120.9755859375, 275.9085693359375, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Fort Wildervar - Difficulty: 0) CreateObject1
+(@OGUID+44, 195256, 571, 495, 4003, 1, 1, 2417.9619140625, -5122.1416015625, 276.593963623046875, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Fort Wildervar - Difficulty: 0) CreateObject1
+(@OGUID+45, 195256, 571, 495, 4003, 1, 1, 2429.50341796875, -5159.25, 277.0015869140625, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Fort Wildervar - Difficulty: 0) CreateObject1
+(@OGUID+46, 195256, 571, 495, 4003, 1, 1, 2429.84716796875, -5168.77587890625, 277.110870361328125, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Fort Wildervar - Difficulty: 0) CreateObject1
+(@OGUID+47, 195266, 571, 495, 4000, 1, 1, 1955.9967041015625, -6111.82958984375, 41.53107452392578125, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+48, 195266, 571, 495, 4000, 1, 1, 1971.8021240234375, -6102.19775390625, 73.710601806640625, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+49, 195266, 571, 495, 4000, 1, 1, 1960.259521484375, -6117.28662109375, 41.52031326293945312, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+50, 195266, 571, 495, 4000, 1, 1, 1966.4713134765625, -6119.72265625, 41.52581024169921875, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+51, 195266, 571, 495, 4000, 1, 1, 1949.329833984375, -6147.3056640625, 31.00298500061035156, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+52, 195256, 571, 495, 4000, 1, 1, 1919.9151611328125, -6182.5986328125, 24.47692298889160156, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+53, 195257, 571, 495, 4532, 1, 1, 1891.3333740234375, -6175.7236328125, 26.62350845336914062, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+54, 195256, 571, 495, 4000, 1, 1, 1927.3294677734375, -6186.8359375, 24.11248397827148437, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+55, 195256, 571, 495, 4000, 1, 1, 1882.5814208984375, -6170.53076171875, 23.82955741882324218, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+56, 195273, 571, 495, 4532, 1, 1, 1896.3685302734375, -6177.45849609375, 28.25125503540039062, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+57, 195273, 571, 495, 4532, 1, 1, 1900.7137451171875, -6182.30615234375, 31.16156959533691406, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+58, 195256, 571, 495, 4000, 1, 1, 1899.3099365234375, -6178.33203125, 24.02913856506347656, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+59, 195273, 571, 495, 4532, 1, 1, 1889.537353515625, -6174.26025390625, 27.78375434875488281, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+60, 195257, 571, 495, 4532, 1, 1, 1894.1710205078125, -6177.046875, 26.61498832702636718, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+61, 195266, 571, 495, 4000, 1, 1, 1933.8350830078125, -6188.439453125, 30.40494155883789062, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+62, 195273, 571, 495, 4532, 1, 1, 1883.0047607421875, -6173.48095703125, 30.73777008056640625, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+63, 195273, 571, 495, 4532, 1, 1, 1892.77783203125, -6183.73583984375, 25.80629158020019531, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+64, 195273, 571, 495, 4532, 1, 1, 1886.857421875, -6181.00341796875, 26.00834846496582031, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+65, 195256, 571, 495, 4000, 1, 1, 2021.9947509765625, -6214.67822265625, 7.750906944274902343, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Vengeance Landing - Difficulty: 0) CreateObject1
+(@OGUID+66, 195257, 571, 495, 4532, 1, 1, 1872.6788330078125, -6195.767578125, 26.33468437194824218, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+67, 195257, 571, 495, 4532, 1, 1, 1890.347900390625, -6204.115234375, 26.52462577819824218, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+68, 195266, 571, 495, 4532, 1, 1, 1881.4010009765625, -6201.0380859375, 33.84504318237304687, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+69, 195273, 571, 495, 4532, 1, 1, 1869.909912109375, -6225.537109375, 14.98772907257080078, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+70, 195266, 571, 495, 4532, 1, 1, 1872.57861328125, -6219.77392578125, 42.40207672119140625, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1
+(@OGUID+71, 195259, 571, 495, 0, 1, 1, 1420.2181396484375, -3720.072998046875, 139.7719268798828125, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+72, 195256, 571, 495, 3998, 1, 1, 1351.6649169921875, -3457.366455078125, 175.92462158203125, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+73, 195256, 571, 495, 3998, 1, 1, 1400.15625, -3458.59033203125, 174.57183837890625, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+74, 195255, 571, 495, 3998, 1, 1, 1390.8802490234375, -3366.663330078125, 194.8545074462890625, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+75, 195255, 571, 495, 3998, 1, 1, 1350.9930419921875, -3356.947998046875, 196.8577423095703125, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+76, 195256, 571, 495, 3998, 1, 1, 1370.0364990234375, -3334.958251953125, 173.6849517822265625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+77, 195256, 571, 495, 3998, 1, 1, 1394.3992919921875, -3307.069580078125, 166.7923126220703125, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+78, 195256, 571, 495, 3998, 1, 1, 1349.4683837890625, -3297.907470703125, 174.712890625, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+79, 195256, 571, 495, 3998, 1, 1, 1401.3507080078125, -3262.329345703125, 163.0069122314453125, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+80, 195256, 571, 495, 3998, 1, 1, 1341.441650390625, -3276.220947265625, 174.6176910400390625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+81, 195266, 571, 495, 3998, 1, 1, 1425.03125, -3316.349365234375, 173.511322021484375, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+82, 195256, 571, 495, 3998, 1, 1, 1352.595947265625, -3284.4013671875, 174.7100830078125, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+83, 195257, 571, 495, 3998, 1, 1, 1438.02783203125, -3267.56591796875, 169.51300048828125, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+84, 195266, 571, 495, 3998, 1, 1, 1426.4947509765625, -3265.442626953125, 172.1591796875, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+85, 195264, 571, 495, 3998, 1, 1, 1422.9478759765625, -3265.15283203125, 165.6198883056640625, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+86, 195257, 571, 495, 3998, 1, 1, 1437.1353759765625, -3266.9150390625, 169.50579833984375, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+87, 195257, 571, 495, 3998, 1, 1, 1427.001708984375, -3268.350830078125, 169.1820831298828125, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+88, 195257, 571, 495, 3998, 1, 1, 1429.5816650390625, -3265.2744140625, 169.2191925048828125, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+89, 195266, 571, 495, 3998, 1, 1, 1428.7725830078125, -3274.498291015625, 181.041748046875, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+90, 195257, 571, 495, 3998, 1, 1, 1431.482666015625, -3274.532958984375, 169.1914825439453125, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+91, 195273, 571, 495, 3998, 1, 1, 1421.9583740234375, -3261.317626953125, 175.985443115234375, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+92, 195256, 571, 495, 3998, 1, 1, 1435.888916015625, -3265.0625, 178.281341552734375, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+93, 195264, 571, 495, 3998, 1, 1, 1425.6666259765625, -3261.8369140625, 165.59271240234375, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+94, 195260, 571, 495, 3998, 1, 1, 1457.2899169921875, -3270.154541015625, 173.5816192626953125, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+95, 195266, 571, 495, 3998, 1, 1, 1465.5989990234375, -3290.569580078125, 178.728485107421875, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+96, 195257, 571, 495, 3998, 1, 1, 1454.4930419921875, -3273.579833984375, 168.527313232421875, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+97, 195256, 571, 495, 3998, 1, 1, 1428.2559814453125, -3256.800048828125, 165.614959716796875, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+98, 195260, 571, 495, 3998, 1, 1, 1447.376708984375, -3267.913330078125, 179.70086669921875, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+99, 195260, 571, 495, 3998, 1, 1, 1445.7447509765625, -3269.810791015625, 179.7055511474609375, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+100, 195260, 571, 495, 3998, 1, 1, 1445.814208984375, -3264.553955078125, 168.4409942626953125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+101, 195266, 571, 495, 3998, 1, 1, 1474.51806640625, -3279.563232421875, 178.9401397705078125, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+102, 195260, 571, 495, 3998, 1, 1, 1456.939208984375, -3279.14404296875, 173.58538818359375, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+103, 195260, 571, 495, 3998, 1, 1, 1454.4375, -3273.76220703125, 173.581878662109375, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+104, 195260, 571, 495, 3998, 1, 1, 1458.5521240234375, -3277.08154296875, 173.58538818359375, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+105, 195260, 571, 495, 3998, 1, 1, 1447.826416015625, -3262.189208984375, 168.4409942626953125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+106, 195266, 571, 495, 3998, 1, 1, 1431.548095703125, -3252.89404296875, 183.7872772216796875, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+107, 195264, 571, 495, 3998, 1, 1, 1432.4129638671875, -3253.822021484375, 166.5709686279296875, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+108, 195256, 571, 495, 3998, 1, 1, 1408.13037109375, -3251.247314453125, 162.0142974853515625, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+109, 195256, 571, 495, 3998, 1, 1, 1355.770751953125, -3193.905029296875, 162.8225250244140625, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+110, 195257, 571, 495, 3998, 1, 1, 1445.7396240234375, -3257.578125, 169.240325927734375, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+111, 195266, 571, 495, 3998, 1, 1, 1449.8897705078125, -3254.639404296875, 183.129852294921875, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+112, 195266, 571, 495, 3998, 1, 1, 1461.296630859375, -3264.23828125, 183.4601287841796875, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+113, 195256, 571, 495, 3998, 1, 1, 1371.2991943359375, -3185.6533203125, 162.822479248046875, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+114, 195256, 571, 495, 3998, 1, 1, 1458.7532958984375, -3200.10009765625, 165.5916900634765625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+115, 195256, 571, 495, 3998, 1, 1, 1431.1324462890625, -3152.292236328125, 164.81585693359375, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+116, 195256, 571, 495, 3998, 1, 1, 1429.0374755859375, -3131.0703125, 167.7346038818359375, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+117, 195256, 571, 495, 3998, 1, 1, 1416.0601806640625, -3120.2861328125, 167.5702056884765625, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+118, 195256, 571, 495, 3998, 1, 1, 1389.0931396484375, -3096.109375, 167.4994659423828125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Westguard Keep - Difficulty: 0) CreateObject1
+(@OGUID+119, 195256, 571, 495, 3988, 1, 1, 784.982666015625, -2956.30029296875, 8.627841949462890625, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+120, 195256, 571, 495, 3988, 1, 1, 807.62677001953125, -2945.673583984375, 6.90543985366821289, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+121, 195256, 571, 495, 3988, 1, 1, 811.69793701171875, -2925.720458984375, 7.491168022155761718, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+122, 195256, 571, 495, 3988, 1, 1, 786.56964111328125, -2895.315673828125, 7.33187723159790039, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+123, 195256, 571, 495, 3988, 1, 1, 765.16839599609375, -2962.79345703125, 9.955371856689453125, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+124, 195259, 571, 495, 3988, 1, 1, 789.05792236328125, -2887.321533203125, 6.061471939086914062, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+125, 195256, 571, 495, 3988, 1, 1, 728.25341796875, -2936.780029296875, 8.085320472717285156, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+126, 195259, 571, 495, 3988, 1, 1, 737.04168701171875, -2925.069580078125, 7.038447856903076171, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+127, 195256, 571, 495, 3988, 1, 1, 731.57293701171875, -2945.84375, 9.6584320068359375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+128, 195256, 571, 495, 3988, 1, 1, 738.81585693359375, -2917.705810546875, 7.835750102996826171, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+129, 195256, 571, 495, 3988, 1, 1, 785.8663330078125, -2882.145751953125, 4.52708292007446289, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+130, 195256, 571, 495, 3988, 1, 1, 726.3077392578125, -2921.696044921875, 7.548036098480224609, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+131, 195259, 571, 495, 3988, 1, 1, 737.80206298828125, -2929.8369140625, 6.96212005615234375, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+132, 195256, 571, 495, 3988, 1, 1, 785.396484375, -2856.019287109375, 4.484004974365234375, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+133, 195256, 571, 495, 3988, 1, 1, 775.663818359375, -2854.297607421875, 4.683801174163818359, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+134, 195256, 571, 495, 3988, 1, 1, 708.98089599609375, -2939.20654296875, -3.25597691535949707, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+135, 195264, 571, 495, 3988, 1, 1, 701.36212158203125, -2933.382568359375, -3.06848502159118652, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+136, 195266, 571, 495, 3988, 1, 1, 713.49896240234375, -2931.3994140625, 2.87617802619934082, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+137, 195256, 571, 495, 3988, 1, 1, 706.6024169921875, -2924.741455078125, -3.16570091247558593, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+138, 195256, 571, 495, 3988, 1, 1, 733.01739501953125, -2896.645751953125, 7.161568164825439453, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+139, 195264, 571, 495, 3988, 1, 1, 701.6728515625, -2935.085205078125, -3.06848907470703125, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Kamagua - Difficulty: 0) CreateObject1
+(@OGUID+140, 195256, 571, 495, 3991, 1, 1, 403.79498291015625, -4652.39501953125, 243.967742919921875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+141, 195256, 571, 495, 3991, 1, 1, 412.763092041015625, -4658.490234375, 246.6353302001953125, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+142, 195266, 571, 495, 3991, 1, 1, 445.420135498046875, -4640.56103515625, 253.317840576171875, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+143, 195256, 571, 495, 3991, 1, 1, 493.69927978515625, -4605.00634765625, 243.6478118896484375, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+144, 195256, 571, 495, 3991, 1, 1, 446.30670166015625, -4559.88427734375, 245.503204345703125, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+145, 195273, 571, 495, 3991, 1, 1, 447.466217041015625, -4556.9453125, 252.1781463623046875, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+146, 195273, 571, 495, 3991, 1, 1, 442.438262939453125, -4552.8017578125, 249.541961669921875, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+147, 195257, 571, 495, 3991, 1, 1, 440.052093505859375, -4547.9130859375, 248.6341094970703125, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+148, 195257, 571, 495, 3991, 1, 1, 458.644866943359375, -4542.12353515625, 247.725830078125, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+149, 195273, 571, 495, 3991, 1, 1, 438.434295654296875, -4546.44677734375, 249.345184326171875, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+150, 195257, 571, 495, 3991, 1, 1, 441.81829833984375, -4550.703125, 248.5897979736328125, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+151, 195266, 571, 495, 3991, 1, 1, 465.8819580078125, -4545.6630859375, 251.8805694580078125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+152, 195266, 571, 495, 3991, 1, 1, 463.704864501953125, -4534.5625, 254.9478607177734375, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+153, 195257, 571, 495, 3991, 1, 1, 455.163299560546875, -4536.6796875, 247.5673370361328125, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+154, 195273, 571, 495, 3991, 1, 1, 437.384185791015625, -4539.97119140625, 252.37353515625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+155, 195266, 571, 495, 3991, 1, 1, 454.9619140625, -4528.65185546875, 251.8440704345703125, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+156, 195256, 571, 495, 3991, 1, 1, 434.159942626953125, -4539.46826171875, 245.803192138671875, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+157, 195256, 571, 495, 3991, 1, 1, 404.2421875, -4538.7001953125, 245.8211212158203125, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+158, 195256, 571, 495, 3991, 1, 1, 400.006561279296875, -4535.0859375, 246.1531829833984375, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+159, 195273, 571, 495, 3991, 1, 1, 481.2320556640625, -4523.52294921875, 260.99676513671875, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+160, 195266, 571, 495, 3991, 1, 1, 486.494781494140625, -4520.140625, 239.765869140625, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: New Agamand - Difficulty: 0) CreateObject1
+(@OGUID+161, 195260, 571, 495, 3997, 1, 1, 492.902740478515625, -5928.03076171875, 309.63958740234375, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1
+(@OGUID+162, 195264, 571, 495, 3997, 1, 1, 491.8101806640625, -5927.2802734375, 309.67877197265625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1
+(@OGUID+163, 195256, 571, 495, 3997, 1, 1, 493.364593505859375, -5904.35595703125, 308.904937744140625, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1
+(@OGUID+164, 195256, 571, 495, 3997, 1, 1, 469.700531005859375, -5927.3427734375, 308.720245361328125, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1
+(@OGUID+165, 195256, 571, 495, 3997, 1, 1, 499.0128173828125, -5932.87744140625, 308.70391845703125, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1
+(@OGUID+166, 195264, 571, 495, 3997, 1, 1, 491.35296630859375, -5933.67138671875, 310.585845947265625, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1
+(@OGUID+167, 195260, 571, 495, 3997, 1, 1, 490.626617431640625, -5934.06298828125, 309.60113525390625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1
+(@OGUID+168, 195256, 571, 495, 3980, 1, 1, 604.16217041015625, -5108.1396484375, 4.842274188995361328, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Daggercap Bay - Difficulty: 0) CreateObject1
+(@OGUID+169, 195256, 571, 495, 3980, 1, 1, 575.376953125, -5101.06884765625, 5.191133975982666015, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Daggercap Bay - Difficulty: 0) CreateObject1
+(@OGUID+170, 195266, 571, 495, 3980, 1, 1, 548.75616455078125, -5021.97314453125, 17.4747467041015625, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Daggercap Bay - Difficulty: 0) CreateObject1
+(@OGUID+171, 195256, 571, 495, 3980, 1, 1, 563.8280029296875, -5017.78271484375, 11.59004878997802734, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Daggercap Bay - Difficulty: 0) CreateObject1
+(@OGUID+172, 195256, 571, 495, 3980, 1, 1, 569.19403076171875, -5003.27001953125, 11.09979629516601562, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Daggercap Bay - Difficulty: 0) CreateObject1
+(@OGUID+173, 195266, 571, 495, 3980, 1, 1, 597.41204833984375, -5011.13818359375, 9.712256431579589843, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Daggercap Bay - Difficulty: 0) CreateObject1
+(@OGUID+174, 195256, 571, 495, 3980, 1, 1, 641.049072265625, -5019.35498046875, 4.459393024444580078, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Daggercap Bay - Difficulty: 0) CreateObject1
+(@OGUID+175, 195256, 571, 495, 3981, 1, 1, 540.11920166015625, -4999.92041015625, 10.53384208679199218, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+176, 195266, 571, 495, 3981, 1, 1, 639.2745361328125, -5012.3408203125, 11.1266031265258789, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+177, 195256, 571, 495, 3981, 1, 1, 577.20660400390625, -4954.4150390625, 18.21570014953613281, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+178, 195273, 571, 495, 3981, 1, 1, 592.29864501953125, -4952.79345703125, 23.01476669311523437, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+179, 195266, 571, 495, 3981, 1, 1, 587.5086669921875, -4945.892578125, 32.499114990234375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+180, 195273, 571, 495, 3981, 1, 1, 585.97393798828125, -4954.36474609375, 22.95369911193847656, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+181, 195257, 571, 495, 3981, 1, 1, 587.33953857421875, -4934.3564453125, 20.82388496398925781, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+182, 195273, 571, 495, 3981, 1, 1, 572.94793701171875, -4943.798828125, 27.16759872436523437, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+183, 195260, 571, 495, 3981, 1, 1, 593.67724609375, -4929.41357421875, 31.07939338684082031, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+184, 195260, 571, 495, 3981, 1, 1, 582.01080322265625, -4933.2568359375, 31.07901382446289062, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+185, 195257, 571, 495, 3981, 1, 1, 581.4718017578125, -4943.68310546875, 20.6307525634765625, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+186, 195256, 571, 495, 3981, 1, 1, 569.71356201171875, -4931.642578125, 17.79272079467773437, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+187, 195257, 571, 495, 3981, 1, 1, 586.26324462890625, -4934.662109375, 20.74441337585449218, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+188, 195260, 571, 495, 3981, 1, 1, 589.42169189453125, -4926.30126953125, 19.81484222412109375, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+189, 195266, 571, 495, 3981, 1, 1, 578.79864501953125, -4942.296875, 23.31464767456054687, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+190, 195256, 571, 495, 3981, 1, 1, 584.046142578125, -4934.74365234375, 29.65518951416015625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+191, 195257, 571, 495, 3981, 1, 1, 580.5125732421875, -4939.84228515625, 20.76777458190917968, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+192, 195260, 571, 495, 3981, 1, 1, 600.79669189453125, -4920.2919921875, 24.95571327209472656, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+193, 195260, 571, 495, 3981, 1, 1, 588.70184326171875, -4923.255859375, 19.81484222412109375, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+194, 195260, 571, 495, 3981, 1, 1, 606.9359130859375, -4923.4345703125, 24.95921707153320312, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+195, 195260, 571, 495, 3981, 1, 1, 601.9345703125, -4924.68603515625, 24.95571327209472656, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+(@OGUID+196, 195260, 571, 495, 3981, 1, 1, 607.8848876953125, -4925.90478515625, 24.95921707153320312, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 0); -- Standing, Interior, Small - Brewfest (Area: Valgarde - Difficulty: 0) CreateObject1
+
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+196 AND `eventEntry`=@EVENT;
+INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+196;