[Quest][3.3.5a] In Dreams Fix

TerrorBringer commented 7 years ago

Here's the fix for quest http://www.wowhead.com/quest=5944/in-dreams which I ported from SunwellCore (https://github.com/Kittnz/Sunwell) and fixed the errors. All credits goes to everyone involved in SunwellCore and its contributors.

-- In Dreams (5944)

DELETE FROM creature_questender WHERE id=12126;
INSERT INTO creature_questender VALUES
(12126, 5944);

DELETE FROM creature_text WHERE entry IN(1840, 1842, 12126);
INSERT INTO creature_text VALUES
(1842, 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, 0, 0,  'Taelan Fordring'),
(1842, 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, 0, 0,  'Taelan Fordring'),
(1842, 2, 0, "Halt.", 12, 0, 100, 0, 0, 0, 0, 0,  'Taelan Fordring'),
(1842, 3, 0, "Highlord Taelan Fordring calls for his mount.", 16, 0, 100, 22, 0, 0, 0, 0,  'Taelan Fordring'),
(1842, 4, 0, "It's not much further. The main road is just up ahead.", 12, 0, 100, 0, 0, 0, 0, 0,  'Taelan Fordring'),
(1842, 5, 0, "Isillien!", 14, 0, 100, 0, 0, 0, 0, 0,  'Taelan Fordring'),
(1842, 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, 0, 0,  'Taelan Fordring'),
(1840, 0, 0, "You will not make it to the forest's edge, Fordring.", 12, 0, 100, 0, 0, 0, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 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, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 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, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 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, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 4, 0, "Grand Inquisitor Isillien calls for his guardsman.", 16, 0, 100, 22, 0, 0, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 5, 0, "The end is now, Fordring.", 12, 0, 100, 0, 0, 0, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 6, 0, "Enough!", 12, 0, 100, 0, 0, 0, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 7, 0, "Grand Inquisitor Isillien laughs.", 16, 0, 100, 11, 0, 0, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 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, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 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, 0, 0,  'Grand Inquisitor Isillien'),
(1840, 10, 0, "Then come, hermit!", 12, 0, 100, 0, 0, 0, 0, 0,  'Grand Inquisitor Isillien'),
(12126, 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, 0, 0,  'Lord Tirion Fordring'),
(12126, 1, 0, "May your soul burn in anguish, Isillien! Light give me strength to battle this fiend.", 12, 0, 100, 15, 0, 0, 0, 0,  'Lord Tirion Fordring'),
(12126, 2, 0, "Face me, coward. Face the faith and strength that you once embodied.", 12, 0, 100, 25, 0, 0, 0, 0,  'Lord Tirion Fordring'),
(12126, 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, 0, 0,  'Lord Tirion Fordring'),
(12126, 4, 0, "Lord Tirion Fordring falls to one knee.", 16, 0, 100, 0, 0, 0, 0, 0,  'Lord Tirion Fordring'),
(12126, 5, 0, "Look what they did to my boy.", 12, 0, 100, 5, 0, 0, 0, 0,  'Lord Tirion Fordring'),
(12126, 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, 0, 0,  'Lord Tirion Fordring'),
(12126, 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 extinguising the evil that plagues this world. An evil that cannot hide behind politics and pleasantries.", 12, 0, 100, 0, 0, 0, 0, 0,  'Lord Tirion Fordring'),
(12126, 8, 0, "This I promise... This I vow...", 12, 0, 100, 0, 0, 0, 0, 0,  'Lord Tirion Fordring');

UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=1842;
UPDATE creature_template SET faction=16, AIName='SmartAI', ScriptName='' WHERE entry=1840;
DELETE FROM smart_scripts WHERE entryorguid IN(1842, 1840, 12126, 12128) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid IN(1842*100, 1842*100+1, 1840*100, 12126*100, 12126*100+1) AND source_type=9;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=1842 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 
(1842, 0, 0, 0, 34, 0, 100, 0, 8, 16777215, 0, 0, 43, 0, 2402, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Movement Inform - Mount"),
(1842, 0, 1, 0, 19, 0, 100, 0, 5944, 0, 0, 0, 1, 0, 6000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Quest Accept - Talk"),
(1842, 0, 2, 0, 52, 0, 100, 1, 0, 1842, 0, 0, 53, 1, 1842, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, "On Text Over - WP Start"),
(1842, 0, 3, 15, 11, 0, 100, 0, 0, 0, 0, 0, 2, 67, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Respawn - Set Faction"),
(1842, 0, 4, 0, 4, 0, 100, 0, 0, 0, 0, 0, 11, 17232, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Aggro - Cast Spell"),
(1842, 0, 5, 0, 0, 0, 100, 0, 3000, 3000, 5000, 5000, 11, 17281, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "IC Update - Cast Spell"),
(1842, 0, 6, 0, 2, 0, 100, 0, 0, 20, 120000, 120000, 11, 17233, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On HP Update - Cast Spell"),
(1842, 0, 7, 8, 40, 0, 100, 0, 1, 0, 0, 0, 1, 1, 6000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On WP Reach - Talk"),
(1842, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 2, 42, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Quest Accept - Set Faction"),
(1842, 0, 9, 10, 40, 0, 100, 0, 26, 0, 0, 0, 54, 7000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On WP Reach - WP Pause"),
(1842, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 2, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On WP Reach - Talk"),
(1842, 0, 11, 0, 52, 0, 100, 0, 2, 0, 0, 0, 1, 3, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Text Over - Talk"),
(1842, 0, 12, 0, 52, 0, 100, 0, 3, 0, 0, 0, 43, 0, 2402, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Text Over - Mount"),
(1842, 0, 13, 0, 40, 0, 100, 0, 74, 0, 0, 0, 80, 184200, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On WP Reach - Script9"),
(1842, 0, 14, 0, 8, 0, 100, 0, 18969, 0, 0, 0, 80, 184201, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Spell Hit - Script9"),
(1842, 0, 15, 16, 61, 0, 100, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Respawn - Remove Flag"),
(1842, 0, 16, 0, 61, 0, 100, 0, 0, 0, 0, 0, 91, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Respawn - Remove Byte 1"),
(1842*100, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1842*100, 9, 1, 0, 0, 0, 100, 0, 100, 100, 0, 0, 66, 0, 0, 0, 0, 0, 0, 21, 40, 0, 0, 0, 0, 0, 0, 'Script9 - Set Orientation'),
(1842*100, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 12, 1840, 4, 120000, 0, 0, 0, 8, 0, 0, 0, 2683.64, -1926.72, 72.14, 2.0, 'Script9 - Summon Creature'),
(1842*100, 9, 3, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1842*100, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1842*100, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Dismount'),
(1842*100, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Home Position'),
(1842*100, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 19, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Remove Flag'),
(1842*100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 300000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Despawn'),
(1842*100+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Evade'),
(1842*100+1, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 18, 256+512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Flag'),
(1842*100+1, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Byte 1'),
(1840, 0, 0, 0, 37, 0, 100, 0, 0, 0, 0, 0, 80, 1840*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On AI Init - Script9'),
(1840, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 30000, 30000, 11, 11647, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'IC Update - Cast Spell'),
(1840, 0, 2, 0, 0, 0, 100, 0, 3000, 3000, 8000, 9000, 11, 17287, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'IC Update - Cast Spell'),
(1840, 0, 3, 0, 0, 0, 100, 0, 20000, 20000, 20000, 20000, 11, 13639, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'IC Update - Cast Spell'),
(1840, 0, 4, 0, 0, 0, 100, 0, 7000, 8000, 15000, 15000, 11, 17314, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'IC Update - Cast Spell'),
(1840*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 18, 256+512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Flag'),
(1840*100, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 2, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 2677, -1917, 68, 2.1, 'Script9 - Move To Pos'),
(1840*100, 9, 3, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 4, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 5, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 6, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 7, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 2674, -1920, 68.41, 1.8, 'Script9 - Summon Creature'),
(1840*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 2684, -1918, 69.52, 2.2, 'Script9 - Summon Creature'),
(1840*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 2694, -1875, 66.86, 3.8, 'Script9 - Summon Creature'),
(1840*100, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 2693, -1869, 66.87, 3.9, 'Script9 - Summon Creature'),
(1840*100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 12128, 4, 40000, 0, 0, 0, 8, 0, 0, 0, 2697, -1879, 66.8, 3.8, 'Script9 - Summon Creature'),
(1840*100, 9, 13, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 45, 1, 1, 0, 0, 0, 0, 11, 12128, 100, 0, 0, 0, 0, 0, 'Script9 - Set Data'),
(1840*100, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 19, 256+512+8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Remove Flag'),
(1840*100, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 1842, 30, 0, 0, 0, 0, 0, 'Script9 - Attack Start'),
(1840*100, 9, 16, 0, 0, 0, 100, 0, 45000, 45000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 17, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Home Pos'),
(1840*100, 9, 18, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 18969, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Cast Spell'),
(1840*100, 9, 19, 0, 0, 0, 100, 0, 500, 500, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Evade'),
(1840*100, 9, 20, 0, 0, 0, 100, 0, 0, 0, 0, 0, 18, 256+512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Flag'),
(1840*100, 9, 21, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 22, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(1840*100, 9, 23, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 19, 256+512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Remove Flag'),
(1840*100, 9, 24, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 50, 0, 0, 0, 0, 0, 0, 'Script9 - Attack Start'),
(1840*100, 9, 25, 0, 0, 0, 100, 0, 25000, 25000, 0, 0, 12, 12126, 4, 180000, 0, 0, 0, 8, 0, 0, 0, 2642.8, -1913, 71.2, 0.4, 'Script9 - Summon Creature'),
(12126, 0, 0, 1, 37, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On AI Init - Set Flag'),
(12126, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 43, 0, 2402, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On AI Init - Mount'),
(12126, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On AI Init - Set Run'),
(12126, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On AI Init - Set NPC Flag'),
(12126, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 1, 12126, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On AI Init - Start Escort'),
(12126, 0, 5, 0, 40, 0, 100, 0, 1, 0, 0, 0, 80, 12126*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On MovementInform - Script9'),
(12126, 0, 6, 0, 7, 1, 100, 0, 0, 0, 0, 0, 80, 12126*100+1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Evade - Script9 out of combat'),
(12126*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Home Position'),
(12126*100, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 43, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Dismount'),
(12126*100, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Byte 1'),
(12126*100, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Remove Byte 1'),
(12126*100, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 'Script9 - Set Orientation'),
(12126*100, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100, 9, 6, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 9, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100, 9, 7, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100, 9, 8, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 10, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 19, 256+512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Remove Flag'),
(12126*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 42, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Faction'),
(12126*100, 9, 11, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 1840, 50, 0, 0, 0, 0, 0, 'Script9 - Attack Start'),
(12126*100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Phase'),
(12126*100+1, 9, 0, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100+1, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Byte 1'),
(12126*100+1, 9, 3, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100+1, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Remove Byte 1'),
(12126*100+1, 9, 5, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100+1, 9, 6, 0, 0, 0, 100, 0, 9000, 9000, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100+1, 9, 7, 0, 0, 0, 100, 0, 12000, 12000, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(12126*100+1, 9, 8, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 15, 5944, 0, 0, 0, 0, 0, 18, 50, 0, 0, 0, 0, 0, 0, 'Script9 - Area Explored'),
(12126*100+1, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 81, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set NPC Flag'),
(12128, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 9000, 10000, 11, 17143, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'IC Update - Cast Spell'),
(12128, 0, 1, 0, 0, 0, 100, 0, 8000, 9000, 20000, 22000, 11, 14518, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'IC Update - Cast Spell'),
(12128, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 2674, -1906, 66.1, 5.3, 'On Data Set - Move To Pos');

DELETE FROM waypoints WHERE entry=12126;
INSERT INTO waypoints VALUES 
(12126, 1, 2667, -1899, 66.81, 'Taelan Fordring');

UPDATE creature_template SET unit_flags=0, faction=35, flags_extra=2, AIName='SmartAI', ScriptName='' WHERE entry=12126;
UPDATE creature_template SET faction=16, AIName='SmartAI', ScriptName='' WHERE entry=12128;

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

DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry=18969;
INSERT INTO conditions VALUES 
(13, 1, 18969, 0, 0, 31, 0, 3, 1842, 0, 0, 0, 0, '', 'Target Taelan');

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

Win 8.1 x64 90a5811

Rushor commented 7 years ago

UPDATE creature_template SET unit_flags=0, faction=35, flags_extra=2, AIName='SmartAI', ScriptName='' WHERE entry=12126;

the factionchange is confirmed by sniffs?

Killyana commented 7 years ago

No, In Sunwell core they hacks the faction very often, also blizzard use the faction 250 for escort quests if a faction change is required.

Killyana commented 6 years ago

Waiting for the waypoint system to be fixed before finishing the script.

sirikfoll commented 5 years ago

Updated texts with BroadcastTextId

DELETE FROM `creature_text` WHERE `CreatureID` IN (1840, 1842, 12126);
INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES 
(1840,0,0,'You will not make it to the forest\'s edge, Fordring.',12,0,100,0,0,0,7395,0,'Grand Inquisitor Isillien'),
(1840,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'),
(1840,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'),
(1840,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'),
(1840,4,0,'%s calls for his guardsmen.',16,0,100,22,0,0,7360,0,'Grand Inquisitor Isillien'),
(1840,5,0,'The end is now, Fordring.',12,0,100,0,0,0,7361,0,'Grand Inquisitor Isillien'),
(1840,6,0,'Enough!',12,0,100,0,0,0,7381,0,'Grand Inquisitor Isillien'),
(1840,7,0,'%s laughs.',16,0,100,11,0,0,7382,0,'Grand Inquisitor Isillien'),
(1840,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'),
(1840,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'),
(1840,10,0,'Then come, hermit!',12,0,100,0,0,0,7436,0,'Grand Inquisitor Isillien'),
(1842,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'),
(1842,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'),
(1842,2,0,'Halt.',12,0,100,0,0,0,7315,0,'Taelan Fordring'),
(1842,3,0,'%s calls for his mount.',16,0,100,22,0,0,7316,0,'Taelan Fordring'),
(1842,4,0,'It\'s not much further. The main road is just up ahead.',12,0,100,0,0,0,7329,0,'Taelan Fordring'),
(1842,5,0,'Isillien!',14,0,100,0,0,0,7370,0,'Taelan Fordring'),
(1842,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'),
(12126,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'),
(12126,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'),
(12126,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'),
(12126,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'),
(12126,4,0,'%s falls to one knee.',16,0,100,0,0,0,7421,0,'Lord Tirion Fordring'),
(12126,5,0,'Look what they did to my boy.',12,0,100,5,0,0,7423,0,'Lord Tirion Fordring'),
(12126,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'),
(12126,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'),
(12126,8,0,'This I promise... This I vow...',12,0,100,0,0,0,7430,0,'Lord Tirion Fordring');

soniczhang11 commented 5 years ago

Confirmed by 401777d024785c58f90947cfdadd9b1b7d8fbd3b

Jinnaix commented 4 years ago

Just a quick feedback especially for when @Killyana may look over this again : I tested this a few weeks ago and it worked quite good up to the point where old Fordring should attack Grand Inquisitor Isillien- he doesnt. Still completeable anyway when you kill Isillien yourself.

ghost commented 4 years ago

Maybe the faction hack is removed, but not substituted with any working replacement?

Jinnaix commented 4 years ago

Ive formatted this into a more readable version:

https://gist.github.com/Jinnaix/bf50bf5a1b5f40a10c917a75c24ecb22

There are a few problems left:

[ ] SmartAIMgr: Entry 1842 SourceType 0 Event 11 Action 1 using non-existent Text id 2, skipped.
[ ] SmartAIMgr: Entry 1842 SourceType 0 Event 12 Action 43 using non-existent Text id 3, skipped.
[ ] Taelan Fordring sometimes doesnt mount after leaving the barracks
[ ] After being hit by the deathspell, Taelan Fordrings HP bar is shown as full, afaik it should show as empty.
[ ] Tirion Fordring cant attack Grand Inquisitor Isillien
[ ] the faction changes are questionable

But summed up, the quest works if you are able to kill Grand Inquisitor Isillien on your own.

Maybe @offl can give this a final touch?

dr-j commented 4 years ago

These are changes I made to this script the below was applied after the above

DELETE FROM `smart_scripts` WHERE `entryorguid`IN (1840,1842) AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`IN (184000,184200,184201) AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE `entryorguid`=12126 AND `source_type`=0 AND `id`IN(7,8,9,10);
DELETE FROM `smart_scripts` WHERE `entryorguid`=12128 AND `source_type`=0 AND `id`IN(3);

UPDATE `smart_scripts` SET `target_param2`='0' WHERE  `entryorguid`=1212600 AND `source_type`=9 AND `id`=11 AND `link`=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`, `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 
(1840, 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, 'On AI Init - Script9'),
(1840, 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, 'IC Update - Cast Spell'),
(1840, 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, 'IC Update - Cast Spell'),
(1840, 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, 'IC Update - Cast Spell'),
(1840, 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, 'IC Update - Cast Spell'),
(1842, 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, 'On Movement Inform - Mount'),
(1842, 0, 1, 17, 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, 'On Quest Accept - Talk'),
(1842, 0, 2, 0, 52, 0, 100, 1, 0, 1842, 0, 0, 0, 53, 0, 1842, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Text Over - WP Start'),
(1842, 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, 'On Respawn - Set Faction'),
(1842, 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, 'On Aggro - Cast Spell'),
(1842, 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, 'IC Update - Cast Spell'),
(1842, 0, 6, 0, 2, 0, 100, 0, 0, 10, 20000, 40000, 0, 11, 17233, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On HP Update - Cast Spell'),
(1842, 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, 'On WP Reach - Talk'),
(1842, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Quest Accept - Set Faction'),
(1842, 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, 'On WP Reach - WP Pause'),
(1842, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 2, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On WP Reach - Talk'),
(1842, 0, 11, 0, 52, 0, 100, 0, 2, 1842, 0, 0, 0, 1, 3, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Text Over - Talk'),
(1842, 0, 12, 27, 52, 0, 100, 0, 3, 1842, 0, 0, 0, 43, 0, 2402, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Text Over - Mount'),
(1842, 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, 'On WP Reach - Script9'),
(1842, 0, 14, 0, 8, 0, 100, 0, 18969, 0, 0, 0, 0, 80, 184201, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Spell Hit - Script9'),
(1842, 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, 'On Respawn - Remove Flag'),
(1842, 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, 'On Respawn - Remove Byte 1'),
(1842, 0, 17, 18, 61, 0, 100, 0, 0, 0, 0, 0, 0, 2, 67, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Quest Accept - Set Faction'),
(1842, 0, 18, 19, 61, 0, 100, 0, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Quest Accept - Set Active'),
(1842, 0, 19, 20, 61, 0, 100, 0, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Quest Accept - Allow Auto Attack'),
(1842, 0, 20, 21, 61, 0, 100, 0, 0, 0, 0, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Quest Accept - Allow Combat Movement'),
(1842, 0, 21, 26, 61, 0, 100, 0, 0, 0, 0, 0, 0, 8, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Quest Accept - Set Aggresive'),
(1842, 0, 22, 0, 40, 0, 100, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Reached WP (any) update home position'),
(1842, 0, 23, 0, 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, 'On Spawn Set Faction'),
(1842, 0, 24, 0, 9, 0, 100, 0, 0, 5, 5000, 9000, 0, 11, 18819, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Range - Cast'),
(1842, 0, 25, 0, 9, 0, 100, 0, 0, 10, 15000, 25000, 0, 11, 18810, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Range Cast'),
(1842, 0, 26, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 42, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Quest Acceot - Set Invincibility HP'),
(1842, 0, 27, 0, 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, 'On Text Over - Set Run On'),
(12126, 0, 7, 0, 9, 0, 100, 0, 0, 5, 5000, 9000, 0, 11, 18819, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Range - Cast'),
(12126, 0, 8, 0, 2, 0, 100, 0, 0, 10, 20000, 40000, 0, 11, 17233, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On HP Update - Cast Spell'),
(12126, 0, 9, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Spawn - Set Flags'),
(12126, 0, 10, 0, 4, 0, 100, 0, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 11, 12128, 100, 0, 0, 0, 0, 0, 0, 'On Spawn - Set Flags'),
(12128, 0, 3, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 25, 100, 0, 0, 0, 0, 0, 0, 0, 'OOC - Attack Closest Enemy'),
(184000, 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, 'Script9 - Set Flag'),
(184000, 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, 'Script9 - Talk'),
(184000, 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, 'Script9 - Move To Pos'),
(184000, 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, 'Script9 - Talk'),
(184000, 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, 'Script9 - Talk'),
(184000, 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, 'Script9 - Talk'),
(184000, 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, 'Script9 - Talk'),
(184000, 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, 'Script9 - Talk'),
(184000, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 300000, 0, 0, 0, 8, 0, 0, 0, 0, 2674, -1920, 68.41, 1.8, 'Script9 - Summon Creature'),
(184000, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 300000, 0, 0, 0, 8, 0, 0, 0, 0, 2684, -1918, 69.52, 2.2, 'Script9 - Summon Creature'),
(184000, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 300000, 0, 0, 0, 8, 0, 0, 0, 0, 2694, -1875, 66.86, 3.8, 'Script9 - Summon Creature'),
(184000, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 300000, 0, 0, 0, 8, 0, 0, 0, 0, 2693, -1869, 66.87, 3.9, 'Script9 - Summon Creature'),
(184000, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 12128, 4, 300000, 0, 0, 0, 8, 0, 0, 0, 0, 2697, -1879, 66.8, 3.8, 'Script9 - Summon Creature'),
(184000, 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, 'Script9 - Set Data'),
(184000, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 19, 774, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Remove Flag'),
(184000, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 1842, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Attack Start'),
(184000, 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, 'IC (Phase 1/No repeat) - Say Line 6'),
(184000, 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, 'IC (Phase 1/No repeat)  - Set Home Pos'),
(184000, 9, 18, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 18969, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'IC (Phase 1/No repeat)  - Cast Spell'),
(184000, 9, 19, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Evade'),
(184000, 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, 'Script9 - Set Flag'),
(184000, 9, 21, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Talk'),
(184000, 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, 'Script9 - Talk'),
(184000, 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, 'Script9 - Remove Flag'),
(184000, 9, 24, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 100, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Attack Start'),
(184000, 9, 25, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 12, 12126, 4, 180000, 0, 0, 0, 8, 0, 0, 0, 0, 2642.8, -1913, 71.2, 0.4, 'Script9 - Summon Creature'),
(184200, 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, 'Script9 - Talk'),
(184200, 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, 'Script9 - Set Orientation'),
(184200, 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, 'Script9 - Summon Creature'),
(184200, 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, 'Script9 - Talk'),
(184200, 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, 'Script9 - Talk'),
(184200, 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, 'Script9 - Dismount'),
(184200, 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, 'Script9 - Set Home Position'),
(184200, 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, 'Script9 - Remove Flag'),
(184200, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 41, 450000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Despawn'),
(184201, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Passive'),
(184201, 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'),
(184201, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Set Byte 1'),
(184201, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Script9 - Die');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=18811;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 18811, 0, 0, 31, 0, 4, 0, 0, 1, 0, 0, '', 'Taelans Suffering Effect not hit Player'),
(13, 1, 18811, 0, 0, 31, 0, 3, 1842, 0, 1, 0, 0, '', 'Taelans Suffering Effect does not hit Taelan');

DELETE FROM `smart_scripts` WHERE `entryorguid`=1840 AND `source_type`=0 AND `id` IN(5,6) AND `link`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=12126 AND `source_type`=0 AND `id`=11 AND `link`=0;
UPDATE `smart_scripts` SET `link`='11' WHERE  `entryorguid`=12126 AND `source_type`=0 AND `id`=10 AND `link`=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`, `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 
(1840, 0, 5, 0, 54, 0, 100, 0, 0, 0, 0, 0, 0, 42, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - On Just Summoned - Set Invincibility HP ON'),
(1840, 0, 6, 0, 38, 0, 100, 0, 6, 6, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Inquisitor Isillien - On Data Set - Set Invincibility HP OFF'),
(12126, 0, 11, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 6, 6, 0, 0, 0, 0, 19, 1840, 0, 0, 0, 0, 0, 0, 0, 'Lord Tirion Fordring - Linked with Previous Event - Set Data 6 6 to Grand Inquisitor Isillien');

comments are crap I know I just used existing comment style

ghost commented 4 years ago

@dr-j : I have not tested any of this yet, but did you manage to get less DB errors than @Jinnaix with your SQL added?

I tried to troubleshoot the SQL in Jinnaix's gist, but I got stuck on the first 2 error lines, so I don't know what the cause is.

dr-j commented 4 years ago

I currently have no errors from this script but cant remember much about this ive been sitting on this for about 9 months however as said original still needs applying first as was used as base

LEO33SoFo commented 3 years ago

This quest is still bugged, having the same problem as the issue #23553, as of 9d959123e68020a83c780f53a967b3589cb70786.

dr-j commented 3 years ago

There still has been no commit for this quest and nothing has changed yet in so why would it not still be bugged

ghost commented 3 years ago

@offl : Would you like to have a look at the suggested solutions and see if any or all of it can be used?

Jinnaix commented 3 years ago

For anyone interested, this is my current state of the quest that i am using now:

https://gist.github.com/Jinnaix/347ecc74b3e546c608fe465dd3fcb415

/Edit: Updated the gist after @offl gave me some tips (thank you). Most errors are now gone.

The current move_run speed of some creatures involved (Crimson Elite, Taelan, Isillien...) seems to be wrong. I didn't touch them. Mounting with SAI works good, telling a creature to stop mounting again is another topic... Quest is fully complete-able and i also implemented a safety switch to prevent a group of people nuking Isillien in the first fight phase (this would bug the quest).

NOTE: I use set active in this script for Taelan. Without this, the script has a high potential to get stuck and Taelan will never return if the invoking player decides to stop/disconnect/interrupt this quest.

For a fast way to test this quest, i suggest the following: Apply SQL to your world database .gm on .cheat god .quest add 5862 .go c id 1842 turn in 5862 at c id 1842 accept in dreams 5944 wait 6 seconds .gm off have fun

Surggurrian commented 3 years ago

For anyone interested, this is my current state of the quest that i am using now:

https://gist.github.com/Jinnaix/347ecc74b3e546c608fe465dd3fcb415

/Edit: Updated the gist after @offl gave me some tips (thank you). Most errors are now gone.

The current move_run speed of some creatures involved (Crimson Elite, Taelan, Isillien...) seems to be wrong. I didn't touch them. Mounting with SAI works good, telling a creature to stop mounting again is another topic... Quest is fully complete-able and i also implemented a safety switch to prevent a group of people nuking Isillien in the first fight phase (this would bug the quest).

NOTE: I use set active in this script for Taelan. Without this, the script has a high potential to get stuck and Taelan will never return if the invoking player decides to stop/disconnect/interrupt this quest.

For a fast way to test this quest, i suggest the following: Apply SQL to your world database .gm on .cheat god .quest add 5862 .go c id 1842 turn in 5862 at c id 1842 accept in dreams 5944 wait 6 seconds .gm off have fun

It's working. Finally, I can complete this quest normally, the only problem is the moving speed of Taelan is really fast.

TQPS commented 3 years ago

Came here to log the issue regarding the quest.

Before adding this fix, when a final fix is implemented, will it override/modify the values used here or create additional/different ones requiring that this fix be removed first?

Jinnaix commented 3 years ago

Came here to log the issue regarding the quest.

Before adding this fix, when a final fix is implemented, will it override/modify the values used here or create additional/different ones requiring that this fix be removed first?

Most likely overwrite if you pick this fix for now. Or, to be specific, delete old code and insert new code.

TQPS commented 3 years ago

Thanks for that. I'll give it a shot.

Much appreciated.

TQPS commented 3 years ago

Worked perfectly. I didn't have any speed issues on my end. The quest and pace were executed great!

I took 2 bots with me so we managed to save him but of course, he's meant to fail.

![image](https://user-images.githubusercontent.com/66294837/130949558-b357fb93-a798-426e-b46d-7ef4809bff0c.png)

Thanks again for this.

Jinnaix commented 3 years ago

Hmm... Should not be possible. Isillien is invulnerable untill he hits Taelan with the death spell and Taelan must die when he got hit by it. Might need to rework this once more... But not today.

Anyway, good to see people using it, i hope you had fun.

TQPS commented 2 years ago

Recent commit changes are now causing the following to be logged to DBErrors if this script is implemented:

SmartAIMgr: Unused action_type(19), event_type(61), Entry 1842 SourceType 0 Event 5, skipped.
SmartAIMgr: Unused action_type(18), event_type(1), Entry 184000 SourceType 9 Event 0, skipped.
SmartAIMgr: Unused action_type(19), event_type(1), Entry 184000 SourceType 9 Event 14, skipped.
SmartAIMgr: Unused action_type(18), event_type(1), Entry 184000 SourceType 9 Event 21, skipped.
SmartAIMgr: Unused action_type(19), event_type(1), Entry 184000 SourceType 9 Event 25, skipped.
SmartAIMgr: Unused action_type(19), event_type(1), Entry 184200 SourceType 9 Event 8, skipped.
SmartAIMgr: Unused action_type(19), event_type(1), Entry 1212600 SourceType 9 Event 7, skipped.
SmartAIMgr::LoadSmartAIFromDB: Entry 1842 SourceType 0, Event 4, Link Event 5 not found or invalid.
SmartAIMgr::LoadSmartAIFromDB: Entry 1842 SourceType 0, Event 6, Link Source Event not found or invalid. Event will never trigger.

ASBaj commented 1 year ago

Thought I'd drop in and say that I tested the script proposed by @dr-j on the latest 3.3.5 build, and it works quite well. I did not have any of the issues others have reported. Someone should look into merging this into the 3.3.5 branch.

TrinityCore / TrinityCore

[Quest][3.3.5a] In Dreams Fix #18601