shadowfang keep sql

UPDATE `creature_template` SET `faction_a`=16, `faction_h`=16 WHERE `entry`=50857;
UPDATE `creature_template` SET `faction_a`=16, `faction_h`=16 WHERE `entry`=50869;
UPDATE `creature_template` SET `faction_a`=16, `faction_h`=16 WHERE `entry`=50834;
UPDATE `creature_template` SET `faction_a`=16, `faction_h`=16 WHERE `entry`=50851;

UPDATE `creature_template` SET `faction_a`=16, `faction_h`=16 WHERE `entry`=50613;
UPDATE `creature_template` SET `faction_a`=16, `faction_h`=16 WHERE `entry`=50615;
UPDATE `creature_template` SET `faction_a`=16, `faction_h`=16, `flags_extra`=128 WHERE `entry`=50503;

UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `faction_a`=16, `faction_h`=16, `flags_extra`=128 WHERE `entry`=50522;
UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `faction_a`=16, `faction_h`=16, `flags_extra`=128 WHERE `entry`=50439;

UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry`=52065;


UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=18895;
UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=18972;
UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=18971;
UPDATE `gameobject` SET `state`=1 WHERE `id`=18895;
UPDATE `gameobject` SET `state`=1 WHERE `id`=18972;
UPDATE `gameobject` SET `state`=1 WHERE `id`=18971;

#скрипты

#эшбери
UPDATE `creature_template` SET `ScriptName`='boss_baron_ashbury' WHERE `entry`=46962;

DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=16081;
INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `ScriptName`) VALUES (16081, 11, 'achievement_pardon_denied');


#сильверлейн
UPDATE `creature_template` SET `ScriptName`='boss_baron_silverlaine' WHERE `entry`=3887;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen_spirit' WHERE `entry`=50085;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen_spirit' WHERE `entry`=51080;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen_spirit' WHERE `entry`=50934;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen_spirit' WHERE `entry`=51047;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen' WHERE `entry`=50857;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen' WHERE `entry`=50869;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen' WHERE `entry`=50834;
UPDATE `creature_template` SET `ScriptName`='npc_silverlaine_worgen' WHERE `entry`=50851;

#спрингвейл
UPDATE `creature_template` SET `ScriptName`='boss_commander_springvale' WHERE `entry`=4278;
UPDATE `creature_template` SET `ScriptName`='npc_springvale_wailing_guardsman' WHERE `entry`=50613;
UPDATE `creature_template` SET `ScriptName`='npc_springvale_tormented_officer' WHERE `entry`=50615;
UPDATE `creature_template` SET `ScriptName`='npc_springvale_desecration_bunny' WHERE `entry`=50503;

#вальден
UPDATE `creature_template` SET `ScriptName`='boss_lord_valden' WHERE `entry`=4278;
UPDATE `creature_template` SET `ScriptName`='npc_valden_mystery_toxin' WHERE `entry`=50522;
UPDATE `creature_template` SET `ScriptName`='npc_valden_mystery_toxin' WHERE `entry`=50439;

#годфри
UPDATE `creature_template` SET `ScriptName`='boss_lord_godfrey' WHERE `entry`=46964;
UPDATE `creature_template` SET `ScriptName`='npc_godfrey_pistol_barrage' WHERE `entry`=52065;

#спеллы

#эшбери
DELETE FROM `spell_script_names` WHERE `spell_id`=93423;
DELETE FROM `spell_script_names` WHERE `spell_id`=93710;
DELETE FROM `spell_script_names` WHERE `spell_id`=93424;

#сильверлейн
DELETE FROM `spell_script_names` WHERE `spell_id`=93857;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93857, 'spell_silverlaine_summon_worgen_spirit');

#спрингвейл


#вальден
DELETE FROM `spell_script_names` WHERE `spell_id`=93695;
DELETE FROM `spell_script_names` WHERE `spell_id`=93563;
DELETE FROM `spell_script_names` WHERE `spell_id`=93562;
DELETE FROM `spell_script_names` WHERE `spell_id`=93572;
DELETE FROM `spell_script_names` WHERE `spell_id`=93617;
DELETE FROM `spell_script_names` WHERE `spell_id`=93573;
DELETE FROM `spell_script_names` WHERE `spell_id`=93689;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93617, 'spell_valden_toxic_coagulant');

#годфри

DELETE FROM `spell_script_names` WHERE `spell_id`=93707;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93707, 'spell_godfrey_summon_bloodthirsty_ghouls');