Trinitycore: DB/Quest: Convert & update support for 'Ebon Blade Prisoners' to SAI

[offl]

The script to remove is 'go_jotunheim_cage', thanks!

-- (Source: https://www.youtube.com/watch?v=jWlqGVyb_mQ & https://www.youtube.com/watch?v=KED-XZBGlmI)
UPDATE `gameobject_template` SET `AIName` = "SmartGameObjectAI", `ScriptName` = "" WHERE `entry` = 192135;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 192135 AND `source_type` = 1;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(192135,1,0,1,70,0,100,0,2,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Jotunheim Cage - On Gameobject State Changed - Store Targetlist"),
(192135,1,1,2,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30186,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,2,3,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30194,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,3,4,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30195,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,4,5,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30196,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,5,6,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30186,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)"),
(192135,1,6,7,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30194,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)"),
(192135,1,7,8,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30195,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)"),
(192135,1,8,0,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30196,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)");

UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` IN (30186,30194,30195,30196,30197,30198,30199,30200);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30186,30194,30195,30196,30197,30198,30199,30200) AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3018600,3019400,3019500,3019600) AND `source_type` = 9;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(30186,0,0,0,38,0,100,0,0,1,0,0,0,80,3018600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),
(30194,0,0,0,38,0,100,0,0,1,0,0,0,80,3019400,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),
(30195,0,0,0,38,0,100,0,0,1,0,0,0,80,3019500,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),
(30196,0,0,0,38,0,100,0,0,1,0,0,0,80,3019600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),

(3018600,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3018600,9,1,0,0,0,100,0,0,0,0,0,0,85,56207,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Human'"),
(3018600,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),
(3019400,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3019400,9,1,0,0,0,100,0,0,0,0,0,0,85,56209,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Night Elf'"),
(3019400,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),
(3019500,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3019500,9,1,0,0,0,100,0,0,0,0,0,0,85,56212,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Orc'"),
(3019500,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),
(3019600,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3019600,9,1,0,0,0,100,0,0,0,0,0,0,85,56214,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Troll'"),
(3019600,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),

(30197,0,0,0,54,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30197,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30197,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30197,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'"),
(30198,0,0,0,54,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30198,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30198,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30198,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'"),
(30199,0,0,0,54,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30199,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30199,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30199,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'"),
(30200,0,0,0,54,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30200,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30200,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30200,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'");

DELETE FROM `creature_text` WHERE `CreatureID` IN (30197,30198,30199,30200);
INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
(30197,0,0,"Let's do this.",12,0,100,0,0,0,30898,0,"Ebon Blade Knight"),
(30197,0,1,"Thanks. How can I help?",12,0,100,0,0,0,30899,0,"Ebon Blade Knight"),
(30197,0,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,0,0,0,30900,0,"Ebon Blade Knight"),
(30197,0,3,"Thank you, $c. I owe you.",12,0,100,0,0,0,30901,0,"Ebon Blade Knight"),
(30197,0,4,"Excellent. Let's kill some vrykul!",12,0,100,0,0,0,30902,0,"Ebon Blade Knight"),
(30197,0,5,"It's time for revenge!",12,0,100,0,0,0,30903,0,"Ebon Blade Knight"),
(30197,0,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,0,0,0,30904,0,"Ebon Blade Knight"),
(30197,0,7,"Kill!",12,0,100,0,0,0,30905,0,"Ebon Blade Knight"),
(30198,0,0,"Let's do this.",12,0,100,0,0,0,30898,0,"Ebon Blade Knight"),
(30198,0,1,"Thanks. How can I help?",12,0,100,0,0,0,30899,0,"Ebon Blade Knight"),
(30198,0,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,0,0,0,30900,0,"Ebon Blade Knight"),
(30198,0,3,"Thank you, $c. I owe you.",12,0,100,0,0,0,30901,0,"Ebon Blade Knight"),
(30198,0,4,"Excellent. Let's kill some vrykul!",12,0,100,0,0,0,30902,0,"Ebon Blade Knight"),
(30198,0,5,"It's time for revenge!",12,0,100,0,0,0,30903,0,"Ebon Blade Knight"),
(30198,0,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,0,0,0,30904,0,"Ebon Blade Knight"),
(30198,0,7,"Kill!",12,0,100,0,0,0,30905,0,"Ebon Blade Knight"),
(30199,0,0,"Let's do this.",12,0,100,0,0,0,30898,0,"Ebon Blade Knight"),
(30199,0,1,"Thanks. How can I help?",12,0,100,0,0,0,30899,0,"Ebon Blade Knight"),
(30199,0,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,0,0,0,30900,0,"Ebon Blade Knight"),
(30199,0,3,"Thank you, $c. I owe you.",12,0,100,0,0,0,30901,0,"Ebon Blade Knight"),
(30199,0,4,"Excellent. Let's kill some vrykul!",12,0,100,0,0,0,30902,0,"Ebon Blade Knight"),
(30199,0,5,"It's time for revenge!",12,0,100,0,0,0,30903,0,"Ebon Blade Knight"),
(30199,0,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,0,0,0,30904,0,"Ebon Blade Knight"),
(30199,0,7,"Kill!",12,0,100,0,0,0,30905,0,"Ebon Blade Knight"),
(30200,0,0,"Let's do this.",12,0,100,0,0,0,30898,0,"Ebon Blade Knight"),
(30200,0,1,"Thanks. How can I help?",12,0,100,0,0,0,30899,0,"Ebon Blade Knight"),
(30200,0,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,0,0,0,30900,0,"Ebon Blade Knight"),
(30200,0,3,"Thank you, $c. I owe you.",12,0,100,0,0,0,30901,0,"Ebon Blade Knight"),
(30200,0,4,"Excellent. Let's kill some vrykul!",12,0,100,0,0,0,30902,0,"Ebon Blade Knight"),
(30200,0,5,"It's time for revenge!",12,0,100,0,0,0,30903,0,"Ebon Blade Knight"),
(30200,0,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,0,0,0,30904,0,"Ebon Blade Knight"),
(30200,0,7,"Kill!",12,0,100,0,0,0,30905,0,"Ebon Blade Knight");

Branch: 3.3.5
TC rev. hash/commit: 69dc704cd5cf
Operating system: Windows 8.1

[offl]

I'd like to add https://github.com/TrinityCore/TrinityCore/issues/18203#issuecomment-258622111 and test https://github.com/TrinityCore/TrinityCore/issues/18203#issue-187492480

[offl]

Updated with texts from https://github.com/TrinityCore/TrinityCore/issues/18203#issuecomment-258622111 but I don't know how to use them before the guardian despawn

-- (Source: https://www.youtube.com/watch?v=jWlqGVyb_mQ & https://www.youtube.com/watch?v=KED-XZBGlmI)
UPDATE `gameobject_template` SET `AIName` = "SmartGameObjectAI", `ScriptName` = "" WHERE `entry` = 192135;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 192135 AND `source_type` = 1;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(192135,1,0,1,70,0,100,0,2,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Jotunheim Cage - On Gameobject State Changed - Store Targetlist"),
(192135,1,1,2,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30186,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,2,3,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30194,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,3,4,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30195,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,4,5,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,30196,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Send Target 1 (Ebon Blade Prisoner)"),
(192135,1,5,6,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30186,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)"),
(192135,1,6,7,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30194,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)"),
(192135,1,7,8,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30195,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)"),
(192135,1,8,0,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,30196,5,0,0,0,0,0,0,"Jotunheim Cage - On Link - Set Data 0 1 (Ebon Blade Prisoner)");

UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` IN (30186,30194,30195,30196,30197,30198,30199,30200);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30186,30194,30195,30196,30197,30198,30199,30200) AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3018600,3019400,3019500,3019600) AND `source_type` = 9;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(30186,0,0,0,38,0,100,0,0,1,0,0,0,80,3018600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),
(30194,0,0,0,38,0,100,0,0,1,0,0,0,80,3019400,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),
(30195,0,0,0,38,0,100,0,0,1,0,0,0,80,3019500,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),
(30196,0,0,0,38,0,100,0,0,1,0,0,0,80,3019600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Data Set 0 1 - Run Script"),

(3018600,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3018600,9,1,0,0,0,100,0,0,0,0,0,0,85,56207,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Human'"),
(3018600,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),
(3019400,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3019400,9,1,0,0,0,100,0,0,0,0,0,0,85,56209,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Night Elf'"),
(3019400,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),
(3019500,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3019500,9,1,0,0,0,100,0,0,0,0,0,0,85,56212,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Orc'"),
(3019500,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),
(3019600,9,0,0,0,0,100,0,0,0,0,0,0,33,30186,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Quest Credit 'Ebon Blade Prisoners'"),
(3019600,9,1,0,0,0,100,0,0,0,0,0,0,85,56214,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Self Cast 'Ebon Blade Prisoners: Summon Ebon Blade Knight - Troll'"),
(3019600,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ebon Blade Prisoner - On Script - Despawn (0)"),

(30197,0,0,0,54,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30197,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30197,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30197,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'"),

(30198,0,0,0,54,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30198,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30198,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30198,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'"),

(30199,0,0,0,54,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30199,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30199,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30199,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'"),

(30200,0,0,0,54,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ebon Blade Knight - On Just Summoned - Say Line 0"),
(30200,0,1,0,0,0,100,0,6000,10000,7000,12000,0,11,60945,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Blood Strike'"),
(30200,0,2,0,0,0,100,0,8000,14000,12000,21000,0,11,60949,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Death Coil'"),
(30200,0,3,0,0,0,100,0,3000,11000,3000,17000,0,11,60951,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ebon Blade Knight - In Combat - Cast 'Frost Strike'");

DELETE FROM `creature_text` WHERE `CreatureID` IN (30197,30198,30199,30200);
INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
(30197,0,0,"You have my thanks. I'm going back to The Shadow Vault now.",12,0,100,1,0,0,30874,0,"Ebon Blade Knight"),
(30197,0,1,"I've tarried too long here. I must get back to The Shadow Vault. Farewell.",12,0,100,1,0,0,30875,0,"Ebon Blade Knight"),
(30197,0,2,"I will see you back at The Shadow Vault.",12,0,100,1,0,0,30876,0,"Ebon Blade Knight"),
(30197,0,3,"That's enough for me. I'm heading back now.",12,0,100,1,0,0,30877,0,"Ebon Blade Knight"),
(30197,0,4,"I'd love to stay and kill vrykul with you all day, but I'm sure the baron will be wondering where I am.",12,0,100,1,0,0,30878,0,"Ebon Blade Knight"),
(30197,0,5,"I have to go. You stay and kill more of these ugly mongrels.",12,0,100,1,0,0,30879,0,"Ebon Blade Knight"),
(30197,0,6,"Time to go. Don't let them capture you or they'll put you in the stew!",12,0,100,1,0,0,30880,0,"Ebon Blade Knight"),
(30197,0,7,"I'm heading back now. I'll let the baron know that you liberated me.",12,0,100,1,0,0,30881,0,"Ebon Blade Knight"),
(30197,1,0,"Let's do this.",12,0,100,5,0,0,30898,0,"Ebon Blade Knight"),
(30197,1,1,"Thanks. How can I help?",12,0,100,5,0,0,30899,0,"Ebon Blade Knight"),
(30197,1,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,5,0,0,30900,0,"Ebon Blade Knight"),
(30197,1,3,"Thank you, $c. I owe you.",12,0,100,5,0,0,30901,0,"Ebon Blade Knight"),
(30197,1,4,"Excellent. Let's kill some vrykul!",12,0,100,5,0,0,30902,0,"Ebon Blade Knight"),
(30197,1,5,"It's time for revenge!",12,0,100,5,0,0,30903,0,"Ebon Blade Knight"),
(30197,1,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,5,0,0,30904,0,"Ebon Blade Knight"),
(30197,1,7,"Kill!",12,0,100,5,0,0,30905,0,"Ebon Blade Knight"),
(30198,0,0,"You have my thanks. I'm going back to The Shadow Vault now.",12,0,100,1,0,0,30874,0,"Ebon Blade Knight"),
(30198,0,1,"I've tarried too long here. I must get back to The Shadow Vault. Farewell.",12,0,100,1,0,0,30875,0,"Ebon Blade Knight"),
(30198,0,2,"I will see you back at The Shadow Vault.",12,0,100,1,0,0,30876,0,"Ebon Blade Knight"),
(30198,0,3,"That's enough for me. I'm heading back now.",12,0,100,1,0,0,30877,0,"Ebon Blade Knight"),
(30198,0,4,"I'd love to stay and kill vrykul with you all day, but I'm sure the baron will be wondering where I am.",12,0,100,1,0,0,30878,0,"Ebon Blade Knight"),
(30198,0,5,"I have to go. You stay and kill more of these ugly mongrels.",12,0,100,1,0,0,30879,0,"Ebon Blade Knight"),
(30198,0,6,"Time to go. Don't let them capture you or they'll put you in the stew!",12,0,100,1,0,0,30880,0,"Ebon Blade Knight"),
(30198,0,7,"I'm heading back now. I'll let the baron know that you liberated me.",12,0,100,1,0,0,30881,0,"Ebon Blade Knight"),
(30198,1,0,"Let's do this.",12,0,100,5,0,0,30898,0,"Ebon Blade Knight"),
(30198,1,1,"Thanks. How can I help?",12,0,100,5,0,0,30899,0,"Ebon Blade Knight"),
(30198,1,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,5,0,0,30900,0,"Ebon Blade Knight"),
(30198,1,3,"Thank you, $c. I owe you.",12,0,100,5,0,0,30901,0,"Ebon Blade Knight"),
(30198,1,4,"Excellent. Let's kill some vrykul!",12,0,100,5,0,0,30902,0,"Ebon Blade Knight"),
(30198,1,5,"It's time for revenge!",12,0,100,5,0,0,30903,0,"Ebon Blade Knight"),
(30198,1,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,5,0,0,30904,0,"Ebon Blade Knight"),
(30198,1,7,"Kill!",12,0,100,5,0,0,30905,0,"Ebon Blade Knight"),
(30199,0,0,"You have my thanks. I'm going back to The Shadow Vault now.",12,0,100,1,0,0,30874,0,"Ebon Blade Knight"),
(30199,0,1,"I've tarried too long here. I must get back to The Shadow Vault. Farewell.",12,0,100,1,0,0,30875,0,"Ebon Blade Knight"),
(30199,0,2,"I will see you back at The Shadow Vault.",12,0,100,1,0,0,30876,0,"Ebon Blade Knight"),
(30199,0,3,"That's enough for me. I'm heading back now.",12,0,100,1,0,0,30877,0,"Ebon Blade Knight"),
(30199,0,4,"I'd love to stay and kill vrykul with you all day, but I'm sure the baron will be wondering where I am.",12,0,100,1,0,0,30878,0,"Ebon Blade Knight"),
(30199,0,5,"I have to go. You stay and kill more of these ugly mongrels.",12,0,100,1,0,0,30879,0,"Ebon Blade Knight"),
(30199,0,6,"Time to go. Don't let them capture you or they'll put you in the stew!",12,0,100,1,0,0,30880,0,"Ebon Blade Knight"),
(30199,0,7,"I'm heading back now. I'll let the baron know that you liberated me.",12,0,100,1,0,0,30881,0,"Ebon Blade Knight"),
(30199,1,0,"Let's do this.",12,0,100,5,0,0,30898,0,"Ebon Blade Knight"),
(30199,1,1,"Thanks. How can I help?",12,0,100,5,0,0,30899,0,"Ebon Blade Knight"),
(30199,1,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,5,0,0,30900,0,"Ebon Blade Knight"),
(30199,1,3,"Thank you, $c. I owe you.",12,0,100,5,0,0,30901,0,"Ebon Blade Knight"),
(30199,1,4,"Excellent. Let's kill some vrykul!",12,0,100,5,0,0,30902,0,"Ebon Blade Knight"),
(30199,1,5,"It's time for revenge!",12,0,100,5,0,0,30903,0,"Ebon Blade Knight"),
(30199,1,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,5,0,0,30904,0,"Ebon Blade Knight"),
(30199,1,7,"Kill!",12,0,100,5,0,0,30905,0,"Ebon Blade Knight"),
(30200,0,0,"You have my thanks. I'm going back to The Shadow Vault now.",12,0,100,1,0,0,30874,0,"Ebon Blade Knight"),
(30200,0,1,"I've tarried too long here. I must get back to The Shadow Vault. Farewell.",12,0,100,1,0,0,30875,0,"Ebon Blade Knight"),
(30200,0,2,"I will see you back at The Shadow Vault.",12,0,100,1,0,0,30876,0,"Ebon Blade Knight"),
(30200,0,3,"That's enough for me. I'm heading back now.",12,0,100,1,0,0,30877,0,"Ebon Blade Knight"),
(30200,0,4,"I'd love to stay and kill vrykul with you all day, but I'm sure the baron will be wondering where I am.",12,0,100,1,0,0,30878,0,"Ebon Blade Knight"),
(30200,0,5,"I have to go. You stay and kill more of these ugly mongrels.",12,0,100,1,0,0,30879,0,"Ebon Blade Knight"),
(30200,0,6,"Time to go. Don't let them capture you or they'll put you in the stew!",12,0,100,1,0,0,30880,0,"Ebon Blade Knight"),
(30200,0,7,"I'm heading back now. I'll let the baron know that you liberated me.",12,0,100,1,0,0,30881,0,"Ebon Blade Knight"),
(30200,1,0,"Let's do this.",12,0,100,5,0,0,30898,0,"Ebon Blade Knight"),
(30200,1,1,"Thanks. How can I help?",12,0,100,5,0,0,30899,0,"Ebon Blade Knight"),
(30200,1,2,"I can fight by your side for a few minutes before I need to return to The Shadow Vault.",12,0,100,5,0,0,30900,0,"Ebon Blade Knight"),
(30200,1,3,"Thank you, $c. I owe you.",12,0,100,5,0,0,30901,0,"Ebon Blade Knight"),
(30200,1,4,"Excellent. Let's kill some vrykul!",12,0,100,5,0,0,30902,0,"Ebon Blade Knight"),
(30200,1,5,"It's time for revenge!",12,0,100,5,0,0,30903,0,"Ebon Blade Knight"),
(30200,1,6,"Where's my damned helmet? Well, at least they left my sword here. Idiots.",12,0,100,5,0,0,30904,0,"Ebon Blade Knight"),
(30200,1,7,"Kill!",12,0,100,5,0,0,30905,0,"Ebon Blade Knight");

[msoky]

can be merged?

[offl]

Nope, it's WIP
I want to slightly change it and try again to use texts before despawn

[github-actions[bot]]

6611b7145746d5bc18541f7f3a4b641739877740