diff options
| author | Killyana <morphone1@gmail.com> | 2015-09-29 20:07:02 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2015-09-29 20:07:02 +0200 |
| commit | 3e01ec1f22b3989c2b0c4d44ab62f30000b0ed08 (patch) | |
| tree | 57bd25c15f6d8207fa9acbddf5204dc4f2ba82df | |
| parent | 402a3c45ffe65597d9863dce5fb76362795d706a (diff) | |
DB/Creature: Fix some Npcs in The Storm Peaks
Fix Brunnhildar Prisoner react state.
Add missing aura to Dead Frost Giant and Frostworg Carcass, and remove random movements
Fix react state for Brunnhildar Warbear, Frostworg and Niffelem Frost Giant, and add SAI scripts.
Fix inhabittype for some npcs trigger.
Closes #15635
Closes #15634
| -rw-r--r-- | sql/updates/world/2015_09_29_02_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/2015_09_29_02_world.sql b/sql/updates/world/2015_09_29_02_world.sql new file mode 100644 index 00000000000..de63019221f --- /dev/null +++ b/sql/updates/world/2015_09_29_02_world.sql @@ -0,0 +1,15 @@ +-- +UPDATE `creature_template` SET `flags_extra`=2 WHERE `entry`=29639; +UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `guid`=105166; +UPDATE `creature_addon` SET `auras`=29266 WHERE `guid`=105166; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=29500; +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (29558, 32520); +UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `guid`=105243; +UPDATE `creature_addon` SET `auras`=29266 WHERE `guid`=105243; + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `Entry` IN (29351, 29358); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29351, 29358) 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 +(29351,0,0,0,0,0,100,0,2000,5000,7000,9000,11,38621,0,0,0,0,0,2,0,0,0,0,0,0,0,'Niffelem Frost Giant - IC - Cast Debilitating Strike'), +(29358,0,0,0,0,0,100,0,2000,5000,7000,9000,11,61572,0,0,0,0,0,2,0,0,0,0,0,0,0,'Frostworg - IC - Cast Frostbite'), +(29358,0,1,0,0,0,100,0,2000,6000,6000,9000,11,50075,0,0,0,0,0,2,0,0,0,0,0,0,0,'Frostworg - IC - Cast Maim Flesh'); |