rendered paste body-- fixed in creature, creature_template, creature_movment
-- Darkspear Axe Thrower
-- Darnassian Archer
-- Fel Soldier
-- Ironforge Paladin
-- Justinius the Harbinger
-- Melgromm Highmountain
-- Stormwind Soldier
-- Undercity Mage
-- Pit Commander
-- Warth Master
-- Orgrimmat Grunt
-- Stormwind Mage
DELETE FROM creature WHERE id=18970;
DELETE FROM creature WHERE id in (321185,321186,321187,321188);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321185, 18970, 530, "-244.674", "1069.2", "54.3087", "1.59747", 180, 0, 0, "-244.674", "1069.2", "54.3087", 0, 1, 0, 0, 2, ""),
(321186, 18970, 530, "-241.763", "1069.28", "54.3087", "1.59747", 180, 0, 0, "-241.763", "1069.28", "54.3087", 0, 1, 0, 0, 2, ""),
(321187, 18970, 530, "-239.327", "1069.35", "54.3087", "1.59747", 180, 0, 0, "-239.327", "1069.35", "54.3087", 0, 1, 0, 0, 2, ""),
(321188, 18970, 530, "-236.759", "1069.41", "54.3087", "1.59747", 180, 0, 0, "-236.759", "1069.41", "54.3087", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18970;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18970, 15574, 0, "Darkspear Axe Thrower", "", 67, 68, 14000, 14000, 100, 100, 0, 1758, 0, 1, 1, 595, 831, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321185,321186,321187,321188);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321185, 1, "-244.204", "1095.37", "41.667", 0),
(321185, 2, "-245.296", "1096.4", "41.6667", 0),
(321186, 1, "-240.919", "1095.78", "41.667", 0),
(321186, 2, "-240.671", "1096.87", "41.6667", 0),
(321187, 1, "-237.615", "1096.08", "41.667", 0),
(321187, 2, "-236.758", 1096, "41.6667", 0),
(321188, 1, "-233.426", "1096.47", "41.667", 0),
(321188, 2, "-232.344", "1095.55", "41.6667", 0);
DELETE FROM creature WHERE id=18965;
DELETE FROM creature WHERE guid in (321189,321190,321191,321192);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321189, 18965, 530, "-265.795", "1070.36", "54.309", "1.55662", 180, 0, 0, "-265.795", "1070.36", "54.309", 0, 1, 0, 0, 2, ""),
(321190, 18965, 530, "-263.491", "1070.43", "54.309", "1.54876", 180, 0, 0, "-263.491", "1070.43", "54.309", 0, 1, 0, 0, 2, ""),
(321191, 18965, 530, "-261.545", "1070.39", "54.309", "1.54876", 180, 0, 0, "-261.545", "1070.39", "54.309", 0, 1, 0, 0, 2, ""),
(321192, 18965, 530, "-259.272", "1070.61", "54.309", "1.54876", 180, 0, 0, "-259.272", "1070.61", "54.309", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18965;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18965, 2306, 0, "Darnassian Archer", "", 67, 68, 13000, 14000, 100, 100, 0, 1755, 0, 1, 1, 595, 831, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321189,321190,321191,321192);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321189, 1, "-268.368", "1096.79", "41.7747", 0),
(321189, 2, "-267.659", "1096.18", "41.7506", 0),
(321189, 3, "-264.92", "1099.08", "41.6721", 0),
(321190, 1, "-265.469", "1096.98", "41.686", 0),
(321191, 1, "-262.564", "1097.17", "41.6669", 0),
(321191, 2, "-262.487", "1097.58", "41.6668", 0),
(321192, 1, "-259.113", "1097.4", "41.6669", 0),
(321192, 2, "-262.487", "1097.58", "41.6668", 0);
DELETE FROM creature WHERE id=18944;
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321193, 18944, 530, "-237.387", "1153.12", "41.6389", "4.70777", 180, 0, 0, "-237.387", "1153.12", "41.6389", 0, 140800, 0, 0, 2, ""),
(321194, 18944, 530, "-242.069", "1153.25", "41.6431", "4.68421", 180, 0, 0, "-242.069", "1153.25", "41.6431", 0, 140800, 0, 0, 2, ""),
(321195, 18944, 530, "-245.574", "1153.35", "41.6509", "4.68421", 180, 0, 0, "-245.574", "1153.35", "41.6509", 0, 140800, 0, 0, 2, ""),
(321196, 18944, 530, "-250.186", "1153.33", "41.6494", "4.68421", 180, 0, 0, "-250.186", "1153.33", "41.6494", 0, 140800, 0, 0, 2, ""),
(321197, 18944, 530, "-255.357", 1154, "41.6494", "4.68421", 180, 0, 0, "-255.357", 1154, "41.6494", 0, 140800, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18944;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18944, 18345, 0, "Fel Soldier", "", 70, 70, 88000, 88000, 100, 100, 0, 1752, 0, 1, 1, 624, 871, 0, 1, 0, 0, 0, 2, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 3, 0, 8, 28717, 0, 0, 218171394, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321193,321194,321195,321196,321197);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321193, 1, "-236.406", "1099.07", "41.6667", 0),
(321193, 2, "-237.253", "1152.32", "41.6423", 0),
(321193, 3, "-265.306", "1096.86", "41.6839", 0),
(321194, 1, "-242.023", "1104.03", "41.6667", 0),
(321194, 2, "-241.202", "1153.21", "41.6416", 0),
(321194, 3, "-263.095", "1097.25", "41.6685", 0),
(321195, 1, "-244.966", "1098.73", "41.6667", 0),
(321196, 1, "-253.352", "1098.65", "41.6667", 0),
(321196, 2, "-250.447", "1153.28", "41.6488", 0),
(321197, 1, "-263.71", "1098.52", "41.6705", 0),
(321197, 2, "-255.259", "1154.53", "41.65", 0);
DELETE FROM creature WHERE id=18986;
DELETE FROM creature WHERE guid in (321198,321199,321200);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321198, 18986, 530, "-264.533", "1068.33", "54.3091", "1.59196", 180, 0, 0, "-264.533", "1068.33", "54.3091", 0, 1, 0, 0, 2, ""),
(321199, 18986, 530, "-262.315", "1068.38", "54.3091", "1.59196", 180, 0, 0, "-262.315", "1068.38", "54.3091", 0, 1, 0, 0, 2, ""),
(321200, 18986, 530, "-260.362", "1068.42", "54.3091", "1.59196", 180, 0, 0, "-260.362", "1068.42", "54.3091", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18986;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18986, 18457, 0, "Ironforge Paladin", "", 67, 68, 2500, 4500, 29330, 29910, 0, 1755, 0, 1, 1, 595, 831, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 24919, 0, 0, 285346306, 0, 0, 273, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id IN (321198,321199,321200);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321198, 1, "-267.652", "1097.89", "41.7252", 0),
(321199, 1, "-265.246", "1100.96", "41.671", 0),
(321200, 1, "-262.147", "1101.39", "41.6668", 0);
DELETE FROM creature WHERE id=18966;
DELETE FROM creature WHERE guid=321201;
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321201, 18966, 530, "-270.142", "1072.16", "54.3076", "1.44902", 180, 0, 0, "-270.142", "1072.16", "54.3076", 0, 127399, 47325, 0, 2, "");
DELETE FROM creature_template WHERE entry=18966;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18966, 18443, 0, "Justinius the Harbinger", "", 70, 70, 98000, 98000, 47325, 47325, 0, 1755, 0, 1, 1, 624, 871, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id=321201;
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321201, 1, "-269.47", "1093.97", "41.8569", 0),
(321201, 2, "-268.687", "1095.52", "41.8192", 0);
DELETE FROM creature WHERE id=18969;
DELETE FROM creature WHERE guid=321202;
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321202, 18969, 530, "-231.485", "1071.44", "54.3083", "1.58707", 180, 0, 0, "-231.485", "1071.44", "54.3083", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18969;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18969, 18409, 0, "Melgromm Highmountain", "", 70, 70, 110000, 110000, 50250, 50250, 0, 1758, 0, 1, 1, 624, 871, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 24924, 0, 0, 285345026, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id=321202;
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321202, 1, "-235.741", "1096.32", "41.6667", 0);
DELETE FROM creature WHERE id=18945;
DELETE FROM creature WHERE guid in (321203,321204);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321203, 18945, 530, "-250.975", "1172.21", "41.5971", "4.72549", 180, 0, 0, "-250.975", "1172.21", "41.5971", 0, 41600, 330900, 0, 2, ""),
(321204, 18945, 530, "-3419.86", "2973.08", "169.9", "4.50975", 180, 0, 0, "-3419.86", "2973.08", "169.9", 0, 33799, 330900, 0, 2, "");
DELETE FROM creature_template WHERE entry=18945;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18945, 18622, 0, "Pit Commander", "", 72, 72, 230000, 260000, 330900, 330900, 0, 1752, 0, 1, 1, 643, 898, 0, 1, 0, 0, 0, 3, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 3, 0, 8, 8090, 0, 0, 218171138, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321203,321204);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321203, 1, "-251.278", "1138.88", "41.6605", 0),
(321203, 2, "-251.564", "1102.32", "41.6674", 0),
(321203, 3, "-251.62", "1095.09", "41.6667", 0),
(321203, 4, "-251.751", "1078.42", "51.6455", 0),
(321203, 5, "-251.622", "1094.94", "41.6667", 0),
(321203, 6, "-251.277", "1139.02", "41.6519", 0),
(321203, 7, "-251.01", "1173.03", "41.6121", 0),
(321204, 1, "-3422.1", "2959.81", "169.899", 0),
(321204, 2, "-3402.61", "2968.96", "169.88", 0),
(321204, 3, "-3382.64", "2998.82", "170.374", 0),
(321204, 4, "-3348.15", "2970.92", "170.155", 0),
(321204, 5, "-3352.57", "2940.92", "169.879", 0),
(321204, 6, "-3381.1", "2940.94", "169.879", 0),
(321204, 7, "-3392.5", "2943.22", "169.879", 0),
(321204, 8, "-3401.17", "2957.65", "169.879", 0),
(321204, 9, "-3398.78", "2989.28", "169.88", 0),
(321204, 10, "-3420.97", "2991.39", "169.941", 0),
(321204, 11, "-3427.01", "2973.87", "170.156", 0);
DELETE FROM creature WHERE id=18948;
DELETE FROM creature WHERE guid in (321205,321206,321207,321208,321209);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321205, 18948, 530, "-266.684", "1072.23", "54.3076", "1.6273", 180, 0, 0, "-266.684", "1072.23", "54.3076", 0, 1, 0, 0, 2, ""),
(321206, 18948, 530, "-264.451", "1072.16", "54.3076", "1.6273", 180, 0, 0, "-264.451", "1072.16", "54.3076", 0, 1, 0, 0, 2, ""),
(321207, 18948, 530, "-262.618", "1072.22", "54.3076", "1.60374", 180, 0, 0, "-262.618", "1072.22", "54.3076", 0, 1, 0, 0, 2, ""),
(321208, 18948, 530, "-260.414", "1072.3", "54.3076", "1.60374", 180, 0, 0, "-260.414", "1072.3", "54.3076", 0, 1, 0, 0, 2, ""),
(321209, 18948, 530, "-258.322", "1072.37", "54.3076", "1.60374", 180, 0, 0, "-258.322", "1072.37", "54.3076", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18948;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18948, 3167, 0, "Stormwind Soldier", "", 67, 68, 11000, 12000, 100, 100, 0, 1755, 0, 1, 1, 595, 831, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 7483, 2080, 0, 218171138, 33490436, 0, 3, 1038, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321205,321206,321207,321208,321209);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321205, 1, "-266.943", 1094, "41.7037", 0),
(321205, 2, "-267.244", "1094.72", "41.7283", 0),
(321206, 1, "-264.43", "1094.02", "41.668", 0),
(321206, 2, "-264.457", "1095.34", "41.6793", 0),
(321207, 1, "-262.981", "1094.04", "41.6667", 0),
(321207, 2, "-263.218", "1095.14", "41.6669", 0),
(321208, 1, "-260.035", "1094.06", "41.6667", 0),
(321208, 2, "-260.687", "1094.59", "41.6668", 0),
(321209, 1, "-257.314", "1094.98", "41.6667", 0);
DELETE FROM creature WHERE id=18971;
DELETE FROM creature WHERE guid in (321210,321211);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321210, 18971, 530, "-227.675", "1076.95", "54.312", "2.29628", 180, 0, 0, "-227.675", "1076.95", "54.312", 0, 1, 0, 0, 2, ""),
(321211, 18971, 530, "-227.402", "1081.59", "54.3218", "2.29628", 180, 0, 0, "-227.402", "1081.59", "54.3218", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18971;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18971, 18454, 0, "Undercity Mage", "", 68, 69, 6900, 9200, 70310, 73470, 0, 1758, 0, 1, 1, 604, 844, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321210,321211);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321210, 1, "-238.661", "1096.71", "41.6667", 0),
(321211, 1, "-238.062", "1099.46", "41.6667", 0);
DELETE FROM creature WHERE id=19005;
DELETE FROM creature WHERE guid in (321212,321213,321214);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321212, 19005, 530, "-240.358", "1158.42", "41.5991", "4.72741", 180, 0, 0, "-240.358", "1158.42", "41.5991", 0, 224000, 0, 0, 2, ""),
(321213, 19005, 530, "-248.398", "1159.55", "41.6081", "4.72741", 180, 0, 0, "-248.398", "1159.55", "41.6081", 0, 224000, 0, 0, 2, ""),
(321214, 19005, 530, "-252.933", "1159.48", "41.6217", "4.72741", 180, 0, 0, "-252.933", "1159.48", "41.6217", 0, 224000, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=19005;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(19005, 18531, 0, "Wrath Master", "", 71, 71, 140000, 140000, 100, 100, 0, 14, 0, 1, 1, 633, 885, 0, 1, 0, 0, 0, "2.4", 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 3, 0, 8, 31867, 0, 0, 218171138, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321212,321213,321214);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321212, 1, "-239.558", "1105.92", "41.6667", 0),
(321212, 2, "-240.806", "1159.14", "41.5914", 0),
(321213, 1, "-250.384", "1104.82", "41.6667", 0),
(321213, 2, "-248.516", "1159.28", "41.6097", 0),
(321214, 1, "-259.584", "1108.79", "41.6668", 0),
(321214, 2, "-253.035", "1160.21", "41.6185", 0);
DELETE FROM creature WHERE id=18950;
DELETE FROM creature WHERE guid in (321215,321216,321217,321218,321219);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(321215, 18950, 530, "-235.427", "1071.49", "54.3078", "1.59747", 180, 0, 0, "-235.427", "1071.49", "54.3078", 0, 1, 0, 0, 2, ""),
(321216, 18950, 530, "-237.995", "1071.42", "54.3078", "1.59747", 180, 0, 0, "-237.995", "1071.42", "54.3078", 0, 1, 0, 0, 2, ""),
(321217, 18950, 530, "-240.563", "1071.35", "54.3078", "1.59747", 180, 0, 0, "-240.563", "1071.35", "54.3078", 0, 1, 0, 0, 2, ""),
(321218, 18950, 530, "-243.278", "1071.28", "54.3078", "1.59747", 180, 0, 0, "-243.278", "1071.28", "54.3078", 0, 1, 0, 0, 2, ""),
(321219, 18950, 530, "-245.972", "1071.21", "54.3078", "1.59747", 180, 0, 0, "-245.972", "1071.21", "54.3078", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18950;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18950, 4259, 0, "Orgrimmar Grunt", "", 65, 65, 12000, 12000, 5280, 5280, 0, 1758, 65, 1, 1, 575, 803, 100, 1440, 1584, 0, 0, 1, 0, 2, 0, 0, 0, 0, "69.696", "95.832", 100, 4, 7, 0, 273154050, 3797, 0, 0, 285278466, 0, 0, 1, 0, 0, 3296, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 714, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321215,321216,321217,321218,321219);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321215, 1, "-235.741", "1096.32", "41.6667", 0),
(321216, 1, "-238.781", "1095.97", "41.6667", 0),
(321217, 1, "-243.358", "1095.46", "41.6667", 0),
(321218, 1, "-246.676", "1095.08", "41.6667", 0),
(321219, 1, "-249.214", "1094.8", "41.6667", 0);
DELETE FROM creature WHERE id=18949;
DELETE FROM creature WHERE guid in (321220,321221);
INSERT INTO creature
(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
(100406, 18949, 530, "-273.867", "1075.53", "54.3114", "1.07595", 180, 0, 0, "-273.867", "1075.53", "54.3114", 0, 1, 0, 0, 2, ""),
(100407, 18949, 530, "-273.36", "1084.79", "54.3316", "0.819914", 180, 0, 0, "-273.36", "1084.79", "54.3316", 0, 1, 0, 0, 2, "");
DELETE FROM creature_template WHERE entry=18949;
INSERT INTO creature_template
(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, ScriptName)
VALUES
(18949, 18452, 0, "Stormwind Mage", "", 68, 69, 9100, 9200, 68820, 70310, 0, 1755, 0, 1, 1, 604, 844, 0, 1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 4, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, "");
DELETE FROM creature_movement WHERE id in (321220,321221);
INSERT INTO creature_movement
(id, point, position_x, position_y, position_z, waittime)
VALUES
(321220, 1, "-263.364", "1094.38", "41.6668", 0),
(321220, 2, "-261.961", "1096.04", "41.6668", 0),
(321221, 1, "-269.47", "1093.97", "41.8569", 0),
(321221, 2, "-268.774", "1094.45", "41.8167", 0);