#Naxxramas
             #Naxxramas Portal is active
             UPDATE `gameobject_template` SET `flags` = 0 WHERE `entry` IN (181575,181576,181577,181578,181212, 181233,181235,181197,181209,181126,181195,181167);
             #Open all door
             UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` IN (181405, 181404, 181403, 181402, 181444, 181228, 181225, 181197, 181209, 181235, 181195, 181121, 181120, 181123, 181242, 181243, 181240, 181241, 181496, 181203, 181202, 181201, 181200, 181199, 181124, 181170, 181125, 181119);
             UPDATE `gameobject` SET `state` = 0 WHERE `id` IN (181201, 181202, 181203);
             #Spawn Four Horsemen Chest
             UPDATE `gameobject` SET `spawntimesecs` = 604800 WHERE `id` IN (181366, 193426);
#Halls of Stone
             #Open Tribunal Chest
             UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` IN (190586, 193996);
#Slave Pens
             #Open Ice chest
             UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` = 187892;
#Hellfire Ramparts
             #Open Reinforced Fel Iron Chest
             UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` IN (185168, 185169);
#Ulduar
             #Open All Door
             UPDATE `gameobject_template` SET `faction` = 0, `flags` = 0 WHERE `entry` IN (194905, 194416, 194556, 194255, 194750);
             #Open Base Teleport
             DELETE FROM areatrigger_teleport WHERE id = '5420';
             INSERT INTO areatrigger_teleport VALUES (5420, "Ulduar (base teleport)", 0, 0, 0, 0, 0, 0, 0, "", 603, 1498.09, -24.246, 421.366, 0);
             UPDATE `gameobject` SET `state` = 0 WHERE `guid` = 73286;
             #Spawn Cache
             UPDATE `gameobject` SET `spawntimesecs` = 604800 WHERE `id` IN (194327, 194331, 194307, 194308, 194200, 194201, 195046, 195047, 194313, 194315, 194789, 194956, 194822, 194823);

UPDATE `quest_template` SET `ObjectiveText1`='Hack: Use Control Mechanism',`ObjectiveText2`='',`ObjectiveText3`='',`ObjectiveText4`='', `ReqCreatureOrGOId1`='-191609',`ReqCreatureOrGOId2`='0',`ReqCreatureOrGOId3`='0',`ReqCreatureOrGOId4`='0',`ReqCreatureOrGOCount1`='1',`ReqCr  eatureOrGOCount2`='0',`ReqCreatureOrGOCount3`='0',`ReqCreatureOrGOCount4`='0',`ReqSpellCast1`='0',`ReqSpellCast2`='0',`ReqSpellCast3`='0',`R  eqSpellCast4`='0' WHERE (`entry`='12641');   
UPDATE `quest_template` SET `ReqSpellCast1`='0', `ObjectiveText1`='Scarlet Miners Killed', `RequestItemsText`='You have fought hard to invade the realm of the harvester... Wait. <Gothik looks at his notes.> My apologies, <race>. Old habits die hard.' WHERE (`entry`='12698');   
UPDATE `quest_template` SET `ReqCreatureOrGOId1`='28763', `ReqCreatureOrGOCount1`='10', `ObjectiveText1`='Scarlet Crusader slain' WHERE (`entry`='12701');   
UPDATE `quest_template` SET `QuestFlags`='4',`SpecialFlags`='2' WHERE `entry`='12687';   
DELETE FROM `creature_ai_scripts` WHERE `creature_id`='28768';   
INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event  _param4`,`action1_type`,`action1_param1`,`action1_param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`action2_param3`  ,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`,`comment`) VALUES    
('80000031','28768','0','0','100','1','3500','4000','8400','14800','11','52374','1','2','0','0','0','0','0','0','0','0','Dark Rider of Acherus - Cast Strike'),   
('80000033','28768','0','0','100','1','6000','6000','12000','12800','11','50688','1','2','0','0','0','0','0','0','0','0','Dark Rider of Acherus - Cast Plague Strike'),   
('80000034','28768','4','0','100','0','0','0','0','0','11','52356','1','2','0','0','0','0','0','0','0','0','Dark Rider of Acherus - Cast Throw'),   
('80000032','28768','0','0','100','1','8000','8000','16000','18800','11','52372','1','2','0','0','0','0','0','0','0','0','Dark Rider of Acherus - Cast Touch'),   
('80000269','28768','0','0','100','0','100','1000','0','0','11','52361','1','2','0','0','0','0','0','0','0','0','Dark Rider of Acherus - Cast Death Race Complete');   
UPDATE `creature_template` SET  `AIName`='EventAI', `ScriptName`='' WHERE `entry`='28768';   
UPDATE `creature_template` SET `unit_flags`='32768' WHERE (`entry`='28942');   
UPDATE `quest_template` SET `ExclusiveGroup`='-12756' WHERE (`entry`='12757');   
UPDATE `quest_template` SET `ReqCreatureOrGOId1`='0',`ReqCreatureOrGOId2`='0',`ReqCreatureOrGOCount1`='0',`ReqCreatureOrGOCount2`='0' WHERE (`entry`='12779');   
UPDATE `quest_template` SET `ReqCreatureOrGOId1`='0',`ReqCreatureOrGOCount1`='0' WHERE (`entry`='12801');   
UPDATE `creature_template` SET `faction_A`='1733', `faction_H`='1733' WHERE (`entry`='29611' );   
UPDATE `creature_template` SET `faction_A`='1734', `faction_H`='1734' WHERE (`entry`='4949' );
UPDATE `quest_template` SET `ExclusiveGroup`='0' WHERE (`entry`='12756');
UPDATE `quest_template` SET `NextQuestId`='12754',`ExclusiveGroup`='-12754' WHERE (`entry`='12722');
UPDATE `quest_template` SET `NextQuestId`='12754',`ExclusiveGroup`='-12754' WHERE (`entry`='12717');
UPDATE `quest_template` SET `NextQuestId`='12754',`ExclusiveGroup`='-12754' WHERE (`entry`='12751');    

UPDATE `quest_template` SET `ObjectiveText1`='Use Control Mechanism',`ObjectiveText2`='',`ObjectiveText3`='',`ObjectiveText4`='', `ReqCreatureOrGOId1`='-191609',`ReqCreatureOrGOId2`='0',`ReqCreatureOrGOId3`='0',`ReqCreatureOrGOId4`='0',`ReqCreatureOrGOCount1`='1',`ReqCr  eatureOrGOCount2`='0',`ReqCreatureOrGOCount3`='0',`ReqCreatureOrGOCount4`='0',`ReqSpellCast1`='0',`ReqSpellCast2`='0',`ReqSpellCast3`='0',`R  eqSpellCast4`='0' WHERE (`entry`='12641');
UPDATE `quest_template` SET `ReqCreatureOrGOId1`='28763', `ReqCreatureOrGOCount1`='10', `ObjectiveText1`='Scarlet Crusader slain' WHERE (`entry`='12701');
UPDATE `creature_template` SET `unit_flags`='32768' WHERE (`entry`='28942');
UPDATE `quest_template` SET `ReqCreatureOrGOId1`='0',`ReqCreatureOrGOId2`='0',`ReqCreatureOrGOCount1`='0',`ReqCreatureOrGOCount2`='0' WHERE (`entry`='12779');
UPDATE `creature_template` SET `faction_A`='1733', `faction_H`='1733' WHERE `entry`='29611';
UPDATE `creature_template` SET `faction_A`='1734', `faction_H`='1734' WHERE `entry`='4949';
UPDATE `quest_template` SET `ExclusiveGroup`='0' WHERE (`entry`='12756');
UPDATE `quest_template` SET `NextQuestId`='12754',`ExclusiveGroup`='-12754' WHERE (`entry`='12722');
UPDATE `quest_template` SET `NextQuestId`='12754',`ExclusiveGroup`='-12754' WHERE (`entry`='12717');
UPDATE `quest_template` SET `NextQuestId`='12754',`ExclusiveGroup`='-12754' WHERE (`entry`='12751');
UPDATE `creature_template` SET `unit_flags`='33536' WHERE `entry` IN ('29074', '29072', '29073', '29071', '29070', '29068', '29061', '29065', '29067', '29032');  

# The Scarlet Enclave
insert into creature_ai_scripts values
('2855701','28557','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Peasant - Quest Kill Credit'),
('2857601','28576','6','0','100','0','0','0','0','0','33','28764','6','0','0','0','0','0','0','0','0','0','Citizen of Havenshire - Quest Kill Credit'),
('2857701','28577','6','0','100','0','0','0','0','0','33','28764','6','0','0','0','0','0','0','0','0','0','Citizen of Havenshire - Quest Kill Credit'),
('2860801','28608','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Medic - Quest Kill Credit'),
('2860901','28609','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Infantryman - Quest Kill Credit'),
('2861001','28610','8','0','100','0','52781','-1','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Set Phase 1 on Spell Hit'),
('2861002','28610','0','510','100','0','0','0','0','0','31','2','8','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Random In-Combat Say (Phase 1)'),
('2861003','28610','0','509','100','0','0','0','0','0','1','-555','0','0','20','0','0','0','18','2','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861004','28610','0','509','100','0','5000','5000','0','0','1','-556','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861005','28610','0','509','100','0','14000','14000','0','0','1','-557','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861006','28610','0','509','100','0','20000','20000','0','0','1','-558','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861007','28610','0','509','100','0','30000','30000','0','0','1','-559','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861008','28610','6','509','100','0','31500','34000','0','0','26','12720','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Quest Event on Death (Phase 2)'),
('2861009','28610','0','509','100','0','32000','32000','0','0','37','0','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Die (Phase 2)'),
('2861010','28610','0','507','100','0','0','0','0','0','1','-560','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 3)'),
('2861011','28610','0','503','100','0','0','0','0','0','1','-561','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 4)'),
('2861012','28610','0','495','100','0','0','0','0','0','1','-562','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 5)'),
('2861013','28610','0','479','100','0','0','0','0','0','1','-563','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 6)'),
('2861014','28610','0','447','100','0','0','0','0','0','1','-564','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 7)'),
('2861015','28610','0','383','100','0','0','0','0','0','1','-565','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 8)'),
('2861016','28610','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Quest Kill Credit'),
('2861101','28611','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Captain - Quest Kill Credit'),
('2883401','28834','6','0','100','0','0','0','0','0','33','28849','6','0','0','0','0','0','0','0','0','0','Scarlet Fleet Defender - Quest Kill Credit'),
('2885601','28856','6','0','100','0','0','0','0','0','33','28849','6','0','0','0','0','0','0','0','0','0','Scarlet Fleet Guardian - Quest Kill Credit'),
('2893601','28936','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Commander - Quest Kill Credit'),
('2893901','28939','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Preacher - Quest Kill Credit'),
('2894001','28940','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Crusader - Quest Kill Credit'),
('2894101','28941','6','0','100','0','0','0','0','0','33','28986','6','0','0','0','0','0','0','0','0','0','Citizen of New Avalon - Quest Kill Credit'),
('2894201','28942','6','0','100','0','0','0','0','0','33','28986','6','0','0','0','0','0','0','0','0','0','Citizen of New Avalon - Quest Kill Credit'),
('2910201','29102','6','0','100','0','0','0','0','0','33','29150','6','0','0','0','0','0','0','0','0','0','Hearthglen Crusader - Quest Kill Credit'),
('2910301','29103','6','0','100','0','0','0','0','0','33','29150','6','0','0','0','0','0','0','0','0','0','Hearthglen Crusader - Quest Kill Credit'),
('3109501','31095','6','0','100','0','0','0','0','0','33','31100','6','0','0','0','0','0','0','0','0','0','Valkyr Battle-maiden - Quest Kill Credit'),
('3109601','31096','6','0','100','0','0','0','0','0','33','31100','6','0','0','0','0','0','0','0','0','0','Scourge Necromancer - Quest Kill Credit'),
('3109801','31098','6','0','100','0','0','0','0','0','33','31100','6','0','0','0','0','0','0','0','0','0','Terrifying Abomination - Quest Kill Credit');
INSERT into `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `comment`) VALUES
('-555','I\'ll tell you everything! STOP! PLEASE!','0','0','0','28610'),
('-556','We... We have only been told that the \"Crimson Dawn\" is an awakening. You see\, the Light speaks to the High General. It is the Light...','0','0','0','28610'),
('-557','The Light that guides us. The movement was set in motion before you came... We... We do as we are told. It is what must be done.','0','0','0','28610'),
('-558','I know very little else... The High General chooses who may go and who must stay behind. There\'s nothing else... You must believe me!','0','0','0','28610'),
('-559','NO! PLEASE! There is one more thing that I forgot to mention... A courier comes soon... From Hearthglen. It...','0','0','0','28610'),
('-560','You\'ll be hanging in the gallows shortly\, Scourge fiend!','0','0','0','28610'),
('-561','You\'ll have to kill me\, monster! I will tell you NOTHING!','0','0','0','28610'),
('-562','You hit like a girl. Honestly. Is that the best you can do?','0','0','0','28610'),
('-563','ARGH! You burned my last good tabard!','0','0','0','28610'),
('-564','Argh... The pain... The pain is almost as unbearable as the lashings I received in grammar school when I was but a child.','0','0','0','28610'),
('-565','I used to work for Grand Inquisitor Isillien! Your idea of pain is a normal mid-afternoon for me!','0','0','0','28610');
# creature_template
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN (28557,28576,28577,28608,28609,28610,28611,28834,28856,28936,28939,28940,28941,28942,29102,29103,31095,31096,31098);
# Профилактика:
UPDATE `creature_template` SET `ScriptName`='' WHERE (`ScriptName`='generic_creature' AND `AIName`='EventAI');