Показать сообщение отдельно
Старый 22.04.2010, 02:26   #15
Watchman
Trinity User
 
Регистрация: 03.03.2010
Сообщений: 11
Сказал(а) спасибо: 2
Поблагодарили 1 раз в 1 сообщении
Watchman На верном пути
По умолчанию

Код:
-- trial of the champion
UPDATE creature_template SET health_mod=12.84 WHERE entry = 12010;
UPDATE creature_template SET flags_extra='1' WHERE entry IN (12448, 12488, 12439);
UPDATE creature_template SET Health_mod=45.47 WHERE entry = 35119;
UPDATE creature_template SET Health_mod=59.06 WHERE entry = 12011;
-- fix damage and faction
UPDATE creature_template SET dmg_multiplier='20' WHERE entry='35119';
UPDATE creature_template set faction_A='14', faction_H='14' where entry='35119';
-- add heroic mod for "grand champions"
Update creature_template set difficulty_entry_1='12004' where entry ='34705';
Update creature_template set difficulty_entry_1='12009' where entry ='35572';
Update creature_template set difficulty_entry_1='12000' where entry ='34702';
Update creature_template set difficulty_entry_1='12005' where entry ='35569';
Update creature_template set difficulty_entry_1='12001' where entry ='34701';
Update creature_template set difficulty_entry_1='12006' where entry ='35571';
Update creature_template set difficulty_entry_1='12002' where entry ='34657';
Update creature_template set difficulty_entry_1='12007' where entry ='35570';
Update creature_template set difficulty_entry_1='12003' where entry ='34703';
Update creature_template set difficulty_entry_1='12008' where entry ='35617';
Update creature_template set difficulty_entry_1='12011' where entry ='35119';
-- add vehicle for Death Knight
REPLACE INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`description`) VALUES ('35491','35451','0','Death Knight');
-- Flying Grifon
UPDATE `creature_template` SET `InhabitType`='4', `VehicleId`='486' WHERE `entry` ='35491';
-- fix amount of health
-- 10 grand champions ( normal )
UPDATE `creature_template` SET `exp`='2', `Health_mod`='15' WHERE `entry` IN (35572, 35569, 35571, 35570, 35617, 34705, 34702, 34701, 34657, 34703);
-- 10 grand champions ( heroic )
UPDATE `creature_template` SET `exp`='2', `Health_mod`='25' WHERE `entry` IN (12000, 12001, 12002, 12003, 12004, 12005, 12006, 12007, 12008, 12009);
-- prist+pal+dk (normal)
UPDATE `creature_template` SET `exp`='2', `Health_mod`='8.56' WHERE `entry`='34928';
UPDATE `creature_template` SET `exp`='2', `Health_mod`='45.47' WHERE `entry`='35119';
UPDATE `creature_template` SET `exp`='2', `Health_mod`='15' WHERE `entry`='35451';
-- prist+pal+dk (heroic)
UPDATE `creature_template` SET `exp`='2', `Health_mod`='22' WHERE `entry`='12012';
UPDATE `creature_template` SET `exp`='2', `Health_mod`='59.06' WHERE `entry`='12011';
UPDATE `creature_template` SET `exp`='2', `Health_mod`='12.84' WHERE `entry`='12010';
Watchman вне форума