-- Alterac Valley Battlemaster

Код:
DELETE FROM creature_template WHERE entry = 17506;
DELETE FROM creature WHERE id IN (19906, 19907);
INSERT INTO creature (id, map, modelid, equipment_id, 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
(19906, 0, 0, 0, 537.672, -1085.234, 106.339, 4.234, 180, 0, 0, 537.672, -1085.234, 106.339, 4.234, 5300, 0, 0, 0, ''),
(19907, 0, 0, 0, 102.679, -182.953, 127.548, 5.483, 180, 0, 0, 102.679, -182.953, 127.548, 5.483, 5100, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 20271;
UPDATE creature_template SET minhealth = 6400, maxhealth = 6400, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 7410;
UPDATE creature_template SET minhealth = 8500, maxhealth = 8500, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 12197;
UPDATE creature_template SET minhealth = 5100, maxhealth = 5100, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 19907;
UPDATE creature_template SET minhealth = 9700, maxhealth = 9700, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 20119;
UPDATE creature_template SET minhealth = 5400, maxhealth = 5400, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 5118;
UPDATE creature_template SET minhealth = 5300, maxhealth = 5300, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 19906;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 20276;
UPDATE creature_template SET minhealth = 7700, maxhealth = 7700, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 16695;
UPDATE creature_template SET minhealth = 9100, maxhealth = 9100, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 347;
UPDATE creature_template SET minhealth = 6200, maxhealth = 6200, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 14942;
UPDATE creature_template SET minhealth = 6500, maxhealth = 6500, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 7427;
UPDATE creature SET curhealth = 6700 WHERE id = 20271;
UPDATE creature SET spawntimesecs = 180, curhealth = 6400 WHERE id = 7410;
UPDATE creature SET spawntimesecs = 180, curhealth = 6500 WHERE id = 12197;
UPDATE creature SET spawntimesecs = 180, curhealth = 9700 WHERE id = 20119;
UPDATE creature SET spawntimesecs = 180, curhealth = 5400 WHERE id = 5118;
UPDATE creature SET curhealth = 7000 WHERE id = 20276;
UPDATE creature SET curhealth = 7700 WHERE id = 16695;
UPDATE creature SET spawntimesecs = 180, curhealth = 9100 WHERE id = 347;
UPDATE creature SET spawntimesecs = 180, curhealth = 6200 WHERE id = 14942;
UPDATE creature SET spawntimesecs = 180, curhealth = 6500 WHERE id = 7427

-- Arathi Basin Battlemaster

Код:
DELETE FROM creature_template WHERE entry = 16711;
DELETE FROM creature WHERE id IN (19855, 19905);
INSERT INTO creature (id, map, modelid, equipment_id, 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
(19855, 0, 0, 0, -1198.507, -2532.533, 22.393, 3.177, 180, 0, 0, -1198.507, -2532.533, 22.393, 3.177, 9700, 0, 0, 0, ''),
(19905, 0, 0, 0, -817.882, -3510.191, 72.733, 3.786, 180, 0, 0, -817.882, -3510.191, 72.733, 3.786, 4200, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 3500, maxhealth = 3500, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 907;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 15008;
UPDATE creature_template SET minhealth = 9700, maxhealth = 9700, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 19855;
UPDATE creature_template SET minhealth = 7300, maxhealth = 7300, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 857;
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 20273;
UPDATE creature_template SET minhealth = 12000, maxhealth = 12000, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 20120;
UPDATE creature_template SET minhealth = 3000, maxhealth = 3000, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 15007;
UPDATE creature_template SET minhealth = 4400, maxhealth = 4400, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 16694;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 20274;
UPDATE creature_template SET minhealth = 4200, maxhealth = 4200, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 15006;
UPDATE creature_template SET minhealth = 4200, maxhealth = 4200, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 19905;
UPDATE creature_template SET minhealth = 4100, maxhealth = 4100, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 12198;
UPDATE creature SET spawntimesecs = 180, curhealth = 3500 WHERE id = 907;
UPDATE creature SET curhealth = 7000 WHERE id = 15008;
UPDATE creature SET spawntimesecs = 180, curhealth = 7300 WHERE id = 857;
UPDATE creature SET curhealth = 6700 WHERE id = 20273;
UPDATE creature SET curhealth = 12000 WHERE id = 20120;
UPDATE creature SET curhealth = 3000 WHERE id = 15007;
UPDATE creature SET curhealth = 4400 WHERE id = 16694;
UPDATE creature SET curhealth = 7000 WHERE id = 20274;
UPDATE creature SET spawntimesecs = 180, curhealth = 4200 WHERE id = 15006;
UPDATE creature SET curhealth = 4100 WHERE id = 12198;

-- Eye of the Storm Battlemaster

Код:
DELETE FROM creature WHERE id IN (20381, 20385, 20386, 20388);
INSERT INTO creature (id, map, modelid, equipment_id, 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
(20381, 0, 0, 0, -8415.062, 284.552, 120.886, 0.495, 180, 0, 0, -8415.062, 284.552, 120.886, 0.495, 8200, 0, 0, 0, ''),
(20385, 1, 0, 0, 1987.411, -4802.022, 55.820, 2.168, 180, 0, 0, 1987.411, -4802.022, 55.820, 2.168, 7900, 0, 0, 0, ''),
(20386, 0, 0, 0, 1278.476, 285.318, -63.706, 1.267, 180, 0, 0, 1278.476, 285.318, -63.706, 1.267, 7100, 0, 0, 0, ''),
(20388, 1, 0, 0, -1400.021, -95.095, 158.934, 0.289, 180, 0, 0, -1400.021, -95.095, 158.934, 0.289, 9900, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 8200, maxhealth = 8200, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20381;
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20362;
UPDATE creature_template SET minhealth = 13000, maxhealth = 13000, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20382;
UPDATE creature_template SET minhealth = 6500, maxhealth = 6500, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20374;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20383;
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20384;
UPDATE creature_template SET minhealth = 9900, maxhealth = 9900, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20388;
UPDATE creature_template SET minhealth = 7900, maxhealth = 7900, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20385;
UPDATE creature_template SET minhealth = 10000, maxhealth = 10000, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20390;
UPDATE creature_template SET minhealth = 7100, maxhealth = 7100, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20386;
UPDATE creature SET curhealth = 6700 WHERE id = 20362;
UPDATE creature SET spawntimesecs = 180, curhealth = 13000 WHERE id = 20382;
UPDATE creature SET spawntimesecs = 180, curhealth = 6500 WHERE id = 20374;
UPDATE creature SET spawntimesecs = 180, curhealth = 7000 WHERE id = 20383;
UPDATE creature SET curhealth = 6700 WHERE id = 20384;
UPDATE creature SET curhealth = 10000 WHERE id = 20390;

-- Warsong Gulch Battlemaster

Код:
DELETE FROM creature_template WHERE entry IN (17507, 20002);
DELETE FROM creature WHERE id IN (19908, 19910);
INSERT INTO creature (id, map, modelid, equipment_id, 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
(19908, 1, 0, 0, 1434.383, -1856.436, 133.574, 6.200, 180, 0, 0, 1434.383, -1856.436, 133.574, 6.200, 1800, 0, 0, 0, ''),
(19910, 1, 0, 0, 1034.386, -2093.156, 124.765, 4.668, 180, 0, 0, 1034.386, -2093.156, 124.765, 4.668, 1500, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 7900, maxhealth = 7900, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 20118;
UPDATE creature_template SET minhealth = 7400, maxhealth = 7400, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 14982;
UPDATE creature_template SET minhealth = 6600, maxhealth = 6600, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 20272;
UPDATE creature_template SET minhealth = 3700, maxhealth = 3700, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 14981;
UPDATE creature_template SET minhealth = 2700, maxhealth = 2700, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 2302;
UPDATE creature_template SET minhealth = 1800, maxhealth = 1800, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 19908;
UPDATE creature_template SET minhealth = 1500, maxhealth = 1500, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 19910;
UPDATE creature_template SET minhealth = 7100, maxhealth = 7100, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 20269;
UPDATE creature_template SET minhealth = 3800, maxhealth = 3800, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 3890;
UPDATE creature_template SET minhealth = 3200, maxhealth = 3200, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 10360;
UPDATE creature_template SET minhealth = 1800, maxhealth = 1800, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 16696;
UPDATE creature_template SET minhealth = 2400, maxhealth = 2400, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 2804;
UPDATE creature SET spawntimesecs = 180, curhealth = 7900 WHERE id = 20118;
UPDATE creature SET spawntimesecs = 180, curhealth = 7400 WHERE id = 14982;
UPDATE creature SET curhealth = 6600 WHERE id = 20272;
UPDATE creature SET curhealth = 3700 WHERE id = 14981;
UPDATE creature SET spawntimesecs = 180, curhealth = 2700 WHERE id = 2302;
UPDATE creature SET curhealth = 7100 WHERE id = 20269;
UPDATE creature SET spawntimesecs = 180, curhealth = 3800 WHERE id = 3890;
UPDATE creature SET spawntimesecs = 180, curhealth = 3200 WHERE id = 10360;
UPDATE creature SET curhealth = 1800 WHERE id = 16696;
UPDATE creature SET spawntimesecs = 180, curhealth = 2400 WHERE id = 2804;