DB/Spawns Updated some missing Brewfest spawns for Stormwind

Closes #28277

1 files changed, 112 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_10_04_00_world.sql b/sql/updates/world/master/2022_10_04_00_world.sql
new file mode 100644
index 00000000000..d91056fc365
--- /dev/null
+++ b/sql/updates/world/master/2022_10_04_00_world.sql
@@ -0,0 +1,112 @@
+SET @OGUID := 500890;
+
+-- Human Commoner
+UPDATE `creature_template` SET `gossip_menu_id`=8988, `npcflag`=1 WHERE `entry`=18927;
+
+DELETE FROM `creature_template_addon` WHERE `entry`=18927;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(18927, 0, 0, 0, 257, 0, 0, 0, 0, 0, '33209 33207 33208'); -- Aura 65511 - Gossip NPC Appearance (only during Brewfest)
+
+UPDATE `creature` SET `npcflag`=3 WHERE `guid` IN (850253, 850255, 850257, 850259, 850262);
+
+-- Old/Duplicated spawns/game_event references
+DELETE FROM `creature` WHERE `guid` IN (361960, 361961, 361962, 361963, 361964, 361965, 361966, 361967, 361968, 361969);
+DELETE FROM `gameobject` WHERE `guid` IN (226355, 226356, 226357, 226358, 226359, 226360, 226365, 226366, 226370, 226371, 226372, 226373, 226374, 226377, 226378, 226379, 226380, 226381, 226382);
+
+DELETE FROM `game_event_creature` WHERE `guid` IN (361957, 361958, 361959, 361960, 361961, 361962, 361963, 361964, 361965, 361966, 361967, 361968, 361969);
+DELETE FROM `game_event_gameobject` WHERE `guid` IN (226376, 226369, 226368, 226367, 226361, 226364, 226362, 226363, 226375, 226354, 226355, 226356, 226357, 226358, 226359, 226360, 226365, 226366, 226370, 226371, 226372, 226373, 226374, 226377, 226378, 226379, 226380, 226381, 226382);
+
+-- Missing spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+43;
+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, 195254, 0, 1519, 4411, '0', 0, 0, -8093.10498046875, 1630.17626953125, 54.13048934936523437, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+1, 195254, 0, 1519, 4411, '0', 0, 0, -8078.40478515625, 1636.4937744140625, 54.33069992065429687, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+2, 195254, 0, 1519, 4411, '0', 0, 0, -8098.27197265625, 1644.759521484375, 54.70997238159179687, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+3, 195254, 0, 1519, 4411, '0', 0, 0, -8083.8603515625, 1651.0186767578125, 54.50894546508789062, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45338), -- Hanging, Square, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+4, 195255, 0, 1519, 4411, '0', 0, 0, -8224.44921875, 1094.302978515625, 26.46458053588867187, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+5, 195255, 0, 1519, 4411, '0', 0, 0, -8181.67626953125, 1120.0240478515625, 26.8634033203125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Large - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+6, 195256, 0, 1519, 5390, '0', 0, 0, -8554.1103515625, 459.614990234375, 104.6930007934570312, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: The Canals - Difficulty: 0)
+(@OGUID+7, 195256, 0, 1519, 4411, '0', 0, 0, -8336.73828125, 1109.5745849609375, 57.2621612548828125, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+8, 195256, 0, 1519, 4411, '0', 0, 0, -8328.4267578125, 1192.4251708984375, 5.81889200210571289, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+9, 195256, 0, 1519, 4411, '0', 0, 0, -8232.3681640625, 1236.46484375, 5.230234146118164062, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+10, 195256, 0, 1519, 4411, '0', 0, 0, -8367.7626953125, 1314.9942626953125, 6.094531059265136718, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+11, 195256, 0, 1519, 4411, '0', 0, 0, -8396.861328125, 1314.03125, 5.981066226959228515, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+12, 195256, 0, 1519, 4411, '0', 0, 0, -8048.81982421875, 1406.9000244140625, 1.113070011138916015, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+13, 195256, 0, 1519, 4411, '0', 0, 0, -8058.7900390625, 1407.3900146484375, 1.10141003131866455, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+14, 195256, 0, 1519, 4411, '0', 0, 0, -8069.64013671875, 1596.5, 0.995334029197692871, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+15, 195256, 0, 1519, 4411, '0', 0, 0, -8061.05712890625, 1591.5364990234375, 1.019675016403198242, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+16, 195256, 0, 1519, 4411, '0', 0, 0, -8459.2861328125, 1323.4476318359375, 5.861742973327636718, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+17, 195256, 0, 1519, 4411, '0', 0, 0, -8489.1279296875, 1323.8216552734375, 5.894642829895019531, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 45338), -- Standing, Exterior, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+18, 195266, 0, 1519, 4411, '0', 0, 0, -8276.1064453125, 1193.0032958984375, 16.38175582885742187, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+19, 195266, 0, 1519, 4411, '0', 0, 0, -8268.5498046875, 1200.7298583984375, 16.45653724670410156, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+20, 195266, 0, 1519, 4411, '0', 0, 0, -8260.66796875, 1204.397705078125, 16.41504287719726562, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+21, 195266, 0, 1519, 4411, '0', 0, 0, -8238.3828125, 1200.4781494140625, 16.38265228271484375, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+22, 195266, 0, 1519, 4411, '0', 0, 0, -8246.6689453125, 1204.4066162109375, 16.3173370361328125, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 45338), -- Hanging, Streamer - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+23, 195273, 0, 1519, 4411, '0', 0, 0, -8310.4189453125, 1178.3892822265625, 19.21945762634277343, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+24, 195273, 0, 1519, 4411, '0', 0, 0, -8310.26171875, 1181.2342529296875, 19.20934295654296875, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+25, 195273, 0, 1519, 4411, '0', 0, 0, -8291.951171875, 1178.3892822265625, 19.18671607971191406, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+26, 195273, 0, 1519, 4411, '0', 0, 0, -8291.900390625, 1181.2344970703125, 19.26672172546386718, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+27, 195273, 0, 1519, 4411, '0', 0, 0, -8215.396484375, 1178.389404296875, 19.15112113952636718, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+28, 195273, 0, 1519, 4411, '0', 0, 0, -8215.24609375, 1181.2340087890625, 19.1291961669921875, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+29, 195273, 0, 1519, 4411, '0', 0, 0, -8305.875, 1251.857177734375, 9.635152816772460937, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+30, 195273, 0, 1519, 4411, '0', 0, 0, -8275.3076171875, 1254.1783447265625, 9.69086456298828125, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+31, 195273, 0, 1519, 4411, '0', 0, 0, -8275.341796875, 1252.017578125, 9.699513435363769531, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+32, 195273, 0, 1519, 4411, '0', 0, 0, -8196.923828125, 1181.233642578125, 19.02257156372070312, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+33, 195273, 0, 1519, 4411, '0', 0, 0, -8196.830078125, 1178.3896484375, 19.10471534729003906, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+34, 195273, 0, 1519, 4411, '0', 0, 0, -8305.8681640625, 1254.0186767578125, 9.708476066589355468, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+35, 195273, 0, 1519, 4411, '0', 0, 0, -8366.8388671875, 1252.010009765625, 9.964110374450683593, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+36, 195273, 0, 1519, 4411, '0', 0, 0, -8305.9013671875, 1396.6033935546875, 9.7128753662109375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+37, 195273, 0, 1519, 4411, '0', 0, 0, -8275.2861328125, 1396.76318359375, 9.693218231201171875, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+38, 195273, 0, 1519, 4411, '0', 0, 0, -8305.8291015625, 1394.443359375, 9.677066802978515625, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+39, 195273, 0, 1519, 4411, '0', 0, 0, -8275.30859375, 1394.6011962890625, 9.658045768737792968, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+40, 195273, 0, 1519, 4411, '0', 0, 0, -8604.505859375, 1295.4071044921875, 8.346570968627929687, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+41, 195273, 0, 1519, 4411, '0', 0, 0, -8600.1708984375, 1298.5792236328125, 8.680917739868164062, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+42, 195273, 0, 1519, 4411, '0', 0, 0, -8621.3720703125, 1329.6346435546875, 8.122531890869140625, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 45338), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+43, 195273, 0, 1519, 4411, '0', 0, 0, -8660.154296875, 1311.9586181640625, 8.162707328796386718, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 45338); -- Hanging, Tall/Thin; Medium - Brewfest (Area: Stormwind Harbor - Difficulty: 0)
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=24 AND `guid` BETWEEN @OGUID+0 AND @OGUID+43;
+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);
\ No newline at end of file