diff options
| -rw-r--r-- | sql/updates/world/3.3.5/9999_99_99_99_rivenwood_captives_world.sql (renamed from sql/updates/world/3.3.5/9999_99_99_18094_world.sql) | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/sql/updates/world/3.3.5/9999_99_99_18094_world.sql b/sql/updates/world/3.3.5/9999_99_99_99_rivenwood_captives_world.sql index 0fbb53cb2ac..7597a1c58b2 100644 --- a/sql/updates/world/3.3.5/9999_99_99_18094_world.sql +++ b/sql/updates/world/3.3.5/9999_99_99_99_rivenwood_captives_world.sql @@ -2,14 +2,14 @@ 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 -UPDATE `creature_template` SET `unit_flags`=`unit_flags`|131072 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); +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'), @@ -43,3 +43,7 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (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'); + |