wod Fixed Quest The Fallen Guardian (29437)

[MENZ411]

-- Fixed Quest The Fallen Guardian (29437)
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `npcflag`=1, `gossip_menu_id`=12990, `unit_flags`=`unit_flags`|4 WHERE `entry`=54314;
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=54315;
UPDATE `creature_template` SET `unit_flags`=`unit_flags`|33536 WHERE `entry`=54382;

DELETE FROM `gossip_menu_option` WHERE `menu_id`=12990;
INSERT INTO `gossip_menu_option` 
(`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES 
(12990, 0, 0, 'You turned Fandral Staghelm over to the Twilight''s Hammer. Why have you betrayed the dragonflights?', 1, 1, 0, 0, 0, 0, NULL);

DELETE FROM `conditions` WHERE `SourceGroup`=12990 AND `SourceTypeOrReferenceId`=15;
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(15, 12990, 0, 0, 0, 9, 0, 29437, 0, 0, 0, 0, '', 'Show gossip if quest 29437 taken');

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (54314, 54315) AND `source_type`=0 OR `entryorguid` IN (5431400, 5431500) AND `source_type`=9;
INSERT INTO `smart_scripts` 
(`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
-- Alysra
(54314, 0, 0, 1, 62, 0, 100, 0, 12990, 0, 0, 0, 80, 5431400, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - On gossip option select - Rus script'),
(54314, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Alysra - On link - Close gossip'),
(54314, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 83, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - On link - Remove gossip flag'),
(5431400, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - Script - Say line'),
(5431400, 9, 1, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - Script - Set faction'),
(5431400, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 19, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - Script - Remove immune glag'),
(54314, 0, 3, 0, 0, 0, 100, 0, 0, 1000, 1000, 2000, 11, 101325, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Alysra - In combat - Cast Living Firebolt'),
(54314, 0, 4, 0, 0, 0, 100, 0, 4000, 5000, 15000, 16000, 11, 101328, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Alysra - In combat - Cast Chaotic Growth'),
(54314, 0, 5, 0, 0, 0, 100, 0, 9000, 10000, 20000, 21000, 11, 101321, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - In combat - Cast Living Flame'),
(54314, 0, 6, 7, 7, 0, 100, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - On evade - reset faction'),
(54314, 0, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 18, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - On link - Set immune flag'),
(54314, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 81, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alysra - On link - Set gossip flag'),
(54314, 0, 9, 0, 6, 0, 100, 0, 0, 0, 0, 0, 45, 0, 1, 0, 0, 0, 0, 19, 54315, 0, 0, 0, 0, 0, 0, 'Alysra - On death - Set data - Leyara'),
-- Leyara
(54315, 0, 0, 0, 38, 0, 100, 0, 0, 1, 1000, 1000, 80, 5431500, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - On data set - Run script'),
(5431500, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 101481, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Cast Meteor Smash Birth'),
(5431500, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 86, 101480, 0, 9, 54316, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Cast Meteor Smash Birth - Druid of the Flame'),
(5431500, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 54316, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Say line - Druid of the Flame'),
(5431500, 9, 3, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Say line'),
(5431500, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 86, 101482, 0, 9, 54316, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Cast Flames of Ascendency - Druid of the Flame'),
(5431500, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 101482, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Cast Flames of Ascendency'),
(5431500, 9, 6, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 28, 101482, 0, 0, 0, 0, 0, 9, 54314, 0, 100, 0, 0, 0, 0, 'Leyara - Script - Remove Flames of Ascendency'),
(5431500, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 86, 101494, 2, 9, 54314, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Cast Summon Alysrazor'),
(5431500, 9, 8, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 54382, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Say line - Alysrazor'),
(5431500, 9, 9, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 28, 101480, 0, 0, 0, 0, 0, 9, 54316, 0, 100, 0, 0, 0, 0, 'Leyara - Script - Remove Meteor Smash Birth - Druid of the Flame'),
(5431500, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 101481, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Meteor Smash Birth'),
-- https://github.com/TrinityCore/TrinityCore/commit/e5f7beecf5fabefa13fbe2645cc7d7ca707e46e8
(5431500, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 54382, 0, 0, 0, 0, 0, 0, 'Leyara - Script - Force despawn - Alysrazor');

DELETE FROM `conditions` WHERE `SourceEntry`=101482 AND `SourceTypeOrReferenceId` IN (13, 17);
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 101482, 0, 0, 31, 0, 3, 54314, 0, 0, 0, '', 'Flames of Ascendency can hit Alysra'),
(13, 1, 101482, 0, 0, 36, 0, 0, 0, 0, 1, 0, '', 'Flames of Ascendency can hit Alysra (dead)');

DELETE FROM `creature_text` WHERE `entry` IN (54314, 54316, 54315, 54382);
INSERT INTO `creature_text` 
(`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES 
(54314, 0, 0, 'No, NO! I didn''t "betray" the dragonflights. We were all betrayed. Ysera was lost in a dream while this whole world came undone.', 12, 0, 100, 0, 0, 24440, 'Alysra'),
(54316, 0, 0, 'We are too late! They killed her, as Fandrall predicted.', 12, 0, 100, 0, 0, 0, 'Druid of the Flame'),
(54315, 0, 0, 'No, the Firelord has already claimed this one for his own. Do you doubt his power?', 12, 0, 100, 0, 0, 0, 'Leyara'),
(54382, 0, 0, 'Reborn in flame!', 12, 0, 100, 0, 0, 24437, 'Alysrazor');