Фикс мастера БГ

[Винсент]

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;

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;

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;

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;

Для тех у кого при регестрацыи бг, или арену пишет что слишком маленький лвл:

UPDATE `battleground_template` SET `MaxLvl`='80' WHERE `id` IN (1,2,3,4,5,6,7,8);