diff options
| author | Naddley <64811442+Naddley@users.noreply.github.com> | 2022-09-22 03:03:27 +0200 |
|---|---|---|
| committer | ModoX <moardox@gmail.com> | 2022-09-22 03:04:25 +0200 |
| commit | 8be27e5bd45ade060faf23081f038581229abe09 (patch) | |
| tree | 7f76437ecd0d6eeb906bebb213942b7254e34f07 | |
| parent | 68d6044a5cfe0575d18f63d3eb7ece94515cb205 (diff) | |
DB/Spawns: Updated Brewfest spawns at the doors of Stormwind
Closes #28269
| -rw-r--r-- | sql/updates/world/master/2022_09_22_00_world.sql | 890 |
1 files changed, 890 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_09_22_00_world.sql b/sql/updates/world/master/2022_09_22_00_world.sql new file mode 100644 index 00000000000..acfc9e49417 --- /dev/null +++ b/sql/updates/world/master/2022_09_22_00_world.sql @@ -0,0 +1,890 @@ +SET @CGUID := 850253; +SET @OGUID := 500515; + +-- delete old stuff +DELETE FROM `creature` WHERE `guid` IN(361957, 361958, 361959); +DELETE FROM `gameobject` WHERE `guid` IN(226376, 226369, 226368, 226367, 226361, 226364, 226362, 226363, 226375, 226354); + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+23; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 18927, 0, 1519, 5148, '0', 0, 0, 0, 4, -8855.1533203125, 651.25347900390625, 96.38057708740234375, 2.321287870407104492, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Trade District - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+1, 18927, 0, 1519, 5148, '0', 0, 0, 0, 0, -8856.7470703125, 652.8992919921875, 96.367340087890625, 5.462880611419677734, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Trade District - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+2, 18927, 0, 1519, 5148, '0', 0, 0, 0, 6, -8835.80078125, 559.625, 95.37226104736328125, 2.356194496154785156, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Trade District - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+3, 18927, 0, 1519, 5148, '0', 0, 0, 0, 0, -8836.97265625, 560.6805419921875, 95.29747772216796875, 5.602506637573242187, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Trade District - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+4, 18927, 0, 1519, 5149, '0', 0, 0, 0, 7, -8642.9794921875, 439.052093505859375, 101.6998977661132812, 1.256637096405029296, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Old Town - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+5, 18927, 0, 1519, 5149, '0', 0, 0, 0, 0, -8642.3974609375, 440.9757080078125, 101.9238739013671875, 4.433136463165283203, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Old Town - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+6, 18927, 0, 1519, 5150, '0', 0, 0, 0, 5, -8366.1611328125, 615.2257080078125, 95.3541717529296875, 2.635447263717651367, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Dwarven District - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+7, 18927, 0, 1519, 5150, '0', 0, 0, 0, 0, -8368.1962890625, 616.234375, 95.25559234619140625, 5.846852779388427734, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Dwarven District - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+8, 18927, 0, 1519, 5154, '0', 0, 0, 0, 0, -9038.0732421875, 860.951416015625, 107.1946487426757812, 4.520402908325195312, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Mage Quarter - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+9, 18927, 0, 1519, 5154, '0', 0, 0, 0, 7, -9038.5244140625, 858.94097900390625, 107.19451904296875, 1.308996915817260742, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Human Commoner (Area: Mage Quarter - Difficulty: 0) (Auras: 65511 - Gossip NPC Appearance - Brewfest, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk) +(@CGUID+10, 40441, 0, 1519, 5148, '0', 0, 0, 0, 0, -8835.66015625, 639.55206298828125, 96.187744140625, 4.066617012023925781, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Battered Brewmaster (Area: Trade District - Difficulty: 0) +(@CGUID+11, 153931, 0, 12, 7486, '0', '0', 0, 0, 3, -9133.109375, 352.23089599609375, 92.892364501953125, 3.181359052658081054, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300441 - -Unknown-) +(@CGUID+12, 153931, 0, 12, 7486, '0', '0', 0, 0, 6, -9138.0849609375, 335.118072509765625, 92.0803985595703125, 1.621237158775329589, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300447 - -Unknown-) +(@CGUID+13, 153931, 0, 12, 7486, '0', '0', 0, 0, 2, -9135.498046875, 353.383697509765625, 92.45139312744140625, 5.1783447265625, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300442 - -Unknown-) +(@CGUID+14, 153931, 0, 12, 7486, '0', '0', 0, 0, 5, -9127.341796875, 342.84722900390625, 93.7291717529296875, 4.930837631225585937, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300450 - -Unknown-) +(@CGUID+15, 153931, 0, 12, 7486, '0', '0', 0, 0, 6, -9135.623046875, 350.361114501953125, 92.4774322509765625, 0.866958022117614746, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300442 - -Unknown-) +(@CGUID+16, 153931, 0, 12, 7486, '0', '0', 0, 0, 1, -9128.7236328125, 339.298614501953125, 93.88889312744140625, 0.202819958329200744, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300449 - -Unknown-) +(@CGUID+17, 153931, 0, 12, 7486, '0', '0', 0, 0, 4, -9125.109375, 338.3819580078125, 94.046875, 1.994780659675598144, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300447 - -Unknown-) +(@CGUID+18, 153931, 0, 12, 7486, '0', '0', 0, 0, 5, -9137.98828125, 338.805572509765625, 92.26348876953125, 4.651520729064941406, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300447 - -Unknown-) +(@CGUID+19, 153931, 0, 12, 7486, '0', '0', 0, 0, 6, -9124.2236328125, 341.4757080078125, 94.2743072509765625, 3.549948930740356445, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Brewfest Reveler (Area: -Unknown- - Difficulty: 0) (Auras: 300444 - -Unknown-) +(@CGUID+20, 23482, 0, 12, 7486, '0', '0', 0, 0, 0, -9118.478515625, 348.45550537109375, 93.9492340087890625, 3.787364482879638671, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Barleybrew Apprentice (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 23510, 0, 12, 7486, '0', '0', 0, 0, 0, -9114.78515625, 338.7652587890625, 93.627655029296875, 2.914699792861938476, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Thunderbrew Apprentice (Area: -Unknown- - Difficulty: 0) +(@CGUID+22, 155345, 0, 12, 7486, '0', '0', 0, 0, 0, -9126.232421875, 342.791656494140625, 94.23699951171875, 0, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- [DNT] Brewfest Music (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 23511, 0, 12, 7486, '0', '0', 0, 0, 0, -9121.544921875, 328.48785400390625, 93.27951812744140625, 2.103765249252319335, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338); -- Gordok Brew Apprentice (Area: -Unknown- - Difficulty: 0) + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+374; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 195264, 0, 1519, 5148, '0', 0, 0, -8856.1484375, 671.78057861328125, 98.84055328369140625, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 45338), -- Standing, Interior, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+1, 195266, 0, 1519, 5148, '0', 0, 0, -8860.6826171875, 662.83843994140625, 101.1599884033203125, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+2, 195260, 0, 1519, 5148, '0', 0, 0, -8855.509765625, 650.281005859375, 97.19789886474609375, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+3, 367977, 0, 1519, 5148, '0', 0, 0, -8858.5, 646.4840087890625, 99.142303466796875, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+4, 367977, 0, 1519, 5148, '0', 0, 0, -8858.4697265625, 650.91302490234375, 99.12270355224609375, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+5, 367978, 0, 1519, 5148, '0', 0, 0, -8857.8701171875, 649.3189697265625, 100.7580032348632812, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+6, 195265, 0, 1519, 5148, '0', 0, 0, -8884.16015625, 565.98101806640625, 93.18990325927734375, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+7, 195256, 0, 1519, 5148, '0', 0, 0, -8879.1787109375, 649.49188232421875, 96.0198211669921875, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+8, 195260, 0, 1519, 5148, '0', 0, 0, -8901.25, 623.21697998046875, 100.7139968872070312, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+9, 195263, 0, 1519, 5148, '0', 0, 0, -8840.8203125, 660.00201416015625, 99.18509674072265625, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+10, 195265, 0, 1519, 5148, '0', 0, 0, -8894.5595703125, 579.27398681640625, 92.986602783203125, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+11, 195260, 0, 1519, 5148, '0', 0, 0, -8857.830078125, 644.77398681640625, 97.18630218505859375, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+12, 195273, 0, 1519, 5148, '0', 0, 0, -8821.4501953125, 670.08001708984375, 101.305999755859375, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+13, 367977, 0, 1519, 5148, '0', 0, 0, -8857.2001953125, 647.72198486328125, 99.1681976318359375, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+14, 367978, 0, 1519, 5148, '0', 0, 0, -8860.0703125, 647.14898681640625, 100.7379989624023437, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+15, 195264, 0, 1519, 5148, '0', 0, 0, -8895.2900390625, 618.68597412109375, 101.2580032348632812, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 45338), -- Standing, Interior, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+16, 195260, 0, 1519, 5148, '0', 0, 0, -8898.76953125, 624.61602783203125, 100.7139968872070312, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+17, 195264, 0, 1519, 5148, '0', 0, 0, -8908.6103515625, 643.5560302734375, 101.2699966430664062, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 45338), -- Standing, Interior, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+18, 195266, 0, 1519, 5148, '0', 0, 0, -8871.8974609375, 682.27740478515625, 102.2920913696289062, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+19, 195260, 0, 1519, 5148, '0', 0, 0, -8863.2099609375, 650.3389892578125, 97.074798583984375, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+20, 367977, 0, 1519, 5148, '0', 0, 0, -8861.6396484375, 649.60198974609375, 99.079803466796875, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+21, 367978, 0, 1519, 5148, '0', 0, 0, -8857.8603515625, 648.05902099609375, 100.7679977416992187, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+22, 195260, 0, 1519, 5148, '0', 0, 0, -8860.9599609375, 652.5469970703125, 97.09059906005859375, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+23, 367977, 0, 1519, 5148, '0', 0, 0, -8861.66015625, 647.77801513671875, 99.0941009521484375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+24, 367978, 0, 1519, 5148, '0', 0, 0, -8858.7900390625, 650.28997802734375, 100.7350006103515625, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+25, 195260, 0, 1519, 5148, '0', 0, 0, -8857.759765625, 652.56402587890625, 97.1490020751953125, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+26, 195256, 0, 1519, 5148, '0', 0, 0, -8874.091796875, 640.25860595703125, 96.08939361572265625, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+27, 195266, 0, 1519, 5148, '0', 0, 0, -8904.8701171875, 629.76898193359375, 108.4390029907226562, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+28, 367977, 0, 1519, 5148, '0', 0, 0, -8860.2900390625, 646.5050048828125, 99.125396728515625, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+29, 367978, 0, 1519, 5148, '0', 0, 0, -8858.76953125, 647.10198974609375, 100.7610015869140625, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+30, 195260, 0, 1519, 5148, '0', 0, 0, -8860.8896484375, 644.79302978515625, 97.1533966064453125, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+31, 195263, 0, 1519, 5148, '0', 0, 0, -8842.4296875, 716.519287109375, 109.501068115234375, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+32, 195260, 0, 1519, 5148, '0', 0, 0, -8908.2802734375, 636.25, 100.7139968872070312, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+33, 195263, 0, 1519, 5148, '0', 0, 0, -8832.990234375, 641.9110107421875, 99.12180328369140625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+34, 367977, 0, 1519, 5148, '0', 0, 0, -8857.1396484375, 649.64202880859375, 99.15450286865234375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+35, 367978, 0, 1519, 5148, '0', 0, 0, -8860.98046875, 648.09197998046875, 100.71600341796875, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+36, 195260, 0, 1519, 5148, '0', 0, 0, -8905.759765625, 637.5780029296875, 100.7139968872070312, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+37, 195273, 0, 1519, 5148, '0', 0, 0, -8812.5302734375, 649.03497314453125, 101.2009963989257812, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+38, 195260, 0, 1519, 5148, '0', 0, 0, -8863.2197265625, 647.09002685546875, 97.08480072021484375, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+39, 195263, 0, 1519, 5148, '0', 0, 0, -8819.5205078125, 643.828125, 97.83412933349609375, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+40, 367977, 0, 1519, 5148, '0', 0, 0, -8860.3203125, 650.947998046875, 99.0919036865234375, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45338), -- Standing, Interior, Small 2 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+41, 367978, 0, 1519, 5148, '0', 0, 0, -8860.98046875, 649.3389892578125, 100.707000732421875, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+42, 195260, 0, 1519, 5148, '0', 0, 0, -8855.4697265625, 647.093994140625, 97.2158966064453125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+43, 367978, 0, 1519, 5148, '0', 0, 0, -8860.0595703125, 650.2760009765625, 100.714996337890625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 45338), -- Standing, Interior, Small 3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+44, 195256, 0, 1519, 5148, '0', 0, 0, -8833.5234375, 541.75274658203125, 96.9852752685546875, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+45, 195256, 0, 1519, 5148, '0', 0, 0, -8839.07421875, 545.26629638671875, 96.83765411376953125, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+46, 195254, 0, 1519, 5148, '0', 0, 0, -8852.5283203125, 539.68133544921875, 117.809112548828125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+47, 195253, 0, 1519, 5148, '0', 0, 0, -8862.3466796875, 489.577789306640625, 122.2630386352539062, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+48, 195254, 0, 1519, 5148, '0', 0, 0, -8951.5673828125, 538.97918701171875, 97.63472747802734375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+49, 195254, 0, 1519, 5148, '0', 0, 0, -8936.01953125, 519.77606201171875, 97.50989532470703125, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+50, 195265, 0, 1519, 1617, '0', 0, 0, -8973.23046875, 491.10400390625, 97.04229736328125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+51, 195265, 0, 1519, 1617, '0', 0, 0, -8987.8095703125, 509.178985595703125, 97.07109832763671875, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+52, 195265, 0, 1519, 1617, '0', 0, 0, -9018.01953125, 485.072998046875, 97.101898193359375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+53, 195265, 0, 1519, 1617, '0', 0, 0, -9003.5498046875, 467.0360107421875, 97.11280059814453125, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+54, 186737, 0, 1519, 1617, '0', 0, 0, -9111.8388671875, 351.595489501953125, 93.2698974609375, 5.615478038787841796, 0.019821643829345703, 0.004260063171386718, -0.32779121398925781, 0.944532632827758789, 120, 255, 1, 45338), -- Brewfest Wagon Loaded (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+55, 186717, 0, 1519, 1617, '0', 0, 0, -9124.60546875, 357.99884033203125, 92.98186492919921875, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 45338), -- Brewfest Banner (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+56, 186717, 0, 1519, 1617, '0', 0, 0, -9137.3642578125, 389.87890625, 90.97507476806640625, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 45338), -- Brewfest Banner (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+57, 186717, 0, 1519, 1617, '0', 0, 0, -9114.4912109375, 342.775390625, 93.66717529296875, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45338), -- Brewfest Banner (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+58, 186717, 0, 1519, 1617, '0', 0, 0, -9137.0625, 372.11529541015625, 90.57259368896484375, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 45338), -- Brewfest Banner (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+59, 195265, 0, 1519, 1617, '0', 0, 0, -9071.2099609375, 449.920013427734375, 93.285797119140625, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+60, 195265, 0, 1519, 1617, '0', 0, 0, -9063.1396484375, 456.014007568359375, 93.27629852294921875, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+61, 195265, 0, 1519, 1617, '0', 0, 0, -9043.3203125, 430.9110107421875, 93.28790283203125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+62, 195265, 0, 1519, 1617, '0', 0, 0, -9050.5703125, 424.714996337890625, 93.285003662109375, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+63, 195255, 0, 1519, 1617, '0', 0, 0, -9062.1103515625, 436.52301025390625, 111.1930007934570312, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+64, 195254, 0, 1519, 1617, '0', 0, 0, -9065.8798828125, 414.82598876953125, 98.7891998291015625, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+65, 195265, 0, 1519, 1617, '0', 0, 0, -9089.3798828125, 431.970001220703125, 92.8513031005859375, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+66, 195254, 0, 1519, 1617, '0', 0, 0, -9083.6298828125, 437.9429931640625, 98.2519989013671875, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+67, 195265, 0, 1519, 1617, '0', 0, 0, -9072.8095703125, 411.154998779296875, 92.744903564453125, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 45338), -- Standing, Large - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+68, 186183, 0, 12, 7486, '0', '0', 0, -9120.4345703125, 356.536468505859375, 93.25022125244140625, 0.75047844648361206, 0, 0, 0.366495132446289062, 0.930419981479644775, 120, 255, 1, 45338), -- Barleybrew Festive Keg (Area: -Unknown- - Difficulty: 0) +(@OGUID+69, 326705, 0, 12, 7486, '0', '0', 0, -9116.0205078125, 347.00347900390625, 93.77057647705078125, 0, 0, 0, 0, 1, 120, 255, 1, 45338), -- Brewfest Torch (Area: -Unknown- - Difficulty: 0) +(@OGUID+70, 186683, 0, 12, 7486, '0', '0', 0, -9107.7412109375, 340.62152099609375, 93.30258941650390625, 0.831298112869262695, 0, 0, 0.403783798217773437, 0.914854466915130615, 120, 255, 1, 45338), -- Empty Brew Wagon (Area: -Unknown- - Difficulty: 0) +(@OGUID+71, 327165, 0, 12, 7486, '0', '0', 0, -9108.7919921875, 341.149322509765625, 94.8296051025390625, 0.831298112869262695, 0, 0, 0.403783798217773437, 0.914854466915130615, 120, 255, 1, 45338), -- Keg (Area: -Unknown- - Difficulty: 0) +(@OGUID+72, 186717, 0, 12, 7486, '0', '0', 0, -9184.3330078125, 334.999664306640625, 82.31685638427734375, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 45338), -- Brewfest Banner (Area: -Unknown- - Difficulty: 0) +(@OGUID+73, 186717, 0, 12, 7486, '0', '0', 0, -9129.2763671875, 326.677093505859375, 93.44791412353515625, 1.448324084281921386, 0, 0, 0.662508010864257812, 0.74905484914779663, 120, 255, 1, 45338), -- Brewfest Banner (Area: -Unknown- - Difficulty: 0) +(@OGUID+74, 292549, 0, 12, 7486, '0', '0', 0, -9121.90625, 325.99652099609375, 93.22713470458984375, 6.15463113784790039, 0, 0, -0.06423282623291015, 0.997934937477111816, 120, 255, 1, 45338), -- Hay Bale (Area: -Unknown- - Difficulty: 0) +(@OGUID+75, 186717, 0, 12, 7486, '0', '0', 0, -9150.7236328125, 357.49993896484375, 89.90228271484375, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 45338), -- Brewfest Banner (Area: -Unknown- - Difficulty: 0) +(@OGUID+76, 205110, 0, 12, 7486, '0', '0', 0, -9119.169921875, 325.26910400390625, 93.23209381103515625, 1.765843868255615234, 0, 0, 0.772597312927246093, 0.634896337985992431, 120, 255, 1, 45338), -- Brewfest Crate (Area: -Unknown- - Difficulty: 0) +(@OGUID+77, 292549, 0, 12, 7486, '0', '0', 0, -9117.66015625, 328.0850830078125, 93.13021087646484375, 3.94624495506286621, 0, 0, -0.92015266418457031, 0.391559779644012451, 120, 255, 1, 45338), -- Hay Bale (Area: -Unknown- - Difficulty: 0) +(@OGUID+78, 326139, 0, 12, 7486, '0', '0', 0, -9133.7431640625, 350.560760498046875, 93.9886016845703125, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+79, 326139, 0, 12, 7486, '0', '0', 0, -9126.00390625, 340.19964599609375, 95.2180023193359375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+80, 326705, 0, 12, 7486, '0', '0', 0, -9118.1357421875, 331.54339599609375, 93.24826812744140625, 6.214612483978271484, 0, 0, -0.03427982330322265, 0.999412298202514648, 120, 255, 1, 45338), -- Brewfest Torch (Area: -Unknown- - Difficulty: 0) +(@OGUID+81, 327165, 0, 12, 7486, '0', '0', 0, -9118.3642578125, 329.696197509765625, 93.1788177490234375, 6.214612483978271484, 0, 0, -0.03427982330322265, 0.999412298202514648, 120, 255, 1, 45338), -- Keg (Area: -Unknown- - Difficulty: 0) +(@OGUID+82, 326139, 0, 12, 7486, '0', '0', 0, -9126.8994140625, 340.4132080078125, 95.1802520751953125, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+83, 326138, 0, 12, 7486, '0', '0', 0, -9126.3056640625, 340.2413330078125, 94.041290283203125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45338), -- Party Table (Area: -Unknown- - Difficulty: 0) +(@OGUID+84, 326139, 0, 12, 7486, '0', '0', 0, -9126.6982421875, 339.873260498046875, 95.15944671630859375, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+85, 326139, 0, 12, 7486, '0', '0', 0, -9134.638671875, 350.774322509765625, 93.81700897216796875, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+86, 327165, 0, 12, 7486, '0', '0', 0, -9117.59375, 325.989593505859375, 93.17708587646484375, 6.214612483978271484, 0, 0, -0.03427982330322265, 0.999412298202514648, 120, 255, 1, 45338), -- Keg (Area: -Unknown- - Difficulty: 0) +(@OGUID+87, 326138, 0, 12, 7486, '0', '0', 0, -9134.044921875, 350.602447509765625, 92.78646087646484375, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45338), -- Party Table (Area: -Unknown- - Difficulty: 0) +(@OGUID+88, 326139, 0, 12, 7486, '0', '0', 0, -9134.439453125, 350.234375, 93.89134979248046875, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+89, 326139, 0, 12, 7486, '0', '0', 0, -9134.1142578125, 350.836822509765625, 93.90525054931640625, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+90, 326139, 0, 12, 7486, '0', '0', 0, -9126.375, 340.4757080078125, 95.21901702880859375, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45338), -- Alcohol-Free Brewfest Sampler (Area: -Unknown- - Difficulty: 0) +(@OGUID+91, 186184, 0, 12, 7486, '0', '0', 0, -9113.3251953125, 332.2216796875, 93.15085601806640625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 45338), -- Thunderbrew Festive Keg (Area: -Unknown- - Difficulty: 0) +(@OGUID+92, 186185, 0, 12, 7486, '0', '0', 0, -9125.5283203125, 324.802093505859375, 93.46527862548828125, 4.835803031921386718, 0, 0, -0.6621551513671875, 0.74936676025390625, 120, 255, 1, 45338), -- Gordok Festive Keg (Area: -Unknown- - Difficulty: 0) +(@OGUID+93, 195253, 0, 1519, 1617, '0', 0, 0, -8845.916015625, 468.921875, 122.3519134521484375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+94, 195263, 0, 1519, 5148, '0', 0, 0, -8740.796875, 579.02410888671875, 109.8196792602539062, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+95, 195255, 0, 1519, 5148, '0', 0, 0, -8680.7099609375, 609.13201904296875, 103.9000015258789062, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+96, 195263, 0, 1519, 5148, '0', 0, 0, -8743.3583984375, 695.37646484375, 110.7000732421875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+97, 195263, 0, 1519, 5148, '0', 0, 0, -8719.5673828125, 507.91253662109375, 107.537322998046875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+98, 195255, 0, 1519, 5148, '0', 0, 0, -8653.9697265625, 574.87701416015625, 103.9059982299804687, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: Trade District - Difficulty: 0) +(@OGUID+99, 195255, 0, 1519, 5390, '0', 0, 0, -8647.150390625, 636.46002197265625, 103.86199951171875, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+100, 195256, 0, 1519, 5390, '0', 0, 0, -8657.150390625, 500.305999755859375, 101.6050033569335937, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+101, 195256, 0, 1519, 5390, '0', 0, 0, -8711.8798828125, 463.470001220703125, 97.4506988525390625, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+102, 195263, 0, 1519, 5390, '0', 0, 0, -8680.7998046875, 461.0889892578125, 105.227996826171875, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+103, 195260, 0, 1519, 5390, '0', 0, 0, -8713.76953125, 417.77801513671875, 99.17099761962890625, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+104, 195260, 0, 1519, 5390, '0', 0, 0, -8720.2998046875, 413.782989501953125, 101.279998779296875, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+105, 195260, 0, 1519, 5390, '0', 0, 0, -8714.8203125, 419.131988525390625, 99.176300048828125, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+106, 195260, 0, 1519, 5390, '0', 0, 0, -8714.349609375, 410.970001220703125, 98.94390106201171875, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+107, 195260, 0, 1519, 5390, '0', 0, 0, -8720.33984375, 418.412994384765625, 98.98349761962890625, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+108, 195260, 0, 1519, 5390, '0', 0, 0, -8722.080078125, 415.22900390625, 98.84459686279296875, 0, 0, 0, 0, 1, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+109, 195260, 0, 1519, 5390, '0', 0, 0, -8717.23046875, 416.49700927734375, 103.4260025024414062, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+110, 195260, 0, 1519, 5390, '0', 0, 0, -8718.8603515625, 412.00201416015625, 101.2710037231445312, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+111, 195260, 0, 1519, 5390, '0', 0, 0, -8716, 417.287994384765625, 101.503997802734375, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+112, 195260, 0, 1519, 5390, '0', 0, 0, -8715.91015625, 409.740997314453125, 98.85630035400390625, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+113, 195260, 0, 1519, 5390, '0', 0, 0, -8714.7802734375, 413.238006591796875, 101.4250030517578125, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+114, 195260, 0, 1519, 5390, '0', 0, 0, -8714.5400390625, 415.49700927734375, 101.496002197265625, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+115, 195260, 0, 1519, 5390, '0', 0, 0, -8717.8701171875, 409.938995361328125, 98.809600830078125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+116, 195260, 0, 1519, 5390, '0', 0, 0, -8721.08984375, 411.803985595703125, 98.7816009521484375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+117, 195260, 0, 1519, 5390, '0', 0, 0, -8716.919921875, 419.4010009765625, 99.12889862060546875, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+118, 195260, 0, 1519, 5390, '0', 0, 0, -8720.0595703125, 416.072998046875, 101.3519973754882812, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+119, 195260, 0, 1519, 5390, '0', 0, 0, -8712.6201171875, 414.12200927734375, 99.08950042724609375, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+120, 195260, 0, 1519, 5390, '0', 0, 0, -8716.599609375, 411.819000244140625, 101.3160018920898437, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+121, 195260, 0, 1519, 5390, '0', 0, 0, -8718.259765625, 417.555999755859375, 101.4459991455078125, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+122, 195260, 0, 1519, 5390, '0', 0, 0, -8722.259765625, 413.342010498046875, 98.79450225830078125, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+123, 195260, 0, 1519, 5390, '0', 0, 0, -8718.8203125, 419.563995361328125, 99.07160186767578125, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+124, 195260, 0, 1519, 5390, '0', 0, 0, -8721.8701171875, 417.154998779296875, 98.902496337890625, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+125, 195260, 0, 1519, 5390, '0', 0, 0, -8719.759765625, 410.18798828125, 98.7864990234375, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+126, 195260, 0, 1519, 5390, '0', 0, 0, -8715.5400390625, 414.343994140625, 103.4069976806640625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+127, 195260, 0, 1519, 5390, '0', 0, 0, -8712.419921875, 416.092010498046875, 99.15689849853515625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+128, 195256, 0, 1519, 5390, '0', 0, 0, -8746.150390625, 410.779998779296875, 98.2071990966796875, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+129, 195260, 0, 1519, 5390, '0', 0, 0, -8717.599609375, 412.6090087890625, 103.2979965209960937, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+130, 195260, 0, 1519, 5390, '0', 0, 0, -8719.4296875, 414.77801513671875, 103.305999755859375, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+131, 195260, 0, 1519, 5390, '0', 0, 0, -8712.83984375, 412.220001220703125, 99.03929901123046875, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+132, 195263, 0, 1519, 5390, '0', 0, 0, -8762.2900390625, 382.514007568359375, 103.6529998779296875, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+133, 195256, 0, 1519, 5390, '0', 0, 0, -8732.0595703125, 393.212005615234375, 98.2071990966796875, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+134, 195256, 0, 1519, 5390, '0', 0, 0, -8673.009765625, 442.39599609375, 100.0309982299804687, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+135, 195263, 0, 1519, 5390, '0', 0, 0, -8612.7119140625, 504.63714599609375, 115.3036270141601562, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+136, 195255, 0, 1519, 5390, '0', 0, 0, -8619.6298828125, 600.8800048828125, 103.897003173828125, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+137, 195263, 0, 1519, 5149, '0', 0, 0, -8633.3203125, 421.480987548828125, 104.7610015869140625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+138, 195256, 0, 1519, 5149, '0', 0, 0, -8626.26953125, 441.27398681640625, 103.2350006103515625, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+139, 195263, 0, 1519, 5149, '0', 0, 0, -8640.8896484375, 415.50299072265625, 104.7910003662109375, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+140, 195260, 0, 1519, 5149, '0', 0, 0, -8627.669921875, 413.610992431640625, 104.8389968872070312, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+141, 195260, 0, 1519, 5149, '0', 0, 0, -8629.3603515625, 412.2550048828125, 104.8639984130859375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+142, 195260, 0, 1519, 5149, '0', 0, 0, -8631.2998046875, 410.615997314453125, 104.8430023193359375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+143, 195260, 0, 1519, 5149, '0', 0, 0, -8620.0595703125, 419.2659912109375, 104.8639984130859375, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+144, 195260, 0, 1519, 5149, '0', 0, 0, -8618.26953125, 420.782989501953125, 104.8440017700195312, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+145, 195263, 0, 1519, 5149, '0', 0, 0, -8738.650390625, 379.631988525390625, 103.7239990234375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+146, 195263, 0, 1519, 5149, '0', 0, 0, -8747.7099609375, 372.355987548828125, 103.7529983520507812, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+147, 195260, 0, 1519, 5149, '0', 0, 0, -8622.080078125, 417.625, 104.84100341796875, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+148, 195253, 0, 1519, 5149, '0', 0, 0, -8623, 413.57501220703125, 114.802001953125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+149, 195263, 0, 1519, 5149, '0', 0, 0, -8755.009765625, 373.194000244140625, 103.8420028686523437, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+150, 195260, 0, 1519, 5149, '0', 0, 0, -8611.33984375, 397.406005859375, 111.2949981689453125, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+151, 195253, 0, 1519, 5149, '0', 0, 0, -8610.8603515625, 398.37799072265625, 114.7939987182617187, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+152, 195260, 0, 1519, 5149, '0', 0, 0, -8613.33984375, 395.938995361328125, 111.2829971313476562, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+153, 195253, 0, 1519, 5149, '0', 0, 0, -8616.7900390625, 405.72198486328125, 114.6839981079101562, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+154, 195260, 0, 1519, 5149, '0', 0, 0, -8615.400390625, 394.3699951171875, 111.2259979248046875, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+155, 195260, 0, 1519, 5149, '0', 0, 0, -8609.5595703125, 398.915008544921875, 111.3219985961914062, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+156, 195260, 0, 1519, 5149, '0', 0, 0, -8605.7001953125, 401.894012451171875, 111.3389968872070312, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+157, 195260, 0, 1519, 5149, '0', 0, 0, -8607.6298828125, 400.3330078125, 111.3130035400390625, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+158, 195253, 0, 1519, 5149, '0', 0, 0, -8605.400390625, 391.31298828125, 114.6859970092773437, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+159, 195256, 0, 1519, 5149, '0', 0, 0, -8538.669921875, 470.20001220703125, 104.5210037231445312, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Old Town - Difficulty: 0) +(@OGUID+160, 195263, 0, 1519, 5390, '0', 0, 0, -8511.3798828125, 527.78997802734375, 109.8679962158203125, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+161, 195255, 0, 1519, 5390, '0', 0, 0, -8546.8095703125, 354.77301025390625, 133.5149993896484375, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+162, 195255, 0, 1519, 5390, '0', 0, 0, -8482, 359.67498779296875, 119.134002685546875, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+163, 195255, 0, 1519, 5390, '0', 0, 0, -8433.8798828125, 435.0159912109375, 133.477996826171875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+164, 195255, 0, 1519, 5390, '0', 0, 0, -8459.259765625, 377.5419921875, 118.4810028076171875, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+165, 195254, 0, 1519, 0, '0', 0, 0, -8465.6396484375, 324.45001220703125, 177.1450042724609375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+166, 195256, 0, 1519, 0, '0', 0, 0, -8511.080078125, 320.92401123046875, 135.7100067138671875, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+167, 195255, 0, 1519, 0, '0', 0, 0, -8416.1201171875, 410.0679931640625, 141.3849945068359375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+168, 195256, 0, 1519, 0, '0', 0, 0, -8465.08984375, 322.696014404296875, 135.90899658203125, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+169, 195255, 0, 1519, 0, '0', 0, 0, -8530.2099609375, 333.0050048828125, 140.720001220703125, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+170, 195256, 0, 1519, 0, '0', 0, 0, -8428.75, 351.0159912109375, 135.9669952392578125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+171, 195254, 0, 1519, 0, '0', 0, 0, -8428.66015625, 352.906005859375, 177.80499267578125, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+172, 195256, 0, 1519, 0, '0', 0, 0, -8413.7900390625, 397.641998291015625, 135.7100067138671875, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: 0 - Difficulty: 0) +(@OGUID+173, 195256, 0, 1519, 5150, '0', 0, 0, -8430.9853515625, 596.3505859375, 94.6203155517578125, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+174, 195260, 0, 1519, 5150, '0', 0, 0, -8381.16015625, 590.3909912109375, 98.918701171875, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+175, 195263, 0, 1519, 5150, '0', 0, 0, -8408.650390625, 635.03302001953125, 101.40899658203125, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+176, 195260, 0, 1519, 5150, '0', 0, 0, -8379.3203125, 591.947998046875, 98.94409942626953125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0 +(@OGUID+177, 195260, 0, 1519, 5150, '0', 0, 0, -8383.0595703125, 588.96502685546875, 98.90579986572265625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+178, 195266, 0, 1519, 5150, '0', 0, 0, -8385.4599609375, 598, 104.569000244140625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+179, 195266, 0, 1519, 5150, '0', 0, 0, -8379.23046875, 603.39801025390625, 104.4680023193359375, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+180, 195266, 0, 1519, 5150, '0', 0, 0, -8376.7802734375, 589.87298583984375, 107.9199981689453125, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+181, 195260, 0, 1519, 5150, '0', 0, 0, -8386.349609375, 623.93902587890625, 96.31549835205078125, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+182, 195260, 0, 1519, 5150, '0', 0, 0, -8389.16015625, 630.61102294921875, 96.137298583984375, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+183, 195260, 0, 1519, 5150, '0', 0, 0, -8387.7099609375, 625.27801513671875, 96.30049896240234375, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+184, 195260, 0, 1519, 5150, '0', 0, 0, -8387.150390625, 627.6300048828125, 98.62200164794921875, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+185, 195260, 0, 1519, 5150, '0', 0, 0, -8385.5595703125, 625.97198486328125, 98.6584014892578125, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+186, 195260, 0, 1519, 5150, '0', 0, 0, -8387.1201171875, 629.906005859375, 98.54340362548828125, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+187, 195260, 0, 1519, 5150, '0', 0, 0, -8389.1201171875, 626.697998046875, 96.2743988037109375, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+188, 195260, 0, 1519, 5150, '0', 0, 0, -8384.3701171875, 623.92498779296875, 96.26580047607421875, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+189, 195260, 0, 1519, 5150, '0', 0, 0, -8389.169921875, 628.47100830078125, 96.2133026123046875, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+190, 195260, 0, 1519, 5150, '0', 0, 0, -8377.3896484375, 593.47900390625, 98.91660308837890625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+191, 195260, 0, 1519, 5150, '0', 0, 0, -8383.25, 626.010009765625, 98.580596923828125, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+192, 195260, 0, 1519, 5150, '0', 0, 0, -8380.9501953125, 631.93902587890625, 95.94789886474609375, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+193, 195266, 0, 1519, 5150, '0', 0, 0, -8370.5400390625, 582.072998046875, 107.9589996337890625, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+194, 195260, 0, 1519, 5150, '0', 0, 0, -8365.16015625, 574.33502197265625, 105.302001953125, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+195, 195266, 0, 1519, 5150, '0', 0, 0, -8368.1103515625, 596.7760009765625, 107.9199981689453125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+196, 195260, 0, 1519, 5150, '0', 0, 0, -8379.6298828125, 630.61798095703125, 95.96309661865234375, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+197, 195260, 0, 1519, 5150, '0', 0, 0, -8384.3798828125, 626.86297607421875, 100.5749969482421875, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+198, 195260, 0, 1519, 5150, '0', 0, 0, -8363.0595703125, 575.92498779296875, 105.3600006103515625, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+199, 195260, 0, 1519, 5150, '0', 0, 0, -8382.3896484375, 628.8179931640625, 100.464996337890625, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+200, 195260, 0, 1519, 5150, '0', 0, 0, -8382.4404296875, 623.92498779296875, 96.22039794921875, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+201, 195260, 0, 1519, 5150, '0', 0, 0, -8381.150390625, 625.22198486328125, 96.16049957275390625, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+202, 195266, 0, 1519, 5150, '0', 0, 0, -8372.83984375, 608.9010009765625, 104.3860015869140625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+203, 195260, 0, 1519, 5150, '0', 0, 0, -8382.4599609375, 633.3389892578125, 95.92220306396484375, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+204, 195260, 0, 1519, 5150, '0', 0, 0, -8384.4501953125, 633.45098876953125, 95.9521026611328125, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+205, 195260, 0, 1519, 5150, '0', 0, 0, -8387.73046875, 632.10101318359375, 96.0623016357421875, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+206, 195260, 0, 1519, 5150, '0', 0, 0, -8368.099609375, 600.5989990234375, 98.92060089111328125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+207, 195260, 0, 1519, 5150, '0', 0, 0, -8385.5400390625, 631.54498291015625, 98.4506988525390625, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+208, 195260, 0, 1519, 5150, '0', 0, 0, -8379.6396484375, 628.64202880859375, 96.03600311279296875, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+209, 195260, 0, 1519, 5150, '0', 0, 0, -8383.23046875, 631.56402587890625, 98.41120147705078125, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+210, 195260, 0, 1519, 5150, '0', 0, 0, -8371.8701171875, 597.489990234375, 98.9149017333984375, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+211, 195260, 0, 1519, 5150, '0', 0, 0, -8369.990234375, 599.0780029296875, 98.946197509765625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+212, 195260, 0, 1519, 5150, '0', 0, 0, -8386.3798828125, 633.322998046875, 95.99030303955078125, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+213, 195260, 0, 1519, 5150, '0', 0, 0, -8384.3896484375, 630.76702880859375, 100.4369964599609375, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+214, 195260, 0, 1519, 5150, '0', 0, 0, -8379.669921875, 626.72900390625, 96.09929656982421875, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+215, 195260, 0, 1519, 5150, '0', 0, 0, -8381.6201171875, 629.9169921875, 98.4380035400390625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+216, 195260, 0, 1519, 5150, '0', 0, 0, -8386.2900390625, 629.08697509765625, 100.5250015258789062, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+217, 195260, 0, 1519, 5150, '0', 0, 0, -8381.580078125, 627.6090087890625, 98.5211029052734375, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+218, 195260, 0, 1519, 5150, '0', 0, 0, -8366.25, 602.09698486328125, 98.90540313720703125, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+219, 195260, 0, 1519, 5150, '0', 0, 0, -8357.3896484375, 580.20697021484375, 105.3870010375976562, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+220, 195260, 0, 1519, 5150, '0', 0, 0, -8361.16015625, 577.29302978515625, 105.365997314453125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+221, 195253, 0, 1519, 5150, '0', 0, 0, -8360.6396484375, 578.25897216796875, 108.80999755859375, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+222, 195266, 0, 1519, 5150, '0', 0, 0, -8361.8798828125, 588.97698974609375, 107.9459991455078125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+223, 195260, 0, 1519, 5150, '0', 0, 0, -8355.4296875, 581.78497314453125, 105.41400146484375, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+224, 195260, 0, 1519, 5150, '0', 0, 0, -8359.3095703125, 578.79901123046875, 105.3980026245117187, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+225, 195253, 0, 1519, 5150, '0', 0, 0, -8355.1201171875, 571.25, 108.8700027465820312, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+226, 195263, 0, 1519, 5150, '0', 0, 0, -8378.3896484375, 659.16302490234375, 98.5727996826171875, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+227, 195273, 0, 1519, 5150, '0', 0, 0, -8375.5498046875, 658.73101806640625, 100.4929962158203125, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+228, 195273, 0, 1519, 5150, '0', 0, 0, -8378.9404296875, 672.36297607421875, 100.5120010375976562, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+229, 195263, 0, 1519, 5150, '0', 0, 0, -8468.7421875, 686.888916015625, 110.7254867553710937, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+230, 195273, 0, 1519, 5150, '0', 0, 0, -8361.349609375, 647.88201904296875, 100.78900146484375, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+231, 195253, 0, 1519, 5150, '0', 0, 0, -8341.169921875, 615.3489990234375, 104.2730026245117187, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+232, 195266, 0, 1519, 5150, '0', 0, 0, -8329.48046875, 589.61798095703125, 104.134002685546875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+233, 195273, 0, 1519, 5150, '0', 0, 0, -8353.580078125, 664.33502197265625, 100.5579986572265625, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+234, 195266, 0, 1519, 5150, '0', 0, 0, -8333.1201171875, 594.05401611328125, 104.214996337890625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+235, 195263, 0, 1519, 5150, '0', 0, 0, -8329.7998046875, 637.0050048828125, 100.5110015869140625, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+236, 195266, 0, 1519, 5150, '0', 0, 0, -8321.6201171875, 603.00201416015625, 104.1529998779296875, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+237, 195266, 0, 1519, 5150, '0', 0, 0, -8317.8603515625, 598.41302490234375, 104.2300033569335937, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+238, 195263, 0, 1519, 5150, '0', 0, 0, -8343.8896484375, 654.08197021484375, 100.3600006103515625, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+239, 195273, 0, 1519, 5150, '0', 0, 0, -8356.7197265625, 677.468994140625, 100.5189971923828125, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Dwarven District - Difficulty: 0) +(@OGUID+240, 195263, 0, 1519, 5390, '0', 0, 0, -8551.73046875, 761.64801025390625, 101.7779998779296875, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+241, 195263, 0, 1519, 5390, '0', 0, 0, -8588.4072265625, 706.8125, 108.9886932373046875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+242, 195263, 0, 1519, 5390, '0', 0, 0, -8558.7998046875, 770.135009765625, 101.7600021362304687, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+243, 195256, 0, 1519, 5151, '0', 0, 0, -8611.9580078125, 774.59185791015625, 97.13689422607421875, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+244, 195260, 0, 1519, 5151, '0', 0, 0, -8632.080078125, 760.66998291015625, 98.3329010009765625, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+245, 195260, 0, 1519, 5151, '0', 0, 0, -8631.6396484375, 764.7030029296875, 98.36640167236328125, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+246, 195256, 0, 1519, 5151, '0', 0, 0, -8621.1865234375, 786.200439453125, 97.1391143798828125, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+247, 195260, 0, 1519, 5151, '0', 0, 0, -8494.73046875, 837.82598876953125, 106.6569976806640625, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+248, 195260, 0, 1519, 5151, '0', 0, 0, -8635.2998046875, 758.21502685546875, 98.369903564453125, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+249, 195260, 0, 1519, 5151, '0', 0, 0, -8634.16015625, 767.9219970703125, 98.3634033203125, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+250, 195260, 0, 1519, 5151, '0', 0, 0, -8493.2802734375, 836.66998291015625, 106.6630020141601562, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+251, 195260, 0, 1519, 5151, '0', 0, 0, -8638.1796875, 768.38702392578125, 98.362396240234375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+252, 195260, 0, 1519, 5151, '0', 0, 0, -8641.830078125, 761.8590087890625, 98.36710357666015625, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+253, 195260, 0, 1519, 5151, '0', 0, 0, -8639.330078125, 758.64801025390625, 98.365997314453125, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+254, 195260, 0, 1519, 5151, '0', 0, 0, -8641.33984375, 765.8590087890625, 98.36750030517578125, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+255, 195263, 0, 1519, 5151, '0', 0, 0, -8665.8203125, 741.17498779296875, 108.7089996337890625, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+256, 195263, 0, 1519, 5151, '0', 0, 0, -8656.2236328125, 844.97674560546875, 108.9539794921875, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+257, 195263, 0, 1519, 5151, '0', 0, 0, -8752.1298828125, 799.635009765625, 109.9039993286132812, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+258, 195260, 0, 1519, 5151, '0', 0, 0, -8572.2099609375, 900.8330078125, 100.5100021362304687, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+259, 195260, 0, 1519, 5151, '0', 0, 0, -8568.2802734375, 905.49298095703125, 104.8330001831054687, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+260, 195260, 0, 1519, 5151, '0', 0, 0, -8572.1298828125, 910.29998779296875, 100.378997802734375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+261, 195266, 0, 1519, 5151, '0', 0, 0, -8624.951171875, 933.5069580078125, 125.2897720336914062, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+262, 195260, 0, 1519, 5151, '0', 0, 0, -8573.0498046875, 906.73101806640625, 102.8479995727539062, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+263, 195260, 0, 1519, 5151, '0', 0, 0, -8565.51953125, 903.57501220703125, 100.4840011596679687, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+264, 195263, 0, 1519, 5151, '0', 0, 0, -8535.490234375, 903.0689697265625, 103.569000244140625, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+265, 195260, 0, 1519, 5151, '0', 0, 0, -8570.2197265625, 903.64202880859375, 104.8649978637695312, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+266, 195260, 0, 1519, 5151, '0', 0, 0, -8567.419921875, 906.697998046875, 102.8509979248046875, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+267, 195260, 0, 1519, 5151, '0', 0, 0, -8566.8798828125, 908.86798095703125, 100.4039993286132812, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+268, 195260, 0, 1519, 5151, '0', 0, 0, -8569.0595703125, 908.37701416015625, 102.8259963989257812, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+269, 195263, 0, 1519, 5151, '0', 0, 0, -8539.650390625, 892.7030029296875, 103.6699981689453125, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+270, 195260, 0, 1519, 5151, '0', 0, 0, -8568.41015625, 910.24298095703125, 100.3779983520507812, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+271, 195260, 0, 1519, 5151, '0', 0, 0, -8573.01953125, 904.406005859375, 102.8690032958984375, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+272, 195260, 0, 1519, 5151, '0', 0, 0, -8571.3896484375, 908.385009765625, 102.81500244140625, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+273, 195260, 0, 1519, 5151, '0', 0, 0, -8566.8701171875, 902.15997314453125, 100.48699951171875, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+274, 195260, 0, 1519, 5151, '0', 0, 0, -8574.98046875, 903.5159912109375, 100.4680023193359375, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+275, 195260, 0, 1519, 5151, '0', 0, 0, -8567.4296875, 904.40997314453125, 102.88800048828125, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+276, 195260, 0, 1519, 5151, '0', 0, 0, -8565.5703125, 907.47698974609375, 100.4250030517578125, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+277, 195260, 0, 1519, 5151, '0', 0, 0, -8573.6201171875, 902.2139892578125, 100.4860000610351562, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+278, 195260, 0, 1519, 5151, '0', 0, 0, -8565.5, 905.54498291015625, 100.4520034790039062, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+279, 195260, 0, 1519, 5151, '0', 0, 0, -8571.3896484375, 902.75701904296875, 102.9000015258789062, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+280, 195260, 0, 1519, 5151, '0', 0, 0, -8573.51953125, 908.98602294921875, 100.391998291015625, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+281, 195260, 0, 1519, 5151, '0', 0, 0, -8569.0595703125, 902.78997802734375, 102.8669967651367187, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+282, 195260, 0, 1519, 5151, '0', 0, 0, -8570.169921875, 910.260009765625, 100.3769989013671875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+283, 195260, 0, 1519, 5151, '0', 0, 0, -8572.2001953125, 905.61602783203125, 104.8349990844726562, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+284, 195260, 0, 1519, 5151, '0', 0, 0, -8570.2099609375, 900.76397705078125, 100.5009994506835937, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+285, 195260, 0, 1519, 5151, '0', 0, 0, -8575, 907.4949951171875, 100.4059982299804687, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+286, 195260, 0, 1519, 5151, '0', 0, 0, -8575.0400390625, 905.50299072265625, 100.4449996948242187, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+287, 195260, 0, 1519, 5151, '0', 0, 0, -8570.2900390625, 907.552001953125, 104.8040008544921875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+288, 195260, 0, 1519, 5151, '0', 0, 0, -8568.23046875, 900.78802490234375, 100.4929962158203125, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+289, 195253, 0, 1519, 5151, '0', 0, 0, -8523.935546875, 930.32086181640625, 108.9770278930664062, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+290, 195256, 0, 1519, 5151, '0', 0, 0, -8586.7041015625, 962.4266357421875, 98.4514617919921875, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+291, 195253, 0, 1519, 5151, '0', 0, 0, -8630.92578125, 945.2586669921875, 135.815643310546875, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+292, 195255, 0, 1519, 5151, '0', 0, 0, -8630.6298828125, 945.80035400390625, 112.9881973266601562, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+293, 195266, 0, 1519, 5151, '0', 0, 0, -8641.03125, 953.5711669921875, 122.9622268676757812, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+294, 195260, 0, 1519, 5151, '0', 0, 0, -8489.6396484375, 842.10797119140625, 108.7779998779296875, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+295, 195260, 0, 1519, 5151, '0', 0, 0, -8487.7197265625, 839.50701904296875, 106.66400146484375, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+296, 195260, 0, 1519, 5151, '0', 0, 0, -8489.25, 844.07098388671875, 106.6750030517578125, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+297, 195260, 0, 1519, 5151, '0', 0, 0, -8490.2998046875, 841.06597900390625, 110.5, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+298, 195260, 0, 1519, 5151, '0', 0, 0, -8491.1796875, 843.42401123046875, 108.7779998779296875, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+299, 195260, 0, 1519, 5151, '0', 0, 0, -8493.1396484375, 843.26397705078125, 108.7779998779296875, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+300, 195260, 0, 1519, 5151, '0', 0, 0, -8489.48046875, 840.12799072265625, 108.7819976806640625, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+301, 195260, 0, 1519, 5151, '0', 0, 0, -8489.9296875, 836.9219970703125, 106.6620025634765625, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+302, 195260, 0, 1519, 5151, '0', 0, 0, -8495.83984375, 838.88201904296875, 106.6439971923828125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+303, 195260, 0, 1519, 5151, '0', 0, 0, -8492.1298828125, 845.04901123046875, 106.6699981689453125, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+304, 195260, 0, 1519, 5151, '0', 0, 0, -8490.76953125, 838.59197998046875, 108.7809982299804687, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+305, 195260, 0, 1519, 5151, '0', 0, 0, -8493.9296875, 844.89898681640625, 106.667999267578125, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+306, 195253, 0, 1519, 5151, '0', 0, 0, -8578.419921875, 986.79998779296875, 133.947998046875, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+307, 195260, 0, 1519, 5151, '0', 0, 0, -8494.2900390625, 839.76898193359375, 108.759002685546875, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+308, 195260, 0, 1519, 5151, '0', 0, 0, -8496.1103515625, 840.6199951171875, 106.6510009765625, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+309, 195260, 0, 1519, 5151, '0', 0, 0, -8488.7900390625, 838.1939697265625, 106.6630020141601562, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+310, 195256, 0, 1519, 5151, '0', 0, 0, -8605.8203125, 983.83074951171875, 98.5787200927734375, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+311, 195260, 0, 1519, 5151, '0', 0, 0, -8488, 842.88201904296875, 106.6630020141601562, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+312, 195260, 0, 1519, 5151, '0', 0, 0, -8495.080078125, 843.64202880859375, 106.6650009155273437, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+313, 195260, 0, 1519, 5151, '0', 0, 0, -8487.7998046875, 841.12799072265625, 106.6650009155273437, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+314, 195260, 0, 1519, 5151, '0', 0, 0, -8492.099609375, 842.63702392578125, 110.5, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+315, 195255, 0, 1519, 5151, '0', 0, 0, -8578.53125, 986.1268310546875, 111.2677764892578125, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+316, 195260, 0, 1519, 5151, '0', 0, 0, -8492.759765625, 838.44097900390625, 108.779998779296875, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+317, 195260, 0, 1519, 5151, '0', 0, 0, -8493.6796875, 840.83197021484375, 110.5009994506835937, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+318, 195260, 0, 1519, 5151, '0', 0, 0, -8490.4697265625, 845.10601806640625, 106.6729965209960937, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+319, 195260, 0, 1519, 5151, '0', 0, 0, -8491.5595703125, 836.802001953125, 106.6630020141601562, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+320, 195266, 0, 1519, 5151, '0', 0, 0, -8568.1474609375, 978.65399169921875, 122.7586669921875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+321, 195260, 0, 1519, 5151, '0', 0, 0, -8494.4599609375, 841.74798583984375, 108.7760009765625, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+322, 195260, 0, 1519, 5151, '0', 0, 0, -8496.169921875, 842.2760009765625, 106.6620025634765625, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+323, 195260, 0, 1519, 5151, '0', 0, 0, -8491.8095703125, 839.22698974609375, 110.4980010986328125, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45338), -- Standing, Interior, Small - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+324, 195256, 0, 1519, 5151, '0', 0, 0, -8548.0390625, 997.265869140625, 89.73065185546875, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+325, 195266, 0, 1519, 5151, '0', 0, 0, -8584.169921875, 998.56298828125, 122.819000244140625, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+326, 195256, 0, 1519, 5151, '0', 0, 0, -8562.5634765625, 1016.08551025390625, 89.73065185546875, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Cathedral Square - Difficulty: 0) +(@OGUID+327, 195254, 0, 1519, 4411, '0', 0, 0, -8532.0751953125, 1059.33544921875, 28.86179542541503906, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+328, 195254, 0, 1519, 4411, '0', 0, 0, -8475.3037109375, 1051.581298828125, 29.42984390258789062, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+329, 195273, 0, 1519, 4411, '0', 0, 0, -8489.2880859375, 1178.189697265625, 19.15488624572753906, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+330, 195256, 0, 1519, 4411, '0', 0, 0, -8412.6845703125, 1042.2760009765625, 68.3837890625, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+331, 195266, 0, 1519, 4411, '0', 0, 0, -8534.486328125, 1204.2041015625, 16.40989112854003906, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+332, 195266, 0, 1519, 4411, '0', 0, 0, -8542.3212890625, 1200.5806884765625, 16.43208122253417968, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+333, 195266, 0, 1519, 4411, '0', 0, 0, -8520.5244140625, 1204.2047119140625, 16.42971992492675781, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+334, 195266, 0, 1519, 4411, '0', 0, 0, -8512.31640625, 1200.337890625, 16.39689445495605468, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+335, 195273, 0, 1519, 4411, '0', 0, 0, -8470.8974609375, 1178.189208984375, 19.26302337646484375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+336, 195273, 0, 1519, 4411, '0', 0, 0, -8565.794921875, 1178.1890869140625, 19.314239501953125, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+337, 195273, 0, 1519, 4411, '0', 0, 0, -8584.2392578125, 1178.189208984375, 19.26141548156738281, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+338, 195273, 0, 1519, 4411, '0', 0, 0, -8565.8369140625, 1181.0335693359375, 18.98039054870605468, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+339, 195273, 0, 1519, 4411, '0', 0, 0, -8584.185546875, 1181.032958984375, 18.81927490234375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+340, 195273, 0, 1519, 4411, '0', 0, 0, -8470.8994140625, 1181.034912109375, 19.37266159057617187, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+341, 195266, 0, 1519, 4411, '0', 0, 0, -8504.935546875, 1192.6331787109375, 16.33524894714355468, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+342, 195273, 0, 1519, 4411, '0', 0, 0, -8489.095703125, 1181.034912109375, 19.36829757690429687, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+343, 195273, 0, 1519, 4411, '0', 0, 0, -8489.3603515625, 1251.8638916015625, 9.806099891662597656, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+344, 195256, 0, 1519, 4411, '0', 0, 0, -8439.421875, 1221.0718994140625, 5.66116189956665039, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+345, 195273, 0, 1519, 4411, '0', 0, 0, -8458.8095703125, 1252.0125732421875, 9.891839981079101562, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+346, 195256, 0, 1519, 4411, '0', 0, 0, -8451.66015625, 1220.8668212890625, 5.64672708511352539, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+347, 195273, 0, 1519, 4411, '0', 0, 0, -8397.2392578125, 1251.8677978515625, 9.888047218322753906, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+348, 195256, 0, 1519, 4411, '0', 0, 0, -8350.607421875, 1093.49365234375, 57.26216506958007812, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+349, 195263, 0, 1519, 4411, '0', 0, 0, -8745.3095703125, 860.75177001953125, 110.069366455078125, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+350, 195263, 0, 1519, 8411, '0', 0, 0, -8805.12109375, 868.18316650390625, 109.9552078247070312, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: -Unknown- - Difficulty: 0) +(@OGUID+351, 195263, 0, 1519, 5390, '0', 0, 0, -8811.73046875, 809.0419921875, 109.8079986572265625, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+352, 195263, 0, 1519, 5390, '0', 0, 0, -8883.6806640625, 758.49298095703125, 105.1223526000976562, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+353, 195253, 0, 1519, 5390, '0', 0, 0, -8892.51953125, 867.23602294921875, 109.0019989013671875, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+354, 195263, 0, 1519, 5390, '0', 0, 0, -8857.830078125, 931.6610107421875, 113.0839996337890625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+355, 195253, 0, 1519, 5390, '0', 0, 0, -8914.2099609375, 995.18798828125, 129.576995849609375, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+356, 195253, 0, 1519, 5390, '0', 0, 0, -8904.2197265625, 1010.32000732421875, 130.6670074462890625, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: The Canals - Difficulty: 0) +(@OGUID+357, 195253, 0, 1519, 5154, '0', 0, 0, -8948.169921875, 861.864990234375, 119.2649993896484375, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+358, 195253, 0, 1519, 5154, '0', 0, 0, -8937.3095703125, 861.2340087890625, 119.3000030517578125, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 45338), -- Hanging, Streamer x3 - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+359, 195256, 0, 1519, 5154, '0', 0, 0, -8993.67578125, 964.9757080078125, 67.5161590576171875, 4.15491485595703125, 0, 0, -0.87436962127685546, 0.485260486602783203, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+360, 195256, 0, 1519, 5154, '0', 0, 0, -8986.0263671875, 954.234375, 67.51596832275390625, 3.490974664688110351, 0, 0, -0.98478031158447265, 0.173803776502609252, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+361, 195263, 0, 1519, 5154, '0', 0, 0, -9006.259765625, 877.905029296875, 116.46600341796875, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+362, 195256, 0, 1519, 5154, '0', 0, 0, -9041.0380859375, 932.81597900390625, 66.15769195556640625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+363, 195256, 0, 1519, 5154, '0', 0, 0, -9021.5380859375, 901.03472900390625, 64.86025238037109375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+364, 195256, 0, 1519, 5154, '0', 0, 0, -9002.96875, 877.66839599609375, 64.86025238037109375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+365, 195256, 0, 1519, 5154, '0', 0, 0, -9029.875, 895.02777099609375, 64.86025238037109375, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+366, 195263, 0, 1519, 5154, '0', 0, 0, -9013.9599609375, 872.1409912109375, 113.3000030517578125, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+367, 195263, 0, 1519, 5154, '0', 0, 0, -9003.76953125, 862.552001953125, 129.85699462890625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+368, 195263, 0, 1519, 5154, '0', 0, 0, -8999.5, 865.91497802734375, 129.675994873046875, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 45338), -- Hanging, Square, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+369, 195256, 0, 1519, 5154, '0', 0, 0, -9055.580078125, 921.295166015625, 66.15769195556640625, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+370, 195256, 0, 1519, 5154, '0', 0, 0, -9011.3037109375, 871.66143798828125, 64.86025238037109375, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+371, 195256, 0, 1519, 5154, '0', 0, 0, -9071.94140625, 887.44268798828125, 67.48587799072265625, 1.096506595611572265, 0, 0, 0.521197319030761718, 0.853436231613159179, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+372, 195256, 0, 1519, 5154, '0', 0, 0, -9079.9755859375, 898.69097900390625, 67.47487640380859375, 0.137406647205352783, 0, 0, 0.0686492919921875, 0.997640848159790039, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Mage Quarter - Difficulty: 0) +(@OGUID+373, 292549, 0, 1519, 1617, '0', 0, 0, -9107.373046875, 340.611114501953125, 94.87996673583984375, 1.029241323471069335, 0, 0, 0.492204666137695312, 0.870479464530944824, 120, 255, 1, 45338), -- Hay Bale (Area: Valley of Heroes - Difficulty: 0) +(@OGUID+374, 292549, 0, 1519, 1617, '0', 0, 0, -9116.408203125, 351.524322509765625, 93.59757232666015625, 2.009107112884521484, 0, 0, 0.843922615051269531, 0.536464929580688476, 120, 255, 1, 45338); -- Hay Bale (Area: Valley of Heroes - Difficulty: 0) + +-- Creature Template +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=40441; -- Battered Brewmaster +UPDATE `creature_template` SET `gossip_menu_id`=7861, `npcflag`=3 WHERE `entry`=18927; -- Human Commoner +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `unit_flags3`=16777216 WHERE `entry`=155345; -- [DNT] Brewfest Music +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=23510; -- Thunderbrew Apprentice +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=153931; -- Brewfest Reveler +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=23482; -- Barleybrew Apprentice +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=23511; -- Gordok Brew Apprentice + +-- GameObject Template +DELETE FROM `gameobject_template` WHERE `entry` IN (367978 /*Standing, Interior, Small 3 - Brewfest*/, 367977 /*Standing, Interior, Small 2 - Brewfest*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(367978, 5, 69060, 'Standing, Interior, Small 3 - Brewfest', '', '', '', 1.25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45338), -- Standing, Interior, Small 3 - Brewfest +(367977, 5, 8993, 'Standing, Interior, Small 2 - Brewfest', '', '', '', 1.25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45338); -- Standing, Interior; Small 2 - Brewfest + +UPDATE `gameobject_template` SET `ContentTuningId`=298, `VerifiedBuild`=45338 WHERE `entry`=186185; -- Gordok Festive Keg +UPDATE `gameobject_template` SET `ContentTuningId`=298, `VerifiedBuild`=45338 WHERE `entry`=326139; -- Alcohol-Free Brewfest Sampler +UPDATE `gameobject_template` SET `ContentTuningId`=298, `VerifiedBuild`=45338 WHERE `entry`=186184; -- Thunderbrew Festive Keg +UPDATE `gameobject_template` SET `ContentTuningId`=298, `VerifiedBuild`=45338 WHERE `entry`=186183; -- Barleybrew Festive Keg +UPDATE `gameobject_template` SET `displayId`=57059, `VerifiedBuild`=45338 WHERE `entry`=195254; -- Hanging, Square, Large - Brewfest + +-- GameObject Template Addon +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (326138 /*Party Table*/, 292549 /*Hay Bale*/, 367978 /*Standing, Interior, Small 3 - Brewfest*/, 367977 /*Standing, Interior, Small 2 - Brewfest*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(326138, 114, 0, 0, 0), -- Party Table +(292549, 1375, 8192, 0, 0), -- Hay Bale +(367978, 114, 0, 0, 0), -- Standing, Interior, Small 3 - Brewfest +(367977, 114, 0, 0, 0); -- Standing, Interior, Small 2 - Brewfest + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`Entry`=40441 AND `DifficultyID`=0); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(40441, 0, 0, 0, 298, 45338); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=45338 WHERE (`DifficultyID`=0 AND `Entry` IN (149458,1141,1313,1311,3628,5503,5499,5081,5500,1300,1347,1346,5566,1314,4078,1310,1309,148796,1429,5567,149445,147785,52408,148233,158753,5497,158463,158440,158436,23837,158755,149616,1415,1414,1413,2708,150122,158456,151937,331,149121,149131,2485,5498,149124,5694,149626,89174,174146,85307,149433,5520,1435,461,5496,149099,9584,147741,103033,147714,5495,1733,155739,148124,82564,85819,1307,1305,1419,84751,84749,85818,85817,84745,85816,3627,1308,1304,130828,297,133704,5506,30730,30713,1317,49701,5386,52031,42288,338,1316,1315,1312,46180,11068,1318,1366,5493,5494,188679,113211,1367,188342,188678,49893,11828,11827,5504,9977,151287,7295,114246,5505,29154,43102,188374,3469,141554,44749,29016,29152,29088,29144,29019,176240,176224,176231,176234,36674,176236,176225,176223,50435,44880,6173,5489,15214,376,29712,57800,1212,1371,1370,1368,1348,54443,54442,1405,68980,3520,1350,1349,50424,157498,157496,142816,50432,83883,6171,83890,83882,83878,14450,173819,4982,7917,1444,141508,5484,1351,141504,5492,5491,12336,14496,56796,54117,928,14497,54026,1646,10782,133494,133458,3511,3510,3508,3507,3505,16908,44395,133675,19269,3681,43840,43825,7232,43842,43841,43725,43724,43823,5509,43824,5514,3513,3512,3509,43690,1416,43723,5513,11026,14563,80069,5518,44394,1649,44393,20407,43034,5519,144134,6579,44235,44236,45306,144135,5511,5512,5510,957,144133,29725,188521,7798,133441,5516,5517,2879,5413,44392,5515,1472,53991,54214,54219,54217,54216,54215,54218,53641,656,11069,1439,17103,4960,2285,1752,721,165505,61840,61839,58167,5384,61841,1756,1327,173706,6090,176220,5483,176203,340,6089,3629,5482,155011,1328,164960,164948,164940,164957,164954,164953,164939,164950,164947,1326,164955,6946,164961,164952,164946,1325,164945,164962,164942,164956,164949,164943,164941,175435,62913,167429,7208,7207,51998,8383,35845,13283,14559,114832,44252,14561,153292,1341,918,44237,1324,31146,1323,3626,176192,28355,28347,176237,176235,71526,55684,38821,140407,140403,3504,47688,2330,2331,4961,1333,43694,163007,43693,1721,4269,73190,14560,87503,2795,1395,12783,44245,12787,12786,12785,308,284,58154,146633,54660,69975,52029,12784,19848,44246,175051,12781,12780,12779,62954,69974,52030,176221,87501,188523,23050,1292,11096,176226,1339,1321,1320,176244,5564,5565,1319,52361,52359,52358,44583,50480,1478,1477,61837,176230,176233,176229,18376,44582,50523,133509,56925,42421,50525,50524,29142,61838,2533,2532,61081,18406,43768,890,5917,1933,1412,94,30,1423,2442,61165,23511,60649,155345,883,23510,153931,23482,42218,61080,4959,17804,18360,186180,14721,14394,352,18359,18357,65153,18362,49877,1302,61896,61895,1303,18375,43769,35477,2334,2198,1294,1287,1285,49748,51440,1402,48632,1301,1297,14439,14438,1286,1299,1298,1295,142668,1291,142666,1289,14423,6174,43692,133431,50669,8670,111190,482,4981,4974,46602,12481,12480,1432,1431,1428,1427,483,141270,1257,1275,15659,2457,2456,1976,2455,49540,29093,279,277,5193,121541,18927,8719,43822,43820,179896,32520,175420,3518,175416,188151,68,44774,44773,6740,140253,51348,61836,61834,43819,4075,62822,42339,133433,62821,162935)); +UPDATE `creature_template_scaling` SET `LevelScalingDeltaMax`=-4, `VerifiedBuild`=45338 WHERE (`DifficultyID`=0 AND `Entry` IN (66876,51081)); +UPDATE `creature_template_scaling` SET `LevelScalingDeltaMin`=-4, `LevelScalingDeltaMax`=-4, `VerifiedBuild`=45338 WHERE (`Entry`=108180 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `LevelScalingDeltaMin`=-2, `VerifiedBuild`=45338 WHERE (`Entry`=53626 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2148, `VerifiedBuild`=45338 WHERE (`Entry`=175138 AND `DifficultyID`=0); + +DELETE FROM `creature_model_info` WHERE `DisplayID`=83108; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(83108, 0.347222000360488891, 1.5, 0, 45338); + +-- Equip Template +DELETE FROM `creature_equip_template` WHERE (`CreatureID`=18927 AND `ID`=7); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(18927, 7, 46733, 0, 0, 0, 0, 0, 0, 0, 0, 45338); -- Human Commoner + +-- Vendor Data +DELETE FROM `npc_vendor` WHERE (`entry`=23511 AND `item`=138869 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23510 AND `item`=138868 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23510 AND `item`=138871 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23510 AND `item`=46399 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23482 AND `item`=138867 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23482 AND `item`=46400 AND `ExtendedCost`=0 AND `type`=1); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(23511, 5, 138869, 0, 0, 1, 0, 0, 45338), -- Gordok Bock +(23510, 6, 138868, 0, 0, 1, 0, 0, 45338), -- Mannoroth's Blood Red Ale +(23510, 5, 138871, 0, 0, 1, 0, 0, 45338), -- Storming Saison +(23510, 4, 46399, 0, 0, 1, 0, 0, 45338), -- Thunder's Plunder +(23482, 5, 138867, 0, 0, 1, 0, 0, 45338), -- Shimmer Stout +(23482, 4, 46400, 0, 0, 1, 0, 0, 45338); -- Barleybrew Gold + +UPDATE `npc_vendor` SET `VerifiedBuild`=45338 WHERE (`entry`=23511 AND `item`=46403 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23511 AND `item`=33036 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23511 AND `item`=33035 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23511 AND `item`=33034 AND `ExtendedCost`=0 AND `type`=1); +UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=45338 WHERE (`entry`=23510 AND `item`=33033 AND `ExtendedCost`=0 AND `type`=1); -- Thunderbrew Stout +UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=45338 WHERE (`entry`=23510 AND `item`=33032 AND `ExtendedCost`=0 AND `type`=1); -- Thunderbrew Ale +UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=45338 WHERE (`entry`=23510 AND `item`=33031 AND `ExtendedCost`=0 AND `type`=1); -- Thunder 45 +UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=45338 WHERE (`entry`=23482 AND `item`=33029 AND `ExtendedCost`=0 AND `type`=1); -- Barleybrew Dark +UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=45338 WHERE (`entry`=23482 AND `item`=33028 AND `ExtendedCost`=0 AND `type`=1); -- Barleybrew Light +UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=45338 WHERE (`entry`=23482 AND `item`=33030 AND `ExtendedCost`=0 AND `type`=1); -- Barleybrew Clear + +-- Outdated Commoner spawns +DELETE FROM `creature` WHERE `guid` IN (134885, 134886); +DELETE FROM `game_event_creature` WHERE `guid` IN (134885, 134886); + +-- game_event_spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=24 AND `guid` BETWEEN @CGUID+0 AND @CGUID+23; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(24, @CGUID+0), +(24, @CGUID+1), +(24, @CGUID+2), +(24, @CGUID+3), +(24, @CGUID+4), +(24, @CGUID+5), +(24, @CGUID+6), +(24, @CGUID+7), +(24, @CGUID+8), +(24, @CGUID+9), +(24, @CGUID+10), +(24, @CGUID+11), +(24, @CGUID+12), +(24, @CGUID+13), +(24, @CGUID+14), +(24, @CGUID+15), +(24, @CGUID+16), +(24, @CGUID+17), +(24, @CGUID+18), +(24, @CGUID+19), +(24, @CGUID+20), +(24, @CGUID+21), +(24, @CGUID+22), +(24, @CGUID+23); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=24 AND `guid` BETWEEN @OGUID+0 AND @OGUID+374; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(24, @OGUID+0), +(24, @OGUID+1), +(24, @OGUID+2), +(24, @OGUID+3), +(24, @OGUID+4), +(24, @OGUID+5), +(24, @OGUID+6), +(24, @OGUID+7), +(24, @OGUID+8), +(24, @OGUID+9), +(24, @OGUID+10), +(24, @OGUID+11), +(24, @OGUID+12), +(24, @OGUID+13), +(24, @OGUID+14), +(24, @OGUID+15), +(24, @OGUID+16), +(24, @OGUID+17), +(24, @OGUID+18), +(24, @OGUID+19), +(24, @OGUID+20), +(24, @OGUID+21), +(24, @OGUID+22), +(24, @OGUID+23), +(24, @OGUID+24), +(24, @OGUID+25), +(24, @OGUID+26), +(24, @OGUID+27), +(24, @OGUID+28), +(24, @OGUID+29), +(24, @OGUID+30), +(24, @OGUID+31), +(24, @OGUID+32), +(24, @OGUID+33), +(24, @OGUID+34), +(24, @OGUID+35), +(24, @OGUID+36), +(24, @OGUID+37), +(24, @OGUID+38), +(24, @OGUID+39), +(24, @OGUID+40), +(24, @OGUID+41), +(24, @OGUID+42), +(24, @OGUID+43), +(24, @OGUID+44), +(24, @OGUID+45), +(24, @OGUID+46), +(24, @OGUID+47), +(24, @OGUID+48), +(24, @OGUID+49), +(24, @OGUID+50), +(24, @OGUID+51), +(24, @OGUID+52), +(24, @OGUID+53), +(24, @OGUID+54), +(24, @OGUID+55), +(24, @OGUID+56), +(24, @OGUID+57), +(24, @OGUID+58), +(24, @OGUID+59), +(24, @OGUID+60), +(24, @OGUID+61), +(24, @OGUID+62), +(24, @OGUID+63), +(24, @OGUID+64), +(24, @OGUID+65), +(24, @OGUID+66), +(24, @OGUID+67), +(24, @OGUID+68), +(24, @OGUID+69), +(24, @OGUID+70), +(24, @OGUID+71), +(24, @OGUID+72), +(24, @OGUID+73), +(24, @OGUID+74), +(24, @OGUID+75), +(24, @OGUID+76), +(24, @OGUID+77), +(24, @OGUID+78), +(24, @OGUID+79), +(24, @OGUID+80), +(24, @OGUID+81), +(24, @OGUID+82), +(24, @OGUID+83), +(24, @OGUID+84), +(24, @OGUID+85), +(24, @OGUID+86), +(24, @OGUID+87), +(24, @OGUID+88), +(24, @OGUID+89), +(24, @OGUID+90), +(24, @OGUID+91), +(24, @OGUID+92), +(24, @OGUID+93), +(24, @OGUID+94), +(24, @OGUID+95), +(24, @OGUID+96), +(24, @OGUID+97), +(24, @OGUID+98), +(24, @OGUID+99), +(24, @OGUID+100), +(24, @OGUID+101), +(24, @OGUID+102), +(24, @OGUID+103), +(24, @OGUID+104), +(24, @OGUID+105), +(24, @OGUID+106), +(24, @OGUID+107), +(24, @OGUID+108), +(24, @OGUID+109), +(24, @OGUID+110), +(24, @OGUID+111), +(24, @OGUID+112), +(24, @OGUID+113), +(24, @OGUID+114), +(24, @OGUID+115), +(24, @OGUID+116), +(24, @OGUID+117), +(24, @OGUID+118), +(24, @OGUID+119), +(24, @OGUID+120), +(24, @OGUID+121), +(24, @OGUID+122), +(24, @OGUID+123), +(24, @OGUID+124), +(24, @OGUID+125), +(24, @OGUID+126), +(24, @OGUID+127), +(24, @OGUID+128), +(24, @OGUID+129), +(24, @OGUID+130), +(24, @OGUID+131), +(24, @OGUID+132), +(24, @OGUID+133), +(24, @OGUID+134), +(24, @OGUID+135), +(24, @OGUID+136), +(24, @OGUID+137), +(24, @OGUID+138), +(24, @OGUID+139), +(24, @OGUID+140), +(24, @OGUID+141), +(24, @OGUID+142), +(24, @OGUID+143), +(24, @OGUID+144), +(24, @OGUID+145), +(24, @OGUID+146), +(24, @OGUID+147), +(24, @OGUID+148), +(24, @OGUID+149), +(24, @OGUID+150), +(24, @OGUID+151), +(24, @OGUID+152), +(24, @OGUID+153), +(24, @OGUID+154), +(24, @OGUID+155), +(24, @OGUID+156), +(24, @OGUID+157), +(24, @OGUID+158), +(24, @OGUID+159), +(24, @OGUID+160), +(24, @OGUID+161), +(24, @OGUID+162), +(24, @OGUID+163), +(24, @OGUID+164), +(24, @OGUID+165), +(24, @OGUID+166), +(24, @OGUID+167), +(24, @OGUID+168), +(24, @OGUID+169), +(24, @OGUID+170), +(24, @OGUID+171), +(24, @OGUID+172), +(24, @OGUID+173), +(24, @OGUID+174), +(24, @OGUID+175), +(24, @OGUID+176), +(24, @OGUID+177), +(24, @OGUID+178), +(24, @OGUID+179), +(24, @OGUID+180), +(24, @OGUID+181), +(24, @OGUID+182), +(24, @OGUID+183), +(24, @OGUID+184), +(24, @OGUID+185), +(24, @OGUID+186), +(24, @OGUID+187), +(24, @OGUID+188), +(24, @OGUID+189), +(24, @OGUID+190), +(24, @OGUID+191), +(24, @OGUID+192), +(24, @OGUID+193), +(24, @OGUID+194), +(24, @OGUID+195), +(24, @OGUID+196), +(24, @OGUID+197), +(24, @OGUID+198), +(24, @OGUID+199), +(24, @OGUID+200), +(24, @OGUID+201), +(24, @OGUID+202), +(24, @OGUID+203), +(24, @OGUID+204), +(24, @OGUID+205), +(24, @OGUID+206), +(24, @OGUID+207), +(24, @OGUID+208), +(24, @OGUID+209), +(24, @OGUID+210), +(24, @OGUID+211), +(24, @OGUID+212), +(24, @OGUID+213), +(24, @OGUID+214), +(24, @OGUID+215), +(24, @OGUID+216), +(24, @OGUID+217), +(24, @OGUID+218), +(24, @OGUID+219), +(24, @OGUID+220), +(24, @OGUID+221), +(24, @OGUID+222), +(24, @OGUID+223), +(24, @OGUID+224), +(24, @OGUID+225), +(24, @OGUID+226), +(24, @OGUID+227), +(24, @OGUID+228), +(24, @OGUID+229), +(24, @OGUID+230), +(24, @OGUID+231), +(24, @OGUID+232), +(24, @OGUID+233), +(24, @OGUID+234), +(24, @OGUID+235), +(24, @OGUID+236), +(24, @OGUID+237), +(24, @OGUID+238), +(24, @OGUID+239), +(24, @OGUID+240), +(24, @OGUID+241), +(24, @OGUID+242), +(24, @OGUID+243), +(24, @OGUID+244), +(24, @OGUID+245), +(24, @OGUID+246), +(24, @OGUID+247), +(24, @OGUID+248), +(24, @OGUID+249), +(24, @OGUID+250), +(24, @OGUID+251), +(24, @OGUID+252), +(24, @OGUID+253), +(24, @OGUID+254), +(24, @OGUID+255), +(24, @OGUID+256), +(24, @OGUID+257), +(24, @OGUID+258), +(24, @OGUID+259), +(24, @OGUID+260), +(24, @OGUID+261), +(24, @OGUID+262), +(24, @OGUID+263), +(24, @OGUID+264), +(24, @OGUID+265), +(24, @OGUID+266), +(24, @OGUID+267), +(24, @OGUID+268), +(24, @OGUID+269), +(24, @OGUID+270), +(24, @OGUID+271), +(24, @OGUID+272), +(24, @OGUID+273), +(24, @OGUID+274), +(24, @OGUID+275), +(24, @OGUID+276), +(24, @OGUID+277), +(24, @OGUID+278), +(24, @OGUID+279), +(24, @OGUID+280), +(24, @OGUID+281), +(24, @OGUID+282), +(24, @OGUID+283), +(24, @OGUID+284), +(24, @OGUID+285), +(24, @OGUID+286), +(24, @OGUID+287), +(24, @OGUID+288), +(24, @OGUID+289), +(24, @OGUID+290), +(24, @OGUID+291), +(24, @OGUID+292), +(24, @OGUID+293), +(24, @OGUID+294), +(24, @OGUID+295), +(24, @OGUID+296), +(24, @OGUID+297), +(24, @OGUID+298), +(24, @OGUID+299), +(24, @OGUID+300), +(24, @OGUID+301), +(24, @OGUID+302), +(24, @OGUID+303), +(24, @OGUID+304), +(24, @OGUID+305), +(24, @OGUID+306), +(24, @OGUID+307), +(24, @OGUID+308), +(24, @OGUID+309), +(24, @OGUID+310), +(24, @OGUID+311), +(24, @OGUID+312), +(24, @OGUID+313), +(24, @OGUID+314), +(24, @OGUID+315), +(24, @OGUID+316), +(24, @OGUID+317), +(24, @OGUID+318), +(24, @OGUID+319), +(24, @OGUID+320), +(24, @OGUID+321), +(24, @OGUID+322), +(24, @OGUID+323), +(24, @OGUID+324), +(24, @OGUID+325), +(24, @OGUID+326), +(24, @OGUID+327), +(24, @OGUID+328), +(24, @OGUID+329), +(24, @OGUID+330), +(24, @OGUID+331), +(24, @OGUID+332), +(24, @OGUID+333), +(24, @OGUID+334), +(24, @OGUID+335), +(24, @OGUID+336), +(24, @OGUID+337), +(24, @OGUID+338), +(24, @OGUID+339), +(24, @OGUID+340), +(24, @OGUID+341), +(24, @OGUID+342), +(24, @OGUID+343), +(24, @OGUID+344), +(24, @OGUID+345), +(24, @OGUID+346), +(24, @OGUID+347), +(24, @OGUID+348), +(24, @OGUID+349), +(24, @OGUID+350), +(24, @OGUID+351), +(24, @OGUID+352), +(24, @OGUID+353), +(24, @OGUID+354), +(24, @OGUID+355), +(24, @OGUID+356), +(24, @OGUID+357), +(24, @OGUID+358), +(24, @OGUID+359), +(24, @OGUID+360), +(24, @OGUID+361), +(24, @OGUID+362), +(24, @OGUID+363), +(24, @OGUID+364), +(24, @OGUID+365), +(24, @OGUID+366), +(24, @OGUID+367), +(24, @OGUID+368), +(24, @OGUID+369), +(24, @OGUID+370), +(24, @OGUID+371), +(24, @OGUID+372), +(24, @OGUID+373), +(24, @OGUID+374); |