DB/Quest: Villains of Darrowshire

Closes #4385

(cherry picked from commit b1be7437c56ebd32b09336fb81cba20679fd9666)

1 files changed, 57 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_01_12_22_world_2022_11_05_00_world.sql b/sql/updates/world/master/2023_01_12_22_world_2022_11_05_00_world.sql
new file mode 100644
index 00000000000..f1d02038102
--- /dev/null
+++ b/sql/updates/world/master/2023_01_12_22_world_2022_11_05_00_world.sql
@@ -0,0 +1,57 @@
+-- 
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=17678;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13, 1, 17678, 0, 0, 31, 0, 3, 11288, 0, 0, 0, 0, '', "Despawn Spectral Combatants on Spectral Betrayer only"),
+(13, 1, 17678, 0, 1, 31, 0, 3, 11289, 0, 0, 0, 0, '', "Despawn Spectral Combatants on Spectral Defender only"),
+(13, 1, 17678, 0, 2, 31, 0, 3, 11620, 0, 0, 0, 0, '', "Despawn Spectral Combatants on Spectral Marauder only"),
+(13, 1, 17678, 0, 3, 31, 0, 3, 11621, 0, 0, 0, 0, '', "Despawn Spectral Combatants on Spectral Corpse only");
+UPDATE `creature_template_addon` SET `bytes1`=7, `bytes2`=1 WHERE `entry`=11621;
+UPDATE `creature` SET `wander_distance`=5, `MovementType`=1, `spawntimesecs`=30 WHERE `id` IN (11288, 11289);
+DELETE FROM `creature` WHERE `guid` IN (92824,92831,92823) AND `id` = 11288;
+-- Spectral Corpse SAI
+SET @ENTRY := 11621;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,8,0,100,0,17678,0,5000,5000,11,17680,0,0,0,0,0,1,0,0,0,0,0,0,0,"Spectral Corpse - On spell hit - Cast Spell");
+-- Spectral Corpse SAI
+SET @ENTRY := 11620;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,8,0,100,0,17678,0,5000,5000,11,17680,0,0,0,0,0,1,0,0,0,0,0,0,0,"Spectral Marauder - On spell hit - Cast Spell");
+-- Spectral Defender SAI
+SET @ENTRY := 11289;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,3000,5000,5000,8000,11,11976,0,0,0,0,0,2,0,0,0,0,0,0,0,"Spectral Defender - In Combat - Cast Strike"),
+(@ENTRY,0,1,0,0,0,100,0,5000,7000,7000,10000,11,12169,1,0,0,0,0,1,0,0,0,0,0,0,0,"Spectral Defender - In Combat - Cast Shield Block"),
+(@ENTRY,0,2,0,0,0,20,0,5000,30000,20000,30000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Spectral Defender - In Combat - Say text"),
+(@ENTRY,0,3,0,8,0,100,0,17678,0,5000,5000,11,17680,0,0,0,0,0,1,0,0,0,0,0,0,0,"Spectral Defender - On spell hit - Cast Spell");
+-- Spectral Betrayer SAI
+SET @ENTRY := 11288;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,3000,5000,7000,10000,11,5337,0,0,0,0,0,2,0,0,0,0,0,0,0,"Spectral Betrayer - In Combat - Cast Wither Strike"),
+(@ENTRY,0,1,0,0,0,20,0,5000,30000,20000,30000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Spectral Betrayer - In Combat - Say text"),
+(@ENTRY,0,2,0,8,0,100,0,17678,0,5000,5000,11,17680,0,0,0,0,0,1,0,0,0,0,0,0,0,"Spectral Betrayer - On spell hit - Cast Spell");
+DELETE FROM `creature_text` WHERE `CreatureID` IN (11288, 11289);
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `Comment`, `BroadcastTextId`) VALUES
+(11289, 0, 0, "We must not give up!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6835),
+(11289, 0, 1, "Fight!  Fight for Darrowshire!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6836),
+(11289, 0, 2, "Our captain has fallen!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6837),
+(11289, 0, 3, "The Alliance has abandoned us!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6838),
+(11289, 0, 4, "Where is the Silver Hand?  We need their help!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6839),
+(11289, 0, 5, "Fight for your families!  Don't give up!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6840),
+(11289, 0, 6, "If we fall, then Darrowshire is doomed!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6841),
+(11289, 0, 7, "We must stop these villains!", 12, 0, 100, 0, 0, 0, 'Spectral Defender', 6842),
+(11288, 0, 0, "Hail the Lich King!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6827),
+(11288, 0, 1, "Your soul is doomed!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6828),
+(11288, 0, 2, "Join us, or fall forever!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6829),
+(11288, 0, 3, "There is no hope!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6830),
+(11288, 0, 4, "Our master wants you!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6831),
+(11288, 0, 5, "Darrowshire will fall!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6832),
+(11288, 0, 6, "Scourge will prevail!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6833),
+(11288, 0, 7, "All hope is lost!", 12, 0, 100, 0, 0, 0, 'Spectral Betrayer', 6834);