DB/Spawns: Added Harvest Festival spawns in Ironforge

Closes #28232

1 files changed, 188 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_09_09_00_world.sql b/sql/updates/world/master/2022_09_09_00_world.sql
new file mode 100644
index 00000000000..b419f3c208d
--- /dev/null
+++ b/sql/updates/world/master/2022_09_09_00_world.sql
@@ -0,0 +1,188 @@
+SET @CGUID := 222560;
+SET @OGUID := 165991;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+12;
+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, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5090.5537109375, -804.6905517578125, 495.17425537109375, 4.360944747924804687, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+1, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5066.404296875, -800.34869384765625, 495.252105712890625, 6.03566741943359375, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+2, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5062.71923828125, -800.502685546875, 495.252105712890625, 0.409101009368896484, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+3, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5079.03173828125, -805.7064208984375, 495.17425537109375, 1.304785847663879394, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+4, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5084.7958984375, -793.11962890625, 495.66571044921875, 5.024592399597167968, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+5, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5099.1748046875, -805.93701171875, 495.17425537109375, 0.694738328456878662, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+6, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5080.89794921875, -788.79901123046875, 495.90374755859375, 3.226373910903930664, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+7, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5088.0390625, -806.99920654296875, 495.17425537109375, 2.05725264549255371, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+8, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5092.94677734375, -794.10791015625, 495.18743896484375, 2.082314491271972656, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+9, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5077.5927734375, -793.38507080078125, 495.38348388671875, 3.191384553909301757, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+10, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5069.76953125, -794.537109375, 495.15374755859375, 2.638870954513549804, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+11, 15113, 0, 1, 809, '0', '0', 0, 0, 0, -5095.46435546875, -798.76123046875, 495.15374755859375, 6.145327091217041015, 120, 2, 0, 1604, 0, 1, 0, 0, 0, 45114), -- Honored Hero (Area: Gates of Ironforge - Difficulty: 0)
+(@CGUID+12, 15011, 0, 1, 809, '0', '0', 0, 0, 0, -5060.04248046875, -788.6114501953125, 495.14801025390625, 1.064650893211364746, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45114); -- Wagner Hammerstrike (Area: Gates of Ironforge - Difficulty: 0)
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+63;
+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, 180328, 0, 1, 809, '0', '0', 0, -5087.7880859375, -800.03277587890625, 496.0299072265625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45114), -- General Candelabra 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+1, 180353, 0, 1, 809, '0', '0', 0, -5090.37841796875, -798.074951171875, 495.127105712890625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45114), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+2, 180325, 0, 1, 809, '0', '0', 0, -5085.62841796875, -798.15966796875, 495.127105712890625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+3, 180324, 0, 1, 809, '0', '0', 0, -5083.5478515625, -799.98211669921875, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Dwarven Table Ornate 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+4, 180330, 0, 1, 809, '0', '0', 0, -5081.625, -799.857666015625, 496.016021728515625, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 45114), -- Jar 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+5, 180325, 0, 1, 809, '0', '0', 0, -5082.74169921875, -798.1578369140625, 495.167877197265625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+6, 180325, 0, 1, 809, '0', '0', 0, -5085.60107421875, -801.763916015625, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+7, 180324, 0, 1, 809, '0', '0', 0, -5079.31640625, -799.98760986328125, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Dwarven Table Ornate 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+8, 180325, 0, 1, 809, '0', '0', 0, -5088.47998046875, -798.12969970703125, 495.150726318359375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+9, 180325, 0, 1, 809, '0', '0', 0, -5082.822265625, -801.7591552734375, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+10, 180328, 0, 1, 809, '0', '0', 0, -5083.51904296875, -799.94097900390625, 496.0299072265625, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 45114), -- General Candelabra 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+11, 180325, 0, 1, 809, '0', '0', 0, -5088.3125, -801.76141357421875, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+12, 180329, 0, 1, 809, '0', '0', 0, -5087.3271484375, -799.57098388671875, 496.022796630859375, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 45114), -- Jar 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+13, 180353, 0, 1, 809, '0', '0', 0, -5081.2548828125, -796.47442626953125, 495.1968994140625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+14, 180330, 0, 1, 809, '0', '0', 0, -5083.9912109375, -799.66143798828125, 496.02294921875, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 45114), -- Jar 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+15, 180331, 0, 1, 809, '0', '0', 0, -5087.1181640625, -800.0399169921875, 496.016021728515625, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 45114), -- Jar 03 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+16, 180331, 0, 1, 809, '0', '0', 0, -5083, -800.12677001953125, 496.02294921875, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 45114), -- Jar 03 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+17, 180331, 0, 1, 809, '0', '0', 0, -5089.125, -800.44964599609375, 496.02294921875, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 45114), -- Jar 03 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+18, 180332, 0, 1, 809, '0', '0', 0, -5081.4619140625, -800.32464599609375, 496.016021728515625, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 45114), -- Jug 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+19, 180332, 0, 1, 809, '0', '0', 0, -5087.41162109375, -800.54168701171875, 496.02294921875, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 45114), -- Jug 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+20, 180333, 0, 1, 809, '0', '0', 0, -5084.66845703125, -800.05206298828125, 496.0299072265625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 45114), -- Jug 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+21, 180324, 0, 1, 809, '0', '0', 0, -5087.77978515625, -799.98583984375, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Dwarven Table Ornate 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+22, 180325, 0, 1, 809, '0', '0', 0, -5090.31689453125, -799.91436767578125, 495.127105712890625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+23, 180353, 0, 1, 809, '0', '0', 0, -5081.40087890625, -803.11968994140625, 495.127105712890625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 45114), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+24, 180371, 0, 1, 809, '0', '0', 0, -5082.24658203125, -800.44793701171875, 496.0299072265625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 45114), -- Harvest Fish (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+25, 180370, 0, 1, 809, '0', '0', 0, -5085.63720703125, -799.9305419921875, 496.0299072265625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 45114), -- Harvest Fruit (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+26, 180325, 0, 1, 809, '0', '0', 0, -5074.61962890625, -801.56280517578125, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+27, 180373, 0, 1, 809, '0', '0', 0, -5084.49462890625, -799.37847900390625, 496.05072021484375, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+28, 180328, 0, 1, 809, '0', '0', 0, -5079.29541015625, -799.9698486328125, 496.036834716796875, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 45114), -- General Candelabra 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+29, 180373, 0, 1, 809, '0', '0', 0, -5084.46533203125, -800.50347900390625, 496.043792724609375, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+30, 180325, 0, 1, 809, '0', '0', 0, -5079.94091796875, -798.19891357421875, 495.143280029296875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+31, 180324, 0, 1, 809, '0', '0', 0, -5075.08349609375, -799.99249267578125, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Dwarven Table Ornate 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+32, 180331, 0, 1, 809, '0', '0', 0, -5078.6826171875, -799.6883544921875, 496.016021728515625, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45114), -- Jar 03 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+33, 180373, 0, 1, 809, '0', '0', 0, -5079.73095703125, -800.638916015625, 496.036834716796875, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+34, 180328, 0, 1, 809, '0', '0', 0, -5075.05615234375, -799.9864501953125, 496.036834716796875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- General Candelabra 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+35, 180373, 0, 1, 809, '0', '0', 0, -5079.416015625, -799.40765380859375, 496.05609130859375, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+36, 180329, 0, 1, 809, '0', '0', 0, -5083.798828125, -800.58331298828125, 496.016021728515625, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45114), -- Jar 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+37, 180334, 0, 1, 809, '0', '0', 0, -5083.51611328125, -799.99102783203125, 495.1549072265625, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 45114), -- Stormwind Rug 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+38, 180325, 0, 1, 809, '0', '0', 0, -5074.6240234375, -798.3370361328125, 495.130218505859375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+39, 180331, 0, 1, 809, '0', '0', 0, -5075.8974609375, -799.9444580078125, 496.016021728515625, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 45114), -- Jar 03 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+40, 180371, 0, 1, 809, '0', '0', 0, -5073.673828125, -799.9444580078125, 496.0299072265625, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 45114), -- Harvest Fish (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+41, 179984, 0, 1, 809, '0', '0', 0, -5083.84912109375, -780.97393798828125, 494.5928955078125, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 45114), -- Brazier (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+42, 180373, 0, 1, 809, '0', '0', 0, -5074.09716796875, -799.22052001953125, 496.05072021484375, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+43, 180325, 0, 1, 809, '0', '0', 0, -5077.10791015625, -801.625244140625, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+44, 180370, 0, 1, 809, '0', '0', 0, -5089.048828125, -799.46875, 496.0299072265625, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 45114), -- Harvest Fruit (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+45, 180372, 0, 1, 809, '0', '0', 0, -5075.19775390625, -799.25518798828125, 496.03814697265625, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 45114), -- Harvest Boar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+46, 180329, 0, 1, 809, '0', '0', 0, -5074.64599609375, -800.2100830078125, 496.02294921875, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45114), -- Jar 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+47, 180373, 0, 1, 809, '0', '0', 0, -5087.83154296875, -799.27081298828125, 496.04742431640625, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+48, 180373, 0, 1, 809, '0', '0', 0, -5088.2587890625, -800.3367919921875, 496.043792724609375, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+49, 180329, 0, 1, 809, '0', '0', 0, -5079.94970703125, -799.92364501953125, 496.02294921875, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 45114), -- Jar 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+50, 180330, 0, 1, 809, '0', '0', 0, -5074.52978515625, -799.73663330078125, 496.02294921875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45114), -- Jar 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+51, 180325, 0, 1, 809, '0', '0', 0, -5072.39794921875, -799.88348388671875, 495.127105712890625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+52, 180325, 0, 1, 809, '0', '0', 0, -5077.19482421875, -798.263916015625, 495.127105712890625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+53, 180332, 0, 1, 809, '0', '0', 0, -5076.32275390625, -799.57464599609375, 496.02294921875, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 45114), -- Jug 01 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+54, 180333, 0, 1, 809, '0', '0', 0, -5078.5537109375, -800.31427001953125, 496.009063720703125, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 45114), -- Jug 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+55, 180325, 0, 1, 809, '0', '0', 0, -5079.861328125, -801.66925048828125, 495.127105712890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45114), -- Chair (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+56, 180334, 0, 1, 809, '0', '0', 0, -5079.41650390625, -800.06329345703125, 495.141021728515625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 45114), -- Stormwind Rug 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+57, 180334, 0, 1, 809, '0', '0', 0, -5075.05615234375, -800.016845703125, 495.127105712890625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45114), -- Stormwind Rug 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+58, 180371, 0, 1, 809, '0', '0', 0, -5077.2900390625, -800.1788330078125, 496.0299072265625, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 45114), -- Harvest Fish (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+59, 174746, 0, 1, 809, '0', '0', 0, -5095.4462890625, -785.763916015625, 495.80133056640625, 6.056295394897460937, 0.009865760803222656, 0.086594581604003906, -0.11277103424072265, 0.989791274070739746, 120, 255, 1, 45114), -- Etched Note (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+60, 180373, 0, 1, 809, '0', '0', 0, -5075, -800.55902099609375, 496.043792724609375, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 45114), -- Harvest Nectar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+61, 180334, 0, 1, 809, '0', '0', 0, -5087.767578125, -799.9622802734375, 495.1549072265625, 0, 0, 0, 0, 1, 120, 255, 1, 45114), -- Stormwind Rug 02 (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+62, 180372, 0, 1, 809, '0', '0', 0, -5080.798828125, -799.560791015625, 496.0299072265625, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 45114), -- Harvest Boar (Area: Gates of Ironforge - Difficulty: 0)
+(@OGUID+63, 180353, 0, 1, 809, '0', '0', 0, -5072.04931640625, -801.83087158203125, 495.127105712890625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 45114); -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0)
+
+-- Creature Template
+UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=15011; -- Wagner Hammerstrike
+
+UPDATE `creature_template_addon` SET `bytes2`=257 WHERE `entry`=15011; -- 15011 (Wagner Hammerstrike)
+
+-- Vendor Data
+DELETE FROM `npc_vendor` WHERE (`entry`=15011 AND `item`=34850 AND `ExtendedCost`=0 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(15011, 1, 34850, 0, 0, 1, 0, 0, 45114); -- Midsummer Ground Flower
+
+UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=45114 WHERE (`entry`=15011 AND `item`=9315 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Rose Firework
+UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=45114 WHERE (`entry`=15011 AND `item`=9314 AND `ExtendedCost`=0 AND `type`=1); -- Red Streaks Firework
+UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=45114 WHERE (`entry`=15011 AND `item`=9318 AND `ExtendedCost`=0 AND `type`=1); -- Red Firework
+UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=45114 WHERE (`entry`=15011 AND `item`=9313 AND `ExtendedCost`=0 AND `type`=1); -- Green Firework
+UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=45114 WHERE (`entry`=15011 AND `item`=9312 AND `ExtendedCost`=0 AND `type`=1); -- Blue Firework
+
+-- Game_Event_Creature Data for Alliance Harvest Festival
+DELETE FROM `game_event_creature` WHERE `eventEntry`=11 AND `guid` BETWEEN @CGUID+0 AND @CGUID+12;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(11, @CGUID+0),
+(11, @CGUID+1),
+(11, @CGUID+2),
+(11, @CGUID+3),
+(11, @CGUID+4),
+(11, @CGUID+5),
+(11, @CGUID+6),
+(11, @CGUID+7),
+(11, @CGUID+8),
+(11, @CGUID+9),
+(11, @CGUID+10),
+(11, @CGUID+11),
+(11, @CGUID+12);
+
+-- Game_Event_GameObject Data for Alliance Harvest Festival
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=11 AND `guid` BETWEEN @OGUID+0 AND @OGUID+63;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(11, @OGUID+0),
+(11, @OGUID+1),
+(11, @OGUID+2),
+(11, @OGUID+3),
+(11, @OGUID+4),
+(11, @OGUID+5),
+(11, @OGUID+6),
+(11, @OGUID+7),
+(11, @OGUID+8),
+(11, @OGUID+9),
+(11, @OGUID+10),
+(11, @OGUID+11),
+(11, @OGUID+12),
+(11, @OGUID+13),
+(11, @OGUID+14),
+(11, @OGUID+15),
+(11, @OGUID+16),
+(11, @OGUID+17),
+(11, @OGUID+18),
+(11, @OGUID+19),
+(11, @OGUID+20),
+(11, @OGUID+21),
+(11, @OGUID+22),
+(11, @OGUID+23),
+(11, @OGUID+24),
+(11, @OGUID+25),
+(11, @OGUID+26),
+(11, @OGUID+27),
+(11, @OGUID+28),
+(11, @OGUID+29),
+(11, @OGUID+30),
+(11, @OGUID+31),
+(11, @OGUID+32),
+(11, @OGUID+33),
+(11, @OGUID+34),
+(11, @OGUID+35),
+(11, @OGUID+36),
+(11, @OGUID+37),
+(11, @OGUID+38),
+(11, @OGUID+39),
+(11, @OGUID+40),
+(11, @OGUID+41),
+(11, @OGUID+42),
+(11, @OGUID+43),
+(11, @OGUID+44),
+(11, @OGUID+45),
+(11, @OGUID+46),
+(11, @OGUID+47),
+(11, @OGUID+48),
+(11, @OGUID+49),
+(11, @OGUID+50),
+(11, @OGUID+51),
+(11, @OGUID+52),
+(11, @OGUID+53),
+(11, @OGUID+54),
+(11, @OGUID+55),
+(11, @OGUID+56),
+(11, @OGUID+57),
+(11, @OGUID+58),
+(11, @OGUID+59),
+(11, @OGUID+60),
+(11, @OGUID+61),
+(11, @OGUID+62),
+(11, @OGUID+63);