[Ulduar]

DELETE FROM `conditions` WHERE `condition_entry` IN (3000, 3001, 3002);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`) VALUES
('3000','4','5798','0'),
('3001','37','53793','100'),
('3002','37','53825','100');

UPDATE creature_template SET AIName = 'EventAI', ScriptName = '' WHERE entry = 53793;
DELETE FROM creature_ai_scripts WHERE creature_id=53793;
INSERT INTO creature_ai_scripts VALUES 
('5379301','53793','0','0','100','63','2000','3000','2000','3000','11','100094',​'1','0','11','100094','4','0','0','0','0','0','Harbinger of Flame - Сast 100094'),
('5379302','53793','0','0','100','31','10000','10000','15000','17000','11','1000​95','1','1','0','0','0','0','0','0','0','0','Harbinger of Flame - Cast Fire Barrage. '),
('5379303','53793','24','0','100','31','100094','1','10000','10000','11','100093​','0','2','0','0','0','0','0','0','0','0','Harbinger of Flame - Cast Fire Up on Has Target Aura 100094 (Hack, need EVENT_T_SPELLHIT_TARGET)'),
('5379304','53793','4','0','100','30','0','0','0','0','45','5','80','0','0','0',​'0','0','0','0','0','0','Harbinger of Flame - Send AI Event Custom A on Aggro(inform near Harbringer on start attack)'),
('5379305','53793','30','0','100','31','5','53793','0','0','38','0','0','0','0',​'0','0','0','0','0','0','0','Harbinger of Flame - Send Combat Pulse on Receive AI Event Custom A from Harbringer');

-- Script id: 53793
DELETE FROM dbscripts_on_creature_death WHERE id=53793;
INSERT INTO dbscripts_on_creature_death VALUES 
(53793,10,35,6,80,0,0,0,0,0,0,0,0,0,0,0,'Send AI Event B From Tormented Protector(combat start)'),
(53793,0,34,3000,0,0,0,8,0,0,0,0,0,0,0,0,'Harbringer not in area id = 5798, return false.'),
(53793,0,34,3001,0,0,0,0,0,0,0,0,0,0,0,0,'Harbringer found alive, return true'),
(53793,0,34,3002,0,0,0,0,0,0,0,0,0,0,0,0,'Tormented Protector found, return true.'),
(53793,5,10,53825,86400,0,0,0,0,0,0,0,453.196,521.454,244.325,5.27431,'Summon Tormented Protector');



DELETE FROM `db_script_string` WHERE `entry` IN (2000006679, 2000006680, 2000006681, 2000006682);
INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
('2000006679','Enough...stop...','Хватит! Остановитесь!','25164','1','0','0','Quest Delegation'),
('2000006680','The fires...torment me no longer. But...I am consumed...','Огонь больше не мучает меня. Но я умираю.','25165','1','0','0','Quest Delegation'),
('2000006681','You...friend of Nordrassil...take what remains of my strength...and fight back the flames...','Ты – друг Нордрассила. Возьми то, что осталось от моей силы, и сразись с огнем!','25166','1','0','0','Quest Delegation'),
('2000006682','May the spirit of the Great Tree shelter you...','И пусть дух великого древа хранит тебя...','25167','1','0','0','Quest Delegation');

DELETE FROM `creature_ai_texts` WHERE entry IN (-1900, -1901, -1902, -1903);
INSERT INTO `creature_ai_texts` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
('-1900','Burning Treant erupt from the ground to aid the Protector!','Из-под земли появляются пылающие древни, чтобы помочь защитнику!','0','3','0','0','Delegation quest'),
('-1901','The fires consuming the Tormented Protector wink out!','Пламя, пожирающее заступника, меркнет!','0','3','0','0','Delegation quest'),
('-1902','Molten cracks appear along the Branch of Nordrassil! Something powerful is emerging from the staff!','Ветвь Нордрассила покрывается пылающими трещинами! Из посоха пытается вырваться что-то очень мощное!\r\n','0','3','0','0','Delegation quest'),
('-1903','Come, kindling! Nordrassil\'s power WILL be mine!','Приди огонь! Мощь Нордрассила будет МОЕЙ!','25163','1','0','0','Delegation quest');

DELETE FROM `creature_movement_template` WHERE `entry` = 53825;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
('53825','2','468.616','505.163','243.57','0','0','5.83552'),
('53825','1','468.616','505.163','243.57','0','5382501','5.83552');

DELETE FROM `creature_ai_summons` WHERE `id` IN (34, 35, 36, 37, 38, 39, 40);
INSERT INTO `creature_ai_summons` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `comment`) VALUES
('34','410.825','505.263','243.2','5.43952','86400','53832'),
('35','421.668','517.994','243.544','4.97039','86400','53832'),
('36','479.112','532.044','243.897','4.35389','86400','53832'),
('37','462.279','530.691','243.385','4.45064','86400','53832'),
('38','443.243','527.913','243.483','4.45064','86400','53832'),
('39','429.854','506.019','243.209','5.14814','86400','53832'),
('40','457.24','502.631','244.133','4.86352','86400','53832');



-- Creature id: 53825
UPDATE creature_template SET AIName='EventAI' WHERE entry=53825;
DELETE FROM creature_ai_scripts WHERE creature_id=53825;
INSERT INTO creature_ai_scripts VALUES 
('5382501','53825','0','3','100','31','1000','1000','0','0','20','0','0','0','0'​,'0','0','0','0','0','0','0','Tormented Protector - False Auto Attack.'),
('5382502','53825','0','5','100','31','42000','42000','42000','42000','32','5383​2','4','40','1','-1900','0','0','0','0','0','0','Tormented Protector - Summon Burning Threant.'),
('5382503','53825','0','5','100','31','42000','42000','42000','42000','32','5383​2','4','37','32','53832','4','38','32','53832','4','39','Tormented Protector - Summon Burning Threant.'),
('5382504','53825','0','5','100','31','42000','42000','42000','42000','32','5383​2','4','34','32','53832','4','35','32','53832','4','36','Tormented Protector - Summon Burning Threant.'),
('5382505','53825','0','3','100','30','1000','1000','0','0','48','2','0','0','1'​,'-1901','0','0','21','0','0','0','Tormented Protector(Phase 2) - Change Movement.'),
('5382506','53825','0','3','100','30','30000','30000','0','0','37','0','0','0','​1','-1902','0','0','0','0','0','0','Tormented Protector(Phase 2) Die and Emote.'),
('5382507','53825','11','0','100','30','0','0','0','0','42','1','1','0','0','0',​'0','0','0','0','0','0','Tormented Protector - Damage Taken = 0 on Spawn.'),
('5382508','53825','2','5','100','30','2','1','0','0','45','5','100','0','23','1​','0','0','2','35','1','0','Tormented Protector(Phase 1) - Send AI Event from Burning Threant(from despawn) and Set Phase 2'),
('5382509','53825','7','5','100','30','0','0','0','0','45','5','100','0','23','-1','0','0','0','0','0','0','Tormented Protector(Phase 1) - Send AI Event from Burning Threant.'),
('5382510','53825','24','5','100','31','100146','1','20000','20000','11','100156​','1','4','0','0','0','0','0','0','0','0','Tormented Protector - Target Has Aura 100146 Cast 100156. Phase 1.'),
('5382511','53825','30','0','100','30','6','53793','0','0','38','0','0','0','0',​'0','0','0','0','0','0','0','Tormented Protector - Set in Combat With Zone on Receive AI Event Custom B(pSender !=53793, return false)'),
('5382512','53825','4','0','100','30','0','0','0','0','13','100','6','0','23','1​','0','0','0','0','0','0','Tormented Protector - Add Threat on Aggro and Set Phase 1.'),
('5382513','53825','0','5','100','31','10000','10000','25000','27000','11','1001​46','1','0','0','0','0','0','0','0','0','0','Tormented Protector - Cast Molten. Phase 1.'),
('5382514','53825','17','5','100','31','53832','0','0','0','11','76010','6','18'​,'11','100165','6','18','0','0','0','0','Tormented Protector - Just Summoned Burning Threant - Force Summoned Cast Self Fiery Explosion and Fire Torment.'),
('5382515','53825','2','5','100','30','100','0','0','0','42','1','1','0','0','0'​,'0','0','0','0','0','0','Tormented Protector - Damage Taken = 0');










-- Script id: 5382501
DELETE FROM dbscripts_on_creature_movement WHERE id=5382501;
INSERT INTO dbscripts_on_creature_movement VALUES 
(5382501,0,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'Tormented Protector - Set Pause Movement.'),
(5382501,0,0,1,0,0,0,0,2000006679,0,0,0,0,0,0,0,'Tormented Protector - Yell Epilogue 1'),
(5382501,3,0,1,0,0,0,0,2000006680,0,0,0,0,0,0,0,'Tormented Protector - Yell Epilogue 2'),
(5382501,9,0,1,0,0,0,0,2000006681,0,0,0,0,0,0,0,'Tormented Protector - Yell Epilogue 3'),
(5382501,19,0,1,0,0,0,0,2000006682,0,0,0,0,0,0,0,'Tormented Protector - Yell Epilogue 4'),
(5382501,21,15,100274,0,0,0,0,0,0,0,0,0,0,0,0,'Tormented Protector - Cast Blessed Nordrassil Defender.');

-- Script id: 53825
DELETE FROM dbscripts_on_creature_death WHERE id=53825;
INSERT INTO dbscripts_on_creature_death VALUES 
(53825,5,10,53833,86400,0,0,0,0,0,0,0,453.196,521.454,244.325,5.27431,'Tormented​ Protector - Summon Vulcanus on death.'),
(53825,0,18,15000,0,0,0,0,0,0,0,0,0,0,0,0,'Tormented Protector - Force Despawn'),
(53825,8,35,6,100,0,0,0,0,0,0,0,0,0,0,0,'Tormented Protector - Send AI Event Custom B( inform Vulcanus and start Attack)');

-- Creature id: 53833
UPDATE creature_template SET AIName='EventAI' WHERE entry=53833;
DELETE FROM creature_ai_scripts WHERE creature_id=53833;
INSERT INTO creature_ai_scripts VALUES 
('5383301','53833','0','0','100','31','2000','2000','3000','3000','11','100191',​'0','2','0','0','0','0','0','0','0','0','Vulcanus - Cast Flame.'),
('5383302','53833','0','0','100','31','10000','10000','10000','12000','11','1000​93','0','2','0','0','0','0','0','0','0','0','Vulcanus - Cast Fire Up.'),
('5383303','53833','4','0','100','30','0','0','0','0','1','-1903','0','0','11','100324','0','1','0','0','0','0','Vulcanus - Yell on Aggro and Cast Searing Hate(Need handled 128 aura Possess Pet in Core)'),
('5383304','53833','30','0','100','30','6','53825','0','0','38','0','0','0','0',​'0','0','0','0','0','0','0','Vulcanus - Receive AI Event Custom B(sender=53825) - Set Combat State.');


-- Creature id: 53832
UPDATE creature_template SET AIName='EventAI' WHERE entry=53832;
DELETE FROM creature_ai_scripts WHERE creature_id=53832;
INSERT INTO creature_ai_scripts VALUES 
('5383201','53832','30','0','100','30','5','53825','0','0','41','0','0','0','0',​'0','0','0','0','0','0','0','Burning Threant - Force Despawn on Receive AI Event Custom A.');



UPDATE `creature_template` SET `ScriptName` = '' WHERE `AIName` = 'EventAI' AND `ScriptName` = 'generic_creature';

Пофиксил боевую часть, с фазовыми масками в ЭвентАИ до сих пор путаюсь. Но теперь отремонтировано. Не забудьте у предвестников вернуть spawnmask(гуиды уже не помню какие).
P.S: 4 в 10-тке, 7 в 25-тке.
Проверки на область и тому подобное тут есть. Всё без хаков.
Конец Времён бы реализовать) Мечты, мечты!