
Сообщение от
jacob
RPLACE INTO `creture_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistanc6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (54895, 0, 0, 0, 0, 0, 22965, 0, 0, 0, 'Madrigosa', '', '', 0, 74, 74, 2, 35, 35, 0, 1, 1.14286, 1, 3, 226, 339, 0, 85, 9.1, 1500, 1500, 2, 0, 8, 0, 0, 0, 0, 0, 181, 271, 68, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 44872, 45065, 44843, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 70, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 785350527, 41, '', 12340);
DELETE FROM `smart_scripts` WHERE (`entryorguid`=54895 AND `source_type`=0);
INSERT INTO `smart_script` (`entryguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_parm3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(54895, 0, 52951, 0, 1, 1, 100, 31, 4000, 4000, 0, 0, 4, 12472, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_first'),
(54895, 0, 52952, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12473, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_2nd'),
(54895, 0, 52953, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12474, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_3rd'),
(54895, 0, 52956, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12475, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_4rd'),
(54895, 0, 52958, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12476, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_last'),
(54895, 0, 53954, 52953, 61, 1, 100, 31, 0, 0, 0, 0, 11, 45065, 0, 0, 0, 0, 0, 11, 24882, 100, 0, 0, 0, 0, 0, '1_cast_text_third'),
(54895, 0, 54950, 0, 1, 0, 100, 31, 100, 100, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'phase_1_madrigosa_created'),
(54895, 0, 54951, 52951, 1, 1, 100, 31, 4000, 4000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_text_first'),
(54895, 0, 54952, 52952, 1, 1, 100, 31, 14000, 14000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_text_second'),
(54895, 0, 54953, 54954, 1, 1, 100, 31, 24000, 24000, 0, 0, 1, 2, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_text_third'),
(54895, 0, 54954, 53954, 61, 1, 100, 31, 0, 0, 0, 0, 75, 44872, 1, 0, 0, 0, 0, 11, 24882, 100, 0, 0, 0, 0, 0, '1_cast_text_third'),
(54895, 0, 54955, 0, 1, 1, 100, 31, 26000, 26000, 0, 0, 28, 44872, 0, 0, 0, 0, 0, 11, 24882, 100, 0, 0, 0, 0, 0, 'unaura1'),
(54895, 0, 54956, 54957, 1, 1, 100, 31, 32000, 32000, 0, 0, 1, 3, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_text_4th'),
(54895, 0, 54957, 52956, 61, 1, 100, 31, 0, 0, 0, 0, 75, 45665, 1000, 0, 0, 0, 0, 11, 24882, 100, 0, 0, 0, 0, 0, '1_cast_4th'),
(54895, 0, 54958, 52958, 6, 1, 100, 31, 0, 0, 0, 0, 1, 4, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Death_text'),
(54895, 0, 54959, 0, 63, 0, 100, 31, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fly'),
(54895, 0, 54960, 0, 63, 0, 100, 31, 0, 0, 0, 0, 70, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'resp');
REPLCE INTO `creature_templte` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainr_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (24882, 0, 0, 0, 0, 0, 22711, 0, 0, 0, 'Brutallus', '', '', 0, 200, 200, 2, 14, 14, 0, 1, 1.14286, 1, 3, 208000, 487000, 0, 44000, 1, 1500, 1500, 1, 0, 8, 0, 0, 0, 0, 0, 185, 277, 70, 3, 108, 24882, 0, 0, 0, 0, 0, 0, 0, 0, 26662, 45141, 45150, 45185, 0, 0, 0, 0, 0, 0, 2500000, 2500000, 'SmartAI', 0, 3, 180000000, 1, 1, 0, 0, 0, 0, 0, 0, 0, 224, 1, 0, 8395673, 41, '', 12340);
DELETE FROM `smart_scripts` WHERE (`entryorguid`=24882 AND `source_type`=0);
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(24882, 0, 24685, 0, 61, 1, 100, 31, 0, 0, 0, 0, 11, 40504, 2, 0, 0, 0, 0, 11, 54895, 50, 0, 0, 0, 0, 0, 'damage_madrigosa'),
(24882, 0, 24780, 0, 63, 0, 100, 31, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'set_phase_1'),
(24882, 0, 24781, 25781, 1, 1, 100, 31, 18000, 18000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_text_1st'),
(24882, 0, 24782, 25782, 1, 1, 100, 31, 26000, 26000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_text_2nd'),
(24882, 0, 24783, 24784, 1, 1, 100, 31, 40000, 40000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_text_3rd'),
(24882, 0, 24784, 25784, 61, 1, 100, 31, 0, 0, 0, 0, 46, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1_move'),
(24882, 0, 24785, 24685, 1, 1, 100, 31, 43000, 43000, 0, 0, 51, 0, 0, 0, 0, 0, 0, 11, 54895, 100, 0, 0, 0, 0, 0, 'kill_madrigosa'),
(24882, 0, 24786, 24787, 1, 1, 100, 31, 45000, 45000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1486.58, 626.51, 23.6747, 6, 'set_orient'),
(24882, 0, 24787, 24788, 61, 1, 100, 31, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'text_aggro_1'),
(24882, 0, 24788, 25788, 61, 1, 100, 31, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'phase_2'),
(24882, 0, 24789, 24791, 1, 2, 100, 31, 9000, 9000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'text_aggro_2'),
(24882, 0, 24791, 25791, 61, 2, 100, 31, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 15, 180322, 300, 0, 0, 0, 0, 0, 'act_gob'),
(24882, 0, 24792, 0, 11, 0, 100, 31, 1, 580, 4075, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'set_phase_1_resp'),
(24882, 0, 24880, 0, 0, 2, 100, 30, 7000, 9000, 11000, 21000, 11, 45187, 6, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, ''),
(24882, 0, 24881, 0, 0, 2, 100, 31, 15000, 20000, 0, 0, 11, 46299, 6, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, ''),
(24882, 0, 24882, 0, 0, 2, 100, 31, 15000, 20000, 0, 0, 11, 46296, 6, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, ''),
(24882, 0, 24883, 0, 0, 2, 100, 30, 30000, 30000, 41000, 43000, 11, 47399, 6, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(24882, 0, 24884, 0, 0, 2, 100, 30, 7000, 10000, 10000, 12000, 11, 40504, 6, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, ''),
(24882, 0, 24885, 0, 0, 2, 100, 30, 20000, 21000, 29000, 32000, 11, 46283, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, ''),
(24882, 0, 24890, 0, 6, 0, 100, 31, 0, 0, 0, 0, 12, 25038, 7, 0, 0, 0, 0, 11, 54895, 200, 0, 0, 0, 0, 0, 'Spawn_felm'),
(24882, 0, 25781, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12458, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_1st'),
(24882, 0, 25782, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12459, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_2st'),
(24882, 0, 25784, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12460, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_3st'),
(24882, 0, 25788, 0, 61, 1, 100, 31, 0, 0, 0, 0, 4, 12461, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_4st'),
(24882, 0, 25791, 0, 61, 2, 100, 31, 0, 0, 0, 0, 4, 12462, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '1_emote_5st');
INSERT INTO creature_text VALUES ('54895', '0', '0', 'Постойте, друзья! Нам нужно кое-что узнать, прежде чем этот демон встретит свою смерть!', '14', '0', '0', '0', '0', '0', '');
INSERT INTO crature_text VALUES ('54895', '1', '0', 'Где Анвина? Отвечай, демон! Что с Кейлеком?', '14', '0', '0', '0', '0', '0', '');
INSERT INTO creature_text VALUES ('54895', '2', '0', 'Ты расскажешь мне, что с ними случилось!', '14', '0', '0', '0', '0', '0', '');
INSERT INO creature_text VALUES ('54895', '3', '0', 'Говори! Я устала ждать ответа!', '14', '0', '0', '0', '0', '0', '');
INSERT INO crature_text VALUES ('54895', '4', '0', 'Малигос, господин мой… Я сделала все, что могла…', '14', '0', '0', '0', '0', '0', '');
INSERT INTO crature_text VALUES ('24882', '0', '0', 'Жалкая ящерица! Ты найдешь здесь свою смерть!', '14', '0', '0', '0', '0', '0', '');
INSERT INTO creature_text VALUES ('24882', '1', '0', 'Ха! Твоя магия просто смехотворна!', '14', '0', '0', '0', '0', '0', '');
INSERT INTO creature_text VALUES ('24882', '2', '0', 'Я сокрушу тебя!', '14', '0', '0', '0', '0', '0', '');
INSERT INTO creature_text VALUES ('24882', '3', '0', 'Хорошая разминка! А теперь я жду достойного противника!', '14', '0', '0', '0', '0', '0', '');
INSRT INTO crature_text VALUES ('24882', '4', '0', 'Давай, попытай счастья!', '14', '0', '0', '0', '0', '0', '');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (180322, 0, 6391, 'Ghost Gate', '', '', '', 0, 0, 10, 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, 0, 0, 0, '', '', 12340);