Merge pull request #18094 from Staleness89/3.3.5

Script/Quest: Rivenwood Captives

(cherry picked from commit 8a864fc0853f2a70ee666466d44ab4fab6ddfc4a)

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_02_11_03_world_2016_11_23_00_world.sql b/sql/updates/world/master/2018_02_11_03_world_2016_11_23_00_world.sql
new file mode 100644
index 00000000000..ccbb4b3a6cf
--- /dev/null
+++ b/sql/updates/world/master/2018_02_11_03_world_2016_11_23_00_world.sql
@@ -0,0 +1,49 @@
+-- Remove incomplete SAI and set core scriptname
+DELETE FROM `smart_scripts` WHERE `entryorguid`=24210;
+UPDATE `creature_template` SET `AIName`='', `ScriptName`='npc_riven_widow_cocoon' WHERE `entry`= 24210;
+
+-- add UNIT_FLAG_PACIFIED to Riven Widow Cocoon and disable experience
+UPDATE `creature_template` SET `unit_flags`=`unit_flags`|131072 AND `flags_extra`=`flags_extra`|64 WHERE `entry`=24210;
+
+-- set creatures that spawn to SmartAI (the ones that aren't already)
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (24026,24073,24219);
+
+-- Add an attack summoner on just summoned to each creature. Some of these creatures already have SmartAI, did all this to avoid errors.
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23661,23662,23666,23669,23959,23989,23990,23991,24026,24073,24219,24211);
+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
+(24219,0, 0,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Baby Riven Widow  - On Just Summoned - Attack Summoner'),
+(24073,0, 0,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Fearsome Horror  - On Just Summoned - Attack Summoner'),
+(23661,0, 0,1,  8,0,100,   0, 43036,     0,     0,     0, 11, 43059, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,"Winterskorn Tribesman - On Spellhit 'Dismembering Corpse' - Cast 'Gruesome, But Necessary: Vrykul On Dismember'"),
+(23661,0, 3,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Winterskorn Tribesman  - On Just Summoned - Attack Summoner'),
+(23661,0, 1,0, 61,0,100,   0,     0,     0,     0,     0, 11, 43037, 0,0,0,0,0,  7,     0, 0,0,0,0,0,0,"Winterskorn Tribesman - On Aggro - Cast 'Gruesome, But Necessary: Kill Credit'"),
+(23661,0, 2,0,  0,0,100,   0,  1000, 15000,  7200, 35000,  1,     0, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Winterskorn Tribesman - In Combat - Say Line 0'),
+(23666,0, 4,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Winterskorn Berserker  - On Just Summoned - Attack Summoner'),
+(23666,0, 0,1,  8,0,100,   0, 43036,     0,     0,     0, 11, 43059, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,"Winterskorn Berserker - On Spellhit 'Dismembering Corpse' - Cast 'Gruesome, But Necessary: Vrykul On Dismember'"),
+(23666,0, 1,0, 61,0,100,   0,     0,     0,     0,     0, 11, 43037, 0,0,0,0,0,  7,     0, 0,0,0,0,0,0,"Winterskorn Berserker - On Spellhit 'Dismembering Corpse' - Cast 'Gruesome, But Necessary: Kill Credit'"),
+(23666,0, 2,0,  0,0,100,   0,  1000, 15000,  7200, 35000,  1,     0, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Winterskorn Berserker - In Combat - Say Line 0'),
+(23666,0, 3,0,  1,0,100,   0,     0, 60000, 15000, 70000,  1,     1, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Winterskorn Berserker - Out of Combat - Say Line 1'),
+(23991,0, 0,0,  4,0, 50,   1,     0,     0,     0,     0,  1,     0, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Gjalerbron Warrior - On Aggro - Say (No Repeat)'),
+(23991,0, 1,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Gjalerbron Warrior  - On Just Summoned - Attack Summoner'),
+(23990,0, 0,0,  4,0, 50,   1,     0,     0,     0,     0,  1,     0, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Gjalerbron Rune-Caster - On Aggro - Say (No Repeat)'),
+(23990,0, 1,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Gjalerbron Runecaster  - On Just Summoned - Attack Summoner'),
+(23989,0, 0,0,  4,0, 50,   1,     0,     0,     0,     0,  1,     0, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Gjalerbron Sleep-Watcher - On Aggro - Say (No Repeat)'),
+(23989,0, 1,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Gjalerbron SleepWatcher  - On Just Summoned - Attack Summoner'),
+(23669,0, 0,0,  0,0,100,   0,  1000,  3500,  3000,  9000, 11, 43083, 0,0,0,0,0,  2,     0, 0,0,0,0,0,0,"Winterskorn Oracle - In Combat - Cast 'Frostbolt'"),
+(23669,0, 1,2,  8,0,100,   0, 43036,     0,     0,     0, 11, 43059, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,"Winterskorn Oracle - On Spellhit 'Dismembering Corpse' - Cast 'Gruesome, But Necessary: Vrykul On Dismember'"),
+(23669,0, 1,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Winterskorn Oracle  - On Just Summoned - Attack Summoner'),
+(23669,0, 2,0, 61,0,100,   0,     0,     0,     0,     0, 11, 43037, 0,0,0,0,0,  7,     0, 0,0,0,0,0,0,"Winterskorn Oracle - On Spellhit 'Dismembering Corpse' - Cast 'Gruesome, But Necessary: Kill Credit'"),
+(23669,0, 3,0,  0,0,100,   0,  1000, 15000,  7200, 35000,  5,     1, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Winterskorn Oracle - In Combat - Say Line 0'),
+(23959,0, 0,0, 38,0,100,   0,     0,     1,     0,     0, 69,     1, 0,0,0,0,0, 19, 24230,50,0,0,0,0,0,"Darkclaw Bat - On Data Set 0 1 - Move To Closest Creature 'Feknut's Firecrackers Bunny'"),
+(23959,0, 1,0, 34,0,100, 512,     0,     1,     0,     0, 45,     0, 1,0,0,0,0, 19, 24230, 5,0,0,0,0,0,'Darkclaw Bat - On Reached Point 1 - Set Data 0 1'),
+(23959,0, 2,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Darkclaw Bat  - On Just Summoned - Attack Summoner'),
+(23662,0, 0,0,  0,0,100,   0,   100,  1000,  5000, 14500, 11, 38557, 0,0,0,0,0,  2,     0, 0,0,0,0,0,0,"Winterskorn Woodsman - In Combat - Cast 'Throw'"),
+(23662,0, 1,0,  0,0,100,   0,  1000,  4500,  4900,  8100, 11, 43410, 0,0,0,0,0,  2,     0, 0,0,0,0,0,0,"Winterskorn Woodsman - In Combat - Cast 'Chop'"),
+(23662,0, 2,3,  8,0,100,   0, 43036,     0,     0,     0, 11, 43059, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,"Winterskorn Woodsman - On Spellhit 'Dismembering Corpse' - Cast 'Gruesome, But Necessary: Vrykul On Dismember'"),
+(23662,0, 2,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Winterskorn Woodsman  - On Just Summoned - Attack Summoner'),
+(23662,0, 3,0, 61,0,100,   0,     0,     0,     0,     0, 11, 43037, 0,0,0,0,0,  7,     0, 0,0,0,0,0,0,"Winterskorn Woodsman - On Spellhit 'Dismembering Corpse' - Cast 'Gruesome, But Necessary: Kill Credit'"),
+(23662,0, 4,0,  0,0,100,   0,  1000, 15000,  7200, 35000,  1,     0, 0,0,0,0,0,  1,     0, 0,0,0,0,0,0,'Winterskorn Woodsman - In Combat - Say Line 0'),
+(24026,0, 0,0, 54,0,100, 512,     0,     0,     0,     0, 49,     0, 0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Fanggore Worg  - On Just Summoned - Attack Summoner'),
+(24211,0, 1,2, 61,0,100, 512,     0,     0,     0,     0, 29,      0,0,0,0,0,0, 23,     0, 0,0,0,0,0,0,'Freed Winterhoof Longrunner - On Just Summoned - Follow Summoner'),
+(24211,0, 2,0, 61,0,100, 512,     0,     0,     0,     0, 41, 6000, 0,0,0,0,0,   1,     0, 0,0,0,0,0,0,'Freed Winterhoof Longrunner - On Just Summoned - Despawn In 6000 ms'),
+(24211,0, 0,1, 54,0,100, 512,     0,     0,     0,     0, 1,      0,0,0,0,0,0,   1,     0, 0,0,0,0,0,0,'Freed Winterhoof Longrunner - On Just Summoned - Say Line 0');
+