fix(DB): Add spawns/events for Ahn'Qiraj War Effort event. (#22497)

3 files changed, 649 insertions, 0 deletions

diff --git a/data/sql/updates/pending_db_world/creature-spawns.sql b/data/sql/updates/pending_db_world/creature-spawns.sql
new file mode 100644
index 0000000000..23346778e4
--- /dev/null
+++ b/data/sql/updates/pending_db_world/creature-spawns.sql
@@ -0,0 +1,83 @@
+SET @GUID = 83113;
+
+DELETE FROM `creature` WHERE `id1` IN (3296, 5595, 15383, 15431, 15432, 15434, 15437, 15445, 15446, 15448, 15450, 15451, 15452, 15453, 15455, 15456, 15457, 15458, 15459, 15460, 15469, 15477, 15508, 15512, 15515, 15522, 15525, 15528, 15529, 15532, 15533, 15534, 15535, 15539, 15663, 15696, 15700, 15701, 15702, 15703, 15704, 15707, 15708, 15709, 15731, 15733, 15734, 15735, 15736, 15737, 15738, 15739, 15761, 15762, 15763, 15764, 15765, 15766, 15767, 15768) AND `guid` BETWEEN @GUID AND @GUID+69;
+INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`, `CreateObject`, `Comment`) VALUES
+-- Ironforge
+(@GUID+0, 15731, 0, 0, 0, 0, 0, 1, 1, 0, -4935.1743, -1197.6975, 501.62204, 2.460914134979248046, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Darnassus Commendation Officer
+(@GUID+1, 15733, 0, 0, 0, 0, 0, 1, 1, 0, -4952.5264, -1176.9742, 501.63916, 5.393067359924316406, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Gnomeregan Commendation Officer
+(@GUID+2, 15734, 0, 0, 0, 0, 0, 1, 1, 0, -4975.3374, -1196.7572, 501.74588, 1.884955525398254394, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Ironforge Commendation Officer
+(@GUID+3, 15735, 0, 0, 0, 0, 0, 1, 1, 0, -4934.9854, -1214.3094, 501.7179,  3.333578824996948242, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Stormwind Commendation Officer
+(@GUID+4, 5595,  0, 0, 0, 0, 0, 1, 1, 0, -4980.02,   -1219.984,  501.75632, 3.822271108627319335, 300, 0, 0, 5228,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Ironforge Guard
+(@GUID+5, 15539, 0, 0, 0, 0, 0, 1, 1, 0, -4981.2524, -1218.3779, 501.7562,  3.804817676544189453, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- General Zog <Horde Ambassador>
+(@GUID+6, 5595,  0, 0, 0, 0, 0, 1, 1, 0, -4982.4688, -1216.806,  501.7562,  3.874630928039550781, 300, 0, 0, 5228,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Ironforge Guard
+(@GUID+7, 15383, 0, 0, 0, 0, 0, 1, 1, 0, -4924.3657, -1222.7299, 501.71756, 3.926990747451782226, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Sergeant Stonebrow <Copper Bar Collector>
+(@GUID+8, 15431, 0, 0, 0, 0, 0, 1, 1, 0, -4914.172,  -1227.4949, 501.73282, 3.59537816047668457,  300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Corporal Carnes <Iron Bar Collector>
+(@GUID+9, 15432, 0, 0, 0, 0, 0, 1, 1, 0, -4930.287,  -1218.7476, 501.71875, 3.752457857131958007, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Dame Twinbraid <Thorium Bar Collector>
+(@GUID+10, 15434, 0, 0, 0, 0, 0, 1, 1, 0, -4952.255,  -1274.4495, 501.75662, 1.797689080238342285, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Private Draxlegauge <Stranglekelp Collector>
+(@GUID+11, 15437, 0, 0, 0, 0, 0, 1, 1, 0, -4945.4204, -1282.0215, 501.75787, 1.029744267463684082, 300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Master Nightsong <Purple Lotus Collector>
+(@GUID+12, 15445, 0, 0, 0, 0, 0, 1, 1, 0, -4948.3345, -1273.7974, 501.75522, 1.064650893211364746, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Sergeant Major Germaine <Arthas' Tears Collector>
+(@GUID+13, 15446, 0, 0, 0, 0, 0, 1, 1, 0, -4972.2017, -1169.0591, 501.72,    3.281219005584716796, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Bonnie Stoneflayer <Light Leather Collector>
+(@GUID+14, 15448, 0, 0, 0, 0, 0, 1, 1, 0, -4966.0938, -1176.0596, 501.74265, 3.298672199249267578, 300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Private Porter <Medium Leather Collector>
+(@GUID+15, 15450, 0, 0, 0, 0, 0, 1, 1, 0, -4969.4565, -1180.2417, 501.7428,  3.246312379837036132, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Marta Finespindle <Thick Leather Collector>
+(@GUID+16, 15451, 0, 0, 0, 0, 0, 1, 1, 0, -4971.5747, -1151.5566, 501.73938, 3.560471534729003906, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Sentinel Silversky <Linen Bandage Collector>
+(@GUID+17, 15452, 0, 0, 0, 0, 0, 1, 1, 0, -4979.116,  -1149.51,   501.7331,  3.368485450744628906, 300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Nurse Stonefield <Silk Bandage Collector>
+(@GUID+18, 15453, 0, 0, 0, 0, 0, 1, 1, 0, -4979.9287, -1142.1707, 501.7428,  3.682644605636596679, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Keeper Moonshade <Runecloth Bandage Collector>
+(@GUID+19, 15455, 0, 0, 0, 0, 0, 1, 1, 0, -4938.0024, -1275.1202, 501.75195, 2.460914134979248046, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Slicky Gastronome <Rainbow Fin Albacore Collector>
+(@GUID+20, 15456, 0, 0, 0, 0, 0, 1, 1, 0, -4940.392,  -1277.704,  501.7544,  1.989675283432006835, 300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Sarah Sadwhistle <Roast Raptor Collector>
+(@GUID+21, 15457, 0, 0, 0, 0, 0, 1, 1, 0, -4933.8027, -1279.1617, 501.74948, 2.426007747650146484, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Huntress Swiftriver <Spotted Yellowtail Collector>
+(@GUID+22, 15663, 0, 0, 0, 0, 0, 1, 1, 0, -4917.319,  -1224.8823, 501.7417,  4.327857494354248046, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Volunteer
+(@GUID+23, 15663, 0, 0, 0, 0, 0, 1, 1, 0, -4944.852,  -1277.7028, 501.75586, 4.258603572845458984, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Volunteer
+(@GUID+24, 15663, 0, 0, 0, 0, 0, 1, 1, 0, -4966.2954, -1173.8835, 501.72675, 3.648972272872924804, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Volunteer
+(@GUID+25, 15663, 0, 0, 0, 0, 0, 1, 1, 0, -4975.13,   -1153.5369, 501.74008, 3.013503551483154296, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Volunteer
+(@GUID+26, 15663, 0, 0, 0, 0, 0, 1, 1, 0, -4937.548,  -1280.2931, 501.7544,  4.558997154235839843, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Volunteer
+(@GUID+27, 15701, 0, 0, 0, 0, 0, 1, 1, 0, -4977.4976, -1172.4156, 501.7317,  2.282009840011596679, 300, 0, 0, 30520, 0, 2, 0, 0, 0, '', 61582, 2, NULL), -- Field Marshal Snowfall <War Effort Commander>
+-- Orgrimmar
+(@GUID+28, 15736, 0, 0, 1, 0, 0, 1, 1, 0, 1584.7704, -4112.9443, 33.37767,  5.410520553588867187, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Orgrimmar Commendation Officer
+(@GUID+29, 15737, 0, 0, 1, 0, 0, 1, 1, 0, 1618.4412, -4101.7646, 32.95245,  5.235987663269042968, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Darkspear Commendation Officer
+(@GUID+30, 15738, 0, 0, 1, 0, 0, 1, 1, 0, 1660.3582, -4107.4517, 34.620274, 2.059488534927368164, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Undercity Commendation Officer
+(@GUID+31, 15739, 0, 0, 1, 0, 0, 1, 1, 0, 1603.886,  -4142.897,  33.78176,  2.443460941314697265, 300, 0, 0, 2614,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Thunder Bluff Commendation Officer
+(@GUID+32, 3296,  0, 0, 1, 0, 0, 1, 1, 0, 1628.9564, -4119.1763, 31.244139, 2.094395160675048828, 300, 0, 0, 5228,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Orgrimmar Grunt
+(@GUID+33, 15458, 0, 0, 1, 0, 0, 1, 1, 0, 1630.693,  -4118.458,  31.265778, 1.972222089767456054, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Commander Stronghammer <Alliance Ambassador>
+(@GUID+34, 3296,  0, 0, 1, 0, 0, 1, 1, 0, 1632.3059, -4117.596,  31.29346,  2.042035102844238281, 300, 0, 0, 5228,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Orgrimmar Grunt
+(@GUID+35, 15522, 0, 0, 1, 0, 0, 1, 1, 0, 1593.2671, -4159.4404, 36.90244,  2.94960641860961914,  300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Sergeant Umala <Thick Leather Collector>
+(@GUID+36, 15533, 0, 0, 1, 0, 0, 1, 1, 0, 1643.4338, -4085.0864, 37.337215, 4.677482128143310546, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Bloodguard Rawtar <Lean Wolf Steak Collector>
+(@GUID+37, 15534, 0, 0, 1, 0, 0, 1, 1, 0, 1629.785,  -4089.1484, 35.632874, 5.25344085693359375,  300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Fisherman Lin'do <Spotted Yellowtail Collector>
+(@GUID+38, 15535, 0, 0, 1, 0, 0, 1, 1, 0, 1634.1218, -4084.9915, 36.52574,  5.218534469604492187, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Chief Sharpclaw <Baked Salmon Collector>
+(@GUID+39, 15459, 0, 0, 1, 0, 0, 1, 1, 0, 1650.3278, -4124.2856, 31.452269, 2.652900457382202148, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Miner Cromwell <Copper Bar Collector>
+(@GUID+40, 15460, 0, 0, 1, 0, 0, 1, 1, 0, 1665.7623, -4117.497,  34.37464,  2.443460941314697265, 300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Grunt Maug <Tin Bar Collector>
+(@GUID+41, 15469, 0, 0, 1, 0, 0, 1, 1, 0, 1655.7728, -4119.1626, 32.695107, 1.326450228691101074, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Senior Sergeant T'kelah <Mithril Bar Collector>
+(@GUID+42, 15477, 0, 0, 1, 0, 0, 1, 1, 0, 1615.0131, -4145.532,  35.131996, 1.378810048103332519, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Herbalist Proudfeather <Peacebloom Collector>
+(@GUID+43, 15508, 0, 0, 1, 0, 0, 1, 1, 0, 1625.951,  -4149.423,  36.395786, 1.902408838272094726, 300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Batrider Pele'keiki <Firebloom Collector>
+(@GUID+44, 15512, 0, 0, 1, 0, 0, 1, 1, 0, 1633.2582, -4142.117,  34.70991,  2.111848354339599609, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Apothecary Jezel <Purple Lotus Collector>
+(@GUID+45, 15515, 0, 0, 1, 0, 0, 1, 1, 0, 1588.1735, -4179.9014, 39.98489,  2.897246599197387695, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Skinner Jamani <Heavy Leather Collector>
+(@GUID+46, 15525, 0, 0, 1, 0, 0, 1, 1, 0, 1595.7618, -4174.3965, 39.766666, 2.722713708877563476, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Doctor Serratus <Rugged Leather Collector>
+(@GUID+47, 15528, 0, 0, 1, 0, 0, 1, 1, 0, 1580.1736, -4116.1064, 34.41577,  5.602506637573242187, 300, 0, 0, 13495, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Healer Longrunner <Wool Bandage Collector>
+(@GUID+48, 15529, 0, 0, 1, 0, 0, 1, 1, 0, 1571.1464, -4118.6587, 36.584232, 5.026548385620117187, 300, 0, 0, 14355, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Lady Callow <Mageweave Bandage Collector>
+(@GUID+49, 15532, 0, 0, 1, 0, 0, 1, 1, 0, 1565.0651, -4123.9863, 37.44075,  0,                    300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Stoneguard Clayhoof <Runecloth Bandage Collector>
+(@GUID+50, 15696, 0, 0, 1, 0, 0, 1, 1, 0, 1576.2423, -4118.5137, 35.26423,  4.112950801849365234, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Recruit
+(@GUID+51, 15696, 0, 0, 1, 0, 0, 1, 1, 0, 1591.8158, -4162.673,  37.39431,  4.81041717529296875,  300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Recruit
+(@GUID+52, 15696, 0, 0, 1, 0, 0, 1, 1, 0, 1639.2985, -4081.972,  37.58056,  4.678342819213867187, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Recruit
+(@GUID+53, 15696, 0, 0, 1, 0, 0, 1, 1, 0, 1629.4264, -4142.979,  34.864754, 3.117774009704589843, 300, 0, 0, 4775,  0, 2, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Recruit
+(@GUID+54, 15696, 0, 0, 1, 0, 0, 1, 1, 0, 1666.3688, -4109.401,  35.089664, 1.868425965309143066, 300, 0, 0, 4775,  0, 0, 0, 0, 0, '', 61582, 2, NULL), -- War Effort Recruit
+(@GUID+55, 15700, 0, 0, 1, 0, 0, 1, 1, 0, 1581.5414, -4184.574,  39.5738,   1.563615918159484863, 300, 0, 0, 30520, 0, 0, 0, 0, 0, '', 61582, 2, NULL), -- Warlord Gorchuk <War Effort Commander>
+
+-- War Effort Recruiters
+(@GUID+56, 15702, 0, 0, 1, 0, 0, 1, 1, 0, -1209.5848, 100.22011,  134.661,   3.159045934677124023, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Senior Sergeant Taiga <War Effort Recruiter>
+(@GUID+57, 15703, 0, 0, 0, 0, 0, 1, 1, 0, 1572.5758,  272.70654,  -43.01935, 5.026548385620117187, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Senior Sergeant Grimsford <War Effort Recruiter>
+(@GUID+58, 15704, 0, 0, 1, 0, 0, 1, 1, 0, 1653.0684,  -4403.811,  18.581886, 4.450589656829833984, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Senior Sergeant Kai'jin <War Effort Recruiter>
+(@GUID+59, 15707, 0, 0, 0, 0, 0, 1, 1, 0, -4956.0864, -931.13306, 503.3468,  5.375614166259765625, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Master Sergeant Fizzlebolt <War Effort Recruiter>
+(@GUID+60, 15708, 0, 0, 0, 0, 0, 1, 1, 0, -8813.751,  654.0678,   96.16028,  4.834561824798583984, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Master Sergeant Maclure <War Effort Recruiter>
+(@GUID+61, 15709, 0, 0, 1, 0, 0, 1, 1, 0, 9945.1455,  2494.2393,  1317.5244, 4.206243515014648437, 300, 0, 0, 15260, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Master Sergeant Moonshadow <War Effort Recruiter>
+-- Commendation Officers
+(@GUID+62, 15761, 0, 0, 1, 0, 0, 1, 1, 0, 1945.322,   -4330.305,  22.101057,  3.50811171531677246,  300, 0, 0, 2914, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Officer Vu'Shalay <Darkspear Commendations>
+(@GUID+63, 15762, 0, 0, 1, 0, 0, 1, 1, 0, 9965.52,    2533.7234,  1319.0049,  0.471238881349563598, 300, 0, 0, 2614, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Officer Lunalight <Darnassus Commendations>
+(@GUID+64, 15763, 0, 0, 0, 0, 0, 1, 1, 0, -4811.9756, -1264.849,  501.95117,  3.054326057434082031, 300, 0, 0, 2614, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Officer Porterhouse <Gnomeregan Commendations>
+(@GUID+65, 15764, 0, 0, 0, 0, 0, 1, 1, 0, -4814.475,  -1055.5201, 502.26733,  6.213372230529785156, 300, 0, 0, 2614, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Officer Ironbeard <Ironforge Commendations>
+(@GUID+66, 15765, 0, 0, 1, 0, 0, 1, 1, 0, 1911.704,   -4276.771,  31.655682,  4.886921882629394531, 300, 0, 0, 2914, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Officer Redblade <Orgrimmar Commendations>
+(@GUID+67, 15766, 0, 0, 0, 0, 0, 1, 1, 0, -8859.14,   638.28687,  96.34692,   1.815142393112182617, 300, 0, 0, 2614, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Officer Maloof <Stormwind Commendations>
+(@GUID+68, 15767, 0, 0, 1, 0, 0, 1, 1, 0, -1246.4849, 74.262695,  128.36818,  5.026548385620117187, 300, 0, 0, 2614, 0, 0, 0, 0, 0, '', 61582, 1, NULL), -- Officer Thunderstrider <Thunder Bluff Commendations>
+(@GUID+69, 15768, 0, 0, 0, 0, 0, 1, 1, 0, 1587.8914,  279.28018,  -43.019344, 4.852015495300292968, 300, 0, 0, 2614, 0, 0, 0, 0, 0, '', 61582, 1, NULL); -- Officer Gothena <Undercity Commendations>
+
+-- Old spawns
+DELETE FROM `creature` WHERE `guid` IN (37, 2032, 6519, 6520, 25997, 32076, 46803) AND `id1` IN (14724, 15761, 15762, 15764, 15765, 15767, 15768);
+DELETE FROM `creature_addon` WHERE `guid` IN (6519, 6520, 25997, 32076, 46803);
diff --git a/data/sql/updates/pending_db_world/game-events.sql b/data/sql/updates/pending_db_world/game-events.sql
new file mode 100644
index 0000000000..17b1fb9390
--- /dev/null
+++ b/data/sql/updates/pending_db_world/game-events.sql
@@ -0,0 +1,464 @@
+SET @EventID = 131,
+    @OGUID   = 3639,
+    @CGUID   = 83113;
+
+SET @AQWarAllianceBarsInitial        = @EventID+0,
+    @AQWarAllianceBarsT1             = @EventID+1,
+    @AQWarAllianceBarsT2             = @EventID+2,
+    @AQWarAllianceBarsT3             = @EventID+3,
+    @AQWarAllianceBarsT4             = @EventID+4,
+    @AQWarAllianceBarsT5             = @EventID+5,
+    @AQWarAllianceHerbsInitial       = @EventID+6,
+    @AQWarAllianceHerbsT1            = @EventID+7,
+    @AQWarAllianceHerbsT2            = @EventID+8,
+    @AQWarAllianceHerbsT3            = @EventID+9,
+    @AQWarAllianceHerbsT4            = @EventID+10,
+    @AQWarAllianceHerbsT5            = @EventID+11,
+    @AQWarAllianceSkinsInitial       = @EventID+12,
+    @AQWarAllianceSkinsT1            = @EventID+13,
+    @AQWarAllianceSkinsT2            = @EventID+14,
+    @AQWarAllianceSkinsT3            = @EventID+15,
+    @AQWarAllianceSkinsT4            = @EventID+16,
+    @AQWarAllianceSkinsT5            = @EventID+17,
+    @AQWarAllianceBandagesInitial    = @EventID+18,
+    @AQWarAllianceBandagesT1         = @EventID+19,
+    @AQWarAllianceBandagesT2         = @EventID+20,
+    @AQWarAllianceBandagesT3         = @EventID+21,
+    @AQWarAllianceBandagesT4         = @EventID+22,
+    @AQWarAllianceBandagesT5         = @EventID+23,
+    @AQWarAllianceCookedGoodsInitial = @EventID+24,
+    @AQWarAllianceCookedGoodsT1      = @EventID+25,
+    @AQWarAllianceCookedGoodsT2      = @EventID+26,
+    @AQWarAllianceCookedGoodsT3      = @EventID+27,
+    @AQWarAllianceCookedGoodsT4      = @EventID+28,
+    @AQWarAllianceCookedGoodsT5      = @EventID+29,
+    @AQWarHordeBarsInitial           = @EventID+30,
+    @AQWarHordeBarsT1                = @EventID+31,
+    @AQWarHordeBarsT2                = @EventID+32,
+    @AQWarHordeBarsT3                = @EventID+33,
+    @AQWarHordeBarsT4                = @EventID+34,
+    @AQWarHordeBarsT5                = @EventID+35,
+    @AQWarHordeHerbsInitial          = @EventID+36,
+    @AQWarHordeHerbsT1               = @EventID+37,
+    @AQWarHordeHerbsT2               = @EventID+38,
+    @AQWarHordeHerbsT3               = @EventID+39,
+    @AQWarHordeHerbsT4               = @EventID+40,
+    @AQWarHordeHerbsT5               = @EventID+41,
+    @AQWarHordeSkinsInitial          = @EventID+42,
+    @AQWarHordeSkinsT1               = @EventID+43,
+    @AQWarHordeSkinsT2               = @EventID+44,
+    @AQWarHordeSkinsT3               = @EventID+45,
+    @AQWarHordeSkinsT4               = @EventID+46,
+    @AQWarHordeSkinsT5               = @EventID+47,
+    @AQWarHordeBandagesInitial       = @EventID+48,
+    @AQWarHordeBandagesT1            = @EventID+49,
+    @AQWarHordeBandagesT2            = @EventID+50,
+    @AQWarHordeBandagesT3            = @EventID+51,
+    @AQWarHordeBandagesT4            = @EventID+52,
+    @AQWarHordeBandagesT5            = @EventID+53,
+    @AQWarHordeCookedGoodsInitial    = @EventID+54,
+    @AQWarHordeCookedGoodsT1         = @EventID+55,
+    @AQWarHordeCookedGoodsT2         = @EventID+56,
+    @AQWarHordeCookedGoodsT3         = @EventID+57,
+    @AQWarHordeCookedGoodsT4         = @EventID+58,
+    @AQWarHordeCookedGoodsT5         = @EventID+59;
+
+DELETE FROM `game_event` WHERE `eventEntry` IN (@AQWarAllianceBarsInitial, @AQWarAllianceBarsT1, @AQWarAllianceBarsT2, @AQWarAllianceBarsT3, @AQWarAllianceBarsT4, @AQWarAllianceBarsT5, @AQWarAllianceHerbsInitial, @AQWarAllianceHerbsT1, @AQWarAllianceHerbsT2, @AQWarAllianceHerbsT3, @AQWarAllianceHerbsT4, @AQWarAllianceHerbsT5, @AQWarAllianceSkinsInitial, @AQWarAllianceSkinsT1, @AQWarAllianceSkinsT2, @AQWarAllianceSkinsT3, @AQWarAllianceSkinsT4, @AQWarAllianceSkinsT5, @AQWarAllianceBandagesInitial, @AQWarAllianceBandagesT1, @AQWarAllianceBandagesT2, @AQWarAllianceBandagesT3, @AQWarAllianceBandagesT4, @AQWarAllianceBandagesT5, @AQWarAllianceCookedGoodsInitial, @AQWarAllianceCookedGoodsT1, @AQWarAllianceCookedGoodsT2, @AQWarAllianceCookedGoodsT3, @AQWarAllianceCookedGoodsT4, @AQWarAllianceCookedGoodsT5, @AQWarHordeBarsInitial, @AQWarHordeBarsT1, @AQWarHordeBarsT2, @AQWarHordeBarsT3, @AQWarHordeBarsT4, @AQWarHordeBarsT5, @AQWarHordeHerbsInitial, @AQWarHordeHerbsT1, @AQWarHordeHerbsT2, @AQWarHordeHerbsT3, @AQWarHordeHerbsT4, @AQWarHordeHerbsT5, @AQWarHordeSkinsInitial, @AQWarHordeSkinsT1, @AQWarHordeSkinsT2, @AQWarHordeSkinsT3, @AQWarHordeSkinsT4, @AQWarHordeSkinsT5, @AQWarHordeBandagesInitial, @AQWarHordeBandagesT1, @AQWarHordeBandagesT2, @AQWarHordeBandagesT3, @AQWarHordeBandagesT4, @AQWarHordeBandagesT5, @AQWarHordeCookedGoodsInitial, @AQWarHordeCookedGoodsT1, @AQWarHordeCookedGoodsT2, @AQWarHordeCookedGoodsT3, @AQWarHordeCookedGoodsT4, @AQWarHordeCookedGoodsT5);
+INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `holidayStage`, `description`, `world_event`, `announce`) VALUES
+(@AQWarAllianceBarsInitial,        '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bars Initial',         5, 2),
+(@AQWarAllianceBarsT1,             '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bars Tier 1',          5, 2),
+(@AQWarAllianceBarsT2,             '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bars Tier 2',          5, 2),
+(@AQWarAllianceBarsT3,             '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bars Tier 3',          5, 2),
+(@AQWarAllianceBarsT4,             '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bars Tier 4',          5, 2),
+(@AQWarAllianceBarsT5,             '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bars Tier 5',          5, 2),
+(@AQWarAllianceHerbsInitial,       '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Herbs Initial',        5, 2),
+(@AQWarAllianceHerbsT1,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Herbs Tier 1',         5, 2),
+(@AQWarAllianceHerbsT2,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Herbs Tier 2',         5, 2),
+(@AQWarAllianceHerbsT3,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Herbs Tier 3',         5, 2),
+(@AQWarAllianceHerbsT4,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Herbs Tier 4',         5, 2),
+(@AQWarAllianceHerbsT5,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Herbs Tier 5',         5, 2),
+(@AQWarAllianceSkinsInitial,       '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Skins Initial',        5, 2),
+(@AQWarAllianceSkinsT1,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Skins Tier 1',         5, 2),
+(@AQWarAllianceSkinsT2,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Skins Tier 2',         5, 2),
+(@AQWarAllianceSkinsT3,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Skins Tier 3',         5, 2),
+(@AQWarAllianceSkinsT4,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Skins Tier 4',         5, 2),
+(@AQWarAllianceSkinsT5,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Skins Tier 5',         5, 2),
+(@AQWarAllianceBandagesInitial,    '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bandages Initial',     5, 2),
+(@AQWarAllianceBandagesT1,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bandages Tier 1',      5, 2),
+(@AQWarAllianceBandagesT2,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bandages Tier 2',      5, 2),
+(@AQWarAllianceBandagesT3,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bandages Tier 3',      5, 2),
+(@AQWarAllianceBandagesT4,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bandages Tier 4',      5, 2),
+(@AQWarAllianceBandagesT5,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Bandages Tier 5',      5, 2),
+(@AQWarAllianceCookedGoodsInitial, '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Cooked Goods Initial', 5, 2),
+(@AQWarAllianceCookedGoodsT1,      '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Cooked Goods Tier 1',  5, 2),
+(@AQWarAllianceCookedGoodsT2,      '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Cooked Goods Tier 2',  5, 2),
+(@AQWarAllianceCookedGoodsT3,      '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Cooked Goods Tier 3',  5, 2),
+(@AQWarAllianceCookedGoodsT4,      '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Cooked Goods Tier 4',  5, 2),
+(@AQWarAllianceCookedGoodsT5,      '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Alliance Cooked Goods Tier 5',  5, 2),
+(@AQWarHordeBarsInitial,           '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bars Initial',            5, 2),
+(@AQWarHordeBarsT1,                '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bars Tier 1',             5, 2),
+(@AQWarHordeBarsT2,                '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bars Tier 2',             5, 2),
+(@AQWarHordeBarsT3,                '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bars Tier 3',             5, 2),
+(@AQWarHordeBarsT4,                '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bars Tier 4',             5, 2),
+(@AQWarHordeBarsT5,                '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bars Tier 5',             5, 2),
+(@AQWarHordeHerbsInitial,          '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Herbs Initial',           5, 2),
+(@AQWarHordeHerbsT1,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Herbs Tier 1',            5, 2),
+(@AQWarHordeHerbsT2,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Herbs Tier 2',            5, 2),
+(@AQWarHordeHerbsT3,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Herbs Tier 3',            5, 2),
+(@AQWarHordeHerbsT4,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Herbs Tier 4',            5, 2),
+(@AQWarHordeHerbsT5,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Herbs Tier 5',            5, 2),
+(@AQWarHordeSkinsInitial,          '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Skins Initial',           5, 2),
+(@AQWarHordeSkinsT1,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Skins Tier 1',            5, 2),
+(@AQWarHordeSkinsT2,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Skins Tier 2',            5, 2),
+(@AQWarHordeSkinsT3,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Skins Tier 3',            5, 2),
+(@AQWarHordeSkinsT4,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Skins Tier 4',            5, 2),
+(@AQWarHordeSkinsT5,               '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Skins Tier 5',            5, 2),
+(@AQWarHordeBandagesInitial,       '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bandages Initial',        5, 2),
+(@AQWarHordeBandagesT1,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bandages Tier 1',         5, 2),
+(@AQWarHordeBandagesT2,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bandages Tier 2',         5, 2),
+(@AQWarHordeBandagesT3,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bandages Tier 3',         5, 2),
+(@AQWarHordeBandagesT4,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bandages Tier 4',         5, 2),
+(@AQWarHordeBandagesT5,            '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Bandages Tier 5',         5, 2),
+(@AQWarHordeCookedGoodsInitial,    '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Cooked Goods Initial',    5, 2),
+(@AQWarHordeCookedGoodsT1,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Cooked Goods Tier 1',     5, 2),
+(@AQWarHordeCookedGoodsT2,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Cooked Goods Tier 2',     5, 2),
+(@AQWarHordeCookedGoodsT3,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Cooked Goods Tier 3',     5, 2),
+(@AQWarHordeCookedGoodsT4,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Cooked Goods Tier 4',     5, 2),
+(@AQWarHordeCookedGoodsT5,         '2000-01-01 14:00:00', '2000-01-01 14:00:00', 5184000, 2592000, 0, 0, 'Ahn''Qiraj War Effort - Horde Cooked Goods Tier 5',     5, 2);
+
+DELETE FROM `game_event_creature` WHERE `eventEntry` = 22 AND `guid` BETWEEN @CGUID AND @CGUID+69;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(22, @CGUID+0),
+(22, @CGUID+1),
+(22, @CGUID+2),
+(22, @CGUID+3),
+(22, @CGUID+4),
+(22, @CGUID+5),
+(22, @CGUID+6),
+(22, @CGUID+7),
+(22, @CGUID+8),
+(22, @CGUID+9),
+(22, @CGUID+10),
+(22, @CGUID+11),
+(22, @CGUID+12),
+(22, @CGUID+13),
+(22, @CGUID+14),
+(22, @CGUID+15),
+(22, @CGUID+16),
+(22, @CGUID+17),
+(22, @CGUID+18),
+(22, @CGUID+19),
+(22, @CGUID+20),
+(22, @CGUID+21),
+(22, @CGUID+22),
+(22, @CGUID+23),
+(22, @CGUID+24),
+(22, @CGUID+25),
+(22, @CGUID+26),
+(22, @CGUID+27),
+(22, @CGUID+28),
+(22, @CGUID+29),
+(22, @CGUID+30),
+(22, @CGUID+31),
+(22, @CGUID+32),
+(22, @CGUID+33),
+(22, @CGUID+34),
+(22, @CGUID+35),
+(22, @CGUID+36),
+(22, @CGUID+37),
+(22, @CGUID+38),
+(22, @CGUID+39),
+(22, @CGUID+40),
+(22, @CGUID+41),
+(22, @CGUID+42),
+(22, @CGUID+43),
+(22, @CGUID+44),
+(22, @CGUID+45),
+(22, @CGUID+46),
+(22, @CGUID+47),
+(22, @CGUID+48),
+(22, @CGUID+49),
+(22, @CGUID+50),
+(22, @CGUID+51),
+(22, @CGUID+52),
+(22, @CGUID+53),
+(22, @CGUID+54),
+(22, @CGUID+55),
+(22, @CGUID+56),
+(22, @CGUID+57),
+(22, @CGUID+58),
+(22, @CGUID+59),
+(22, @CGUID+60),
+(22, @CGUID+61),
+(22, @CGUID+62),
+(22, @CGUID+63),
+(22, @CGUID+64),
+(22, @CGUID+65),
+(22, @CGUID+66),
+(22, @CGUID+67),
+(22, @CGUID+68),
+(22, @CGUID+69);
+
+DELETE FROM `game_event_creature` WHERE `eventEntry` = 22 AND `guid` IN (37, 2032, 6519, 6520, 25997, 32076, 46803);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry` IN (@AQWarAllianceBarsInitial, @AQWarAllianceBarsT1, @AQWarAllianceBarsT2, @AQWarAllianceBarsT3, @AQWarAllianceBarsT4, @AQWarAllianceBarsT5, @AQWarAllianceHerbsInitial, @AQWarAllianceHerbsT1, @AQWarAllianceHerbsT2, @AQWarAllianceHerbsT3, @AQWarAllianceHerbsT4, @AQWarAllianceHerbsT5, @AQWarAllianceSkinsInitial, @AQWarAllianceSkinsT1, @AQWarAllianceSkinsT2, @AQWarAllianceSkinsT3, @AQWarAllianceSkinsT4, @AQWarAllianceSkinsT5, @AQWarAllianceBandagesInitial, @AQWarAllianceBandagesT1, @AQWarAllianceBandagesT2, @AQWarAllianceBandagesT3, @AQWarAllianceBandagesT4, @AQWarAllianceBandagesT5, @AQWarAllianceCookedGoodsInitial, @AQWarAllianceCookedGoodsT1, @AQWarAllianceCookedGoodsT2, @AQWarAllianceCookedGoodsT3, @AQWarAllianceCookedGoodsT4, @AQWarAllianceCookedGoodsT5, @AQWarHordeBarsInitial, @AQWarHordeBarsT1, @AQWarHordeBarsT2, @AQWarHordeBarsT3, @AQWarHordeBarsT4, @AQWarHordeBarsT5, @AQWarHordeHerbsInitial, @AQWarHordeHerbsT1, @AQWarHordeHerbsT2, @AQWarHordeHerbsT3, @AQWarHordeHerbsT4, @AQWarHordeHerbsT5, @AQWarHordeSkinsInitial, @AQWarHordeSkinsT1, @AQWarHordeSkinsT2, @AQWarHordeSkinsT3, @AQWarHordeSkinsT4, @AQWarHordeSkinsT5, @AQWarHordeBandagesInitial, @AQWarHordeBandagesT1, @AQWarHordeBandagesT2, @AQWarHordeBandagesT3, @AQWarHordeBandagesT4, @AQWarHordeBandagesT5, @AQWarHordeCookedGoodsInitial, @AQWarHordeCookedGoodsT1, @AQWarHordeCookedGoodsT2, @AQWarHordeCookedGoodsT3, @AQWarHordeCookedGoodsT4, @AQWarHordeCookedGoodsT5);
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(@AQWarAllianceBarsInitial,        @OGUID+19),
+(@AQWarAllianceBarsT1,             @OGUID+19),
+(@AQWarAllianceBarsT1,             @OGUID+20),
+(@AQWarAllianceBarsT2,             @OGUID+19),
+(@AQWarAllianceBarsT2,             @OGUID+20),
+(@AQWarAllianceBarsT2,             @OGUID+21),
+(@AQWarAllianceBarsT3,             @OGUID+19),
+(@AQWarAllianceBarsT3,             @OGUID+20),
+(@AQWarAllianceBarsT3,             @OGUID+21),
+(@AQWarAllianceBarsT3,             @OGUID+22),
+(@AQWarAllianceBarsT4,             @OGUID+19),
+(@AQWarAllianceBarsT4,             @OGUID+20),
+(@AQWarAllianceBarsT4,             @OGUID+21),
+(@AQWarAllianceBarsT4,             @OGUID+22),
+(@AQWarAllianceBarsT4,             @OGUID+23),
+(@AQWarAllianceBarsT5,             @OGUID+19),
+(@AQWarAllianceBarsT5,             @OGUID+20),
+(@AQWarAllianceBarsT5,             @OGUID+21),
+(@AQWarAllianceBarsT5,             @OGUID+22),
+(@AQWarAllianceBarsT5,             @OGUID+23),
+(@AQWarAllianceBarsT5,             @OGUID+24),
+(@AQWarAllianceHerbsInitial,       @OGUID+25),
+(@AQWarAllianceHerbsT1,            @OGUID+25),
+(@AQWarAllianceHerbsT1,            @OGUID+31),
+(@AQWarAllianceHerbsT2,            @OGUID+25),
+(@AQWarAllianceHerbsT2,            @OGUID+31),
+(@AQWarAllianceHerbsT2,            @OGUID+32),
+(@AQWarAllianceHerbsT3,            @OGUID+25),
+(@AQWarAllianceHerbsT3,            @OGUID+31),
+(@AQWarAllianceHerbsT3,            @OGUID+32),
+(@AQWarAllianceHerbsT3,            @OGUID+33),
+(@AQWarAllianceHerbsT4,            @OGUID+25),
+(@AQWarAllianceHerbsT4,            @OGUID+31),
+(@AQWarAllianceHerbsT4,            @OGUID+32),
+(@AQWarAllianceHerbsT4,            @OGUID+33),
+(@AQWarAllianceHerbsT4,            @OGUID+34),
+(@AQWarAllianceHerbsT5,            @OGUID+25),
+(@AQWarAllianceHerbsT5,            @OGUID+31),
+(@AQWarAllianceHerbsT5,            @OGUID+32),
+(@AQWarAllianceHerbsT5,            @OGUID+33),
+(@AQWarAllianceHerbsT5,            @OGUID+34),
+(@AQWarAllianceHerbsT5,            @OGUID+35),
+(@AQWarAllianceSkinsInitial,       @OGUID+36),
+(@AQWarAllianceSkinsT1,            @OGUID+36),
+(@AQWarAllianceSkinsT1,            @OGUID+37),
+(@AQWarAllianceSkinsT2,            @OGUID+36),
+(@AQWarAllianceSkinsT2,            @OGUID+37),
+(@AQWarAllianceSkinsT2,            @OGUID+38),
+(@AQWarAllianceSkinsT3,            @OGUID+36),
+(@AQWarAllianceSkinsT3,            @OGUID+37),
+(@AQWarAllianceSkinsT3,            @OGUID+38),
+(@AQWarAllianceSkinsT3,            @OGUID+39),
+(@AQWarAllianceSkinsT4,            @OGUID+36),
+(@AQWarAllianceSkinsT4,            @OGUID+37),
+(@AQWarAllianceSkinsT4,            @OGUID+38),
+(@AQWarAllianceSkinsT4,            @OGUID+39),
+(@AQWarAllianceSkinsT4,            @OGUID+40),
+(@AQWarAllianceSkinsT5,            @OGUID+36),
+(@AQWarAllianceSkinsT5,            @OGUID+37),
+(@AQWarAllianceSkinsT5,            @OGUID+38),
+(@AQWarAllianceSkinsT5,            @OGUID+39),
+(@AQWarAllianceSkinsT5,            @OGUID+40),
+(@AQWarAllianceSkinsT5,            @OGUID+41),
+(@AQWarAllianceBandagesInitial,    @OGUID+0),
+(@AQWarAllianceBandagesT1,         @OGUID+0),
+(@AQWarAllianceBandagesT1,         @OGUID+1),
+(@AQWarAllianceBandagesT1,         @OGUID+6),
+(@AQWarAllianceBandagesT2,         @OGUID+0),
+(@AQWarAllianceBandagesT2,         @OGUID+1),
+(@AQWarAllianceBandagesT2,         @OGUID+2),
+(@AQWarAllianceBandagesT2,         @OGUID+6),
+(@AQWarAllianceBandagesT2,         @OGUID+7),
+(@AQWarAllianceBandagesT2,         @OGUID+8),
+(@AQWarAllianceBandagesT2,         @OGUID+9),
+(@AQWarAllianceBandagesT3,         @OGUID+0),
+(@AQWarAllianceBandagesT3,         @OGUID+1),
+(@AQWarAllianceBandagesT3,         @OGUID+2),
+(@AQWarAllianceBandagesT3,         @OGUID+3),
+(@AQWarAllianceBandagesT3,         @OGUID+6),
+(@AQWarAllianceBandagesT3,         @OGUID+7),
+(@AQWarAllianceBandagesT3,         @OGUID+8),
+(@AQWarAllianceBandagesT3,         @OGUID+9),
+(@AQWarAllianceBandagesT3,         @OGUID+10),
+(@AQWarAllianceBandagesT3,         @OGUID+11),
+(@AQWarAllianceBandagesT3,         @OGUID+12),
+(@AQWarAllianceBandagesT3,         @OGUID+13),
+(@AQWarAllianceBandagesT4,         @OGUID+0),
+(@AQWarAllianceBandagesT4,         @OGUID+1),
+(@AQWarAllianceBandagesT4,         @OGUID+2),
+(@AQWarAllianceBandagesT4,         @OGUID+3),
+(@AQWarAllianceBandagesT4,         @OGUID+4),
+(@AQWarAllianceBandagesT4,         @OGUID+6),
+(@AQWarAllianceBandagesT4,         @OGUID+7),
+(@AQWarAllianceBandagesT4,         @OGUID+8),
+(@AQWarAllianceBandagesT4,         @OGUID+9),
+(@AQWarAllianceBandagesT4,         @OGUID+10),
+(@AQWarAllianceBandagesT4,         @OGUID+11),
+(@AQWarAllianceBandagesT4,         @OGUID+12),
+(@AQWarAllianceBandagesT4,         @OGUID+13),
+(@AQWarAllianceBandagesT4,         @OGUID+14),
+(@AQWarAllianceBandagesT4,         @OGUID+15),
+(@AQWarAllianceBandagesT4,         @OGUID+16),
+(@AQWarAllianceBandagesT4,         @OGUID+17),
+(@AQWarAllianceBandagesT4,         @OGUID+18),
+(@AQWarAllianceBandagesT5,         @OGUID+0),
+(@AQWarAllianceBandagesT5,         @OGUID+1),
+(@AQWarAllianceBandagesT5,         @OGUID+2),
+(@AQWarAllianceBandagesT5,         @OGUID+3),
+(@AQWarAllianceBandagesT5,         @OGUID+4),
+(@AQWarAllianceBandagesT5,         @OGUID+5),
+(@AQWarAllianceBandagesT5,         @OGUID+6),
+(@AQWarAllianceBandagesT5,         @OGUID+7),
+(@AQWarAllianceBandagesT5,         @OGUID+8),
+(@AQWarAllianceBandagesT5,         @OGUID+9),
+(@AQWarAllianceBandagesT5,         @OGUID+10),
+(@AQWarAllianceBandagesT5,         @OGUID+11),
+(@AQWarAllianceBandagesT5,         @OGUID+12),
+(@AQWarAllianceBandagesT5,         @OGUID+13),
+(@AQWarAllianceBandagesT5,         @OGUID+14),
+(@AQWarAllianceBandagesT5,         @OGUID+15),
+(@AQWarAllianceBandagesT5,         @OGUID+16),
+(@AQWarAllianceBandagesT5,         @OGUID+17),
+(@AQWarAllianceBandagesT5,         @OGUID+18),
+(@AQWarAllianceBandagesT5,         @OGUID+72),
+(@AQWarAllianceBandagesT5,         @OGUID+73),
+(@AQWarAllianceBandagesT5,         @OGUID+74),
+(@AQWarAllianceBandagesT5,         @OGUID+75),
+(@AQWarAllianceBandagesT5,         @OGUID+76),
+(@AQWarAllianceBandagesT5,         @OGUID+77),
+(@AQWarAllianceBandagesT5,         @OGUID+78),
+(@AQWarAllianceBandagesT5,         @OGUID+79),
+(@AQWarAllianceBandagesT5,         @OGUID+80),
+(@AQWarAllianceBandagesT5,         @OGUID+81),
+(@AQWarAllianceCookedGoodsInitial, @OGUID+25),
+(@AQWarAllianceCookedGoodsT1,      @OGUID+25),
+(@AQWarAllianceCookedGoodsT1,      @OGUID+26),
+(@AQWarAllianceCookedGoodsT2,      @OGUID+25),
+(@AQWarAllianceCookedGoodsT2,      @OGUID+26),
+(@AQWarAllianceCookedGoodsT2,      @OGUID+27),
+(@AQWarAllianceCookedGoodsT3,      @OGUID+25),
+(@AQWarAllianceCookedGoodsT3,      @OGUID+26),
+(@AQWarAllianceCookedGoodsT3,      @OGUID+27),
+(@AQWarAllianceCookedGoodsT3,      @OGUID+28),
+(@AQWarAllianceCookedGoodsT4,      @OGUID+25),
+(@AQWarAllianceCookedGoodsT4,      @OGUID+26),
+(@AQWarAllianceCookedGoodsT4,      @OGUID+27),
+(@AQWarAllianceCookedGoodsT4,      @OGUID+28),
+(@AQWarAllianceCookedGoodsT4,      @OGUID+29),
+(@AQWarAllianceCookedGoodsT5,      @OGUID+25),
+(@AQWarAllianceCookedGoodsT5,      @OGUID+26),
+(@AQWarAllianceCookedGoodsT5,      @OGUID+27),
+(@AQWarAllianceCookedGoodsT5,      @OGUID+28),
+(@AQWarAllianceCookedGoodsT5,      @OGUID+29),
+(@AQWarAllianceCookedGoodsT5,      @OGUID+30),
+(@AQWarHordeBarsInitial,           @OGUID+48),
+(@AQWarHordeBarsT1,                @OGUID+48),
+(@AQWarHordeBarsT1,                @OGUID+49),
+(@AQWarHordeBarsT2,                @OGUID+48),
+(@AQWarHordeBarsT2,                @OGUID+49),
+(@AQWarHordeBarsT2,                @OGUID+50),
+(@AQWarHordeBarsT3,                @OGUID+48),
+(@AQWarHordeBarsT3,                @OGUID+49),
+(@AQWarHordeBarsT3,                @OGUID+50),
+(@AQWarHordeBarsT3,                @OGUID+51),
+(@AQWarHordeBarsT4,                @OGUID+48),
+(@AQWarHordeBarsT4,                @OGUID+49),
+(@AQWarHordeBarsT4,                @OGUID+50),
+(@AQWarHordeBarsT4,                @OGUID+51),
+(@AQWarHordeBarsT4,                @OGUID+52),
+(@AQWarHordeBarsT5,                @OGUID+48),
+(@AQWarHordeBarsT5,                @OGUID+49),
+(@AQWarHordeBarsT5,                @OGUID+50),
+(@AQWarHordeBarsT5,                @OGUID+51),
+(@AQWarHordeBarsT5,                @OGUID+52),
+(@AQWarHordeBarsT5,                @OGUID+53),
+(@AQWarHordeHerbsInitial,          @OGUID+60),
+(@AQWarHordeHerbsT1,               @OGUID+60),
+(@AQWarHordeHerbsT1,               @OGUID+61),
+(@AQWarHordeHerbsT2,               @OGUID+60),
+(@AQWarHordeHerbsT2,               @OGUID+61),
+(@AQWarHordeHerbsT2,               @OGUID+62),
+(@AQWarHordeHerbsT3,               @OGUID+60),
+(@AQWarHordeHerbsT3,               @OGUID+61),
+(@AQWarHordeHerbsT3,               @OGUID+62),
+(@AQWarHordeHerbsT3,               @OGUID+63),
+(@AQWarHordeHerbsT4,               @OGUID+60),
+(@AQWarHordeHerbsT4,               @OGUID+61),
+(@AQWarHordeHerbsT4,               @OGUID+62),
+(@AQWarHordeHerbsT4,               @OGUID+63),
+(@AQWarHordeHerbsT4,               @OGUID+64),
+(@AQWarHordeHerbsT5,               @OGUID+60),
+(@AQWarHordeHerbsT5,               @OGUID+61),
+(@AQWarHordeHerbsT5,               @OGUID+62),
+(@AQWarHordeHerbsT5,               @OGUID+63),
+(@AQWarHordeHerbsT5,               @OGUID+64),
+(@AQWarHordeHerbsT5,               @OGUID+65),
+(@AQWarHordeSkinsInitial,          @OGUID+66),
+(@AQWarHordeSkinsT1,               @OGUID+66),
+(@AQWarHordeSkinsT1,               @OGUID+67),
+(@AQWarHordeSkinsT2,               @OGUID+66),
+(@AQWarHordeSkinsT2,               @OGUID+67),
+(@AQWarHordeSkinsT2,               @OGUID+68),
+(@AQWarHordeSkinsT3,               @OGUID+66),
+(@AQWarHordeSkinsT3,               @OGUID+67),
+(@AQWarHordeSkinsT3,               @OGUID+68),
+(@AQWarHordeSkinsT3,               @OGUID+69),
+(@AQWarHordeSkinsT4,               @OGUID+66),
+(@AQWarHordeSkinsT4,               @OGUID+67),
+(@AQWarHordeSkinsT4,               @OGUID+68),
+(@AQWarHordeSkinsT4,               @OGUID+69),
+(@AQWarHordeSkinsT4,               @OGUID+70),
+(@AQWarHordeSkinsT5,               @OGUID+66),
+(@AQWarHordeSkinsT5,               @OGUID+67),
+(@AQWarHordeSkinsT5,               @OGUID+68),
+(@AQWarHordeSkinsT5,               @OGUID+69),
+(@AQWarHordeSkinsT5,               @OGUID+70),
+(@AQWarHordeSkinsT5,               @OGUID+71),
+(@AQWarHordeBandagesInitial,       @OGUID+42),
+(@AQWarHordeBandagesT1,            @OGUID+42),
+(@AQWarHordeBandagesT1,            @OGUID+43),
+(@AQWarHordeBandagesT2,            @OGUID+42),
+(@AQWarHordeBandagesT2,            @OGUID+43),
+(@AQWarHordeBandagesT2,            @OGUID+44),
+(@AQWarHordeBandagesT3,            @OGUID+42),
+(@AQWarHordeBandagesT3,            @OGUID+43),
+(@AQWarHordeBandagesT3,            @OGUID+44),
+(@AQWarHordeBandagesT3,            @OGUID+45),
+(@AQWarHordeBandagesT4,            @OGUID+42),
+(@AQWarHordeBandagesT4,            @OGUID+43),
+(@AQWarHordeBandagesT4,            @OGUID+44),
+(@AQWarHordeBandagesT4,            @OGUID+45),
+(@AQWarHordeBandagesT4,            @OGUID+46),
+(@AQWarHordeBandagesT5,            @OGUID+42),
+(@AQWarHordeBandagesT5,            @OGUID+43),
+(@AQWarHordeBandagesT5,            @OGUID+44),
+(@AQWarHordeBandagesT5,            @OGUID+45),
+(@AQWarHordeBandagesT5,            @OGUID+46),
+(@AQWarHordeBandagesT5,            @OGUID+47),
+(@AQWarHordeCookedGoodsInitial,    @OGUID+54),
+(@AQWarHordeCookedGoodsT1,         @OGUID+54),
+(@AQWarHordeCookedGoodsT1,         @OGUID+55),
+(@AQWarHordeCookedGoodsT2,         @OGUID+54),
+(@AQWarHordeCookedGoodsT2,         @OGUID+55),
+(@AQWarHordeCookedGoodsT2,         @OGUID+56),
+(@AQWarHordeCookedGoodsT3,         @OGUID+54),
+(@AQWarHordeCookedGoodsT3,         @OGUID+55),
+(@AQWarHordeCookedGoodsT3,         @OGUID+56),
+(@AQWarHordeCookedGoodsT3,         @OGUID+57),
+(@AQWarHordeCookedGoodsT4,         @OGUID+54),
+(@AQWarHordeCookedGoodsT4,         @OGUID+55),
+(@AQWarHordeCookedGoodsT4,         @OGUID+56),
+(@AQWarHordeCookedGoodsT4,         @OGUID+57),
+(@AQWarHordeCookedGoodsT4,         @OGUID+58),
+(@AQWarHordeCookedGoodsT5,         @OGUID+54),
+(@AQWarHordeCookedGoodsT5,         @OGUID+55),
+(@AQWarHordeCookedGoodsT5,         @OGUID+56),
+(@AQWarHordeCookedGoodsT5,         @OGUID+57),
+(@AQWarHordeCookedGoodsT5,         @OGUID+58),
+(@AQWarHordeCookedGoodsT5,         @OGUID+59);
diff --git a/data/sql/updates/pending_db_world/gobject-spawns.sql b/data/sql/updates/pending_db_world/gobject-spawns.sql
new file mode 100644
index 0000000000..8b2082ea4f
--- /dev/null
+++ b/data/sql/updates/pending_db_world/gobject-spawns.sql
@@ -0,0 +1,102 @@
+SET @GUID = 3639;
+-- Note: Some of these are CO2s, especially since there's some weird destroy/recreate thing going on on official, but I just noted them as CO1s for the time being.
+DELETE FROM `gameobject` WHERE `id` IN (180598, 180674, 180675, 180676, 180677, 180678, 180679, 180680, 180681, 180692, 180693, 180694, 180695, 180696, 180714, 180780, 180781, 180782, 180783, 180784, 180800, 180801, 180802, 180803, 180804, 180805, 180806, 180807, 180808, 180809, 180812, 180813, 180814, 180815, 180816, 180817, 180818, 180819, 180820, 180821, 180822, 180823, 180826, 180827, 180828, 180829, 180830, 180831, 180832, 180833, 180834, 180835, 180836, 180837, 180838, 180839, 180840, 180841, 180842, 180843) AND `guid` BETWEEN @GUID AND @GUID+81;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `VerifiedBuild`, `Comment`) VALUES
+-- Ironforge
+-- Bandages
+(@GUID+0, 180598, 0, 0, 0, 1, 1, -4971.5483, -1148.5706, 501.648,  2.2863789, 0, 0, 0.90996075, 0.4146944,  300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+1, 180674, 0, 0, 0, 1, 1, -4968.3267, -1152.889,  501.9254, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+2, 180675, 0, 0, 0, 1, 1, -4969.2095, -1143.8433, 509.2506, 2.2863789, 0, 0, 0.90996075, 0.4146944,  300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+3, 180676, 0, 0, 0, 1, 1, -4983.004,  -1136.2194, 501.6594, 2.3038306, 0, 0, 0.91354465, 0.40673843, 300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+4, 180677, 0, 0, 0, 1, 1, -4975.6016, -1147.3348, 509.2504, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+5, 180678, 0, 0, 0, 1, 1, -4974.111,  -1148.3993, 510.8475, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T5
+-- CrateAllianceFirstAid01
+(@GUID+6, 180714, 0, 0, 0, 1, 1, -4972.807,  -1145.8307, 501.64996, 3.6128378,  0, 0, -0.9723692,  0.23344836,  300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+7, 180714, 0, 0, 0, 1, 1, -4976.2925, -1158.7479, 501.64252, 0.85521054, 0, 0, 0.41469288,  0.90996146,  300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+8, 180714, 0, 0, 0, 1, 1, -4979.9673, -1146.8904, 501.65506, 4.2062464,  0, 0, -0.86162853, 0.5075394,   300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+9, 180714, 0, 0, 0, 1, 1, -4972.857,  -1145.8458, 502.8929,  2.1991146,  0, 0, 0.89100647,  0.45399064,  300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+10, 180714, 0, 0, 0, 1, 1, -4977.4546, -1157.944,  501.64926, 3.9269955,  0, 0, -0.92387867, 0.3826855,   300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+11, 180714, 0, 0, 0, 1, 1, -4985.743,  -1137.5488, 501.6594,  3.5430236,  0, 0, -0.9799242,  0.19937038,  300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+12, 180714, 0, 0, 0, 1, 1, -4979.9263, -1139.9106, 501.65945, 1.3613561,  0, 0, 0.62932014,  0.77714616,  300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+13, 180714, 0, 0, 0, 1, 1, -4972.919,  -1145.8206, 504.1289,  1.7627825,  0, 0, 0.77162457,  0.63607824,  300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+14, 180714, 0, 0, 0, 1, 1, -4976.9517, -1158.2965, 502.88937, 4.153885,   0, 0, -0.8746195,  0.48481005,  300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+15, 180714, 0, 0, 0, 1, 1, -4972.6714, -1152.6599, 509.25027, 0.3316107,  0, 0, 0.16504669,  0.98628575,  300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+16, 180714, 0, 0, 0, 1, 1, -4968.471,  -1149.9625, 501.9254,  5.0265493,  0, 0, -0.58778477, 0.80901736,  300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+17, 180714, 0, 0, 0, 1, 1, -4979.914,  -1139.9069, 502.9025,  1.4835281,  0, 0, 0.67558956,  0.7372779,   300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+18, 180714, 0, 0, 0, 1, 1, -4985.936,  -1135.9319, 501.6594,  3.1590624,  0, 0, -0.99996185, 0.008734641, 300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+72, 180714, 0, 0, 0, 1, 1, -4972.6826, -1136.9497, 509.77707, 4.3807764,  0, 0, -0.8141155,  0.58070296,  300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+73, 180714, 0, 0, 0, 1, 1, -4979.8037, -1146.875,  502.89078, 3.7175536,  0, 0, -0.9588194,  0.28401646,  300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+74, 180714, 0, 0, 0, 1, 1, -4971.91,   -1153.9872, 509.25027, 5.2359877,  0, 0, -0.5,        0.8660254,   300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+75, 180714, 0, 0, 0, 1, 1, -4978.415,  -1159.3356, 501.64444, 3.0368383,  0, 0, 0.9986286,   0.052353222, 300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+76, 180714, 0, 0, 0, 1, 1, -4974.837,  -1156.8785, 503.5236,  6.003934,   0, 0, -0.13917255, 0.9902682,   300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+77, 180714, 0, 0, 0, 1, 1, -4986.0234, -1136.7771, 502.90247, 3.1940022,  0, 0, -0.9996567,  0.026201647, 300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+78, 180714, 0, 0, 0, 1, 1, -4979.7725, -1139.9098, 504.1386,  5.98648,    0, 0, -0.14780903, 0.98901594,  300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+79, 180714, 0, 0, 0, 1, 1, -4968.3887, -1150.027,  503.16846, 0.36651757, 0, 0, 0.18223476,  0.983255,    300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+80, 180714, 0, 0, 0, 1, 1, -4972.4443, -1153.132,  510.49332, 5.2534423,  0, 0, -0.49242306, 0.87035596,  300, 0, 1, '', 61582, NULL), -- T5
+(@GUID+81, 180714, 0, 0, 0, 1, 1, -4984.3228, -1135.7563, 504.87466, 3.6302915,  0, 0, -0.97029495, 0.241925,    300, 0, 1, '', 61582, NULL), -- T5
+-- Bars
+(@GUID+19, 180680, 0, 0, 0, 1, 1, -4913.854,  -1225.9967, 501.6508,  2.2514734, 0, 0, 0.902585,   0.43051165, 300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+20, 180780, 0, 0, 0, 1, 1, -4913.729,  -1225.9507, 501.6506,  2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+21, 180781, 0, 0, 0, 1, 1, -4913.737,  -1225.9277, 501.65067, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+22, 180782, 0, 0, 0, 1, 1, -4913.723,  -1225.9167, 501.65067, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+23, 180783, 0, 0, 0, 1, 1, -4913.71,   -1225.9053, 501.65067, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+24, 180784, 0, 0, 0, 1, 1, -4913.7773, -1225.8594, 501.65082, 2.2863789, 0, 0, 0.90996075, 0.4146944,  300, 0, 1, '', 61582, NULL), -- T5
+-- Cooking
+(@GUID+25, 180679, 0, 0, 0, 1, 1, -4937.2886, -1282.7358, 501.67215, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- Cooking/Herbs Initial
+(@GUID+26, 180800, 0, 0, 0, 1, 1, -4937.282,  -1282.8739, 501.67227, 2.2514734, 0, 0, 0.902585,   0.43051165, 300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+27, 180806, 0, 0, 0, 1, 1, -4937.136,  -1282.895,  501.6721,  2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+28, 180807, 0, 0, 0, 1, 1, -4937.2856, -1282.869,  501.67227, 2.2514734, 0, 0, 0.902585,   0.43051165, 300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+29, 180808, 0, 0, 0, 1, 1, -4937.336,  -1282.7858, 501.67227, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+30, 180809, 0, 0, 0, 1, 1, -4937.2197, -1282.8075, 501.67215, 2.2863789, 0, 0, 0.90996075, 0.4146944,  300, 0, 1, '', 61582, NULL), -- T5
+-- Herbs
+(@GUID+31, 180801, 0, 0, 0, 1, 1, -4935.5796, -1284.82,   501.67105, 2.2514734, 0, 0, 0.902585,  0.43051165, 300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+32, 180802, 0, 0, 0, 1, 1, -4935.6045, -1284.8381, 501.6711,  2.2514734, 0, 0, 0.902585,  0.43051165, 300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+33, 180803, 0, 0, 0, 1, 1, -4935.594,  -1284.833,  501.6711,  2.2514734, 0, 0, 0.902585,  0.43051165, 300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+34, 180804, 0, 0, 0, 1, 1, -4935.621,  -1284.8282, 501.6711,  2.2514734, 0, 0, 0.902585,  0.43051165, 300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+35, 180805, 0, 0, 0, 1, 1, -4935.5576, -1284.8864, 501.67105, 2.2340178, 0, 0, 0.8987932, 0.43837282, 300, 0, 1, '', 61582, NULL), -- T5
+-- Skins
+(@GUID+36, 180681, 0, 0, 0, 1, 1, -4958.5093, -1179.3196, 501.65945, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+37, 180692, 0, 0, 0, 1, 1, -4958.517,  -1179.3344, 501.65945, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+38, 180693, 0, 0, 0, 1, 1, -4958.528,  -1179.335,  501.65945, 2.2514734, 0, 0, 0.902585,   0.43051165, 300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+39, 180694, 0, 0, 0, 1, 1, -4958.526,  -1179.3273, 501.65945, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+40, 180695, 0, 0, 0, 1, 1, -4958.5156, -1179.3286, 501.65945, 2.2689254, 0, 0, 0.9063072,  0.4226195,  300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+41, 180696, 0, 0, 0, 1, 1, -4958.5293, -1179.3357, 501.65945, 2.2863789, 0, 0, 0.90996075, 0.4146944,  300, 0, 1, '', 61582, NULL), -- T5
+-- Orgrimmar
+-- Bandages
+(@GUID+42, 180826, 1, 0, 0, 1, 1, 1579.3531, -4109.2544, 34.541737, 3.7524624, 0, 0, -0.9537163,  0.3007079,  300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+43, 180827, 1, 0, 0, 1, 1, 1579.3342, -4109.2476, 34.54871,  3.7175536, 0, 0, -0.9588194,  0.28401646, 300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+44, 180828, 1, 0, 0, 1, 1, 1579.321,  -4109.278,  34.551514, 3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+45, 180829, 1, 0, 0, 1, 1, 1579.333,  -4109.2837, 34.547028, 3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+46, 180830, 1, 0, 0, 1, 1, 1579.3325, -4109.2783, 34.547504, 3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+47, 180831, 1, 0, 0, 1, 1, 1579.331,  -4109.2827, 34.54776,  3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T5
+-- Bars
+(@GUID+48, 180838, 1, 0, 0, 1, 1, 1683.1149, -4134.354,  39.541912, 3.7175536, 0, 0, -0.9588194,  0.28401646, 300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+49, 180839, 1, 0, 0, 1, 1, 1683.0984, -4134.31,   39.539,    3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+50, 180840, 1, 0, 0, 1, 1, 1683.097,  -4134.3,    39.538742, 3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+51, 180841, 1, 0, 0, 1, 1, 1683.1057, -4134.3135, 39.54028,  3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+52, 180842, 1, 0, 0, 1, 1, 1683.0347, -4134.3135, 39.52796,  3.7175536, 0, 0, -0.9588194,  0.28401646, 300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+53, 180843, 1, 0, 0, 1, 1, 1683.1418, -4134.3403, 39.54657,  3.7524624, 0, 0, -0.9537163,  0.3007079,  300, 0, 1, '', 61582, NULL), -- T5
+-- Cooking
+(@GUID+54, 180832, 1, 0, 0, 1, 1, 1619.8307, -4092.4302, 34.51068,  3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+55, 180833, 1, 0, 0, 1, 1, 1619.8004, -4092.5334, 34.488815, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+56, 180834, 1, 0, 0, 1, 1, 1619.8002, -4092.5317, 34.489204, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+57, 180835, 1, 0, 0, 1, 1, 1619.8073, -4092.5269, 34.490135, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+58, 180836, 1, 0, 0, 1, 1, 1619.8062, -4092.5305, 34.48937,  3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+59, 180837, 1, 0, 0, 1, 1, 1619.8094, -4092.5217, 34.491196, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T5
+-- Herbs
+(@GUID+60, 180818, 1, 0, 0, 1, 1, 1637.1053, -4147.2134, 36.04144,  3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+61, 180819, 1, 0, 0, 1, 1, 1637.1001, -4147.2534, 36.053123, 3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+62, 180820, 1, 0, 0, 1, 1, 1637.111,  -4147.2534, 36.05357,  3.735006,  0, 0, -0.95630455, 0.29237235, 300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+63, 180821, 1, 0, 0, 1, 1, 1637.1099, -4147.2573, 36.054718, 3.7524624, 0, 0, -0.9537163,  0.3007079,  300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+64, 180822, 1, 0, 0, 1, 1, 1637.079,  -4147.228,  36.04483,  3.7175536, 0, 0, -0.9588194,  0.28401646, 300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+65, 180823, 1, 0, 0, 1, 1, 1637.1013, -4147.226,  36.045063, 3.7175536, 0, 0, -0.9588194,  0.28401646, 300, 0, 1, '', 61582, NULL), -- T5
+-- Skins
+(@GUID+66, 180812, 1, 0, 0, 1, 1, 1590.8248, -4155.328,  36.292576, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- Initial
+(@GUID+67, 180813, 1, 0, 0, 1, 1, 1590.8755, -4155.335,  36.298023, 3.6826503, 0, 0, -0.9636297, 0.267241,  300, 0, 1, '', 61582, NULL), -- T1
+(@GUID+68, 180814, 1, 0, 0, 1, 1, 1590.8511, -4155.342,  36.299625, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T2
+(@GUID+69, 180815, 1, 0, 0, 1, 1, 1590.8533, -4155.339,  36.299156, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T3
+(@GUID+70, 180816, 1, 0, 0, 1, 1, 1590.8516, -4155.341,  36.299488, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL), -- T4
+(@GUID+71, 180817, 1, 0, 0, 1, 1, 1590.8517, -4155.3438, 36.299927, 3.7001047, 0, 0, -0.9612608, 0.2756405, 300, 0, 1, '', 61582, NULL); -- T5
+
+-- Old spawns
+DELETE FROM `gameobject` WHERE `guid` IN (29294, 29299, 29300, 29301) AND `id` IN (180598, 180679, 180680, 180681);