sfk_other

/*скрипты аи боссов*/
UPDATE `creature_template` SET `AIName`='', `ScriptName`='boss_baron_ashbury' WHERE `entry`= 46962;
UPDATE `creature_template` SET `AIName`='', `ScriptName`='boss_baron_silverlaine' WHERE `entry`= 3887;
UPDATE `creature_template` SET `AIName`='', `ScriptName`='boss_commander_springvale' WHERE `entry`= 4278;
UPDATE `creature_template` SET `AIName`='', `ScriptName`='boss_lord_valden' WHERE `entry`=46963;
UPDATE `creature_template` SET `AIName`='', `ScriptName`='npc_tormented_officer' WHERE `entry`=506151;
UPDATE `creature_template` SET `AIName`='', `ScriptName`='npc_wailing_guardsman' WHERE `entry`=506131;

/*скрипты для боссов*/
UPDATE `creature_template` SET `flags_extra`=128, `ScriptName`='npc_worgen_spirit' WHERE `entry`=50934;
UPDATE `creature_template` SET `flags_extra`=128, `ScriptName`='npc_worgen_spirit' WHERE `entry`=51047;
UPDATE `creature_template` SET `flags_extra`=128, `ScriptName`='npc_worgen_spirit' WHERE `entry`=51080;
UPDATE `creature_template` SET `flags_extra`=128, `ScriptName`='npc_worgen_spirit' WHERE `entry`=51085;

/*скрипты для скиллов боссов*/
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93710, 'spell_ashbury_asphyxiate_triggering');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93423, 'spell_ashbury_asphyxiate_triggering');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93707, 'spell_godfrey_summon_bloodthirsty_ghouls');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93562, 'spell_valden_mystery_toxin');

/*двери в инсте, добавлять только если их еще нет*/
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (4000507, 18895, 33, 1, 1, -242.499, 2159.25, 90.6241, 4.32699, 0, 0, 0.829436, -0.558602, 300, 0, 1);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (4000536, 18971, 33, 1, 1, -117.563, 2161.7, 155.679, 2.78585, 0, 0, 0.984222, 0.176936, 300, 0, 1);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (4000546, 18972, 33, 1, 1, -129.822, 2166.57, 129.182, 5.79789, 0, 0, 0.240273, -0.970705, 300, 0, 1);