
SELECT * FROM `creature` WHERE (`guid` IN (SELECT `guid` FROM `game_event_creature` WHERE `event` IN (27,28,77,106,108,109)))


UPDATE `game_event` SET `entry` = 28,`start_time` = '2007-06-01 23:59:59',`end_time` = '2020-12-31 00:00:00',`occurence` = 5760,`length` = 60,`holiday` = 0,
`description` = '[Stormwind] Death Legion Attack - Undead Attack (60 level)' WHERE `entry` = 28;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(127343, 880003, 0, 1, 1, 0, 0, -9093.01, 405.788, 92.3606, 0.425684, 600, 0, 0, 15000, 0, 0, 0),
(127344, 880003, 0, 1, 1, 0, 0, -9094.18, 407.142, 92.3492, 0.714711, 600, 0, 0, 15000, 0, 0, 0),
(127345, 880003, 0, 1, 1, 0, 0, -9052.48, 473.881, 87.2364, 5.31086, 600, 0, 0, 15000, 0, 0, 0),
(127346, 880003, 0, 1, 1, 0, 0, -9021.3, 430.265, 84.4179, 2.16142, 600, 0, 0, 15000, 0, 0, 0),
(127347, 880003, 0, 1, 1, 0, 0, -9003.09, 478.779, 96.5607, 0.698415, 600, 0, 0, 15000, 0, 0, 0),
(127348, 880004, 0, 1, 1, 0, 0, -9005.35, 487.914, 96.8458, 0.720212, 600, 0, 0, 13000, 0, 0, 0),
(127349, 880004, 0, 1, 1, 0, 0, -8997.73, 479.227, 96.8518, 0.720212, 600, 0, 0, 13000, 0, 0, 0),
(127350, 880003, 0, 1, 1, 0, 0, -8913.84, 553.59, 93.8616, 0.656788, 600, 0, 0, 15000, 0, 0, 0),
(127351, 880005, 0, 1, 1, 0, 0, -8893.16, 596.046, 94.758, 5.32686, 600, 0, 0, 14000, 5200, 0, 0),
(127352, 880003, 0, 1, 1, 0, 0, -8856.93, 642.095, 96.4466, 3.28875, 600, 0, 0, 15000, 0, 0, 0),
(127353, 880003, 0, 1, 1, 0, 0, -8853.53, 653.296, 96.428, 5.81538, 600, 0, 0, 15000, 0, 0, 0),
(127354, 880005, 0, 1, 1, 0, 0, -8793.24, 614.458, 96.7746, 5.0182, 600, 0, 0, 14000, 5200, 0, 0),
(127355, 880003, 0, 1, 1, 0, 0, -8838.28, 613.426, 93.0426, 3.91, 600, 0, 0, 15000, 0, 0, 0),
(127356, 880003, 0, 1, 1, 0, 0, -8875.39, 593.084, 92.8525, 2.69263, 600, 0, 0, 15000, 0, 0, 0),
(127357, 880004, 0, 1, 1, 0, 0, -8902.07, 561.182, 93.0536, 1.00148, 600, 0, 0, 13000, 0, 0, 0),
(127358, 880005, 0, 1, 1, 0, 0, -8899.66, 560.295, 92.9824, 1.02112, 600, 0, 0, 14000, 5200, 0, 0),
(127362, 880004, 0, 1, 1, 0, 0, -8926.68, 491.201, 93.8455, 4.61904, 600, 0, 0, 13000, 0, 0, 0),
(127363, 880004, 0, 1, 1, 0, 0, -8914.72, 521.28, 93.8175, 0.962223, 600, 0, 0, 13000, 0, 0, 0),
(127364, 880005, 0, 1, 1, 0, 0, -8933.65, 551.431, 94.4118, 2.18273, 600, 0, 0, 14000, 5200, 0, 0);

UPDATE `game_event` SET `entry` = 27,`start_time` = '2007-06-01 23:59:58',`end_time` = '2020-12-31 00:00:00',`occurence` = 5760,`length` = 60,`holiday` = 0,
`description` = '[Stormwind] Death Legion Attack - Guards Defend' WHERE `entry` = 27;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(127359, 1976, 0, 1, 1, 0, 0, -9068.44, 425.014, 93.0568, 4.03626, 300, 0, 0, 495, 0, 0, 0),
(127360, 1976, 0, 1, 1, 0, 0, -9043.08, 450.028, 93.0563, 0.238077, 300, 0, 0, 495, 0, 0, 0),
(127361, 1976, 0, 1, 1, 0, 0, -8949.84, 519.985, 96.3574, 3.92081, 300, 0, 0, 495, 0, 0, 0);

UPDATE `game_event` SET `entry` = 106,`start_time` = '2007-06-02 23:59:59',`end_time` = '2020-12-31 00:00:00',`occurence` = 5760,`length` = 60,`holiday` = 0,
`description` = '[Stormwind] Death Legion Attack (60 level)' WHERE `entry` = 106;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(300221, 880003, 0, 1, 1, 0, 0, -9093.01, 405.788, 92.3606, 0.425684, 7560, 0, 0, 15000, 0, 0, 2),
(300222, 880003, 0, 1, 1, 0, 0, -9094.18, 407.142, 92.3492, 0.714711, 7560, 0, 0, 15000, 0, 0, 2),
(300223, 880003, 0, 1, 1, 0, 0, -9052.48, 473.881, 87.2364, 5.31086, 7560, 0, 0, 15000, 0, 0, 2),
(300224, 880003, 0, 1, 1, 0, 0, -9021.3, 430.265, 84.4179, 2.16142, 7560, 0, 0, 15000, 0, 0, 2),
(300225, 880003, 0, 1, 1, 0, 0, -9003.09, 478.779, 96.5607, 0.698415, 7560, 0, 0, 15000, 0, 0, 2),
(300226, 880004, 0, 1, 1, 0, 0, -9005.35, 487.914, 96.8458, 0.720212, 3360, 0, 0, 13000, 0, 0, 2),
(300227, 880004, 0, 1, 1, 0, 0, -8997.73, 479.227, 96.8518, 0.720212, 3360, 0, 0, 13000, 0, 0, 2),
(300228, 880003, 0, 1, 1, 0, 0, -8913.84, 553.59, 93.8616, 0.656788, 7560, 0, 0, 15000, 0, 0, 2),
(300229, 880005, 0, 1, 1, 0, 0, -8893.16, 596.046, 94.758, 5.32686, 3360, 0, 0, 14000, 5200, 0, 2),
(300230, 880003, 0, 1, 1, 0, 0, -8857.54, 642.114, 96.4027, 2.51049, 7560, 0, 0, 15000, 0, 0, 2),
(300231, 880003, 0, 1, 1, 0, 0, -8853.59, 653.954, 96.4775, 5.78364, 7560, 0, 0, 15000, 0, 0, 2),
(300232, 880005, 0, 1, 1, 0, 0, -8793.24, 614.458, 96.7746, 5.0182, 3360, 0, 0, 14000, 5200, 0, 2),
(300233, 880003, 0, 1, 1, 0, 0, -8838.28, 613.426, 93.0426, 3.91, 7560, 0, 0, 15000, 0, 0, 2),
(300234, 880003, 0, 1, 1, 0, 0, -8875.39, 593.084, 92.8525, 2.69263, 7560, 0, 0, 15000, 0, 0, 2),
(300235, 880004, 0, 1, 1, 0, 0, -8902.07, 561.182, 93.0536, 1.00148, 3360, 10, 0, 13000, 0, 0, 1),
(300236, 880005, 0, 1, 1, 0, 0, -8899.66, 560.295, 92.9824, 1.02112, 3360, 10, 0, 14000, 5200, 0, 1),
(300237, 880004, 0, 1, 1, 0, 0, -8926.68, 491.201, 93.8455, 4.61904, 3360, 0, 0, 13000, 0, 0, 2),
(300238, 880004, 0, 1, 1, 0, 0, -8914.72, 521.28, 93.8175, 0.962223, 3360, 0, 0, 13000, 0, 0, 2),
(300239, 880005, 0, 1, 1, 0, 0, -8933.65, 551.431, 94.4118, 2.18273, 3360, 0, 0, 14000, 5200, 0, 2),
(300240, 1976, 0, 1, 1, 0, 0, -9068.44, 425.014, 93.0568, 4.03626, 3360, 10, 0, 495, 0, 0, 1),
(300241, 1976, 0, 1, 1, 0, 0, -9043.08, 450.028, 93.0563, 0.238077, 3360, 10, 0, 495, 0, 0, 1),
(300242, 1976, 0, 1, 1, 0, 0, -8949.84, 519.985, 96.3574, 3.92081, 3360, 10, 0, 495, 0, 0, 1),
(300261, 880005, 1, 1, 1, 0, 0, 1928.93, -4149.87, 40.4014, 2.22583, 3360, 10, 0, 14000, 5200, 0, 1),
(300262, 880004, 1, 1, 1, 0, 0, 1374.21, -4363.38, 26.0615, 5.8198, 3360, 10, 0, 13000, 0, 0, 1),
(300263, 880004, 1, 1, 1, 0, 0, 1432.8, -4422.57, 25.2359, 0.0698967, 3360, 10, 0, 13000, 0, 0, 1),
(300264, 880004, 1, 1, 1, 0, 0, 1368.01, -4379.92, 26.0766, 0.682511, 3360, 10, 0, 13000, 0, 0, 1),
(300265, 880003, 1, 1, 1, 0, 0, 1926.4, -4262.09, 36.8372, 1.65405, 7560, 10, 0, 15000, 0, 0, 1),
(300266, 880003, 1, 1, 1, 0, 0, 1932.99, -4257.42, 38.4139, 1.58337, 7560, 10, 0, 15000, 0, 0, 1),
(300267, 880003, 1, 1, 1, 0, 0, 1924.56, -4257.53, 38.5704, 1.63442, 7560, 10, 0, 15000, 0, 0, 1),
(300268, 880003, 1, 1, 1, 0, 0, 1921.48, -4479.06, 22.7561, 0.81996, 7560, 10, 0, 15000, 0, 0, 1),
(300269, 880003, 1, 1, 1, 0, 0, 1915.99, -4493.39, 23.7259, 0.929916, 7560, 10, 0, 15000, 0, 0, 1),
(300270, 880003, 1, 1, 1, 0, 0, 1817.55, -4526.57, 19.7136, 0.445546, 7560, 10, 0, 15000, 0, 0, 1),
(300271, 880004, 1, 1, 1, 0, 0, 1908.86, -4155.34, 40.4069, 1.02259, 3360, 10, 0, 13000, 0, 0, 1),
(300272, 880004, 1, 1, 1, 0, 0, 1913.6, -4141.2, 40.396, 4.33697, 3360, 10, 0, 13000, 0, 0, 1),
(300273, 880005, 1, 1, 1, 0, 0, 1928.12, -4242.85, 41.9431, 1.74674, 3360, 10, 0, 14000, 5200, 0, 1),
(300274, 880005, 1, 1, 1, 0, 0, 1933.13, -4339.92, 19.5148, 1.63678, 3360, 10, 0, 14000, 5200, 0, 1),
(300275, 880005, 1, 1, 1, 0, 0, 1606.88, -4382.38, 9.8507, 3.99611, 3360, 10, 0, 14000, 5200, 0, 1),
(300276, 880005, 1, 1, 1, 0, 0, 1932.44, -4426.93, 22.8324, 1.42001, 3360, 10, 0, 14000, 5200, 0, 1),
(300277, 880005, 1, 1, 1, 0, 0, 1664.84, -4409.35, 17.4601, 0.894587, 3360, 10, 0, 14000, 5200, 0, 1),
(300278, 880005, 1, 1, 1, 0, 0, 1446.65, -4423.28, 25.2358, 0.160225, 3360, 10, 0, 14000, 5200, 0, 1),
(300279, 880005, 1, 1, 1, 0, 0, 1380.17, -4363.19, 26.0454, 6.14496, 3360, 10, 0, 14000, 5200, 0, 1),
(300280, 880004, 1, 1, 1, 0, 0, 1565.36, -4378.87, 2.15178, 5.497, 3360, 10, 0, 13000, 0, 0, 1),
(300281, 880004, 1, 1, 1, 0, 0, 1926.25, -4218.97, 40.9464, 1.6564, 3360, 10, 0, 13000, 0, 0, 1),
(300282, 880003, 1, 1, 1, 0, 0, 1677.02, -4393.9, 20.375, 0.655026, 7560, 10, 5, 15000, 0, 0, 1),
(300283, 880003, 1, 1, 1, 0, 0, 1512.92, -4414.91, 18.3764, 1.43051e-006, 7560, 10, 0, 15000, 0, 0, 1),
(300284, 880003, 1, 1, 1, 0, 0, 1597.78, -4436.61, 6.49874, 0.470457, 7560, 10, 0, 15000, 0, 0, 1),
(300285, 880003, 1, 1, 1, 0, 0, 1553.96, -4436.41, 9.39899, 1.03438, 7560, 10, 0, 15000, 0, 0, 1),
(300286, 880005, 1, 1, 1, 0, 0, 1586.13, -4463.61, 7.83809, 5.4499, 3360, 10, 0, 14000, 5200, 0, 1),
(300287, 880003, 1, 1, 1, 0, 0, 1929.11, -4257.18, 38.5806, 1.65405, 7560, 10, 0, 15000, 0, 0, 1),
(300288, 880003, 1, 1, 1, 0, 0, 1896.75, -4283.6, 30.1171, 0.00392771, 7560, 10, 0, 15000, 0, 0, 1),
(300289, 880003, 1, 1, 1, 0, 0, 1931.52, -4262.3, 36.5705, 1.44592, 7560, 10, 0, 15000, 0, 0, 1),
(300290, 880003, 1, 1, 1, 0, 0, 1934.13, -4330.82, 19.885, 1.49304, 7560, 10, 0, 15000, 0, 0, 1),
(300291, 880003, 1, 1, 1, 0, 0, 1567.26, -4377.67, 2.13569, 5.21113, 7560, 10, 0, 15000, 0, 0, 1),
(300292, 880003, 1, 1, 1, 0, 0, 1560.46, -4391.31, 4.49414, 6.19523, 7560, 10, 0, 15000, 0, 0, 1),
(300293, 880003, 1, 1, 1, 0, 0, 1583.12, -4404.29, 5.42259, 0.497169, 7560, 10, 0, 15000, 0, 0, 1);

UPDATE `game_event` SET `entry` = 77,`start_time` = '2007-06-04 23:59:59',`end_time` = '2020-12-31 00:00:00',`occurence` = 5760,`length` = 60,`holiday` = 0,
`description` = '[Stormwind] Death Legion Attack (60 level)' WHERE `entry` = 77;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(300300, 68, 0, 1, 1, 0, 3, -8850.32, 726.661, 97.9491, 5.17764, 360, 0, 0, 795, 0, 0, 0),
(300301, 68, 0, 1, 1, 0, 3, -8847.96, 727.895, 98.0697, 5.19727, 360, 0, 0, 795, 0, 0, 0),
(300302, 68, 0, 1, 1, 0, 3, -8847.71, 732.546, 99.3832, 5.158, 360, 0, 0, 795, 0, 0, 0),
(300303, 68, 0, 1, 1, 0, 3, -8853.82, 729.947, 99.2645, 5.07947, 360, 0, 0, 795, 0, 0, 0),
(300304, 68, 0, 1, 1, 0, 3, -8826.69, 686.453, 97.2256, 4.96951, 360, 0, 0, 795, 0, 0, 0),
(300305, 68, 0, 1, 1, 0, 3, -8851.33, 664.344, 97.3176, 4.3412, 360, 0, 0, 795, 0, 0, 0),
(300306, 68, 0, 1, 1, 0, 3, -8855.32, 639.354, 96.4004, 0.625475, 360, 0, 0, 795, 0, 0, 0),
(300307, 68, 0, 1, 1, 0, 3, -8829.75, 646.08, 94.5729, 5.30017, 360, 0, 0, 795, 0, 0, 0),
(300308, 68, 0, 1, 1, 0, 3, -8834.39, 615.518, 93.5073, 0.988326, 360, 0, 0, 795, 0, 0, 0),
(300309, 68, 0, 1, 1, 0, 3, -8791.25, 642.273, 94.5223, 3.63512, 360, 0, 0, 795, 0, 0, 0),
(300310, 68, 0, 1, 1, 0, 3, -8792.96, 633.212, 94.4531, 2.9479, 360, 0, 0, 795, 0, 0, 0),
(300311, 68, 0, 1, 1, 0, 3, -8817.65, 636.882, 94.2288, 0.703227, 360, 0, 0, 795, 0, 0, 0),
(300312, 68, 0, 1, 1, 0, 3, -8862.93, 603.838, 92.3281, 4.21395, 360, 0, 0, 795, 0, 0, 0),
(300313, 68, 0, 1, 1, 0, 3, -8860.79, 602.681, 92.2112, 4.21788, 360, 0, 0, 795, 0, 0, 0),
(300314, 68, 0, 1, 1, 0, 3, -8862.39, 578.397, 94.4922, 3.08691, 360, 0, 0, 795, 0, 0, 0),
(300315, 68, 0, 1, 1, 0, 3, -8881.04, 597.245, 93.9979, 4.31213, 360, 0, 0, 795, 0, 0, 0),
(300316, 68, 0, 1, 1, 0, 3, -8900.06, 560.702, 92.9848, 3.84089, 360, 0, 0, 795, 0, 0, 0),
(300317, 68, 0, 1, 1, 0, 3, -8903.22, 564.429, 92.9941, 3.78591, 360, 0, 0, 795, 0, 0, 0),
(300318, 68, 0, 1, 1, 0, 3, -8970.44, 502.818, 96.3651, 3.84089, 360, 0, 0, 795, 0, 0, 0),
(300319, 68, 0, 1, 1, 0, 3, -8972.71, 505.492, 96.3657, 3.84874, 360, 0, 0, 795, 0, 0, 0),
(300320, 68, 0, 1, 1, 0, 3, -8974.43, 507.669, 96.3657, 3.80162, 360, 0, 0, 795, 0, 0, 0),
(300321, 68, 0, 1, 1, 0, 3, -8981.03, 498.025, 96.4444, 3.79769, 360, 0, 0, 795, 0, 0, 0),
(300322, 68, 0, 1, 1, 0, 3, -9073.18, 432.806, 93.0563, 3.8134, 360, 0, 0, 795, 0, 0, 0),
(300323, 68, 0, 1, 1, 0, 3, -8742.13, 550.918, 99.4119, 2.3722, 360, 0, 0, 795, 0, 0, 0),
(300324, 68, 0, 1, 1, 0, 3, -8740.3, 552.488, 99.4935, 2.41932, 360, 0, 0, 795, 0, 0, 0),
(300325, 68, 0, 1, 1, 0, 3, -8738.7, 554.168, 99.5084, 2.3722, 360, 0, 0, 795, 0, 0, 0),
(300326, 68, 0, 1, 1, 0, 3, -8741.28, 556.084, 98.6474, 2.34864, 360, 0, 0, 795, 0, 0, 0),
(300327, 68, 0, 1, 1, 0, 3, -8744.73, 552.922, 98.5317, 2.31329, 360, 0, 0, 795, 0, 0, 0),
(300328, 68, 0, 1, 1, 0, 3, -8742.01, 578.573, 97.4882, 2.30937, 360, 0, 0, 795, 0, 0, 0),
(300329, 68, 0, 1, 1, 0, 3, -8706.04, 619.627, 100.494, 1.96772, 360, 0, 0, 795, 0, 0, 0),
(300330, 68, 0, 1, 1, 0, 3, -8742.94, 716.234, 98.6804, 3.60135, 360, 0, 0, 795, 0, 0, 0),
(300331, 68, 0, 1, 1, 0, 3, -8739.37, 711.283, 98.9214, 3.77414, 360, 0, 0, 795, 0, 0, 0),
(300332, 68, 0, 1, 1, 0, 3, -8735.13, 714.362, 100.929, 3.76628, 360, 0, 0, 795, 0, 0, 0),
(300333, 68, 0, 1, 1, 0, 3, -8736.48, 716.749, 100.889, 3.51495, 360, 0, 0, 795, 0, 0, 0),
(300334, 68, 0, 1, 1, 0, 3, -8738.68, 720.356, 100.803, 3.70345, 360, 0, 0, 795, 0, 0, 0),
(300335, 68, 0, 1, 1, 0, 3, -8771.74, 727.474, 99.5342, 4.92867, 360, 0, 0, 795, 0, 0, 0),
(300336, 99121, 0, 1, 1, 0, 1219, -9081.91, 298.38, 93.4867, 2.0973, 360, 0, 0, 5578000, 127740, 0, 0),
(300337, 99122, 0, 1, 1, 0, 295, -9085.64, 299.408, 94.4642, 2.31722, 360, 0, 0, 4700, 0, 0, 0),
(300338, 99122, 0, 1, 1, 14361, 295, -9079.62, 303.36, 92.9847, 2.0973, 360, 0, 0, 4700, 0, 0, 0),
(300339, 99122, 0, 1, 1, 14361, 295, -9076.48, 296.119, 93.1726, 0.797464, 360, 0, 0, 4700, 0, 0, 0),
(300340, 99122, 0, 1, 1, 14361, 295, -9087.87, 292.7, 94.8931, 3.43247, 360, 0, 0, 4700, 0, 0, 0),
(300341, 99120, 0, 1, 1, 0, 295, -9068.18, 299.657, 93.1763, 1.62213, 360, 0, 0, 15000, 1528, 0, 0),
(300342, 99120, 0, 1, 1, 0, 295, -9066.7, 299.269, 93.4255, 1.54752, 360, 0, 0, 15000, 1528, 0, 0),
(300343, 99120, 0, 1, 1, 0, 295, -9065.08, 299.283, 93.6499, 1.72021, 360, 0, 0, 15000, 1528, 0, 0),
(300344, 99120, 0, 1, 1, 0, 295, -9093.6, 305.983, 94.9704, 2.30141, 360, 0, 0, 15000, 1528, 0, 0),
(300345, 99120, 0, 1, 1, 0, 295, -9091.77, 307.412, 94.7278, 2.23072, 360, 0, 0, 15000, 1528, 0, 0),
(300346, 99120, 0, 1, 1, 0, 295, -9083.34, 311.824, 94.163, 2.41136, 360, 0, 0, 15000, 1528, 0, 0),
(300347, 99120, 0, 1, 1, 0, 295, -9081.11, 313.891, 94.1955, 2.51346, 360, 0, 0, 15000, 1528, 0, 0),
(300348, 99120, 0, 1, 1, 0, 295, -9094.98, 291.33, 94.0719, 3.2164, 360, 0, 0, 15000, 1528, 0, 0),
(300349, 99120, 0, 1, 1, 0, 295, -9095.28, 294.114, 94.4507, 3.25174, 360, 0, 0, 15000, 1528, 0, 0),
(300350, 99120, 0, 1, 1, 0, 295, -9100.27, 418.62, 92.3646, 0.813074, 360, 0, 0, 15000, 1528, 0, 0),
(300351, 99120, 0, 1, 1, 0, 295, -9096.02, 408.826, 92.3629, 0.64814, 360, 0, 0, 15000, 1528, 0, 0),
(300352, 99120, 0, 1, 1, 0, 295, -9091.65, 403.695, 92.4622, 0.836636, 360, 0, 0, 15000, 1528, 0, 0),
(300353, 99120, 0, 1, 1, 0, 295, -9081.1, 413.233, 92.5101, 0.589235, 360, 0, 0, 15000, 1528, 0, 0),
(300354, 99120, 0, 1, 1, 0, 295, -9086.86, 420.592, 92.2948, 0.781658, 360, 0, 0, 15000, 1528, 0, 0),
(300355, 99120, 0, 1, 1, 0, 295, -9078.53, 431.602, 93.0562, 1.13195, 360, 0, 0, 15000, 1528, 0, 0),
(300356, 99120, 0, 1, 1, 0, 295, -9076.91, 421.487, 92.7247, 6.18991, 360, 0, 0, 15000, 1528, 0, 0),
(300357, 99120, 0, 1, 1, 0, 295, -9053.43, 434.807, 93.0568, 0.523262, 360, 0, 0, 15000, 1528, 0, 0),
(300358, 99120, 0, 1, 1, 0, 295, -9058.22, 444.069, 93.0568, 0.778516, 360, 0, 0, 15000, 1528, 0, 0),
(300359, 99120, 0, 1, 1, 0, 295, -9022.37, 460.344, 94.5071, 0.817786, 360, 0, 0, 15000, 1528, 0, 0),
(300360, 99120, 0, 1, 1, 0, 295, -9017.1, 472.315, 95.7811, 0.668561, 360, 0, 0, 15000, 1528, 0, 0),
(300361, 99120, 0, 1, 1, 0, 295, -8992.48, 484.123, 96.8625, 0.629291, 360, 0, 0, 15000, 1528, 0, 0),
(300362, 99120, 0, 1, 1, 0, 295, -8995.3, 487.855, 96.6219, 0.648926, 360, 0, 0, 15000, 1528, 0, 0),
(300363, 99120, 0, 1, 1, 0, 295, -8997.1, 490.569, 96.6219, 0.660707, 360, 0, 0, 15000, 1528, 0, 0),
(300364, 99120, 0, 1, 1, 0, 295, -8996.11, 495.053, 96.8288, 0.495773, 360, 0, 0, 15000, 1528, 0, 0),
(300365, 99120, 0, 1, 1, 0, 295, -8980.6, 495.286, 96.4539, 0.707831, 360, 0, 0, 15000, 1528, 0, 0),
(300366, 99120, 0, 1, 1, 0, 295, -8984.94, 500.426, 96.4552, 0.935596, 360, 0, 0, 15000, 1528, 0, 0),
(300367, 99120, 0, 1, 1, 0, 295, -8963.41, 507.422, 96.5925, 0.86491, 360, 0, 0, 15000, 1528, 0, 0),
(300368, 99120, 0, 1, 1, 0, 295, -8966.54, 518.148, 96.5972, 0.138417, 360, 0, 0, 15000, 1528, 0, 0),
(300369, 99120, 0, 1, 1, 0, 295, -8951.83, 505.532, 96.5116, 1.76419, 360, 0, 0, 15000, 1528, 0, 0),
(300370, 99120, 0, 1, 1, 0, 295, -8918.04, 503.658, 93.8919, 1.26861, 360, 0, 0, 15000, 1528, 0, 0),
(300371, 99120, 0, 1, 1, 0, 295, -8911.91, 503.153, 93.8617, 1.76341, 360, 0, 0, 15000, 1528, 0, 0),
(300372, 99120, 0, 1, 1, 0, 295, -8917.9, 506.266, 93.8878, 0.839782, 360, 0, 0, 15000, 1528, 0, 0),
(300373, 99120, 0, 1, 1, 0, 295, -8928.2, 533.777, 94.5112, 0.878266, 360, 0, 0, 15000, 1528, 0, 0),
(300374, 99120, 0, 1, 1, 0, 295, -8930.76, 538.428, 94.3461, 0.784018, 360, 0, 0, 15000, 1528, 0, 0),
(300375, 99120, 0, 1, 1, 0, 295, -8933.32, 541.132, 94.3466, 0.674062, 360, 0, 0, 15000, 1528, 0, 0),
(300376, 99120, 0, 1, 1, 0, 295, -8929.77, 539.989, 94.3274, 0.760456, 360, 0, 0, 15000, 1528, 0, 0),
(300377, 99120, 0, 1, 1, 0, 295, -8937.6, 547.604, 94.3584, 1.6833, 360, 0, 0, 15000, 1528, 0, 0),
(300378, 99120, 0, 1, 1, 0, 295, -8941.31, 550.039, 94.4318, 0.823288, 360, 0, 0, 15000, 1528, 0, 0),
(300379, 99120, 0, 1, 1, 0, 295, -8910.86, 560.089, 93.4845, 0.662279, 360, 0, 0, 15000, 1528, 0, 0),
(300380, 99120, 0, 1, 1, 0, 295, -8909.06, 557.946, 93.4809, 0.709403, 360, 0, 0, 15000, 1528, 0, 0),
(300381, 99120, 0, 1, 1, 0, 295, -8906, 554.76, 93.4574, 0.811505, 360, 0, 0, 15000, 1528, 0, 0),
(300382, 99120, 0, 1, 1, 0, 295, -8898.74, 558.159, 93.058, 1.56156, 360, 0, 0, 15000, 1528, 0, 0),
(300383, 99120, 0, 1, 1, 0, 295, -8884.16, 571.369, 92.7412, 5.60558, 360, 0, 0, 15000, 1528, 0, 0),
(300384, 99120, 0, 1, 1, 0, 295, -8888.42, 578.304, 92.8221, 0.815434, 360, 0, 0, 15000, 1528, 0, 0),
(300385, 99120, 0, 1, 1, 0, 295, -8868.02, 580.915, 93.2273, 0.591596, 360, 0, 0, 15000, 1528, 0, 0),
(300386, 99120, 0, 1, 1, 0, 295, -8872.68, 589.225, 92.6374, 1.27097, 360, 0, 0, 15000, 1528, 0, 0),
(300387, 99120, 0, 1, 1, 0, 295, -8863.11, 603.868, 92.3374, 0.422735, 360, 0, 0, 15000, 1528, 0, 0),
(300388, 99120, 0, 1, 1, 0, 295, -8841.37, 607.345, 93.0258, 0.623012, 360, 0, 0, 15000, 1528, 0, 0),
(300389, 99120, 0, 1, 1, 0, 295, -8844.96, 614.52, 92.94, 0.74789, 360, 0, 0, 15000, 1528, 0, 0),
(300390, 99120, 0, 1, 1, 0, 295, -8835.22, 627.651, 93.9447, 0.200467, 360, 0, 0, 15000, 1528, 0, 0),
(300391, 99120, 0, 1, 1, 0, 295, -8828.38, 625.176, 93.9011, 0.631651, 360, 0, 0, 15000, 1528, 0, 0),
(300392, 99120, 0, 1, 1, 0, 295, -8819.73, 616.19, 94.8804, 1.73121, 360, 0, 0, 15000, 1528, 0, 0),
(300393, 99120, 0, 1, 1, 0, 295, -8811.27, 625.938, 94.2288, 1.83959, 360, 0, 0, 15000, 1528, 0, 0),
(300394, 99120, 0, 1, 1, 0, 295, -8817.1, 643.768, 94.2288, 3.54077, 360, 0, 0, 15000, 1528, 0, 0),
(300395, 99120, 0, 1, 1, 0, 295, -8849.91, 643.25, 96.4629, 3.11665, 360, 0, 0, 15000, 1528, 0, 0),
(300396, 99120, 0, 1, 1, 0, 295, -8878.26, 647.276, 96.0257, 3.77639, 360, 0, 0, 15000, 1528, 0, 0),
(300397, 99120, 0, 1, 1, 0, 295, -8873.58, 642.201, 96.0818, 3.62716, 360, 0, 0, 15000, 1528, 0, 0),
(300398, 99120, 0, 1, 1, 0, 295, -8848.07, 663.816, 97.45, 4.49031, 360, 0, 0, 15000, 1528, 0, 0),
(300399, 99120, 0, 1, 1, 0, 295, -8832.94, 640.486, 94.6362, 5.96215, 360, 0, 0, 15000, 1528, 0, 0),
(300400, 99120, 0, 1, 1, 0, 295, -8826.41, 644.086, 94.3909, 5.4595, 360, 0, 0, 15000, 1528, 0, 0),
(300401, 99120, 0, 1, 1, 0, 295, -8817.09, 640.635, 94.2289, 3.30201, 360, 0, 0, 15000, 1528, 0, 0),
(300402, 99120, 0, 1, 1, 0, 295, -8809.63, 629.125, 94.2289, 2.95251, 360, 0, 0, 15000, 1528, 0, 0),
(300403, 99120, 0, 1, 1, 0, 295, -8807.71, 598.436, 96.8028, 4.5076, 360, 0, 0, 15000, 1528, 0, 0),
(300404, 99120, 0, 1, 1, 0, 295, -8814.28, 584.577, 96.1133, 4.44476, 360, 0, 0, 15000, 1528, 0, 0),
(300405, 99120, 0, 1, 1, 0, 295, -8836.13, 547.055, 96.6393, 0.766733, 360, 0, 0, 15000, 1528, 0, 0),
(300406, 99120, 0, 1, 1, 0, 295, -8853.63, 533.833, 105.921, 1.72021, 360, 0, 0, 15000, 1528, 0, 0),
(300407, 99120, 0, 1, 1, 0, 295, -8849.28, 498.711, 109.605, 5.53488, 360, 0, 0, 15000, 1528, 0, 0),
(300408, 99120, 0, 1, 1, 0, 295, -8851.46, 494.895, 109.598, 6.13571, 360, 0, 0, 15000, 1528, 0, 0),
(300409, 99120, 0, 1, 1, 0, 295, -8817.12, 580.331, 95.2115, 0.590794, 360, 0, 0, 15000, 1528, 0, 0),
(300410, 99120, 0, 1, 1, 0, 295, -8774.08, 602.785, 97.1567, 0.457276, 360, 0, 0, 15000, 1528, 0, 0),
(300411, 99120, 0, 1, 1, 0, 295, -8770.92, 610.331, 97.3196, 5.73908, 360, 0, 0, 15000, 1528, 0, 0),
(300412, 99120, 0, 1, 1, 0, 295, -8756.31, 630.079, 102.484, 2.14118, 360, 0, 0, 15000, 1528, 0, 0),
(300413, 99120, 0, 1, 1, 0, 295, -8764.85, 679.755, 101.987, 0.699975, 360, 0, 0, 15000, 1528, 0, 0),
(300414, 99120, 0, 1, 1, 0, 295, -8762.9, 677.428, 101.978, 0.696048, 360, 0, 0, 15000, 1528, 0, 0),
(300415, 99120, 0, 1, 1, 0, 295, -8722.76, 677.019, 99.2806, 5.34247, 360, 0, 0, 15000, 1528, 0, 0),
(300416, 99120, 0, 1, 1, 0, 295, -8708.59, 634.184, 100.384, 4.77462, 360, 0, 0, 15000, 1528, 0, 0),
(300417, 99120, 0, 1, 1, 0, 295, -8707.28, 613.225, 100.392, 4.77462, 360, 0, 0, 15000, 1528, 0, 0),
(300418, 99120, 0, 1, 1, 0, 295, -8711.04, 590.562, 98.5088, 1.83488, 360, 0, 0, 15000, 1528, 0, 0),
(300419, 99120, 0, 1, 1, 0, 295, -8747.83, 560.505, 97.4025, 5.52624, 360, 0, 0, 15000, 1528, 0, 0),
(300420, 99120, 0, 1, 1, 0, 295, -8749.34, 558.722, 97.3999, 5.593, 360, 0, 0, 15000, 1528, 0, 0),
(300421, 99120, 0, 1, 1, 0, 295, -8749.88, 563.253, 97.3964, 5.46341, 360, 0, 0, 15000, 1528, 0, 0),
(300422, 99120, 0, 1, 1, 0, 295, -8770.59, 533.966, 97.395, 3.88477, 360, 0, 0, 15000, 1528, 0, 0),
(300423, 99120, 0, 1, 1, 0, 295, -8745.15, 708.131, 98.3188, 0.713327, 360, 0, 0, 15000, 1528, 0, 0),
(300424, 99120, 0, 1, 1, 0, 295, -8747.46, 710.747, 98.1178, 0.854699, 360, 0, 0, 15000, 1528, 0, 0),
(300425, 99120, 0, 1, 1, 0, 295, -8768.79, 735.669, 99.2247, 2.51189, 360, 0, 0, 15000, 1528, 0, 0),
(300426, 99120, 0, 1, 1, 0, 295, -8792.73, 764.872, 96.3384, 4.05127, 360, 0, 0, 15000, 1528, 0, 0),
(300427, 99120, 0, 1, 1, 0, 295, -8829.83, 729.855, 98.2912, 3.67428, 360, 0, 0, 15000, 1528, 0, 0),
(300428, 99120, 0, 1, 1, 0, 295, -8839.02, 724.857, 97.4131, 2.95878, 360, 0, 0, 15000, 1528, 0, 0),
(300429, 99120, 0, 1, 1, 0, 295, -8842.42, 720.453, 97.4417, 2.14197, 360, 0, 0, 15000, 1528, 0, 0),
(300430, 99120, 0, 1, 1, 0, 295, -8849.91, 717.492, 97.39, 1.78854, 360, 0, 0, 15000, 1528, 0, 0),
(300431, 99120, 0, 1, 1, 0, 295, -8835.11, 703.609, 97.6244, 5.28356, 360, 0, 0, 15000, 1528, 0, 0),
(300432, 99120, 0, 1, 1, 0, 295, -8835.3, 697.276, 97.5597, 1.77361, 360, 0, 0, 15000, 1528, 0, 0),
(300433, 99120, 0, 1, 1, 0, 295, -8827.99, 678.663, 97.3944, 3.94132, 360, 0, 0, 15000, 1528, 0, 0),
(300434, 99120, 0, 1, 1, 0, 295, -8850.34, 665.082, 97.3901, 4.5932, 360, 0, 0, 15000, 1528, 0, 0),
(300435, 68, 0, 1, 1, 0, 3, -9138.78, 344.878, 92.0939, 5.64563, 360, 0, 0, 795, 0, 0, 2),
(300436, 68, 0, 1, 1, 0, 3, -9137.49, 346.517, 92.3457, 5.5828, 360, 0, 0, 795, 0, 0, 2),
(300437, 68, 0, 1, 1, 0, 3, -9136.08, 348.076, 92.5661, 5.5396, 360, 0, 0, 795, 0, 0, 2),
(300438, 68, 0, 1, 1, 0, 3, -9138.41, 350.304, 92.0153, 5.51997, 360, 0, 0, 795, 0, 0, 2),
(300439, 68, 0, 1, 1, 0, 3, -9139.96, 348.25, 91.7721, 5.63778, 360, 0, 0, 795, 0, 0, 2),
(300440, 68, 0, 1, 1, 0, 3, -9141.06, 346.743, 91.5724, 5.626, 360, 0, 0, 795, 0, 0, 2),
(300441, 68, 0, 1, 1, 0, 3, -9138.78, 344.878, 92.0939, 5.64563, 360, 0, 0, 795, 0, 0, 0),
(300442, 68, 0, 1, 1, 0, 3, -9137.49, 346.517, 92.3457, 5.5828, 360, 0, 0, 795, 0, 0, 0),
(300443, 68, 0, 1, 1, 0, 3, -9111.58, 328.35, 93.2132, 5.67154, 360, 0, 0, 795, 0, 0, 0),
(300444, 68, 0, 1, 1, 0, 3, -9136.08, 348.076, 92.5661, 5.5396, 360, 0, 0, 795, 0, 0, 0),
(300445, 68, 0, 1, 1, 0, 3, -9138.41, 350.304, 92.0153, 5.51997, 360, 0, 0, 795, 0, 0, 0),
(300446, 68, 0, 1, 1, 0, 3, -9139.96, 348.25, 91.7721, 5.63778, 360, 0, 0, 795, 0, 0, 0),
(300447, 68, 0, 1, 1, 0, 3, -9141.06, 346.743, 91.5724, 5.626, 360, 0, 0, 795, 0, 0, 0),
(300448, 68, 0, 1, 1, 0, 3, -9114.39, 326.992, 93.1497, 2.44906, 360, 0, 0, 795, 0, 0, 0);

UPDATE `game_event` SET `entry` = 109,`start_time` = '2007-06-03 00:00:05',`end_time` = '2020-12-31 00:00:00',`occurence` = 5760,`length` = 60,`holiday` = 0,
`description` = '[Stormwind] Death Legion Attack - Guards Defend (60 level)' WHERE `entry` = 109;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(302688, 1976, 0, 1, 1, 0, 0, -9068.44, 425.014, 93.0568, 4.03626, 360, 0, 0, 495, 0, 0, 0),
(302689, 1976, 0, 1, 1, 0, 0, -9043.08, 450.028, 93.0563, 0.238077, 360, 0, 0, 495, 0, 0, 0),
(302690, 1976, 0, 1, 1, 0, 0, -8949.84, 519.985, 96.3574, 3.92081, 360, 0, 0, 495, 0, 0, 0);

UPDATE `game_event` SET `entry` = 108,`start_time` = '2007-06-03 23:59:59',`end_time` = '2020-12-31 00:00:00',`occurence` = 5760,`length` = 60,`holiday` = 0,
`description` = '[Stormwind] Death Legion Attack - Undead Attack (60 level)' WHERE `entry` = 108;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(302669, 880003, 0, 1, 1, 0, 0, -9093.01, 405.788, 92.3606, 0.425684, 360, 0, 0, 15000, 0, 0, 2),
(302670, 880003, 0, 1, 1, 0, 0, -9094.18, 407.142, 92.3492, 0.714711, 360, 0, 0, 15000, 0, 0, 2),
(302671, 880003, 0, 1, 1, 0, 0, -9052.48, 473.881, 87.2364, 5.31086, 360, 0, 0, 15000, 0, 0, 2),
(302673, 880003, 0, 1, 1, 0, 0, -9021.3, 430.265, 84.4179, 2.16142, 360, 0, 0, 15000, 0, 0, 0),
(302675, 880003, 0, 1, 1, 0, 0, -9003.09, 478.779, 96.5607, 0.698415, 360, 0, 0, 15000, 0, 0, 2),
(302676, 880004, 0, 1, 1, 0, 0, -9005.35, 487.914, 96.8458, 0.720212, 360, 0, 0, 13000, 0, 0, 0),
(302677, 880004, 0, 1, 1, 0, 0, -8997.73, 479.227, 96.8518, 0.720212, 360, 0, 0, 13000, 0, 0, 2),
(302678, 880003, 0, 1, 1, 0, 0, -8913.84, 553.59, 93.8616, 0.656788, 360, 0, 0, 15000, 0, 0, 0),
(302679, 880005, 0, 1, 1, 0, 0, -8893.16, 596.046, 94.758, 5.32686, 360, 0, 0, 14000, 5200, 0, 2),
(302681, 880003, 0, 1, 1, 0, 0, -8856.93, 642.095, 96.4466, 3.28875, 360, 0, 0, 15000, 0, 0, 0),
(302682, 880003, 0, 1, 1, 0, 0, -8853.53, 653.296, 96.428, 5.81538, 360, 0, 0, 15000, 0, 0, 0),
(302683, 880005, 0, 1, 1, 0, 0, -8793.24, 614.458, 96.7746, 5.0182, 360, 0, 0, 14000, 5200, 0, 2),
(302684, 880003, 0, 1, 1, 0, 0, -8838.28, 613.426, 93.0426, 3.91, 360, 0, 0, 15000, 0, 0, 0),
(302685, 880003, 0, 1, 1, 0, 0, -8875.39, 593.084, 92.8525, 2.69263, 360, 0, 0, 15000, 0, 0, 2),
(302686, 880004, 0, 1, 1, 0, 0, -8902.07, 561.182, 93.0536, 1.00148, 360, 0, 0, 13000, 0, 0, 0),
(302687, 880005, 0, 1, 1, 0, 0, -8899.66, 560.295, 92.9824, 1.02112, 360, 0, 0, 14000, 5200, 0, 2),
(302692, 880004, 0, 1, 1, 0, 0, -8926.68, 491.201, 93.8455, 4.61904, 360, 0, 0, 13000, 0, 0, 0),
(302693, 880004, 0, 1, 1, 0, 0, -8914.72, 521.28, 93.8175, 0.962223, 360, 0, 0, 13000, 0, 0, 2),
(302694, 880005, 0, 1, 1, 0, 0, -8933.65, 551.431, 94.4118, 2.18273, 360, 0, 0, 14000, 5200, 0, 2);
