-- Shade of Akama
-- Remove Ashtongue Channelers(spawned in SD2 event)
DELETE FROM `creature` WHERE `guid` IN (86114, 86124, 86125, 86126, 86127, 86128, 86129, 86130);
-- Current GUIDS 86114, 86124, 86125, 86126, 86127, 86128, 86129, 86130

-- Add Akama Spawn
DELETE FROM `creature` WHERE `id`=23089;
INSERT INTO `creature`  (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`s pawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth `,`curmana`,`DeathState`,`MovementType`) VALUES
(XXX, 23089, 564, 0, 0, 544.596, 400.677, 112.784, 3.11943, 25, 0, 0, 544.596, 400.677, 112.784, 0, 1, 0, 0, 0);

-- Update stats
UPDATE `creature_template` SET `minlevel` = 73, `maxlevel` = 73, `minhealth` = 480000, `maxhealth` = 480000,  `minmana` = 338700, `maxmana` = 338700, `npcflag` = 3 WHERE `entry` = 23089;

-- Ashtongue Sorcerer
UPDATE `creature_template` SET `minlevel` = 71, `maxlevel` = 71, `minhealth` = 100000, `maxhealth` = 100000,  `minmana` = 73320, `maxmana` = 73320, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23215;

-- Ashtongue Defender
UPDATE `creature_template` SET `minlevel` = 72, `maxlevel` = 72, `minhealth` = 87000, `maxhealth` = 87000,  `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23216;

-- Ashtongue Elementalist
UPDATE `creature_template` SET `minlevel` = 71, `maxlevel` = 71, `minhealth` = 23000, `maxhealth` = 23000,  `minmana` = 32310, `maxmana` = 32310, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23523;

-- Ashtongue Rogue
UPDATE `creature_template` SET `minlevel` = 71, `maxlevel` = 71, `minhealth` = 29000, `maxhealth` = 29000,  `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23318;

-- Ashtongue Spiritbinder
UPDATE `creature_template` SET `minlevel` = 71, `maxlevel` = 71, `minhealth` = 23000, `maxhealth` = 23000,  `minmana` = 32310, `maxmana` = 32310, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23524;

-- Teron Gorefiend
-- Doom Blossoms
UPDATE `creature_template` SET `minlevel` = 72, `maxlevel` = 72 WHERE `entry` = 23123;

-- Shadowy Construct
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 59000, `maxhealth` = 59000,  `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23111;

-- Reliquary of Souls
-- Remove Essences
DELETE FROM `creature` WHERE `guid` IN (86122, 86123, 86121);
-- Current GUIDS 86122 86123 86121

-- Spawn Reliquary(Control Mob)
DELETE FROM `creature` WHERE `id`=22856;
INSERT INTO `creature`  (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`s pawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth `,`curmana`,`DeathState`,`MovementType`) VALUES
(XXX, 22856, 564, 0, 0, 501.603, 184.569, 95.8864, 4.77098, 25, 0, 0, 501.603, 184.569, 95.8864, 0, 1, 0, 0, 0);

-- Enslaved Soul
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 34000, `maxhealth` = 34000,  `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23469;

-- Illidari Council
-- Add Control Mob
DELETE FROM `creature` WHERE `id`=23426;
INSERT INTO `creature`  (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`s pawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth `,`curmana`,`DeathState`,`MovementType`) VALUES
(XXX, 23426, 564, 0, 0, 676.752, 305.279, 271.709, 3.19736, 25, 0, 0, 676.752, 305.279, 271.709, 0, 1, 0, 0, 0);

-- Illidan Stormrage
-- Remove non-Illidan mobs(small flame, assumed use in quest for yell in Outland)
DELETE FROM `creature` WHERE `guid` IN (12719, 77479);
-- Current GUIDS 12719 77479

-- Non-attackable instead of attackable, this will be switched in the script
UPDATE `creature_template` SET `flag1` = 102 WHERE `entry` = 22917;

-- Akama Spawn
DELETE FROM `creature` WHERE `id`=22990;
INSERT INTO `creature`  (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`s pawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth `,`curmana`,`DeathState`,`MovementType`) VALUES
(XXX, 22990, 564, 0, 0, 732.694, 305.133, 352.996, 3.13765, 25, 0, 0, 732.694, 305.133, 352.996, 0, 1, 0, 0, 0);

-- Akama Stats Update
UPDATE `creature_template` SET `minlevel` = 73, `maxlevel` = 73, `minhealth` = 480000, `maxhealth` = 480000,  `minmana` = 338700, `maxmana` = 338700, `faction_A` = 1820, `faction_H` = 1820, `npcflag` = 3, `scale` = 3 WHERE  `entry` = 22990;

-- Parasitic Shadowfiend
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 8700, `maxhealth` = 8700, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23498;

-- Shadow Demon
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 20000, `maxhealth` = 20000, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23375;

-- Blade of Azzinoth
UPDATE `creature_template` SET `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 22996;

-- Flame Crash
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23336;

-- Demon Fire
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23069;

-- Flame of Azzinoth
UPDATE `creature_template` SET `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 22997;