DB/Gameobject; Zul'Drak missing Brewfest spawns

closes #30431 by Foldor1

1 files changed, 83 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_11_12_06_world.sql b/sql/updates/world/3.3.5/2024_11_12_06_world.sql
new file mode 100644
index 00000000000..360638e6b58
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_11_12_06_world.sql
@@ -0,0 +1,83 @@
+--
+SET @OGUID := 85578; -- Need 74
+SET @EVENT := 24;
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+73;
+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, 195256, 571, 66, 4323, 1, 1, 5794.01025390625, -3586.30517578125, 388.6536865234375, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+1, 195256, 571, 66, 4323, 1, 1, 5789.33837890625, -3595.7900390625, 388.8240966796875, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+2, 195260, 571, 66, 4323, 1, 1, 5796.28759765625, -3573.15673828125, 388.1470947265625, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+3, 195260, 571, 66, 4323, 1, 1, 5801.0478515625, -3572.99658203125, 389.088653564453125, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+4, 195260, 571, 66, 4323, 1, 1, 5800.0751953125, -3557.563232421875, 389.77008056640625, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+5, 195253, 571, 66, 4323, 1, 1, 5779.60693359375, -3647.15673828125, 397.078765869140625, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+6, 195257, 571, 66, 4323, 1, 1, 5796.578125, -3553.885498046875, 388.331024169921875, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Hanging, Tall/Thin, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+7, 195259, 571, 66, 4323, 1, 1, 5768.53369140625, -3620.057373046875, 389.515899658203125, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+8, 195259, 571, 66, 4323, 1, 1, 5778.517578125, -3600.4619140625, 387.3365478515625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+9, 195256, 571, 66, 4323, 1, 1, 5783.69384765625, -3600.810302734375, 387.71563720703125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+10, 195260, 571, 66, 4323, 1, 1, 5771.67333984375, -3602.202392578125, 388.42059326171875, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+11, 195256, 571, 66, 4323, 1, 1, 5790.5546875, -3548.06201171875, 387.1112060546875, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+12, 195260, 571, 66, 4323, 1, 1, 5794.41943359375, -3557.553955078125, 388.896392822265625, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+13, 195256, 571, 66, 4323, 1, 1, 5774.17041015625, -3614.330078125, 387.690093994140625, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+14, 195260, 571, 66, 4323, 1, 1, 5767.890625, -3581.119873046875, 388.561767578125, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+15, 195256, 571, 66, 4323, 1, 1, 5758.55078125, -3620.203125, 385.835174560546875, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+16, 195260, 571, 66, 4323, 1, 1, 5760.94091796875, -3580.5234375, 388.68145751953125, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+17, 195260, 571, 66, 4323, 1, 1, 5768.9931640625, -3564.651123046875, 388.132049560546875, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+18, 195260, 571, 66, 4323, 1, 1, 5759.46728515625, -3565.396484375, 388.25091552734375, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+19, 195259, 571, 66, 4323, 1, 1, 5746.46826171875, -3556.42822265625, 390.089630126953125, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+20, 195273, 571, 66, 4323, 1, 1, 5769.6552734375, -3530.541748046875, 396.830230712890625, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+21, 195273, 571, 66, 4323, 1, 1, 5745.5791015625, -3534.723876953125, 396.684967041015625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+22, 195256, 571, 66, 4323, 1, 1, 5750.7998046875, -3535.454345703125, 389.026702880859375, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+23, 195256, 571, 66, 4323, 1, 1, 5764.80029296875, -3532.1552734375, 388.3555908203125, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+24, 195259, 571, 66, 4323, 1, 1, 5762.9599609375, -3526.6650390625, 391.175689697265625, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Zim'Torga - Difficulty: 0) CreateObject1
+(@OGUID+25, 195260, 571, 66, 4275, 1, 1, 5524.15576171875, -2679.053466796875, 305.170166015625, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+26, 195254, 571, 66, 4275, 1, 1, 5391.95947265625, -2692.567626953125, 310.286285400390625, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 0), -- Hanging, Square, Large - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+27, 195260, 571, 66, 4275, 1, 1, 5500.44873046875, -2662.013427734375, 304.96588134765625, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+28, 195253, 571, 66, 4275, 1, 1, 5481.4208984375, -2655.850830078125, 310.491180419921875, 0, 0, 0, 0, 1, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+29, 195256, 571, 66, 4275, 1, 1, 5408.3564453125, -2679.760986328125, 303.953948974609375, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+30, 195253, 571, 66, 4275, 1, 1, 5472.98193359375, -2649.109375, 310.313873291015625, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+31, 195259, 571, 66, 4275, 1, 1, 5526.03369140625, -2669.76416015625, 304.288970947265625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+32, 195253, 571, 66, 4275, 1, 1, 5426.5380859375, -2647.54638671875, 310.758880615234375, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+33, 195253, 571, 66, 4275, 1, 1, 5418.21728515625, -2654.892333984375, 310.675201416015625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+34, 195256, 571, 66, 4275, 1, 1, 5500.0859375, -2657.1953125, 303.953948974609375, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+35, 195260, 571, 66, 4275, 1, 1, 5492.63525390625, -2649.155517578125, 305.27008056640625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+36, 195256, 571, 66, 4275, 1, 1, 5528.21435546875, -2651.125, 303.953948974609375, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+37, 195256, 571, 66, 4275, 1, 1, 5526.2255859375, -2674.839599609375, 303.953948974609375, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+38, 195260, 571, 66, 4275, 1, 1, 5410.43212890625, -2652.655029296875, 306.23101806640625, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+39, 195256, 571, 66, 4275, 1, 1, 5527.7744140625, -2637.86279296875, 303.953948974609375, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+40, 195253, 571, 66, 4275, 1, 1, 5482.34716796875, -2610.53125, 310.678924560546875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+41, 195253, 571, 66, 4275, 1, 1, 5465.97607421875, -2609.939453125, 310.7265625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+42, 195260, 571, 66, 4275, 1, 1, 5492.884765625, -2617.63232421875, 305.299072265625, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+43, 195256, 571, 66, 4275, 1, 1, 5464.55859375, -2619.046142578125, 306.5511474609375, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+44, 195253, 571, 66, 4275, 1, 1, 5473.11669921875, -2618.064697265625, 310.783782958984375, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+45, 195253, 571, 66, 4275, 1, 1, 5474.36474609375, -2602.700927734375, 310.6907958984375, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+46, 195255, 571, 66, 4275, 1, 1, 5490.34912109375, -2575.416748046875, 313.053253173828125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 0), -- Hanging, Tall/Thin, Large - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+47, 195256, 571, 66, 4275, 1, 1, 5436.38916015625, -2618.3818359375, 306.5511474609375, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+48, 195260, 571, 66, 4275, 1, 1, 5407.5224609375, -2646.7421875, 305.290191650390625, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: The Argent Stand - Difficulty: 0) CreateObject1
+(@OGUID+49, 195256, 571, 66, 4317, 1, 1, 5135.755859375, -2204.338134765625, 236.5435638427734375, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+50, 195256, 571, 66, 4317, 1, 1, 5190.787109375, -2215.080810546875, 239.398193359375, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+51, 195259, 571, 66, 4317, 1, 1, 5196.89697265625, -2215.81591796875, 243.9397735595703125, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+52, 195264, 571, 66, 4317, 1, 1, 5157.71240234375, -2215.264892578125, 238.4418182373046875, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+53, 195260, 571, 66, 4317, 1, 1, 5143.44677734375, -2210.877197265625, 237.8242950439453125, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+54, 195264, 571, 66, 4317, 1, 1, 5157.25927734375, -2201.743896484375, 237.5309295654296875, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+55, 195264, 571, 66, 4317, 1, 1, 5141.53857421875, -2211.604248046875, 238.1585235595703125, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+56, 195260, 571, 66, 4317, 1, 1, 5190.736328125, -2212.201171875, 239.39776611328125, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+57, 195260, 571, 66, 4317, 1, 1, 5134.634765625, -2201.14453125, 238.8164825439453125, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+58, 195256, 571, 66, 4317, 1, 1, 5153.60595703125, -2216.569091796875, 236.80499267578125, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+59, 195264, 571, 66, 4317, 1, 1, 5137.095703125, -2201.546142578125, 237.8018951416015625, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+60, 195259, 571, 66, 4317, 1, 1, 5193.83837890625, -2203.542236328125, 239.8356170654296875, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+61, 195260, 571, 66, 4317, 1, 1, 5148.00146484375, -2198.407958984375, 237.6139678955078125, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+62, 195264, 571, 66, 4317, 1, 1, 5177.1533203125, -2180.083740234375, 236.542449951171875, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+63, 195256, 571, 66, 4317, 1, 1, 5135.95458984375, -2183.2392578125, 236.8366241455078125, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+64, 195256, 571, 66, 4317, 1, 1, 5196.79931640625, -2208.14404296875, 239.3988494873046875, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+65, 195259, 571, 66, 4317, 1, 1, 5179.93212890625, -2192.0244140625, 239.8267669677734375, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+66, 195264, 571, 66, 4317, 1, 1, 5192.4345703125, -2209.911376953125, 239.398193359375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+67, 195259, 571, 66, 4317, 1, 1, 5111.6787109375, -2201.835205078125, 243.7792205810546875, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+68, 195256, 571, 66, 4317, 1, 1, 5174.27978515625, -2190.904052734375, 236.5398712158203125, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+69, 195260, 571, 66, 4317, 1, 1, 5173.9501953125, -2179.033203125, 236.537872314453125, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+70, 195256, 571, 66, 4317, 1, 1, 5170.6552734375, -2175.09375, 236.523956298828125, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+71, 195259, 571, 66, 4317, 1, 1, 5141.9833984375, -2154.614501953125, 244.30865478515625, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Light's Breach - Difficulty: 0) CreateObject1
+(@OGUID+72, 195256, 571, 66, 4312, 1, 1, 5235.5537109375, -1320.3189697265625, 242.1471405029296875, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Ebon Watch - Difficulty: 0) CreateObject1
+(@OGUID+73, 195256, 571, 66, 4312, 1, 1, 5233.94384765625, -1309.33349609375, 242.7247772216796875, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 0); -- Standing, Exterior, Medium - Brewfest (Area: Ebon Watch - Difficulty: 0) CreateObject1
+
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+73 AND `eventEntry`=@EVENT;
+INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+73;