Trinitycore: [Quest][3.3.5a] In Dreams Fix

Created on 26 Dec 2016 · 14Comments · Source: TrinityCore/TrinityCore

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.

```sql
-- 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(1842100, 1842100+1, 1840100, 12126100, 12126100+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"),
(1842100, 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'),
(1842100, 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'),
(1842100, 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'),
(1842100, 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'),
(1842100, 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'),
(1842100, 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'),
(1842100, 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'),
(1842100, 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'),
(1842100, 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'),
(1842100+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'),
(1842100+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'),
(1842100+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, 1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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'),
(1840100, 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, 12126100, 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, 12126100+1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Evade - Script9 out of combat'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100, 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'),
(12126100+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'),
(12126100+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'),
(12126100+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'),
(12126100+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'),
(12126100+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'),
(12126100+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'),
(12126100+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'),
(12126100+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'),
(12126100+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

Branch-3.3.5a Comp-Core Feedback-FixOutdatedMissingWIP

Source

TerrorBringer

All 14 comments

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

the factionchange is confirmed by sniffs?

Rushor on 28 Dec 2016

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 on 28 Dec 2016

👍1

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

Killyana on 5 Nov 2017

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');

sirikfoll on 21 Mar 2019

👍1

Confirmed by 401777d024785c58f90947cfdadd9b1b7d8fbd3b

soniczhang11 on 2 Jul 2019

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.

Jinnaix on 10 Feb 2020

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

illfated on 10 Feb 2020

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?

Jinnaix on 27 Aug 2020

👍1

These are changes I made to this script the below was applied after the above
~~~sql
DELETE FROM smart_scripts WHERE entryorguidIN (1840,1842) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguidIN (184000,184200,184201) AND source_type=9;
DELETE FROM smart_scripts WHERE entryorguid=12126 AND source_type=0 AND idIN(7,8,9,10);
DELETE FROM smart_scripts WHERE entryorguid=12128 AND source_type=0 AND idIN(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;

~~~
comments are crap I know I just used existing comment style

dr-j on 27 Aug 2020

@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.

illfated on 27 Aug 2020

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

dr-j on 27 Aug 2020

👍1

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