|
Архив - только для чтения |
| Модератор форума: andycrowz |
| Форум Корзина форума Корзина [Fixes] Мастера БГ |
| [Fixes] Мастера БГ |
-- Alterac Valley Battlemaster
Code 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 Code 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; Добавлено (09.01.2009, 14:42) Code 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; Добавлено (09.01.2009, 14:43) Code 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;
Сообщение # 1 написано 09.01.2009 в 14:43
|
Quote (Arteks) это сразу для всех Алликов/Орды/Нейтр. ??? Да
Сообщение # 3 написано 09.01.2009 в 14:58
|
Quote (wert322) у меня после этого фикса они ваще говорить перестали, раньше когда нажимаешь на них было чё-то написано красным цветом а теперь на них просто не нажать правой кнопкой интересный ФИКС
Кто винду поюзать рад,
Тот позорит наш отряд! @ Tux.
Сообщение # 6 написано 09.01.2009 в 21:25
|
Quote (Arteks) интересный ФИКС вот я про то же Добавлено (09.01.2009, 21:48)
Сообщение # 7 написано 09.01.2009 в 21:48
|
Quote Raymond, у меня када на бг регался, или арену было написано типа слишком маленький лвл, вот я и залил, а после фикса они вообще перестали работать, но до меня дошло в чём проблема и теперь они у меня работают вот фикс! Code UPDATE `battleground_template` SET `MaxLvl`='80' WHERE `id` IN (1,2,3,4,5,6,7,8);
Сообщение # 10 написано 10.01.2009 в 13:00
|
Данная тема была перемещена из раздела Фиксы к MaNGOS.
Причина перемещения: устарело Переместил: ph3n.
Сообщение # 12 написано 16.10.2012 в 20:11
|
| |||
| |||