INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `trash`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `RacialLeader`, `equipment_id`, `ScriptName`) VALUES (880003, 17213, 0, 17213, 0, 'Draenei warrior', 'Assault band', 60, 70, 12000, 15000, 100, 100, 1, 1802, 0, 0, 1.2, 1, 450, 550, 0, 260, 1420, 1520, 1, 0, 0, 0, 0, 0, 0, 214, 288, 200, 7, 0, 72, 666557, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 'mob_blacktemple'), (880004, 17214, 0, 17214, 0, 'Draenei warrior', 'Assault band', 60, 70, 12000, 15000, 100, 100, 1, 1802, 0, 0, 1.2, 1, 450, 550, 0, 260, 1420, 1520, 1, 0, 0, 0, 0, 0, 0, 214, 288, 200, 7, 0, 72, 666557, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 'mob_blacktemple'); INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES (260, '2007-11-11 20:00:00', '2020-12-31 00:00:00', 1440, 10, 'Gate of Orgrimmar under attack'), (261, '2007-11-11 20:10:00', '2020-12-31 00:00:00', 1440, 60, 'Gate of Orgrimmar has been seized'), (262, '2007-11-11 20:10:00', '2020-12-31 00:00:00', 1440, 30, 'Orgrimmar under attack'), (263, '2007-11-11 21:10:00', '2020-12-31 00:00:00', 1440, 30, 'Orgrimmar has been occupied'); INSERT INTO `game_event_creature` VALUES (100926,260), (125721,260), (125766,260), (125722,260), (125767,260), (100918,260), (100919,260), (100920,260), (100921,260), (100922,260), (100925,260), (100927,260), (100928,260), (100929,260), (100930,260), (125723,260), (125768,260), (125724,260), (125769,260), (24634,-261), (24635,-261), (24636,-261), (24637,-261), (24638,-261), (30403,-261), (125725,261), (125726,261), (125770,261), (125771,261), (125727,261), (125728,261), (125729,261), (125730,261), (125731,261), (125732,261), (125733,261), (101041,262), (125772,262), (125734,262), (125773,262), (125735,262), (125774,262), (125736,262), (125775,262), (125737,262), (100989,262), (100990,262), (100991,262), (100992,262), (100993,262), (100994,262), (125738,262), (125776,262), (125739,262), (125777,262), (125740,262), (125778,262), (125741,262), (101014,262), (101015,262), (101016,262), (101018,262), (101019,262), (101020,262), (101021,262), (101022,262), (101024,262), (101025,262), (101029,262), (125779,262), (101031,262), (101033,262), (125742,262), (101037,262), (101038,262), (101039,262), (101040,262), (101023,262), (101017,262), (101042,262), (125753,263), (24639,-263), (24640,-263), (24641,-263), (24642,-263), (24643,-263), (24644,-263), (24645,-263), (24648,-263), (24649,-263), (24651,-263), (24652,-263), (24653,-263), (24655,-263), (24656,-263), (24659,-263), (24661,-263), (24662,-263), (24665,-263), (24666,-263), (24676,-263), (25068,-263), (25069,-263), (25070,-263), (25071,-263), (25072,-263), (25075,-263), (25076,-263), (25077,-263), (25078,-263), (25079,-263), (25080,-263), (25081,-263), (25127,-263), (34123,-263), (37701,-263), (37707,-263), (37709,-263), (37712,-263), (37713,-263), (37714,-263), (37716,-263), (37717,-263), (38205,-263), (40512,-263), (41796,-263), (45518,-263), (45575,-263), (47262,-263), (48197,-263), (53759,-263), (53976,-263), (53977,-263), (54002,-263), (54245,-263), (54742,-263), (86358,-263), (125780,263), (125781,263), (125743,263), (125744,263), (125782,263), (125745,263), (125746,263), (125783,263), (125747,263), (125784,263), (125785,263), (125748,263), (125749,263), (125750,263), (125787,263), (125751,263), (125752,263), (125754,263), (125755,263), (125756,263), (125786,263), (125788,263), (125789,263), (125757,263), (125758,263), (125759,263), (125760,263), (125790,263), (125791,263), (125761,263), (125762,263), (125792,263), (125763,263), (125793,263), (125764,263), (125765,263), (125794,263); INSERT INTO `creature` (`guid` ,`id` ,`map` ,`modelid` ,`equipment_id` ,`position_x` ,`position_y` ,`position_z` ,`orientation` ,`spawntimesecs` ,`spawndist` ,`currentwaypoint` ,`trash1` ,`trash2` ,`trash3` ,`trash4` ,`curhealth` ,`curmana` ,`DeathState` ,`MovementType` ) VALUES (125721, 880003, 1, 0, 0, 1366, -4358.3, 26.3599, 0.0470645, 25, 0, 0, 1366, -4358.3, 26.3599, 0, 91000, 100, 0, 2), (125722, 880003, 1, 0, 0, 1379.57, -4375.71, 26.0229, 3.26946, 25, 0, 0, 1379.57, -4375.71, 26.0229, 3.26946, 91000, 100, 0, 2), (125723, 880003, 1, 0, 0, 1380.11, -4362.78, 26.0468, 0.325771, 25, 0, 0, 1380.11, -4362.78, 26.0468, 0, 95000, 100, 0, 0), (125724, 880003, 1, 0, 0, 1383.8, -4376.85, 26.0231, 0.585738, 25, 0, 0, 1383.8, -4376.85, 26.0231, 0, 93000, 100, 0, 0), (125725, 880003, 1, 0, 0, 1384.39, -4358.51, 27.0153, 3.18857, 25, 0, 0, 1384.39, -4358.51, 27.0153, 0, 90000, 100, 0, 0), (125726, 880003, 1, 0, 0, 1387.28, -4378.89, 27.0149, 3.20035, 25, 0, 0, 1387.28, -4378.89, 27.0149, 0, 94000, 100, 0, 0), (125727, 880003, 1, 0, 0, 1416.26, -4364.77, 25.2364, 3.22156, 25, 0, 0, 1416.26, -4364.77, 25.2364, 0, 96999, 100, 0, 0), (125728, 880003, 1, 0, 0, 1448.4, -4414.67, 25.2364, 4.75701, 25, 0, 0, 1448.4, -4414.67, 25.2364, 0, 96999, 100, 0, 0), (125729, 880003, 1, 0, 0, 1455.52, -4413.89, 25.2364, 4.81591, 25, 0, 0, 1455.52, -4413.89, 25.2364, 0, 92000, 100, 0, 0), (125730, 880003, 1, 0, 0, 1464.77, -4413, 25.2364, 4.80806, 25, 0, 0, 1464.77, -4413, 25.2364, 0, 95000, 100, 0, 0), (125731, 880003, 1, 0, 0, 1465.54, -4425.9, 25.2364, 1.65861, 25, 0, 0, 1465.54, -4425.9, 25.2364, 0, 95000, 100, 0, 0), (125732, 880003, 1, 0, 0, 1460.45, -4426.85, 25.2364, 1.70181, 25, 0, 0, 1460.45, -4426.85, 25.2364, 0, 92000, 100, 0, 0), (125733, 880003, 1, 0, 0, 1449.39, -4428.19, 25.2364, 1.51724, 25, 0, 0, 1449.39, -4428.19, 25.2364, 0, 98000, 100, 0, 0), (125734, 880003, 1, 0, 0, 1542.05, -4437.69, 11.8115, 1.01614, 25, 0, 0, 1542.05, -4437.69, 11.8115, 0, 95000, 100, 0, 2), (125735, 880003, 1, 0, 0, 1548.36, -4427.51, 10.035, 1.01614, 25, 0, 0, 1548.36, -4427.51, 10.035, 0, 98000, 100, 0, 2), (125736, 880003, 1, 0, 0, 1552.6, -4420.66, 8.93137, 1.01614, 25, 0, 0, 1552.6, -4420.66, 8.93137, 0, 98999, 100, 0, 2), (125737, 880003, 1, 0, 0, 1556.84, -4413.82, 8.14013, 1.01614, 25, 0, 0, 1556.84, -4413.82, 8.14013, 0, 95000, 100, 0, 2), (125738, 880003, 1, 0, 0, 1560.39, -4373.82, 2.14466, 1.49456, 25, 0, 0, 1560.39, -4373.82, 2.14466, 1.49456, 98000, 100, 0, 0), (125739, 880003, 1, 0, 0, 1576.51, -4416.27, 7.24133, 0.226807, 25, 0, 0, 1576.51, -4416.27, 7.24133, 0, 98999, 100, 0, 0), (125740, 880003, 1, 0, 0, 1598.46, -4390.53, 9.86482, 3.69041, 25, 0, 0, 1598.46, -4390.53, 9.86482, 0, 91000, 100, 0, 0), (125741, 880003, 1, 0, 0, 1553.27, -4330.44, 20.2577, 1.20698, 25, 0, 0, 1553.27, -4330.44, 20.2577, 0, 100000, 100, 0, 0), (125742, 880003, 1, 0, 0, 1525.2, -4391.24, 15.4867, 4.61729, 25, 0, 0, 1525.2, -4391.24, 15.4867, 4.61729, 100000, 100, 0, 2), (125743, 880003, 1, 0, 0, 1526.11, -4438.99, 16.5215, 2.49046, 25, 0, 0, 1526.11, -4438.99, 16.5215, 0, 92000, 100, 0, 0), (125744, 880003, 1, 0, 0, 1531.26, -4429.01, 13.1987, 2.34123, 25, 0, 0, 1531.26, -4429.01, 13.1987, 0, 98999, 100, 0, 0), (125745, 880003, 1, 0, 0, 1534.2, -4414.3, 11.6328, 2.9185, 25, 0, 0, 1534.2, -4414.3, 11.6328, 0, 98000, 100, 0, 0), (125746, 880003, 1, 0, 0, 1533.36, -4398.88, 13.4535, 3.7471, 25, 0, 0, 1533.36, -4398.88, 13.4535, 0, 96999, 100, 0, 0), (125747, 880003, 1, 0, 0, 1545.45, -4446.58, 12.0398, 1.21733, 25, 0, 0, 1545.45, -4446.58, 12.0398, 0, 96000, 100, 0, 0), (125748, 880003, 1, 0, 0, 1586.16, -4419.66, 8.41743, 3.65992, 25, 0, 0, 1586.16, -4419.66, 8.41743, 0, 96000, 100, 0, 0), (125749, 880003, 1, 0, 0, 1586.13, -4462.37, 7.87848, 2.31688, 25, 0, 0, 1586.13, -4462.37, 7.87848, 0, 95000, 100, 0, 0), (125750, 880003, 1, 0, 0, 1632.36, -4440.34, 15.5029, 2.59177, 25, 0, 0, 1632.36, -4440.34, 15.5029, 0, 94000, 100, 0, 0), (125751, 880003, 1, 0, 0, 1670.94, -4433.54, 19.3689, 2.16766, 25, 0, 0, 1670.94, -4433.54, 19.3689, 0, 90000, 100, 0, 0), (125752, 880003, 1, 0, 0, 1682.95, -4415.49, 21.7878, 3.22402, 25, 0, 0, 1682.95, -4415.49, 21.7878, 0, 98999, 100, 0, 0), (125753, 880003, 1, 0, 0, 1739.06, -4320.83, 33.4862, 3.82878, 25, 0, 0, 1739.06, -4320.83, 33.4862, 0, 93000, 100, 0, 0), (125754, 880003, 1, 0, 0, 1697.92, -4278.75, 33.3578, 3.817, 25, 0, 0, 1697.92, -4278.75, 33.3578, 0, 98999, 100, 0, 0), (125755, 880003, 1, 0, 0, 1674.72, -4265.36, 33.0909, 4.65737, 25, 0, 0, 1674.72, -4265.36, 33.0909, 0, 95000, 100, 0, 0), (125756, 880003, 1, 0, 0, 1586.22, -4309.86, 20.3307, 3.80129, 25, 0, 0, 1586.22, -4309.86, 20.3307, 0, 96999, 100, 0, 0), (125757, 880003, 1, 0, 0, 1616.23, -4374.88, 12.2962, 4.38248, 25, 0, 0, 1616.23, -4374.88, 12.2962, 0, 90000, 100, 0, 0), (125758, 880003, 1, 0, 0, 1599.66, -4448.38, 7.63953, 1.74746, 25, 0, 0, 1599.66, -4448.38, 7.63953, 0, 95000, 100, 0, 0), (125759, 880003, 1, 0, 0, 1736.58, -4405.21, 37.2772, 2.10089, 25, 0, 0, 1736.58, -4405.21, 37.2772, 0, 92000, 100, 0, 0), (125760, 880003, 1, 0, 0, 1728.14, -4410.49, 37.1574, 2.17158, 25, 0, 0, 1728.14, -4410.49, 37.1574, 0, 92000, 100, 0, 0), (125761, 880003, 1, 0, 0, 1671.37, -4278.37, 50.9627, 1.46786, 25, 0, 0, 1671.37, -4278.37, 50.9627, 0, 91000, 100, 0, 0), (125762, 880003, 1, 0, 0, 1664.7, -4329.77, 61.2465, 5.74043, 25, 0, 0, 1664.7, -4329.77, 61.2465, 0, 91000, 100, 0, 0), (125763, 880003, 1, 0, 0, 1667.74, -4343.6, 32.3208, 3.94657, 25, 0, 0, 1667.74, -4343.6, 32.3208, 0, 95000, 100, 0, 0), (125764, 880003, 1, 0, 0, 1629.1, -4414.5, 15.9385, 6.15746, 25, 0, 0, 1629.1, -4414.5, 15.9385, 0, 91000, 100, 0, 0), (125765, 880003, 1, 0, 0, 1524.21, -4355.85, 18.8951, 6.15746, 25, 0, 0, 1524.21, -4355.85, 18.8951, 0, 96999, 100, 0, 0), (125766, 880004, 1, 0, 0, 1366.45, -4359.91, 26.2418, 0.325881, 25, 0, 0, 1366.45, -4359.91, 26.2418, 0, 94000, 100, 0, 2), (125767, 880004, 1, 0, 0, 1366.41, -4381.94, 26.0855, 0.286612, 25, 0, 0, 1366.41, -4381.94, 26.0855, 0, 94000, 100, 0, 2), (125768, 880004, 1, 0, 0, 1380.75, -4364.66, 26.0355, 0.329698, 25, 0, 0, 1380.75, -4364.66, 26.0355, 0, 100000, 100, 0, 0), (125769, 880004, 1, 0, 0, 1383.67, -4373.75, 26.0231, 1.61068, 25, 0, 0, 1383.67, -4373.75, 26.0231, 0, 98000, 100, 0, 0), (125770, 880004, 1, 0, 0, 1417.47, -4359.21, 25.2364, 3.24748, 25, 0, 0, 1417.47, -4359.21, 25.2364, 0, 98000, 100, 0, 0), (125771, 880004, 1, 0, 0, 1419.24, -4371.97, 25.2364, 3.2357, 25, 0, 0, 1419.24, -4371.97, 25.2364, 0, 92000, 100, 0, 0), (125772, 880004, 1, 0, 0, 1519.33, -4423.56, 17.9607, 4.62661, 25, 0, 0, 1519.33, -4423.56, 17.9607, 0, 96000, 100, 0, 2), (125773, 880004, 1, 0, 0, 1543.85, -4434.79, 11.3387, 1.01614, 25, 0, 0, 1543.85, -4434.79, 11.3387, 0, 94000, 100, 0, 2), (125774, 880004, 1, 0, 0, 1550.48, -4424.09, 9.51217, 1.01614, 25, 0, 0, 1550.48, -4424.09, 9.51217, 0, 94000, 100, 0, 2), (125775, 880004, 1, 0, 0, 1554.72, -4417.24, 8.48301, 1.01614, 25, 0, 0, 1554.72, -4417.24, 8.48301, 0, 96000, 100, 0, 2), (125776, 880004, 1, 0, 0, 1565.05, -4403.35, 7.25231, 0.073654, 25, 0, 0, 1565.05, -4403.35, 7.25231, 0, 96000, 100, 0, 0), (125777, 880004, 1, 0, 0, 1593.77, -4444.71, 6.15911, 5.5361, 25, 0, 0, 1593.77, -4444.71, 6.15911, 0, 96000, 100, 0, 0), (125778, 880004, 1, 0, 0, 1564.33, -4404.42, 7.01041, 1.1575, 25, 0, 0, 1564.33, -4404.42, 7.01041, 0, 92000, 100, 0, 0), (125779, 880004, 1, 0, 0, 1526.85, -4410.71, 13.7856, 4.96601, 25, 0, 0, 1526.85, -4410.71, 13.7856, 4.96601, 98000, 100, 0, 2), (125780, 880004, 1, 0, 0, 1527.02, -4394.42, 14.5812, 3.7683, 25, 0, 0, 1527.02, -4394.42, 14.5812, 0, 94000, 100, 0, 0), (125781, 880004, 1, 0, 0, 1534.45, -4406.48, 12.2262, 3.32848, 25, 0, 0, 1534.45, -4406.48, 12.2262, 0, 98000, 100, 0, 0), (125782, 880004, 1, 0, 0, 1533.51, -4421.87, 12.4441, 2.60041, 25, 0, 0, 1533.51, -4421.87, 12.4441, 0, 98000, 100, 0, 0), (125783, 880004, 1, 0, 0, 1523.12, -4384.89, 17.4747, 4.23954, 25, 0, 0, 1523.12, -4384.89, 17.4747, 0, 98000, 100, 0, 0), (125784, 880004, 1, 0, 0, 1565.33, -4430.25, 7.03683, 2.80776, 25, 0, 0, 1565.33, -4430.25, 7.03683, 0, 90000, 100, 0, 0), (125785, 880004, 1, 0, 0, 1565.95, -4428.23, 7.05285, 2.89415, 25, 0, 0, 1565.95, -4428.23, 7.05285, 0, 90000, 100, 0, 0), (125786, 880004, 1, 0, 0, 1546.5, -4323.82, 21.6576, 4.70057, 25, 0, 0, 1546.5, -4323.82, 21.6576, 0, 96000, 100, 0, 0), (125787, 880004, 1, 0, 0, 1565.11, -4377.14, 1.79474, 4.55527, 25, 0, 0, 1565.11, -4377.14, 1.79474, 0, 98000, 100, 0, 0), (125788, 880004, 1, 0, 0, 1621.98, -4341.91, 4.62514, 2.70801, 25, 0, 0, 1621.98, -4341.91, 4.62514, 0, 98000, 100, 0, 0), (125789, 880004, 1, 0, 0, 1620.98, -4384.05, 12.2994, 2.55093, 25, 0, 0, 1620.98, -4384.05, 12.2994, 0, 96000, 100, 0, 0), (125790, 880004, 1, 0, 0, 1732.11, -4406.46, 36.1967, 2.11739, 25, 0, 0, 1732.11, -4406.46, 36.1967, 0, 96000, 100, 0, 0), (125791, 880004, 1, 0, 0, 1694.74, -4379.31, 24.614, 3.69211, 25, 0, 0, 1694.74, -4379.31, 24.614, 0, 90000, 100, 0, 0), (125792, 880004, 1, 0, 0, 1679.18, -4322.75, 61.2467, 4.54662, 25, 0, 0, 1679.18, -4322.75, 61.2467, 0, 94000, 100, 0, 0), (125793, 880004, 1, 0, 0, 1661.44, -4391.46, 23.1341, 4.53955, 25, 0, 0, 1661.44, -4391.46, 23.1341, 0, 94000, 100, 0, 0), (125794, 880004, 1, 0, 0, 1627, -4311.72, 3.25977, 5.44274, 25, 0, 0, 1627, -4311.72, 3.25977, 0, 96000, 100, 0, 0);