Ahune.sql

UPDATE `creature_template` SET  `minlevel`=82,`maxlevel`=82, `ScriptName`='boss_ahune' WHERE `entry`=25740;-- Ahune
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `AIName`='SmartAI' WHERE `entry`=25755;-- Ahunite Hailstone
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `AIName`='SmartAI' WHERE `entry`=25756;-- Ahunite Coldwave
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `AIName`='SmartAI' WHERE `entry`=25757;-- Ahunite Frostwind
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `ScriptName`='npc_frozen_core' WHERE `entry`=25865;-- Frozen Core
UPDATE `creature_template` SET `ScriptName`='npc_ahune_bunny' WHERE `entry`=25745;
UPDATE `creature_template` SET `ScriptName`='npc_ice_spear_bunny' WHERE `entry`=25985;
UPDATE `creature_template` SET  `DamageModifier`=10,`HealthModifier`=13, `AIName`='SmartAI' WHERE `entry`=40446;
UPDATE `gameobject_template` SET `ScriptName`='go_ahune_ice_stone' WHERE `entry`=187882;

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=46363;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ScriptName`, `Comment`) VALUES
(13,1,46363,0,0,31,0,3,25740,0,0,0,'','Beam Atack target Ahune');

DELETE FROM `creature_text` WHERE `entry`=25740;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(25740, 0, 0, 'The Earthen Ring\'s Assault Begins.', 41, 0, 100, 0, 0, 0, 24930, 0, 'Ahune - EMOTE_EARTHEN_ASSAULT'),
(25740, 1, 0, 'Ahune Retreats.  His defenses diminish.', 41, 0, 100, 0, 0, 0, 24931, 0, 'Ahune - EMOTE_RETREAT'),
(25740, 2, 0, 'Ahune will soon resurface.', 41, 0, 100, 0, 0, 0, 24932, 0, 'Ahune - EMOTE_RESURFACE');

-- Skar'this the Summoner
DELETE FROM `smart_scripts` WHERE `entryorguid`=40446 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 
(40446,0,0,0,0,0,100,0,5000,5000,15000,15000,11,55909,1,0,0,0,0,2,0,0,0,0,0,0,0,'Skar''this the Summoner - cast Crashing Wave'),
(40446,0,1,0,0,0,100,0,10000,10000,20000,20000,11,11831,1,0,0,0,0,2,0,0,0,0,0,0,0,'Skar''this the Summoner - cast Frost Nova'),
(40446,0,2,0,0,0,100,0,7000,7000,9000,9000,11,15043,0,0,0,0,0,2,0,0,0,0,0,0,0,'Skar''this the Summoner - cast Frostbolt');

SET @CGUID := 600043;
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID AND @CGUID+10;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(@CGUID,40446,547,1,1,0,0,-77.2636,-151.912,-1.92421,5.44435,300,0,0,164,300,0,0,0,0),
(@CGUID+1,25754,547,1,1,0,0, -140.734543, -139.580399, -1.591881, 5.427049,300,0,0,164,300,0,0,0,0),
(@CGUID+2,25754,547,1,1,0,0, -134.587418, -134.331085, -1.855661, 5.336747,300,0,0,164,300,0,0,0,0),
(@CGUID+3,25754,547,1,1,0,0, -128.186356, -130.267303, -2.016853, 5.460842,300,0,0,164,300,0,0,0,0),
(@CGUID+4,25961,547,1,1,0,0, -129.179459, -141.099503,-1.992221, 5.160010,300,0,0,164,300,0,0,0,0),
(@CGUID+5,25961,547,1,1,0,0, -122.147339, -136.741470, -2.285978, 5.132535,300,0,0,164,300,0,0,0,0),
(@CGUID+6,25961,547,1,1,0,0, -135.871445, -145.185211, -1.851782, 5.427049,300,0,0,164,300,0,0,0,0),
(@CGUID+7,25697,547,1,1,0,0, -93.114006, -110.953400, -2.992313, 2.759339,300,0,0,164,300,0,0,0,0);

SET @OGUID := 450000;
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+11;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@OGUID, 187882, 547, 0, 0, 1, 1, -73.4977,-155.976, -1.8987, 3.23816, 0, 0, 0.998834, -0.0482674, 300, 0, 1,0), -- Icestone
(@OGUID+1, 188072, 547, 0, 0, 1, 1, -73.4977, -155.976, -1.8987, 0, 0, 0, 0, 0, 300, 0, 1, 0), -- base
(@OGUID+2, 188067, 547, 0, 0, 1, 1, -73.353821, -145.553024, -1.550907, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- pequena
(@OGUID+3, 188067, 547, 0, 0, 1, 1, -82.760483, -171.683609, -3.855457, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- pequena
(@OGUID+4, 188142, 547, 0, 0, 1, 1, -72.478348, -185.619064, -4.919844, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- grande
(@OGUID+5, 188142, 547, 0, 0, 1, 1, -75.330658, -221.291504, -2.872238, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- grande
(@OGUID+6, 188142, 547, 0, 0, 1, 1, -74.433388, -243.315552, -3.374731, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- grande
(@OGUID+7, 188142, 547, 0, 0, 1, 1, -103.836685, -245.468842, -1.413185, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- grande
(@OGUID+8, 188142, 547, 0, 0, 1, 1, -118.770912, -204.678040, -1.472812, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- grande
(@OGUID+9, 188142, 547, 0, 0, 1, 1, -117.611099, -166.497559, -1.693311, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- grande
(@OGUID+10, 188073, 547, 0, 0, 1, 1, -89.884483, -113.541809, -2.383388, 0, 0, 0, 0, 0, 300, 100, 1, 0), -- fogueira
(@OGUID+11, 188073, 547, 0, 0, 1, 1, -112.853088, -122.196358, -2.770177, 0, 0, 0, 0, 0, 300, 100, 1, 0); -- fogueira

-- Ahunite Hailstone SAI
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=25755;
DELETE FROM `smart_scripts` WHERE `entryorguid`=25755 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
(25755,0,0,0,54,0,100,0,0,0,0,0,11,46542,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahunite Hailstone - On Just Summoned - Cast \'Chilling Aura\''),
(25755,0,1,0,0,0,100,0,6000,8000,0,0,11,2676,0,0,0,0,0,2,0,0,0,0,0,0,0,'Ahunite Hailstone - In Combat - Cast \'Pulverize\'');
-- Ahunite Coldwave SAI
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=25756;
DELETE FROM `smart_scripts` WHERE `entryorguid`=25756 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
(25756,0,0,0,0,0,100,0,5000,7000,0,0,11,46406,0,0,0,0,0,2,0,0,0,0,0,0,0,'Ahunite Coldwave - In Combat - Cast \'Bitter Blast\'');
-- Ahunite Frostwind SAI
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=25757;
DELETE FROM `smart_scripts` WHERE `entryorguid`=25757 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
(25757,0,0,0,54,0,100,0,0,0,0,0,11,12550,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahunite Frostwind - On Just Summoned - Cast \'Lightning Shield\''),
(25757,0,1,0,0,0,100,0,2000,2000,5000,7000,11,46568,0,0,0,0,0,18,120,0,0,0,0,0,0,'Ahunite Frostwind - In Combat - Cast \'Wind Buffet\'');