DB/Quest: Rework 'If He Cannot Be Turned' (12896\12897)

(cherry picked from commit 6b158fd254462ed22b8c929af10d4c5638662ae3)

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_21_11_world_2021_11_07_00_world.sql b/sql/updates/world/master/2022_03_21_11_world_2021_11_07_00_world.sql
new file mode 100644
index 00000000000..c2b1500797c
--- /dev/null
+++ b/sql/updates/world/master/2022_03_21_11_world_2021_11_07_00_world.sql
@@ -0,0 +1,49 @@
+--
+DELETE FROM `waypoints` WHERE `entry` IN (29858,29859,29860);
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29858,29859,29860) 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`,`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
+(29858,0,0,0,11,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lady Nightswood - On Spawn - Say Line 0"),
+(29858,0,1,0,11,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,19,29851,0,0,0,0,0,0,0,"Lady Nightswood - On Spawn - Start Attack (General Lightsbane)"),
+(29858,0,2,0,7,0,100,0,0,0,0,0,0,41,10000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lady Nightswood - On Evade - Delayed Despawn"),
+(29858,0,3,0,0,0,100,0,10000,15000,13000,18000,0,11,5884,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Lady Nightswood - In Combat - Cast 'Banshee Curse'"),
+(29858,0,4,0,0,0,100,0,15000,20000,15000,20000,0,11,16838,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lady Nightswood - In Combat - Cast 'Banshee Shriek'"),
+-- The Leaper: Jump 27770 NYI, on aggro
+(29859,0,0,0,11,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"The Leaper - On Spawn - Say Line 0"),
+(29859,0,1,0,11,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,19,29851,0,0,0,0,0,0,0,"The Leaper - On Spawn - Start Attack (General Lightsbane)"),
+(29859,0,2,0,7,0,100,0,0,0,0,0,0,41,10000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"The Leaper - On Evade - Delayed Despawn"),
+(29859,0,3,0,0,0,100,0,5000,10000,5000,10000,0,11,60195,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"The Leaper - In Combat - Cast 'Sinister Strike'"),
+(29859,0,4,0,0,0,100,0,10000,15000,10000,15000,0,11,60177,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"The Leaper - In Combat - Cast 'Hunger For Blood'"),
+
+(29860,0,0,0,11,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Vile - On Spawn - Say Line 0"),
+(29860,0,1,0,11,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,19,29851,0,0,0,0,0,0,0,"Vile - On Spawn - Start Attack (General Lightsbane)"),
+(29860,0,2,0,7,0,100,0,0,0,0,0,0,41,10000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Vile - On Evade - Delayed Despawn"),
+(29860,0,3,0,0,0,100,0,5000,10000,10000,15000,0,11,6253,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Vile - In Combat - Cast 'Backhand'"),
+(29860,0,4,0,0,0,100,0,15000,20000,10000,20000,0,11,56646,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Vile - In Combat - Cast 'Enrage'"),
+(29860,0,5,0,0,0,100,0,5000,10000,15000,15000,0,11,37548,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Vile - In Combat - Cast 'Taunt'");
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 29840 AND `source_type` = 0 AND `id` IN (2,3,4);
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 29769 AND `source_type` = 0 AND `id` IN (3,4);
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`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
+(29840,0,2,0,0,0,100,0,5000,10000,5000,10000,0,11,60195,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"The Leaper - In Combat - Cast 'Sinister Strike'"),
+(29840,0,3,0,0,0,100,0,10000,15000,10000,15000,0,11,60177,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"The Leaper - In Combat - Cast 'Hunger For Blood'"),
+
+(29769,0,3,0,0,0,100,0,5000,10000,10000,15000,0,11,6253,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Vile - In Combat - Cast 'Backhand'"),
+(29769,0,4,0,0,0,100,0,15000,20000,10000,20000,0,11,56646,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Vile - In Combat - Cast 'Enrage'");
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 29851 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2985100 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
+(29851,0,0,0,11,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"General Lightsbane - On Spawn - Say Line 0"),
+(29851,0,1,0,11,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"General Lightsbane - On Spawn - Start Attack Owner"),
+(29851,0,2,0,4,0,100,0,0,0,0,0,0,80,2985100,1,0,0,0,0,1,0,0,0,0,0,0,0,0,"General Lightsbane - On Aggro - Run Script"),
+(29851,0,3,0,7,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"General Lightsbane - On Evade - Despawn"),
+(29851,0,4,0,0,0,100,0,5000,10000,5000,10000,0,11,15284,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"General Lightsbane - In Combat - Cast 'Cleave'"),
+(29851,0,5,0,0,0,100,0,10000,15000,10000,10000,0,11,60186,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"General Lightsbane - In Combat - Cast 'Plague Strike'"),
+(29851,0,6,0,0,0,100,0,20000,20000,20000,20000,0,11,60160,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"General Lightsbane - In Combat - Cast 'Death and Decay'"),
+
+(2985100,9,0,0,0,0,100,0,7000,7000,0,0,0,12,29860,1,300000,0,0,0,8,0,0,0,0,8551.562,2654.033,652.4367,6.0737457275390625,"General Lightsbane - Script - Summon Vile"),
+(2985100,9,1,0,0,0,100,0,10000,10000,0,0,0,12,29858,1,300000,0,0,0,8,0,0,0,0,8598.224,2670.0774,652.4367,4.433136463165283203,"General Lightsbane - Script - Summon Lady Nightswood"),
+(2985100,9,2,0,0,0,100,0,10000,10000,0,0,0,12,29859,1,300000,0,0,0,8,0,0,0,0,8556.31,2633.7283,652.4367,0.349065840244293212,"General Lightsbane - Script - Summon The Leaper");
+
+UPDATE `event_scripts` SET `delay` = 0, `x` = 8578.525, `y` = 2642.0154, `z` = 652.3538, `o` = 5.433159351348876953 WHERE `id` = 19423;