Satanicmerlien

-- Atotona #930

-- Aotona1
DELETE FROM `creature` WHERE `guid`=152004;
INSERT INTO `creature` VALUES (152004, 32481, 571, 0, 0, 1, 1, 0, 0, 5368.74, 4427.76, -133.397, 0.206642, 28800, 20, 0, 15952, 0, 2, 0, 0, 0, 0);
SET @ENTRY := 1520040;
SET @GUID := 152004;
DELETE FROM `waypoint_data` WHERE `id`=1520040;
INSERT INTO `waypoint_data` VALUES 
(1520040, 1, 5373.04, 4428.42, -129.448, 0, 0, 0, 0, 100, 0),

Satanicmerlien

-- Crystal Handler #4353
SET @ENTRY := 26627;
SET @SOURCETYPE := 0;

DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1;
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,@SOURCETYPE,0,0,0,0,100,0,1000,1000,5000,5000,11,49668,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Crystal Handler - In Combat - Cast 'Flash of Darkness'");

Satanicmerlien

-- Bat Rider Guard #1072
DELETE FROM `creature` WHERE `id`=15242;
INSERT INTO `creature` VALUES 
(54840, 15242, 530, 0, 0, 1, 1, 0, 0, 156.903, 2554.78, 170.895, 5.15224, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0),
(54841, 15242, 530, 0, 0, 1, 1, 0, 0, 65.9778, 2661.21, 163.675, 0.511107, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0),
(54842, 15242, 530, 0, 0, 1, 1, 0, 0, 263.597, 2694.82, 169.731, 1.23918, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0),
(54843, 15242, 530, 0, 0, 1, 1, 0, 0, 62.4202, 2785.72, 192.112, 4.43018, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0),
(54846, 15242, 530, 0, 0, 1, 1, 0, 0, -3013, 2633, 126, 5, 300, 7, 0, 13972, 0, 1, 0, 0, 0, 0),
(54847, 15242, 530, 0, 0, 1, 1, 0, 0, -3101, 2598, 109, 1, 300, 7, 0, 13972, 0, 1, 0, 0, 0, 0),
(54848, 15242, 530, 0, 0, 1, 1, 0, 0, 77.5297, 5191.24, 74.6276, 1.8675, 300, 7, 0, 13972, 0, 1, 0, 0, 0, 0),

Satanicmerlien

-- Scourge Brute #4356
SET @ENTRY := 26623;
SET @SOURCETYPE := 0;

DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1;
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,@SOURCETYPE,0,0,0,0,100,2,1000,3000,14000,18500,11,16856,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Scourge Brute - In Combat - Cast 'Mortal Strike' (No Repeat)"),
(@ENTRY,@SOURCETYPE,1,0,0,0,100,2,6000,9000,9000,12000,11,35011,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Scourge Brute - In Combat - Cast 'Knockdown' (No Repeat)"),
(@ENTRY,@SOURCETYPE,2,0,0,0,100,2,1000,3000,10000

Satanicmerlien

-- Unleashed Hellion #4758
DELETE FROM `creature` WHERE `guid`=93983;
INSERT INTO `creature` VALUES 
(93983, 25002, 530, 0, 0, 1, 1, 0, 1, 12667.5, -7094.47, 18.3963, 1.39092, 450, 4, 0, 5589, 3155, 1, 0, 0, 0, 0);

Satanicmerlien

-- Twilight avenger #4760
DELETE FROM `creature` WHERE `guid`=42997;
INSERT INTO `creature` VALUES 
(42997, 11880, 1, 0, 0, 1, 1, 11812, 1, -7049.92, 1111.83, 5.21439, -0.756329, 300, 5, 0, 3876, 0, 1, 0, 0, 0, 0);

Satanicmerlien

-- Twilight avenger #4761
DELETE FROM `creature` WHERE `guid`=42970;
INSERT INTO `creature` VALUES 
(42970, 11880, 1, 0, 0, 1, 1, 11823, 1, -6972.02, 1073.48, 5.04001, 0.701645, 300, 5, 0, 3876, 0, 1, 0, 0, 0, 0);

Satanicmerlien

-- bonepaw Hyena #4819
DELETE FROM `creature` WHERE `guid`=27947;
INSERT INTO `creature` VALUES 
(27947, 4688, 1, 0, 0, 1, 1, 10902, 0, -442.361, 2116.41, 90.3753, 4.39939, 300, 5, 0, 444, 0, 1, 0, 0, 0, 0);

Satanicmerlien

-- bonepaw Hyena1 #4820
DELETE FROM `creature` WHERE `guid`=27946;
INSERT INTO `creature` VALUES 
(27946, 4688, 1, 0, 0, 1, 1, 10902, 0, -440.505, 2118.62, 90.3753, 4.09959, 300, 5, 0, 444, 0, 1, 0, 0, 0, 0);

Satanicmerlien

-- bonepaw Hyena3 #4821
DELETE FROM `creature` WHERE `guid`=27945;
INSERT INTO `creature` VALUES 
(27945, 4688, 1, 0, 0, 1, 1, 10902, 0, -438.82, 2118.56, 90.3753, 4.32633, 300, 5, 0, 444, 0, 1, 0, 0, 0, 0);