From 455ea9a3967bb4df063d51ed8a3dc7249fa992f5 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 29 Sep 2015 20:07:02 +0200
Subject: 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

(cherry picked from commit 3e01ec1f22b3989c2b0c4d44ab62f30000b0ed08)
---
 sql/updates/world/2015_10_31_17_world_2015_09_29_02.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 sql/updates/world/2015_10_31_17_world_2015_09_29_02.sql

(limited to 'sql')

diff --git a/sql/updates/world/2015_10_31_17_world_2015_09_29_02.sql b/sql/updates/world/2015_10_31_17_world_2015_09_29_02.sql
new file mode 100644
index 00000000000..de63019221f
--- /dev/null
+++ b/sql/updates/world/2015_10_31_17_world_2015_09_29_02.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');
-- 
cgit v1.2.3