In Dreams Quest fix (ID5944)

indeams.sql

-- In Dreams Quest fix (ID5944)

-- Set Variables
-- Grand Inquisitor Isillien
SET @ISILLIEN := 1840;
-- Highlord Taelan Fordring <Highlord of the Scarlet Crusade>
SET @TAELAN := 1842;
-- Lord Tirion Fordring <Order of the Silver Hand>
SET @TIRION := 12126;
-- Crimson Elite
SET @CRIMSON := 12128;
-- Taelan Death Spell
SET @DEATHSPELL := 18969;

-- Questending
DELETE FROM `creature_questender` WHERE `id`=@TIRION;
INSERT INTO `creature_questender` VALUES
(@TIRION, 5944);

-- Text
DELETE FROM `creature_text` WHERE `CreatureID` IN (@ISILLIEN, @TAELAN, @TIRION);
INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES 
(@ISILLIEN,0,0,'You will not make it to the forest\'s edge, Fordring.',12,0,100,0,0,0,7395,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,1,0,'You disappoint me, Taelan. I had plans for you... grand plans. Alas, it was only a matter of time before your filthy bloodline would catch up with you.',12,0,100,0,0,0,7337,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,2,0,'It is as they say: Like father, like son. You are as weak of will as Tirion... perhaps more so. I can only hope my assassins finally succeeded in ending his pitiful life.',12,0,100,0,0,0,7338,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,3,0,'The Grand Crusader has charged me with destroying you and your newfound friends, Taelan, but know this: I do this for pleasure, not of obligation or duty.',12,0,100,0,0,0,7359,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,4,0,'%s calls for his guardsmen.',16,0,100,22,0,0,7360,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,5,0,'The end is now, Fordring.',12,0,100,0,0,0,7361,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,6,0,'Enough!',12,0,100,0,0,0,7381,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,7,0,'%s laughs.',16,0,100,11,0,0,7382,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,8,0,'Did you really believe that you could defeat me? Your friends are soon to join you, Taelan.',12,0,100,0,0,0,7383,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,9,0,'Tragic. The elder Fordring lives on... You are too late, old man. Retreat back to your cave, hermit, unless you wish to join your son in the Twisting Nether.',12,0,100,0,0,0,7433,0,'Grand Inquisitor Isillien'),
(@ISILLIEN,10,0,'Then come, hermit!',12,0,100,0,0,0,7436,0,'Grand Inquisitor Isillien'),
(@TAELAN,0,0,'I will lead us through Hearthglen to the forest\'s edge. From there, you will take me to my father.',12,0,100,0,0,0,7313,0,'Taelan Fordring'),
(@TAELAN,1,0,'Remove your disguise, lest you feel the bite of my blade when the fury has taken control.',12,0,100,0,0,0,7314,0,'Taelan Fordring'),
(@TAELAN,2,0,'Halt.',12,0,100,0,0,0,7315,0,'Taelan Fordring'),
(@TAELAN,3,0,'%s calls for his mount.',16,0,100,22,0,0,7316,0,'Taelan Fordring'),
(@TAELAN,4,0,'It\'s not much further. The main road is just up ahead.',12,0,100,0,0,0,7329,0,'Taelan Fordring'),
(@TAELAN,5,0,'Isillien!',14,0,100,0,0,0,7370,0,'Taelan Fordring'),
(@TAELAN,6,0,'This is not your fight, stranger. Protect yourself from the attacks of the Crimson Elite. I shall battle the Grand Inquisitor.',12,0,100,0,0,0,7371,0,'Taelan Fordring'),
(@TIRION,0,0,'What have you done,  Isillien? You once fought with honor, for the good of our people... and now... you have murdered my boy... ',12,0,100,1,0,0,7372,0,'Lord Tirion Fordring'),
(@TIRION,1,0,'May your soul burn in anguish, Isillien! Light give me strength to battle this fiend.',12,0,100,15,0,0,7373,0,'Lord Tirion Fordring'),
(@TIRION,2,0,'Face me, coward. Face the faith and strength that you once embodied.',12,0,100,25,0,0,7374,0,'Lord Tirion Fordring'),
(@TIRION,3,0,'A thousand more like him exist. Ten thousand. Should one fall, another will rise to take the seat of power.',12,0,100,0,0,0,7420,0,'Lord Tirion Fordring'),
(@TIRION,4,0,'%s falls to one knee.',16,0,100,0,0,0,7421,0,'Lord Tirion Fordring'),
(@TIRION,5,0,'Look what they did to my boy.',12,0,100,5,0,0,7423,0,'Lord Tirion Fordring'),
(@TIRION,6,0,'Too long have I sat idle, gripped in this haze... this malaise, lamenting what could have been... what should have been.',12,0,100,0,0,0,7429,0,'Lord Tirion Fordring'),
(@TIRION,7,0,'Your death will not have been in vain, Taelan. A new Order is born on this day... an Order which will dedicate itself to extinguishing the evil that plagues this world. An evil that cannot hide behind politics and pleasantries.',12,0,100,0,0,0,7426,0,'Lord Tirion Fordring'),
(@TIRION,8,0,'This I promise... This I vow...',12,0,100,0,0,0,7430,0,'Lord Tirion Fordring');

-- SAI
-- E1840 Grand Inquisitor Isillien SAI
UPDATE `creature_template` SET `faction`=16, `AIName`='SmartAI', `ScriptName`='' WHERE entry=@ISILLIEN;

DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = @ISILLIEN);
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`, `comment`) VALUES
(@ISILLIEN, 0, 0, 0, 37, 0, 100, 0, 0, 0, 0, 0, 0, 80, 184000, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - On Initialize - Run Script'),
(@ISILLIEN, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 30000, 30000, 0, 11, 11647, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - In Combat - Cast \'Power Word: Shield\''),
(@ISILLIEN, 0, 2, 0, 0, 0, 100, 0, 3000, 3000, 8000, 9000, 0, 11, 17287, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - In Combat - Cast \'Mind Blast\''),
(@ISILLIEN, 0, 3, 0, 0, 0, 100, 0, 20000, 20000, 20000, 20000, 0, 11, 13639, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - In Combat - Cast \'Greater Health\''),
(@ISILLIEN, 0, 4, 0, 0, 0, 100, 0, 7000, 8000, 15000, 15000, 0, 11, 17314, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - In Combat - Cast \'Mind Flay\'');

-- E1840 Grand Inquisitor Isillien Actionlist 1
DELETE FROM `smart_scripts` WHERE (`source_type` = 9 AND `entryorguid` = @ISILLIEN*100);
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`, `comment`) VALUES
(@ISILLIEN*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Set Flags Immune To Players & Immune To NPC\'s'),
(@ISILLIEN*100, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 0'),
(@ISILLIEN*100, 9, 2, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 2677, -1917, 68, 2.1, 'Grand Inquisitor Isillien - Actionlist - Move To Position'),
(@ISILLIEN*100, 9, 3, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 1'),
(@ISILLIEN*100, 9, 4, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 2'),
(@ISILLIEN*100, 9, 5, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 3'),
(@ISILLIEN*100, 9, 6, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 4'),
(@ISILLIEN*100, 9, 7, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 5'),
(@ISILLIEN*100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 0, 2674, -1920, 68.41, 1.8, 'Grand Inquisitor Isillien - Actionlist - Summon Creature \'Crimson Elite\''),
(@ISILLIEN*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 0, 2684, -1918, 69.52, 2.2, 'Grand Inquisitor Isillien - Actionlist - Summon Creature \'Crimson Elite\''),
(@ISILLIEN*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 0, 2694, -1875, 66.86, 3.8, 'Grand Inquisitor Isillien - Actionlist - Summon Creature \'Crimson Elite\''),
(@ISILLIEN*100, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 0, 2693, -1869, 66.87, 3.9, 'Grand Inquisitor Isillien - Actionlist - Summon Creature \'Crimson Elite\''),
(@ISILLIEN*100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 0, 2697, -1879, 66.8, 3.8, 'Grand Inquisitor Isillien - Actionlist - Summon Creature \'Crimson Elite\''),
(@ISILLIEN*100, 9, 13, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 11, 12128, 100, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Set Data 1 1'),
(@ISILLIEN*100, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 19, 776, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Remove Flags PvP Attackable & Immune To Players & Immune To NPC\'s'),
(@ISILLIEN*100, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 1842, 30, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Start Attacking'),
(@ISILLIEN*100, 9, 16, 0, 0, 0, 100, 0, 45000, 45000, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 6'),
(@ISILLIEN*100, 9, 17, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Set Home Position'),
(@ISILLIEN*100, 9, 18, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, @DEATHSPELL, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Cast \'Taelan Death\''),
(@ISILLIEN*100, 9, 19, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Evade'),
(@ISILLIEN*100, 9, 20, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Set Flags Immune To Players & Immune To NPC\'s'),
(@ISILLIEN*100, 9, 21, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 7'),
(@ISILLIEN*100, 9, 22, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Say Line 8'),
(@ISILLIEN*100, 9, 23, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Remove Flags Immune To Players & Immune To NPC\'s'),
(@ISILLIEN*100, 9, 24, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 50, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - Actionlist - Start Attacking'),
(@ISILLIEN*100, 9, 25, 0, 0, 0, 100, 0, 25000, 25000, 0, 0, 0, 12, 12126, 4, 180000, 0, 0, 0, 8, 0, 0, 0, 0, 2642.8, -1913, 71.2, 0.4, 'Grand Inquisitor Isillien - Actionlist - Summon Creature \'Lord Tirion Fordring\'');

-- E1842 Highlord Taelan Fordring SAI
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = @TAELAN;

DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = @TAELAN);
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`, `comment`) VALUES
(@TAELAN, 0, 0, 0, 34, 0, 100, 0, 8, 16777215, 0, 0, 0, 43, 0, 2402, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Reached Point 16777215 - Mount To Model 2402'),
(@TAELAN, 0, 1, 0, 19, 0, 100, 0, 5944, 0, 0, 0, 0, 1, 0, 6000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Quest \'In Dreams\' Taken - Say Line 0'),
(@TAELAN, 0, 2, 0, 52, 0, 100, 1, 0, 1842, 0, 0, 0, 53, 1, 1842, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Text 0 Over - Start Waypoint (No Repeat)'),
(@TAELAN, 0, 3, 15, 11, 0, 100, 0, 0, 0, 0, 0, 0, 2, 67, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Respawn - Set Faction 67'),
(@TAELAN, 0, 4, 0, 4, 0, 100, 0, 0, 0, 0, 0, 0, 11, 17232, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Aggro - Cast \'Devotion Aura\''),
(@TAELAN, 0, 5, 0, 0, 0, 100, 0, 3000, 3000, 5000, 5000, 0, 11, 17281, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - In Combat - Cast \'Crusader Strike\''),
(@TAELAN, 0, 6, 0, 2, 0, 100, 0, 0, 20, 120000, 120000, 0, 11, 17233, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Between 0-20% Health - Cast \'Lay on Hands\''),
(@TAELAN, 0, 7, 8, 40, 0, 100, 0, 1, 0, 0, 0, 0, 1, 1, 6000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Waypoint 1 Reached - Say Line 1'),
(@TAELAN, 0, 8, 0, 61, 0, 100, 0, 1, 0, 0, 0, 0, 2, 42, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Waypoint 1 Reached - Set Faction 42'),
(@TAELAN, 0, 9, 10, 40, 0, 100, 0, 26, 0, 0, 0, 0, 54, 7000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Waypoint 26 Reached - Pause Waypoint'),
(@TAELAN, 0, 10, 0, 61, 0, 100, 0, 26, 0, 0, 0, 0, 1, 2, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Waypoint 26 Reached - Say Line 2'),
(@TAELAN, 0, 11, 0, 52, 0, 100, 0, 2, 0, 0, 0, 0, 1, 3, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Text 2 Over - Say Line 3'),
(@TAELAN, 0, 12, 0, 52, 0, 100, 0, 3, 0, 0, 0, 0, 43, 0, 2402, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Text 3 Over - Mount To Model 2402'),
(@TAELAN, 0, 13, 0, 40, 0, 100, 0, 74, 0, 0, 0, 0, 80, 184200, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Waypoint 74 Reached - Run Script'),
(@TAELAN, 0, 14, 0, 8, 0, 100, 0, @DEATHSPELL, 0, 0, 0, 0, 80, 184201, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Spellhit \'Taelan Death\' - Run Script'),
(@TAELAN, 0, 15, 16, 61, 0, 100, 0, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Respawn - Remove Flags Immune To Players & Immune To NPC\'s'),
(@TAELAN, 0, 16, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 91, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - On Respawn - Remove FlagStandstate Dead');

-- E1842 Taelan Actionlist 1
DELETE FROM `smart_scripts` WHERE (`source_type` = 9 AND `entryorguid` = @TAELAN*100);
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`, `comment`) VALUES
(@TAELAN*100, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Say Line 4'),
(@TAELAN*100, 9, 1, 0, 0, 0, 100, 0, 100, 100, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 21, 40, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Set Orientation Closest Player'),
(@TAELAN*100, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 12, 1840, 4, 120000, 0, 0, 0, 8, 0, 0, 0, 0, 2683.64, -1926.72, 72.14, 2, 'Highlord Taelan Fordring - Actionlist - Summon Creature \'Grand Inquisitor Isillien\''),
(@TAELAN*100, 9, 3, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Say Line 5'),
(@TAELAN*100, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Say Line 6'),
(@TAELAN*100, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Dismount'),
(@TAELAN*100, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Set Home Position'),
(@TAELAN*100, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 19, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Remove Flags PvP Attackable'),
(@TAELAN*100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 41, 300000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Taelan Fordring - Actionlist - Despawn In 300000 ms');

-- E1842 Taelan Actionlist 2
DELETE FROM `smart_scripts` WHERE (`source_type` = 9 AND `entryorguid` = @TAELAN*100+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`, `comment`) VALUES
(@TAELAN*100+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Evade'),
(@TAELAN*100+1, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Flag'),
(@TAELAN*100+1, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Byte 1');

-- E12126 Tirion Fordring SAI
UPDATE `creature_template` SET `unit_flags`=0, `faction`=35, `flags_extra`=2, `AIName`='SmartAI', `ScriptName`='' WHERE entry=@TIRION;

DELETE FROM `smart_scripts` WHERE (`entryorguid` = @TIRION) AND (`source_type` = 0) AND (`id` IN (0, 1, 2, 3, 4, 5, 6));
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`, `comment`) VALUES
(@TIRION, 0, 0, 1, 37, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - On Initialize - Set Reactstate Aggressive'),
(@TIRION, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 0, 43, 0, 2402, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - On Initialize - Mount To Model 2402'),
(@TIRION, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - On Initialize - Set Run On'),
(@TIRION, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - On Initialize - Set Npc Flag '),
(@TIRION, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 53, 1, 12126, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - On Initialize - Start Waypoint'),
(@TIRION, 0, 5, 0, 40, 0, 100, 0, 1, 0, 0, 0, 0, 80, 1212600, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - On Waypoint 1 Reached - Run Script'),
(@TIRION, 0, 6, 0, 7, 1, 100, 0, 0, 0, 0, 0, 0, 80, 1212601, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - On Evade - Run Script (Phase 1)');

-- E12126 Tirion Fordring Actionlist 1 - Talk and fight
DELETE FROM `smart_scripts` WHERE (`source_type` = 9 AND `entryorguid` = @TIRION*100);
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`, `comment`) VALUES
(@TIRION*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Set Home Position'),
(@TIRION*100, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Dismount'),
(@TIRION*100, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Set Flag Standstate Kneel'),
(@TIRION*100, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Remove FlagStandstate Kneel'),
(@TIRION*100, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Set Orientation Closest Creature \'Grand Inquisitor Isillien\''),
(@TIRION*100, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 1'),
(@TIRION*100, 9, 6, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 9, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 9'),
(@TIRION*100, 9, 7, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 2'),
(@TIRION*100, 9, 8, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 10, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 10'),
(@TIRION*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Remove Flags Immune To Players & Immune To NPC\'s'),
(@TIRION*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 2, 42, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Set Faction 42'),
(@TIRION*100, 9, 11, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Start Attacking'),
(@TIRION*100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Set Event Phase 1');

-- E12126 Tirion Fordring Actionlist 2 - After fight talk and quest complete
DELETE FROM `smart_scripts` WHERE (`source_type` = 9 AND `entryorguid` = @TIRION*100+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`, `comment`) VALUES
(@TIRION*100+1, 9, 0, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 3'),
(@TIRION*100+1, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 4'),
(@TIRION*100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Set Flag Standstate Kneel'),
(@TIRION*100+1, 9, 3, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 5'),
(@TIRION*100+1, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Remove FlagStandstate Kneel'),
(@TIRION*100+1, 9, 5, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 6'),
(@TIRION*100+1, 9, 6, 0, 0, 0, 100, 0, 9000, 9000, 0, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 7'),
(@TIRION*100+1, 9, 7, 0, 0, 0, 100, 0, 12000, 12000, 0, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Say Line 8'),
(@TIRION*100+1, 9, 8, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 15, 5944, 0, 0, 0, 0, 0, 18, 50, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Quest Credit \'In Dreams\''),
(@TIRION*100+1, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 81, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Actionlist - Set Npc Flags Questgiver');

-- E12128 Crimson Elite SAI
UPDATE `creature_template` SET `faction`=16, `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=@CRIMSON;

DELETE FROM `smart_scripts` WHERE (`entryorguid` = @CRIMSON) AND (`source_type` = 0) AND (`id` IN (0, 1, 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`, `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`, `comment`) VALUES
(@CRIMSON, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 9000, 10000, 0, 11, 17143, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Crimson Elite - In Combat - Cast \'Holy Strike\''),
(@CRIMSON, 0, 1, 0, 0, 0, 100, 0, 8000, 9000, 20000, 22000, 0, 11, 14518, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Crimson Elite - In Combat - Cast \'Crusader Strike\''),
(@CRIMSON, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 2674, -1906, 66.1, 5.3, 'Crimson Elite - On Data Set 1 1 - Move To Position');

-- Waypoints
DELETE FROM `waypoints` WHERE `entry`=@TIRION;
INSERT INTO `waypoints` VALUES 
(@TIRION, 1, 2667, -1899, 66.81, 'Tirion Fordring');

DELETE FROM `waypoints` WHERE `entry`=@TAELAN;
INSERT INTO `waypoints` VALUES 
(@TAELAN, 1, 2941.47, -1391.79, 167.237, 'Taelan Fordring'),
(@TAELAN, 2, 2940.59, -1393.34, 166.084, 'Taelan Fordring'),
(@TAELAN, 3, 2934.76, -1403.63, 165.943, 'Taelan Fordring'),
(@TAELAN, 4, 2932.09, -1408.34, 165.943, 'Taelan Fordring'),
(@TAELAN, 5, 2917.95, -1402.97, 165.943, 'Taelan Fordring'),
(@TAELAN, 6, 2919.7, -1398.38, 165.88, 'Taelan Fordring'),
(@TAELAN, 7, 2922.96, -1389.76, 160.89, 'Taelan Fordring'),
(@TAELAN, 8, 2925.9, -1386.68, 160.842, 'Taelan Fordring'),
(@TAELAN, 9, 2946.78, -1396.55, 160.842, 'Taelan Fordring'),
(@TAELAN, 10, 2948.71, -1392.82, 160.842, 'Taelan Fordring'),
(@TAELAN, 11, 2951.88, -1386.69, 155.974, 'Taelan Fordring'),
(@TAELAN, 12, 2953.8, -1383.23, 155.949, 'Taelan Fordring'),
(@TAELAN, 13, 2951.18, -1381.97, 155.949, 'Taelan Fordring'),
(@TAELAN, 14, 2946.54, -1379.57, 152.02, 'Taelan Fordring'),
(@TAELAN, 15, 2943.02, -1377.76, 152.02, 'Taelan Fordring'),
(@TAELAN, 16, 2935.55, -1392.66, 152.02, 'Taelan Fordring'),
(@TAELAN, 17, 2920.61, -1385.01, 152.02, 'Taelan Fordring'),
(@TAELAN, 18, 2915.23, -1395.37, 152.02, 'Taelan Fordring'),
(@TAELAN, 19, 2926.44, -1401.34, 152.03, 'Taelan Fordring'),
(@TAELAN, 20, 2930.45, -1403.49, 150.521, 'Taelan Fordring'),
(@TAELAN, 21, 2933.64, -1405.2, 150.521, 'Taelan Fordring'),
(@TAELAN, 22, 2930.83, -1412.74, 150.504, 'Taelan Fordring'),
(@TAELAN, 23, 2924.04, -1426.34, 150.781, 'Taelan Fordring'),
(@TAELAN, 24, 2917.27, -1439.65, 150.664, 'Taelan Fordring'),
(@TAELAN, 25, 2914.56, -1445.08, 149.505, 'Taelan Fordring'),
(@TAELAN, 26, 2911.01, -1452.17, 147.891, 'Taelan Fordring'),
(@TAELAN, 27, 2911.49, -1460.75, 147.348, 'Taelan Fordring'),
(@TAELAN, 28, 2915.27, -1471.79, 146.082, 'Taelan Fordring'),
(@TAELAN, 29, 2917.16, -1477.3, 146.179, 'Taelan Fordring'),
(@TAELAN, 30, 2937.93, -1475.79, 146.786, 'Taelan Fordring'),
(@TAELAN, 31, 2948.62, -1483.6, 146.287, 'Taelan Fordring'),
(@TAELAN, 32, 2950.48, -1502.29, 146.109, 'Taelan Fordring'),
(@TAELAN, 33, 2949.29, -1521.33, 146.274, 'Taelan Fordring'),
(@TAELAN, 34, 2950.6, -1538.69, 146.082, 'Taelan Fordring'),
(@TAELAN, 35, 2930.13, -1562.47, 145.785, 'Taelan Fordring'),
(@TAELAN, 36, 2916.36, -1578.33, 146.147, 'Taelan Fordring'),
(@TAELAN, 37, 2909.48, -1586.26, 146.515, 'Taelan Fordring'),
(@TAELAN, 38, 2902.06, -1590.55, 146.557, 'Taelan Fordring'),
(@TAELAN, 39, 2888.13, -1591.98, 145.702, 'Taelan Fordring'),
(@TAELAN, 40, 2876.43, -1591.6, 144.335, 'Taelan Fordring'),
(@TAELAN, 41, 2862.5, -1593.03, 142.511, 'Taelan Fordring'),
(@TAELAN, 42, 2846.46, -1603.03, 139.023, 'Taelan Fordring'),
(@TAELAN, 43, 2836.07, -1612.41, 135.225, 'Taelan Fordring'),
(@TAELAN, 44, 2827.58, -1620.07, 132.012, 'Taelan Fordring'),
(@TAELAN, 45, 2820.52, -1623.16, 131.22, 'Taelan Fordring'),
(@TAELAN, 46, 2804.83, -1620.19, 129.717, 'Taelan Fordring'),
(@TAELAN, 47, 2791.11, -1617.4, 129.693, 'Taelan Fordring'),
(@TAELAN, 48, 2780.39, -1615.9, 129.044, 'Taelan Fordring'),
(@TAELAN, 49, 2773.01, -1623.84, 128.074, 'Taelan Fordring'),
(@TAELAN, 50, 2766.04, -1631.69, 127.927, 'Taelan Fordring'),
(@TAELAN, 51, 2759.06, -1639.54, 128.336, 'Taelan Fordring'),
(@TAELAN, 52, 2752.08, -1647.38, 127.494, 'Taelan Fordring'),
(@TAELAN, 53, 2745.11, -1655.23, 126.277, 'Taelan Fordring'),
(@TAELAN, 54, 2738.13, -1663.08, 126.679, 'Taelan Fordring'),
(@TAELAN, 55, 2732.03, -1674.53, 126.673, 'Taelan Fordring'),
(@TAELAN, 56, 2725.5, -1682.87, 126.414, 'Taelan Fordring'),
(@TAELAN, 57, 2717.98, -1692.7, 126.476, 'Taelan Fordring'),
(@TAELAN, 58, 2713.38, -1700, 125.79, 'Taelan Fordring'),
(@TAELAN, 59, 2703.08, -1714.3, 122.214, 'Taelan Fordring'),
(@TAELAN, 60, 2694.95, -1729.79, 117.559, 'Taelan Fordring'),
(@TAELAN, 61, 2689.65, -1745.97, 112.656, 'Taelan Fordring'),
(@TAELAN, 62, 2689.05, -1763.33, 106.147, 'Taelan Fordring'),
(@TAELAN, 63, 2690.09, -1774.06, 102.238, 'Taelan Fordring'),
(@TAELAN, 64, 2691.45, -1786.18, 97.3156, 'Taelan Fordring'),
(@TAELAN, 65, 2692.17, -1800.16, 90.1386, 'Taelan Fordring'),
(@TAELAN, 66, 2692.7, -1810.65, 85.387, 'Taelan Fordring'),
(@TAELAN, 67, 2697.55, -1818.24, 81.7822, 'Taelan Fordring'),
(@TAELAN, 68, 2700.73, -1829.26, 76.4334, 'Taelan Fordring'),
(@TAELAN, 69, 2699.39, -1845.15, 71.4784, 'Taelan Fordring'),
(@TAELAN, 70, 2696.58, -1856.38, 68.2104, 'Taelan Fordring'),
(@TAELAN, 71, 2694.06, -1870.35, 66.9045, 'Taelan Fordring'),
(@TAELAN, 72, 2693.26, -1873.62, 66.8413, 'Taelan Fordring'),
(@TAELAN, 73, 2675.36, -1891.94, 66.1742, 'Taelan Fordring'),
(@TAELAN, 74, 2669.33, -1898.11, 66.7004, 'Taelan Fordring');

-- Conditions
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=@TAELAN;
INSERT INTO `conditions` VALUES 
(22, 1, @TAELAN, 0, 0, 23, 1, 203, 0, 0, 1, 0, 0, '', 'Dont run action in specific area');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@DEATHSPELL;
INSERT INTO `conditions` VALUES 
(13, 1, @DEATHSPELL, 0, 0, 31, 0, 3, @TAELAN, 0, 0, 0, 0, '', 'Target Taelan');