atramedes sql

/* звуки и тексты */
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 0, 0, 'I have no need for eyes to see my enemies. Your clumsy footsteps and foul stench give you away!', 1, 0, 0, 0, 0, 20820, 'VO_BD_ATRAMEDES aggro');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 1, 0, 'Sighted, but blind to the truth. Embrace the finality of it all!', 1, 0, 0, 0, 0, 20821, 'VO_BD_ATRAMEDES kill');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 2, 0, 'Death waits in the darkness!', 1, 0, 0, 0, 0, 20822, 'VO_BD_ATRAMEDES aggro');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 3, 0, 'This miserable existence finally ends.', 1, 0, 0, 0, 0, 20823, 'VO_BD_ATRAMEDES death');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 4, 0, '', 1, 0, 0, 0, 0, 20824, 'VO_BD_ATRAMEDES');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 5, 0, '', 1, 0, 0, 0, 0, 20825, 'VO_BD_ATRAMEDES');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 6, 0, 'You cannot hide from searing flame!', 1, 0, 0, 0, 0, 20826, 'VO_BD_ATRAMEDES searing flame');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 7, 0, 'Yes, run! With every step your heart quickens. The beating, loud and thunderous... Almost deafening. You cannot escape!', 1, 0, 0, 0, 0, 20827, 'VO_BD_ATRAMEDES roaring flame');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (41442, 8, 0, '', 1, 0, 0, 0, 0, 20828, 'VO_BD_ATRAMEDES ');

/* скрипты скиллов */
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (78100, 'spell_atramedes_sonic_breath');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (92553, 'spell_atramedes_sonar_bomb');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (78023, 'spell_atramedes_roaring_flame_aura');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (78353, 'spell_atramedes_roaring_flame');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (77675, 'spell_atramedes_sonar_pulse');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (77612, 'spell_atramedes_modulation');

/* правки нпц */
UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_roaring_flame' WHERE `entry`=41807;
UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_roaring_flame_target' WHERE `entry`=42121;
UPDATE `creature_template` SET `npcflag`=1, `ScriptName`='npc_atramedes_gong' WHERE `entry`=42949;
UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_tracking_flames' WHERE `entry`=41879;
UPDATE `creature_template` SET `ScriptName`='boss_atramedes' WHERE `entry`=41442;
UPDATE `creature_template` SET `movementId`=0, `minlevel`=88, `maxlevel`=88, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_sonar_pulse' WHERE `entry`=41546;