-- Kaw the Mammoth Destroyer SAI
SET @ENTRY := 25802;
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,1,0,100,1,0,0,0,0,18,33024,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kaw the Mammoth Destroyer - Out of Combat - Set Flag Immune To Players (No Repeat)"),
(@ENTRY,0,1,0,38,0,100,0,1,1,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Kaw the Mammoth Destroyer - On Data Set 1 1 - Run Script"),
(@ENTRY,0,2,0,6,0,100,0,0,0,0,0,11,46310,2,0,0,0,0,1,0,0,0,0,0,0,0,"Kaw the Mammoth Destroyer - On Just Died - Cast 'Drop War Halberd'");

-- Actionlist SAI
SET @ENTRY := 2580200;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
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,9,0,0,0,0,100,0,0,0,0,0,1,0,2000,0,0,0,0,1,0,0,0,0,0,0,0,"Kaw the Mammoth Destroyer - On Script - Say Line 0 (No Repeat)"),
(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kaw the Mammoth Destroyer - On Script - Set Run On (No Repeat)"),
(@ENTRY,9,2,0,0,0,100,0,3000,3000,0,0,69,0,0,0,0,0,0,8,0,0,0,3974.17,5476.31,35.602,5.564,"Kaw the Mammoth Destroyer - On Script - Move To Position (No Repeat)"),
(@ENTRY,9,3,0,0,0,100,0,2500,2500,0,0,11,46260,2,0,0,0,0,19,25881,100,0,0,0,0,0,"Kaw the Mammoth Destroyer - On Script - Cast 'Riding Wooly Mammoth Bull' (No Repeat)");

-- Moria SAI
SET @ENTRY := 25881;
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,1,0,100,0,0,0,10000,10000,28,46260,0,0,0,0,0,1,0,0,0,0,0,0,0,"Moria - Out of Combat - Remove Aura 'Riding Wooly Mammoth Bull'"),
(@ENTRY,0,1,0,6,0,100,0,0,0,0,0,19,33024,0,0,0,0,0,19,25802,100,0,0,0,0,0,"Moria - On Just Died - Remove Flag Immune To Players"),
(@ENTRY,0,2,0,1,0,100,0,0,0,10000,10000,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Moria - Out of Combat - Set Reactstate Passive"),
(@ENTRY,0,3,0,27,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,60,0,0,0,0,0,0,"Moria - On Passenger Boarded - Start Attacking");

UPDATE `creature_template` SET `npcflag`=16777216 WHERE  `entry`=25743;
DELETE FROM `creature_loot_template` WHERE  `entry`=25802 AND `item`=35234;
DELETE FROM `smart_scripts` WHERE `entryorguid`=25743;
UPDATE `creature_template` SET `AIName`='' WHERE `entry`=25743;
UPDATE `gameobject_template` SET `flags`=0 WHERE  `entry`=188066;

DELETE FROM `areatrigger_scripts` WHERE `entry` IN (4896);
INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES
(4896,'SmartTrigger');

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (4896) AND `source_type`=2;
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
(4896,2,0,1,46,0,100,0,4896,0,0,0,45,1,1,0,0,0,0,10,114932,25802,0,0,0,0,0,"On Trigger - Set Data");

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=4896;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 1, 4896, 2, 0, 9, 0, 11879, 0, 0, 0, 0, 0, '', 'SAI triggers only if player has taken quest 11879');

DELETE FROM `disables` WHERE `sourceType`=0 AND `entry`=46260;
INSERT INTO `disables`(`sourceType`,`entry`,`flags`,`comment`) VALUES
(0,46260,64,'Ignore LOS');