sql for omnotron

//скрипты для нпц-луж
UPDATE `creature_template` SET `ScriptName`='npc_poison_bomb' WHERE `entry`=42897;
UPDATE `creature_template` SET `ScriptName`='npc_poison_puddle' WHERE `entry`=42920;
UPDATE `creature_template` SET `ScriptName`='npc_power_generator' WHERE `entry`=42733;
UPDATE `creature_template` SET `ScriptName`='npc_chemical_cloud' WHERE `entry`=42934;

//Скрипты для боссов
UPDATE `creature_template` SET `ScriptName`='boss_omnotron' WHERE `entry`=42186;
UPDATE `creature_template` SET `ScriptName`='boss_arcanotron' WHERE `entry`=42166;
UPDATE `creature_template` SET `ScriptName`='boss_electron' WHERE `entry`=42179;
UPDATE `creature_template` SET `ScriptName`='boss_magmatron' WHERE `entry`=42178;
UPDATE `creature_template` SET `ScriptName`='boss_toxitron' WHERE `entry`=42180;

//тексты и звуки
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 0, 0, NULL, 1, 0, 0, 0, 0, 21863, 'VO_BD_Council aggro');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 1, 0, NULL, 1, 0, 0, 0, 0, 21864, 'VO_BD_Council death');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 2, 0, 'Electron unit activated.', 1, 0, 0, 0, 0, 21865, 'VO_BD_Council electron activated');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 3, 0, 'Magmatron unit activated.', 1, 0, 0, 0, 0, 21866, 'VO_BD_Council magmatron activated');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 4, 0, 'Toxitron unit activated.', 1, 0, 0, 0, 0, 21867, 'VO_BD_Council toxitron activated');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 5, 0, 'Arcatron unit activated.', 1, 0, 0, 0, 0, 21868, 'VO_BD_Council arcatron activated');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 6, 0, 'Electron unit shield systems online.', 1, 0, 0, 0, 0, 21869, 'VO_BD_Council electron shield');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 7, 0, 'Magmatron unit shield systems online.', 1, 0, 0, 0, 0, 21870, 'VO_BD_Council magmatron shield');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 8, 0, 'Toxitron unit shield systems online.', 1, 0, 0, 0, 0, 21871, 'VO_BD_Council toxitron shield');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 9, 0, 'Arcanotron unit shield systems online.', 1, 0, 0, 0, 0, 21872, 'VO_BD_Council arcanotron shield');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (42186, 10, 0, 'Rerouting excess energy to Magmatron unit. Engage flamethrower device.', 1, 0, 0, 0, 0, 21873, 'VO_BD_Council magmatron flamethrower');

//Скрипты скиллов
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (79505, 'spell_magmatron_flamethrower');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (78741, 'spell_omnotron_active_trigger');

//Скрипт инстанса
UPDATE `instance_template` SET `script`='instance_blackwing_descent' WHERE `map`=669;

//Добавление босса-контроллера. ВНИМАНИЕ! Не нужно ставить, если уже есть.
//INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES (6644990, 42186, 669, 1, 1, 0, 0, -324.561, -422.36, 213.892, 1.58084, 300, 0, 0, 42000, 0, 0, 0, 0, 0, 0);

//Корректировка местоположения боссов
UPDATE `creature` SET `position_x`=-319.89, `position_y`=-411.36 WHERE `guid`=1082119;
UPDATE `creature` SET `position_x`=-328.02, `position_y`=-412.01 WHERE `guid`=1082113;