A Fall From Grace

A Fall From Grace

DELETE FROM `smart_scripts` WHERE `entryorguid`=27439 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=2743900 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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES 
(27439, 0, 0, 1, 10, 0, 100, 513, 1, 20, 0, 0, 1, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - OOC Los - Store Target'),
(27439, 0, 1, 0, 61, 0, 100, 512,0, 0, 0, 0, 0, 53, 0, 27439, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - OOC Los - Start WP'),
(27439, 0, 2, 3, 40, 0, 100, 512,2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - On Reached WP2 - Say'),
(27439, 0, 3, 4, 61, 0, 100, 512,0, 0, 0, 0, 0, 54, 6000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Linked with Previous Event - Pause WP'),
(27439, 0, 4, 0, 61, 0, 100, 512,0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Linked with Previous Event - Face Target'),
(27439, 0, 5, 0, 40, 0, 100, 512,9, 0, 0, 0, 0, 80, 2743900, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 4.5, 0, 'High Abbot Landgren - On Reached WP9 - Run Script'),
(27439, 0, 6, 0, 6, 0, 100, 512,0, 0, 0, 0, 0, 201, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 4.5, 0, 'High Abbot Landgren - On Death - Despawn'),
(2743900, 9, 0, 0, 0, 0, 100, 512,0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 4.5, 0, 'High Abbot Landgren - Script - Set Orientation'),
(2743900, 9, 1, 0, 0, 0, 100, 512,1000, 1000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Say'),
(2743900, 9, 2, 0, 0, 0, 100, 512,7000, 7000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Say'),
(2743900, 9, 3, 0, 0, 0, 100, 512,13000, 13000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Say'),
(2743900, 9, 4, 0, 0, 0, 100, 512,16000, 16000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Say'),
(2743900, 9, 5, 0, 0, 0, 100, 512,21000, 21000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Say'),
(2743900, 9, 6, 0, 0, 0, 100, 512,0, 0, 0, 0, 0, 11, 48771, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Cast A Fall from Grace: Kill Credit'),
(2743900, 9, 7, 0, 0, 0, 100, 512,0, 0, 0, 0, 0, 15, 12274, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Call Areaexploredoreventhappens'),
(2743900, 9, 8, 0, 0, 0, 100, 512,0, 0, 0, 0, 0, 12, 27446, 1, 30000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Summon High Abbot Langrens Jump Vehicle'),
(2743900, 9, 9, 0, 0, 0, 100, 512,0, 0, 0, 0, 0, 11, 48773, 2, 0, 0, 0, 0, 19, 27446, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Linked with Previous Event - Cast A Fall from Grace: High Abbot Ride Vehicle'),
(2743900, 9, 10, 0, 0, 0, 100, 512,0, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 27446, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Linked with Previous Event - Cast A Fall from Grace: High Abbot Ride Vehicle'),
(2743900, 9, 11, 0, 0, 0, 100, 512,5000, 5000, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Script - Kill self ');

DELETE FROM `smart_scripts` WHERE `entryorguid`=-98593 AND `source_type`=0 AND `id` =1;
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 
(-98593, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 48759, 1, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny -  Linked with Previous Event - Cast A Fall from Grace: Bunny Force Cast');

DELETE FROM `smart_scripts` WHERE `entryorguid`=4987 AND `source_type`=2;
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 
(4987, 2, 0, 1, 46, 0, 100, 0, 4987, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Trigger - Stpre Target'),
(4987, 2, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 10, 98593, 23837, 0, 0, 0, 0, 0, 'On Trigger - Send Target'),
(4987, 2, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 98593, 23837, 0, 0, 0, 0, 0, 'On Trigger - Set Data');

DELETE FROM `areatrigger_involvedrelation` WHERE  `id`=4987;

DELETE FROM `spell_scripts` WHERE `id`=48769;
INSERT INTO `spell_scripts` (`id`, `effIndex`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `Comment`) VALUES 
(48769, 0, 0, 14, 48753, 0, 0, 0, 0, 0, 0, 'A Fall From Grace: Quest Completion Script - Remove A Fall from Grace: Bell Rung Dummy Aura'),
(48769, 0, 0, 14, 48756, 0, 0, 0, 0, 0, 0, 'A Fall From Grace: Quest Completion Script - Remove A Fall from Grace: Ring Kissed Dummy Aura'),
(48769, 0, 0, 14, 48761, 0, 0, 0, 0, 0, 0, 'A Fall From Grace: Quest Completion Script - Remove Raven Priest Image'),
(48769, 0, 0, 14, 48763, 0, 0, 0, 0, 0, 0, 'A Fall From Grace: Quest Completion Script - Remove Raven Priest Image');

UPDATE `smart_scripts` SET `event_type`='40', `event_param1`='28' WHERE  `entryorguid`=-106201 AND `source_type`=0 AND `id`=2 AND `link`=0;
UPDATE `smart_scripts` SET `event_type`='40', `event_param1`='28' WHERE  `entryorguid`=-106200 AND `source_type`=0 AND `id`=4 AND `link`=0;
UPDATE `smart_scripts` SET `event_type`='38', `event_param1`='1', `event_param2`='1',`event_param3`='30000', `event_param4`='30000' WHERE  `entryorguid`=-106200 AND `source_type`=0 AND `id`=2 AND `link`=0;
UPDATE `smart_scripts` SET `link`='0' WHERE  `entryorguid`=-106200 AND `source_type`=0 AND `id`=1 AND `link`=2;
UPDATE `smart_scripts` SET `event_type`='40', `event_param1`='10', `event_param2`='0', `event_param3`='0', `event_param4`='0' WHERE  `entryorguid`=-106200 AND `source_type`=0 AND `id`=1 AND `link`=0;

-- UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=27446;

-- DELETE FROM `smart_scripts` WHERE `entryorguid`=27446 AND `source_type`=0;
-- 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 
-- (27446, 0, 0, 0, 27, 0, 100, 512, 0, 0, 0, 0, 11, 66733, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Langrens Jump Vehicle - On passenger boarded - Cast Jump Back'),
-- (27446, 0, 1, 0, 11, 0, 100, 512, 0, 0, 0, 0, 3, 0, 21342, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Langrens Jump Vehicle - On spawn morph to model');

UPDATE `smart_scripts` SET `link`='2' WHERE  `entryorguid`=27245 AND `source_type`=0 AND `id`=1 AND `link`=0;

DELETE FROM `smart_scripts` WHERE `entryorguid`=27245 AND `source_type`=0 AND `id` IN(2,3,4);
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 
(27245, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Linked with Previous Event - Say Line 0'),
(27245, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 19, 27247, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - Linked with Previous Event - Say Line 2 on Body Guard'),
(27245, 0, 4, 0, 62, 0, 100, 0, 9536, 0, 0, 0, 85, 48756, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'High Abbot Landgren - On gossip option select - Cast Invoker Cast A Fall from Grace: Ring Kissed Dummy Aura');

DELETE FROM `creature_text` WHERE `CreatureID`=27245 AND `GroupID`=0 AND `ID`=0;
DELETE FROM `creature_text` WHERE `CreatureID`=27247 AND `GroupID`=2;

INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(27245, 0, 0, 'Boys, go see who\'s doing that.', 12, 0, 100, 0, 0, 0, 26608, 1, 'High Abbot Langren'),
(27247, 2, 0, 'Yes, your eminence. Come on!', 12, 0, 100, 0, 0, 0, 26609, 1, 'Devout Bodyguard');


UPDATE `creature_text` SET `TextRange`='1' WHERE  `CreatureID`=27247;

UPDATE `creature_text` SET `GroupID`='3', `ID`='0' WHERE  `CreatureID`=27202 AND `GroupID`=0 AND `ID`=2;

UPDATE `creature_template` SET  `flags_extra`='0' WHERE  `entry`=27446;

UPDATE `smart_scripts` SET `link`='2' WHERE  `entryorguid`=188713 AND `source_type`=1 AND `id`=1 AND `link`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=2411001 AND `source_type`=9;

DELETE FROM `smart_scripts` WHERE `entryorguid`=188713 AND `source_type`=1;
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES 
(188713, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 45, 17, 13, 0, 0, 0, 0, 10, 100277, 24110, 0, 0, 0, 0, 0, 'Abbey Bell Rope - On Activate - Set Data High Abbot Landgren'),
(188713, 1, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, 48753, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Abbey Bell Rope - Linked with Previous Event - Invoker Cast A Fall from Grace: Bell Rung Dummy Aura'),
(2411001, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 10, 102082, 27202, 0, 0, 0, 0, 0, 'Abbey Bell Rope - Script - Play Sound'),
(2411001, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 105877, 27245, 0, 0, 0, 0, 0, 'Abbey Bell Rope - Script - Set Data to High Abbot Langren'),
(2411001, 9, 2, 0, 0, 0, 100, 0, 2000, 5000, 0, 0, 4, 7256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Abbey Bell Rope - Script - Play Sound'),
(2411001, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 4, 7256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny Large - Script - Play Sound');

DELETE FROM `smart_scripts` WHERE `entryorguid`=24110 AND `source_type`=0 AND `id`=11;
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 
(24110, 0, 11, 0, 38, 0, 100, 0, 17, 13, 0, 0, 80, 2411001, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny Large - On Data Set 17 13 - Run Script');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=48773 AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 48773, 0, 0, 31, 0, 3, 27446, 0, 0, 0, 0, '', NULL);

DELETE FROM `conditions` WHERE  `SourceTypeOrReferenceId`=22 AND `SourceEntry`=27350 AND `SourceId`=0;

DELETE FROM `smart_scripts` WHERE `entryorguid`=27350 AND `source_type`=0;
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
(27350, 0, 0, 0, 19, 0, 100, 0, 12274, 0, 0, 0, 85, 48774, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Agent Skully - On Quest Accept - Spellcast A Fall from Grace: Quest Accept'),
(27350, 0, 1, 0, 62, 0, 100, 0, 9501, 0, 0, 0, 85, 48762, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Agent Skully - On gossip option select - Spellcast A Fall from Grace: Scarlet Raven Priest Image - Master'),
(27350, 0, 2, 0, 20, 0, 100, 0, 12274, 0, 0, 0, 85, 48765, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Agent Skully - On Quest Complete - Cast A Fall from Grace: Quest Completion');