Miscellany

-- Shade of Akama
-- Remove Ashtongue Channelers(spawned in SD2 event)
-- This is required so as to prevent players from killing the channelers before the event begins and to create a pointer to the Channelers from the Shade's script
DELETE FROM `creature` WHERE `guid` IN (86114, 86124, 86125, 86126, 86127, 86128, 86129, 86130);
-- Current GUIDS 86114, 86124, 86125, 86126, 86127, 86128, 86129, 86130

-- 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 (They are summoned by the Reliquary control mob)
DELETE FROM `creature` WHERE `guid` IN (86122, 86123, 86121);
-- Current GUIDS 86122 86123 86121

-- Enslaved Soul (Spawned in the Reliquary event)
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 34000, `maxhealth` = 34000,

`faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23469;

-- 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 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 (summoned by Illidan - Normal Form)
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 8700, `maxhealth` = 8700, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23498;

-- Shadow Demon (Summoned by Illidan - Demon Form)
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 20000, `maxhealth` = 20000, `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 23375;

-- Blade of Azzinoth (Summoned by Illidan - Phase 2)
UPDATE `creature_template` SET `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 22996;

-- Flame Crash (Summoned by Illidan - normal form. Circular fire on the ground)
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 (Summoned by Illidan - Phase 2)
UPDATE `creature_template` SET `faction_A` = 14, `faction_H` = 14, `scale` = 3 WHERE `entry` = 22997;