-- Consolidated creature_template
DELETE FROM `creature_template` WHERE `entry` IN (14684, 14686, 14695, 28194, 14690, 14693, 14682);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
(14684, 0, 0, 0, 0, 0, 'Balzaphon', NULL, NULL, 0, 60, 60, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14684, 0, 0, 0, 0, 2275, 2984, '', 0, 1, 6, 6, 1, 1, 0, 0, 1, 8405008, 0, 0, '', 12340),
(14686, 0, 0, 0, 0, 0, 'Lady Falther\'ess', NULL, NULL, 0, 37, 37, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 5, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14686, 0, 0, 0, 0, 208, 378, '', 0, 1, 8, 4, 1, 1, 0, 0, 1, 8405008, 0, 0, '', 12340),
(14695, 0, 0, 0, 0, 0, 'Lord Blackwood', NULL, NULL, 0, 60, 60, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14695, 0, 0, 0, 0, 1041, 1871, '', 0, 1, 10, 1, 1, 1, 0, 0, 1, 8388624, 0, 0, '', 12340),
(28194, 0, 0, 0, 0, 0, 'Prince Tenris Mirkblood', 'The San\'layn', '', 0, 70, 70, 1, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 2, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 8, 28194, 0, 0, 0, 0, 0, 0, '', 0, 1, 52.5, 10, 1, 1, 0, 176, 1, 8388624, 0, 0, '', 12340),
(14690, 0, 0, 0, 0, 0, 'Revanchion', NULL, NULL, 0, 60, 60, 0, 21, 0, 1.11111, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14690, 0, 0, 0, 0, 0, 0, '', 0, 1, 10, 2, 1, 1, 0, 0, 1, 8388624, 0, 0, '', 12340),
(14693, 0, 0, 0, 0, 0, 'Scorn', NULL, NULL, 0, 34, 34, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 8, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14693, 0, 0, 0, 0, 238, 657, 'SmartAI', 0, 1, 8, 6, 1, 1, 0, 0, 1, 8390928, 0, 0, '', 12340),
(14682, 0, 0, 0, 0, 0, 'Sever', NULL, NULL, 0, 21, 21, 0, 21, 0, 1, 1.14286, 1, 1, 20, 1, 1, 0, 7.5, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 6, 0, 14682, 0, 0, 0, 0, 64, 151, '', 0, 1, 9, 1, 1, 1, 0, 0, 1, 8388688, 0, 0, '', 12340);


-- Consolidated creature_template_model
DELETE FROM `creature_template_model` WHERE `CreatureID` IN (14684, 14686, 14695, 28194, 14690, 14693, 14682);
INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
(14684, 0, 7919, 1, 1, 12340),
(14686, 0, 10698, 1, 1, 12340),
(14695, 0, 14699, 1, 1, 12340),
(28194, 0, 25541, 1, 1, 12340),
(14690, 0, 14695, 1, 1, 12340),
(14693, 0, 16197, 1, 1, 12340),
(14682, 0, 1061, 1, 1, 12340);


-- Consolidated creature_template_spell
DELETE FROM `creature_template_spell` WHERE `CreatureID` IN (14684, 14690, 14682);
INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES
(14684, 0, 12096, 12340),
(14684, 1, 37265, 12340),
(14684, 2, 8398, 12340),
(14684, 3, 32370, 12340),
(14690, 0, 29849, 12340),
(14690, 1, 30267, 12340),
(14682, 0, 17745, 12340),
(14682, 1, 16508, 12340);


-- Consolidated creature_equip_template
DELETE FROM `creature_equip_template` WHERE `CreatureID` IN (14684, 14695);
INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES
(14684, 1, 13698, 0, 0, 18019),
(14695, 1, 18985, 12893, 5258, 18019);


-- Consolidated creature_loot_template
DELETE FROM `creature_loot_template` WHERE `Entry` IN (14684, 14686, 14695, 28194, 14690, 14693, 14682);
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(14684, 12843, 0, 100, 0, 1, 0, 1, 1, 'Balzaphon - Corruptor''s Scourgestone'),
(14684, 14047, 0, 19, 0, 1, 0, 2, 4, 'Balzaphon - Runecloth'),
(14684, 23124, 0, 0, 0, 1, 1, 1, 1, 'Balzaphon - Staff of Balzaphon'),
(14684, 23125, 0, 0, 0, 1, 1, 1, 1, 'Balzaphon - Chains of the Lich'),
(14684, 23126, 0, 0, 0, 1, 1, 1, 1, 'Balzaphon - Waistband of Balzaphon'),
(14686, 23177, 0, 0, 0, 1, 1, 1, 1, 'Lady Falther''ess - Lady Falther''ess'' Finger'),
(14686, 23178, 0, 0, 0, 1, 1, 1, 1, 'Lady Falther''ess - Mantle of Lady Falther''ess'),
(14695, 12841, 0, 35, 0, 1, 0, 1, 1, 'Lord Blackwood - Invader''s Scourgestone'),
(14695, 23132, 0, 0, 0, 1, 1, 1, 1, 'Lord Blackwood - Lord Blackwood''s Blade'),
(14695, 23139, 0, 0, 0, 1, 1, 1, 1, 'Lord Blackwood - Lord Blackwood''s Buckler'),
(14695, 23156, 0, 0, 0, 1, 1, 1, 1, 'Lord Blackwood - Blackwood''s Thigh'),
(28194, 4113, 4113, 100, 0, 1, 0, 1, 1, 'Prince Tenris Mirkblood - (ReferenceTable)'),
(28194, 29434, 0, 100, 0, 1, 0, 2, 2, 'Prince Tenris Mirkblood - Badge of Justice'),
(28194, 38658, 0, 100, 0, 1, 0, 1, 1, 'Prince Tenris Mirkblood - Vampiric Batling'),
(28194, 39769, 0, 100, 0, 1, 0, 1, 1, 'Prince Tenris Mirkblood - Arcanite Ripper'),
(14690, 12843, 0, 100, 0, 1, 0, 1, 1, 'Revanchion - Corruptor''s Scourgestone'),
(14690, 23127, 0, 0, 0, 1, 1, 1, 1, 'Revanchion - Cloak of Revanchion'),
(14690, 23128, 0, 0, 0, 1, 1, 1, 1, 'Revanchion - The Shadow''s Grasp'),
(14690, 23129, 0, 0, 0, 1, 1, 1, 1, 'Revanchion - Bracers of Mending'),
(14693, 23168, 0, 0, 0, 1, 1, 1, 1, 'Scorn - Scorn''s Focal Dagger'),
(14693, 23169, 0, 0, 0, 1, 1, 1, 1, 'Scorn - Scorn''s Icy Choker'),
(14693, 23170, 0, 0, 0, 1, 1, 1, 1, 'Scorn - The Frozen Clutch'),
(14682, 23171, 0, 0, 0, 1, 1, 1, 1, 'Sever - The Axe of Severing'),
(14682, 23173, 0, 0, 0, 1, 1, 1, 1, 'Sever - Abomination Skin Leggings');


-- Consolidated creature
DELETE FROM `creature` WHERE `id1` IN (14684, 14686, 14695, 28194, 28194, 14690, 14693, 14682);
INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`, `CreateObject`, `Comment`) VALUES
(248654, 14684, 0, 0, 329, 2017, 2017, 1, 1, 0, 3733.27, -3480.11, 131.04, 3.05433, 7200, 0, 0, 14652, 14604, 0, 0, 0, 0, '', 46248, 0, NULL),
(248650, 14686, 0, 0, 129, 722, 722, 1, 1, 0, 2583.18, 695.861, 56.8033, 1.8675, 7200, 0, 0, 8744, 4568, 0, 0, 0, 0, '', 46248, 0, NULL),
(9999207, 14695, 0, 0, 289, 0, 0, 1, 1, 1, 257.816, 153.98, 109.757, 2.9985, 300, 0, 0, 36624, 0, 0, 0, 0, 0, '', NULL, 0, NULL),
(9999173, 28194, 0, 0, 0, 0, 0, 1, 1, 0, 2233.8, -5267.71, 76.0121, 3.45416, 300, 0, 0, 322765, 31550, 0, 0, 0, 0, '', NULL, 0, NULL),
(248651, 14690, 0, 0, 429, 2557, 2557, 1, 1, 0, -112.776, 583.823, -3.47887, 5.60251, 7200, 0, 0, 24420, 4868, 0, 0, 0, 0, '', 46248, 0, NULL),
(248652, 14693, 0, 0, 189, 796, 796, 1, 1, 0, 1797.84, 1233.68, 18.3153, 1.58286, 7200, 0, 0, 7104, 5610, 0, 0, 0, 0, '', 46248, 0, NULL),
(248653, 14682, 0, 0, 33, 209, 209, 1, 1, 0, -225.131, 2302.95, 94.7599, 6.02139, 7200, 0, 0, 4689, 0, 0, 0, 0, 0, '', 46248, 0, NULL);


-- Revanchion (14690) specific tables
DELETE FROM `creature_template_resistance` WHERE `CreatureID` = 14690;
INSERT INTO `creature_template_resistance` (`CreatureID`, `School`, `Resistance`, `VerifiedBuild`) VALUES
(14690, 2, 171, 12340),
(14690, 3, 171, 12340),
(14690, 4, 171, 12340),
(14690, 5, 171, 12340),
(14690, 6, 171, 12340);


DELETE FROM `creature_questitem` WHERE `CreatureEntry` = 14690;
INSERT INTO `creature_questitem` (`CreatureEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES
(14690, 0, 22224, 0);
