sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20251129122735_world.sql
T
ratkosrb c760ea15c8 Fix factions of some mobs in early patches.
2025-11-29 14:29:27 +02:00

151 lines
43 KiB
SQL
Raw Permalink Blame History

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20251129122735');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20251129122735');
-- Add your query below.
-- Nethergarde mobs used faction 210 before 1.6.
DELETE FROM `creature_template` WHERE `entry` IN (5995, 5996, 5997, 5998, 5999, 6000, 6001, 6002, 6002, 6003, 7851);
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(5995, 0, 'Nethergarde Worker', '', 46, 47, 210, 0, 0, 6715, 6716, 6717, 6718, 1, 1, 1, 1, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 5995, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(5996, 0, 'Nethergarde Miner', '', 47, 48, 210, 0, 0, 6719, 6720, 6721, 6722, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 0.25, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5996, 5996, 0, 94, 128, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 5996, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(5997, 0, 'Nethergarde Engineer', '', 47, 48, 210, 0, 0, 6711, 6712, 0, 0, 1.15, 1.15, 0, 0, 1, 1, 0, 0, 2, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 0.25, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5997, 5997, 0, 92, 125, 0, 0, 0, 0, 59970, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 5997, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(5998, 0, 'Nethergarde Foreman', '', 46, 48, 210, 0, 0, 6723, 6724, 6725, 6726, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5998, 5998, 0, 91, 124, 0, 0, 0, 0, 59980, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 5998, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(5999, 0, 'Nethergarde Soldier', '', 49, 50, 210, 0, 0, 6727, 6728, 6729, 6730, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5999, 5999, 0, 109, 147, 0, 0, 0, 0, 59990, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 5999, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(6000, 0, 'Nethergarde Cleric', NULL, 49, 51, 210, 0, 0, 6731, 6732, 6733, 6734, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.3, 1, 1, 1.35, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6000, 6000, 0, 92, 125, 0, 0, 0, 0, 60000, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 6000, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(6001, 0, 'Nethergarde Analyst', NULL, 49, 51, 210, 0, 0, 6713, 6714, 0, 0, 1.15, 1.15, 0, 0, 1, 1, 0, 0, 2, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 0.2, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6001, 6001, 0, 109, 147, 0, 0, 0, 0, 60010, 0, 0, NULL, '', 0, 3, 0, 0, 6001, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(6002, 0, 'Nethergarde Riftwatcher', NULL, 49, 51, 210, 0, 0, 6738, 6739, 6740, 6742, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.3, 1, 0.9, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6002, 6002, 0, 102, 139, 0, 0, 0, 0, 60020, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 6002, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(6003, 0, 'Nethergarde Officer', NULL, 50, 51, 210, 0, 0, 6752, 6753, 6754, 6755, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 1.5, 1.2, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6003, 0, 0, 103, 140, 0, 0, 0, 0, 60030, 0, 0, NULL, '', 0, 3, 0, 0, 6003, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(7851, 0, 'Nethergarde Elite', NULL, 55, 55, 210, 0, 0, 7910, 7911, 7912, 7913, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 20, 5, 0, 7, 0, 1, 1, 1, 3, 2, 1.4, 3.45, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7851, 0, 0, 418, 550, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7851, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(5995, 4, 'Nethergarde Worker', '', 46, 47, 1575, 0, 0, 6715, 6716, 6717, 6718, 1, 1, 1, 1, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 5995, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(5996, 4, 'Nethergarde Miner', '', 47, 48, 1575, 0, 0, 6719, 6720, 6721, 6722, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 0.25, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5996, 5996, 0, 94, 128, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 5996, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(5997, 4, 'Nethergarde Engineer', '', 47, 48, 1575, 0, 0, 6711, 6712, 0, 0, 1.15, 1.15, 0, 0, 1, 1, 0, 0, 2, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 0.25, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5997, 5997, 0, 92, 125, 0, 0, 0, 0, 59970, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 5997, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(5998, 4, 'Nethergarde Foreman', '', 46, 48, 1575, 0, 0, 6723, 6724, 6725, 6726, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5998, 5998, 0, 91, 124, 0, 0, 0, 0, 59980, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 5998, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(5999, 4, 'Nethergarde Soldier', '', 49, 50, 1575, 0, 0, 6727, 6728, 6729, 6730, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5999, 5999, 0, 109, 147, 0, 0, 0, 0, 59990, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 5999, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(6000, 4, 'Nethergarde Cleric', NULL, 49, 51, 1575, 0, 0, 6731, 6732, 6733, 6734, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.3, 1, 1, 1.35, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6000, 6000, 0, 92, 125, 0, 0, 0, 0, 60000, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 6000, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(6001, 4, 'Nethergarde Analyst', NULL, 49, 51, 1575, 0, 0, 6713, 6714, 0, 0, 1.15, 1.15, 0, 0, 1, 1, 0, 0, 2, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 0.2, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6001, 6001, 0, 109, 147, 0, 0, 0, 0, 60010, 0, 0, NULL, '', 0, 3, 0, 0, 6001, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(6002, 4, 'Nethergarde Riftwatcher', NULL, 49, 51, 1575, 0, 0, 6738, 6739, 6740, 6742, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.3, 1, 0.9, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6002, 6002, 0, 102, 139, 0, 0, 0, 0, 60020, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 6002, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(6003, 4, 'Nethergarde Officer', NULL, 50, 51, 1575, 0, 0, 6752, 6753, 6754, 6755, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 1.5, 1.2, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6003, 0, 0, 103, 140, 0, 0, 0, 0, 60030, 0, 0, NULL, '', 0, 3, 0, 0, 6003, 0, 0, 0, 0, 0, 524416, 0, 0, ''),
(7851, 4, 'Nethergarde Elite', NULL, 55, 55, 1575, 0, 0, 7910, 7911, 7912, 7913, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 20, 5, 0, 7, 0, 1, 1, 1, 3, 2, 1.4, 3.45, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7851, 0, 0, 418, 550, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7851, 0, 0, 0, 0, 0, 524416, 0, 0, '');
-- Caledra Dawnbreeze used faction 12 before 1.6.
DELETE FROM `creature_template` WHERE `entry`=1752;
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(1752, 0, 'Caledra Dawnbreeze', NULL, 60, 60, 12, 0, 0, 4731, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 0.9, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 1752, 0, 0, 0, 0, 0, 138936326, 0, 0, ''),
(1752, 4, 'Caledra Dawnbreeze', NULL, 60, 60, 1576, 0, 0, 4731, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 0.9, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 1752, 0, 0, 0, 0, 0, 138936326, 0, 0, '');
-- Sivlermoon Remnant mobs used faction 84 before 1.6.
DELETE FROM `creature_template` WHERE `entry` IN (2691, 2692, 2693, 2694, 8214, 8563, 8564, 8565, 10824);
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(2691, 0, 'Highvale Outrunner', NULL, 43, 44, 84, 0, 0, 6547, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.42857, 18, 5, 0, 7, 0, 0, 1, 1, 1.2, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2691, 2691, 0, 69, 426, 0, 0, 0, 0, 26910, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 2691, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(2692, 0, 'Highvale Scout', NULL, 44, 45, 84, 0, 0, 6549, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.2, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2692, 2692, 0, 81, 440, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 2692, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(2693, 0, 'Highvale Marksman', NULL, 45, 46, 84, 0, 0, 6546, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1.1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2693, 2693, 0, 84, 456, 0, 0, 0, 0, 26930, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 2693, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(2694, 0, 'Highvale Ranger', NULL, 46, 47, 84, 0, 0, 6548, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.25, 1, 1, 0.9, 0.14, 0, 1600, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2694, 2694, 0, 80, 501, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 2694, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8214, 0, 'Jalinde Summerdrake', NULL, 49, 49, 84, 0, 0, 4731, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.42857, 20, 5, 0, 7, 0, 4, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8214, 8214, 0, 96, 495, 15495, 8806, 6660, 0, 82140, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 8214, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8563, 0, 'Woodsman', NULL, 58, 59, 84, 0, 0, 10382, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8563, 8563, 0, 129, 959, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 8563, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8564, 0, 'Ranger', NULL, 59, 60, 84, 0, 0, 10379, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8564, 8564, 0, 134, 751, 0, 0, 0, 0, 85640, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 8564, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8565, 0, 'Pathstrider', NULL, 57, 58, 84, 0, 0, 10381, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8565, 8565, 0, 126, 905, 0, 0, 0, 0, 85650, 0, 0, NULL, '', 0, 3, 0, 0, 8565, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(10824, 0, 'Ranger Lord Hawkspear', NULL, 60, 60, 84, 0, 0, 10375, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 20, 5, 0, 7, 0, 4, 1, 1, 1.35, 1, 1.1, 1.2, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10824, 0, 0, 139, 187, 15547, 12057, 11978, 0, 108240, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 10824, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(2691, 4, 'Highvale Outrunner', NULL, 43, 44, 1576, 0, 0, 6547, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.42857, 18, 5, 0, 7, 0, 0, 1, 1, 1.2, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2691, 2691, 0, 69, 426, 0, 0, 0, 0, 26910, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 2691, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(2692, 4, 'Highvale Scout', NULL, 44, 45, 1576, 0, 0, 6549, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.2, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2692, 2692, 0, 81, 440, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 2692, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(2693, 4, 'Highvale Marksman', NULL, 45, 46, 1576, 0, 0, 6546, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1.1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2693, 2693, 0, 84, 456, 0, 0, 0, 0, 26930, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 2693, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(2694, 4, 'Highvale Ranger', NULL, 46, 47, 1576, 0, 0, 6548, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.25, 1, 1, 0.9, 0.14, 0, 1600, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2694, 2694, 0, 80, 501, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 2694, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8214, 4, 'Jalinde Summerdrake', NULL, 49, 49, 1576, 0, 0, 4731, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.42857, 20, 5, 0, 7, 0, 4, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8214, 8214, 0, 96, 495, 15495, 8806, 6660, 0, 82140, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 8214, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8563, 4, 'Woodsman', NULL, 58, 59, 1576, 0, 0, 10382, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8563, 8563, 0, 129, 959, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 8563, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8564, 4, 'Ranger', NULL, 59, 60, 1576, 0, 0, 10379, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8564, 8564, 0, 134, 751, 0, 0, 0, 0, 85640, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 8564, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(8565, 4, 'Pathstrider', NULL, 57, 58, 1576, 0, 0, 10381, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8565, 8565, 0, 126, 905, 0, 0, 0, 0, 85650, 0, 0, NULL, '', 0, 3, 0, 0, 8565, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(10824, 4, 'Ranger Lord Hawkspear', NULL, 60, 60, 1576, 0, 0, 10375, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 20, 5, 0, 7, 0, 4, 1, 1, 1.35, 1, 1.1, 1.2, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10824, 0, 0, 139, 187, 15547, 12057, 11978, 0, 108240, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 10824, 0, 0, 0, 0, 0, 524288, 0, 0, '');
-- Ivus and Athramanis used faction 11 before 1.6.
DELETE FROM `creature_template` WHERE `entry` IN (13419, 14187);
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(13419, 3, 'Ivus the Forest Lord', NULL, 61, 61, 11, 0, 0, 14884, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 2.14286, 20, 5, 0, 7, 0, 3, 2, 1, 50, 15, 1.7, 5.3, 0.14, 0, 2000, 1255, 0, 15, 15, 15, 15, 15, 0, 0, 0, 0, 13419, 0, 0, 505, 2525, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 3, 0, 0, 0, 0, 0, 617299803, 0, 0, 2160595008, 0, 0, 'npc_worldboss_a_av'),
(13419, 4, 'Ivus the Forest Lord', NULL, 61, 61, 1594, 0, 0, 14884, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 2.14286, 20, 5, 0, 7, 0, 3, 2, 1, 50, 15, 1.7, 5.3, 0.14, 0, 2000, 1255, 0, 15, 15, 15, 15, 15, 0, 0, 0, 0, 13419, 0, 0, 505, 2525, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 3, 0, 0, 0, 0, 0, 617299803, 0, 0, 2160595008, 0, 0, 'npc_worldboss_a_av'),
(14187, 3, 'Athramanis', 'Bounty Hunter', 60, 60, 11, 2, 0, 14215, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14187, 0, 0, 1, 778, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 3, 0, 0, 14187, 0, 0, 0, 0, 0, 4718592, 0, 0, ''),
(14187, 4, 'Athramanis', 'Bounty Hunter', 60, 60, 1594, 2, 0, 14215, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14187, 0, 0, 1, 778, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 3, 0, 0, 14187, 0, 0, 0, 0, 0, 4718592, 0, 0, '');
-- Malyfous and Lokhtos used faction 35 before 1.5.
DELETE FROM `creature_template` WHERE `entry` IN (10637, 12944);
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(10637, 0, 'Malyfous Darkhammer', 'The Thorium Brotherhood', 59, 59, 35, 3, 2984, 9969, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 10637, 0, 0, 0, 0, 0, 524390, 0, 2, ''),
(10637, 2, 'Malyfous Darkhammer', 'The Thorium Brotherhood', 59, 59, 1475, 3, 2984, 9969, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 1, 1.05, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 10637, 0, 0, 0, 0, 0, 524390, 0, 2, ''),
(12944, 0, 'Lokhtos Darkbargainer', 'The Thorium Brotherhood', 60, 60, 35, 7, 4781, 9969, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 2.4, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 3, 0, 0, 12944, 0, 0, 0, 0, 0, 524390, 0, 2, ''),
(12944, 2, 'Lokhtos Darkbargainer', 'The Thorium Brotherhood', 60, 60, 1475, 7, 4781, 9969, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 2.4, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 3, 0, 0, 12944, 0, 0, 0, 0, 0, 524390, 0, 2, ''),
(12944, 3, 'Lokhtos Darkbargainer', 'The Thorium Brotherhood', 60, 60, 1475, 7, 4781, 14666, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.35, 1, 2.4, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 3, 0, 0, 12944, 0, 0, 0, 0, 0, 524390, 0, 2, '');
-- Jaedanar demons used faction 90 before 1.4.
DELETE FROM `creature_template` WHERE `entry` IN (7107, 7111, 7112, 7113, 7114, 7115, 7116, 7117, 7118, 7119, 7120, 7121, 7125, 7126, 7127, 7128, 9516, 9517, 9518, 9860, 9861, 9862, 9877);
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(7107, 0, 'Jadefire Trickster', NULL, 52, 53, 90, 0, 0, 11337, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7107, 7107, 0, 112, 684, 8552, 13578, 12888, 11980, 71070, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7111, 0, 'Jadefire Hellcaller', NULL, 53, 54, 90, 0, 0, 11335, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 8, 1, 1.3, 1, 1, 1, 0.16, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7111, 7111, 0, 93, 718, 0, 11990, 0, 0, 71110, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7125, 0, 'Jaedenar Hound', NULL, 50, 51, 90, 0, 0, 6172, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7125, 0, 7125, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7126, 0, 'Jaedenar Hunter', NULL, 52, 53, 90, 0, 0, 6173, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7126, 0, 7126, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7127, 0, 'Jaedenar Stalker', '', 1, 1, 90, 0, 0, 1913, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7128, 0, 'Jaedenar Mana Leech', '', 1, 1, 90, 0, 0, 1913, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9516, 0, 'Lord Banehollow', NULL, 59, 59, 90, 0, 0, 8611, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 20, 5, 0, 3, 0, 1, 2, 1, 3, 2, 1, 3.9, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 236, 0, 0, 0, 0, 9516, 0, 0, 399, 526, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''),
(9518, 0, 'Rakaiah', NULL, 56, 56, 90, 0, 0, 10191, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.5, 1.5, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9518, 0, 0, 115, 852, 15968, 17227, 0, 0, 95180, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9860, 0, 'Salia', NULL, 54, 54, 90, 0, 0, 10927, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 1, 1, 1.3, 1, 0.75, 1.15, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9860, 0, 0, 115, 565, 12888, 0, 0, 0, 98600, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9861, 0, 'Moora', NULL, 52, 52, 90, 0, 0, 10926, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9861, 0, 0, 92, 301, 11639, 0, 0, 0, 98610, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9862, 0, 'Jaedenar Legionnaire', NULL, 55, 55, 90, 0, 0, 9129, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.42857, 18, 5, 0, 3, 0, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 50, 0, 0, 50, 0, 0, 0, 0, 0, 9862, 9862, 0, 114, 760, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9877, 0, 'Prince Xavalis', NULL, 55, 55, 90, 0, 0, 11335, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9877, 9877, 0, 103, 797, 11962, 13578, 0, 0, 98770, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7107, 2, 'Jadefire Trickster', NULL, 52, 53, 1434, 0, 0, 11337, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7107, 7107, 0, 112, 684, 8552, 13578, 12888, 11980, 71070, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7111, 2, 'Jadefire Hellcaller', NULL, 53, 54, 1434, 0, 0, 11335, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 8, 1, 1.3, 1, 1, 1, 0.16, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7111, 7111, 0, 93, 718, 0, 11990, 0, 0, 71110, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7125, 2, 'Jaedenar Hound', NULL, 50, 51, 1434, 0, 0, 6172, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7125, 0, 7125, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7126, 2, 'Jaedenar Hunter', NULL, 52, 53, 1434, 0, 0, 6173, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7126, 0, 7126, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7127, 2, 'Jaedenar Stalker', '', 1, 1, 1434, 0, 0, 1913, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7128, 2, 'Jaedenar Mana Leech', '', 1, 1, 1434, 0, 0, 1913, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 15, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9516, 2, 'Lord Banehollow', NULL, 59, 59, 1434, 2, 0, 8611, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 20, 5, 0, 3, 0, 1, 2, 1, 3, 2, 1, 3.9, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 236, 0, 0, 0, 0, 9516, 0, 0, 399, 526, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''),
(9518, 2, 'Rakaiah', NULL, 56, 56, 1434, 0, 0, 10191, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.5, 1.5, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9518, 0, 0, 115, 852, 15968, 17227, 0, 0, 95180, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9860, 2, 'Salia', NULL, 54, 54, 1434, 0, 0, 10927, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 1, 1, 1.3, 1, 0.75, 1.15, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9860, 0, 0, 115, 565, 12888, 0, 0, 0, 98600, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9861, 2, 'Moora', NULL, 52, 52, 1434, 0, 0, 10926, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9861, 0, 0, 92, 301, 11639, 0, 0, 0, 98610, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9862, 2, 'Jaedenar Legionnaire', NULL, 55, 55, 1434, 0, 0, 9129, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.42857, 18, 5, 0, 3, 0, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 50, 0, 0, 50, 0, 0, 0, 0, 0, 9862, 9862, 0, 114, 760, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9877, 2, 'Prince Xavalis', NULL, 55, 55, 1434, 0, 0, 11335, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 3, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9877, 9877, 0, 103, 797, 11962, 13578, 0, 0, 98770, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
-- Jaedanar humanoids used faction 14 before 1.4.
(7112, 0, 'Jaedenar Cultist', NULL, 51, 52, 14, 0, 0, 6389, 6392, 11279, 11283, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.3, 1, 1, 1, 0.18, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7112, 7112, 0, 102, 664, 11980, 20825, 11639, 0, 71120, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7112, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7113, 0, 'Jaedenar Guardian', NULL, 50, 51, 14, 0, 0, 6399, 6400, 11272, 11273, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7113, 7113, 0, 130, 639, 3248, 0, 0, 0, 71130, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7113, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7114, 0, 'Jaedenar Enforcer', NULL, 52, 53, 14, 0, 0, 6397, 6398, 11274, 11275, 0, 0, 1.35, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 1, 1.1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7114, 7114, 0, 104, 706, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7114, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7115, 0, 'Jaedenar Adept', NULL, 51, 52, 14, 0, 0, 6390, 6391, 11276, 11277, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7115, 7115, 0, 127, 675, 20823, 20832, 14514, 0, 71150, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7115, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7116, 0, 'Jaedenar Dreadweaver', '', 1, 1, 14, 0, 0, 6395, 6396, 11284, 11285, 1, 1, 1, 1, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7116, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7117, 0, 'Jaedenar Instigator', '', 1, 1, 14, 0, 0, 6403, 6404, 11286, 11287, 1, 1, 1, 1, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7117, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7118, 0, 'Jaedenar Darkweaver', NULL, 53, 54, 14, 0, 0, 6393, 6394, 11281, 11282, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7118, 7118, 0, 168, 752, 0, 0, 0, 0, 71180, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7118, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7119, 0, 'Jaedenar Summoner', '', 1, 1, 14, 0, 0, 6401, 6402, 11289, 11290, 1, 1, 1, 1, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7119, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7120, 0, 'Jaedenar Warlock', NULL, 53, 54, 14, 0, 0, 6405, 6406, 11291, 11292, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7120, 7120, 0, 156, 726, 0, 0, 0, 0, 71200, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7120, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7121, 0, 'Jaedenar Arch Warlock', '', 1, 1, 14, 0, 0, 11278, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7121, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(9517, 0, 'Shadow Lord Fel\'dan', NULL, 57, 57, 14, 0, 0, 10198, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.35, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9517, 9517, 0, 101, 905, 20825, 16583, 9081, 0, 95170, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 9517, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7112, 2, 'Jaedenar Cultist', NULL, 51, 52, 1434, 0, 0, 6389, 6392, 11279, 11283, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.3, 1, 1, 1, 0.18, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7112, 7112, 0, 102, 664, 11980, 20825, 11639, 0, 71120, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7112, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7113, 2, 'Jaedenar Guardian', NULL, 50, 51, 1434, 0, 0, 6399, 6400, 11272, 11273, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7113, 7113, 0, 130, 639, 3248, 0, 0, 0, 71130, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7113, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7114, 2, 'Jaedenar Enforcer', NULL, 52, 53, 1434, 0, 0, 6397, 6398, 11274, 11275, 0, 0, 1.35, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.3, 1, 1, 1.1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7114, 7114, 0, 104, 706, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7114, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7115, 2, 'Jaedenar Adept', NULL, 51, 52, 1434, 0, 0, 6390, 6391, 11276, 11277, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7115, 7115, 0, 127, 675, 20823, 20832, 14514, 0, 71150, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7115, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7116, 2, 'Jaedenar Dreadweaver', '', 1, 1, 1434, 0, 0, 6395, 6396, 11284, 11285, 1, 1, 1, 1, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7116, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7117, 2, 'Jaedenar Instigator', '', 1, 1, 1434, 0, 0, 6403, 6404, 11286, 11287, 1, 1, 1, 1, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7117, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7118, 2, 'Jaedenar Darkweaver', NULL, 53, 54, 1434, 0, 0, 6393, 6394, 11281, 11282, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7118, 7118, 0, 168, 752, 0, 0, 0, 0, 71180, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7118, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7119, 2, 'Jaedenar Summoner', '', 1, 1, 1434, 0, 0, 6401, 6402, 11289, 11290, 1, 1, 1, 1, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7119, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7120, 2, 'Jaedenar Warlock', NULL, 53, 54, 1434, 0, 0, 6405, 6406, 11291, 11292, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1.3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7120, 7120, 0, 156, 726, 0, 0, 0, 0, 71200, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 7120, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(7121, 2, 'Jaedenar Arch Warlock', '', 1, 1, 1434, 0, 0, 11278, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 7121, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(9517, 2, 'Shadow Lord Fel\'dan', NULL, 57, 57, 1434, 0, 0, 10198, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 8, 1, 1.35, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9517, 9517, 0, 101, 905, 20825, 16583, 9081, 0, 95170, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 9517, 0, 0, 0, 0, 0, 524288, 0, 0, '');
-- Spectral Defender used faction 614 before 1.4.
DELETE FROM `creature_template` WHERE `entry`=11289;
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(11289, 0, 'Spectral Defender', NULL, 57, 58, 614, 0, 0, 10939, 10940, 10941, 10942, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 0.857143, 18, 5, 0, 6, 0, 0, 1, 1, 1.35, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11976, 12169, 0, 0, 112890, 0, 0, '17327', 'EventAI', 1, 3, 0, 0, 11289, 0, 0, 8413718, 0, 0, 524326, 0, 0, ''),
(11289, 2, 'Spectral Defender', NULL, 57, 58, 1454, 0, 0, 10939, 10940, 10941, 10942, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 0.857143, 18, 5, 0, 6, 0, 0, 1, 1, 1.35, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11976, 12169, 0, 0, 112890, 0, 0, '17327', 'EventAI', 1, 3, 0, 0, 11289, 0, 0, 8413718, 0, 0, 524326, 0, 0, '');
-- Rogue Black Drake used faction 103 before 1.3.
DELETE FROM `creature_template` WHERE `entry`=14388;
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
(14388, 0, 'Rogue Black Drake', NULL, 50, 52, 103, 0, 0, 6374, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 20, 5, 0, 2, 0, 1, 1, 1, 3, 2, 1, 1.85, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9573, 0, 0, 0, 143880, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 4, 0, 6, 0, 0, ''),
(14388, 1, 'Rogue Black Drake', NULL, 50, 52, 1394, 0, 0, 6374, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 20, 5, 0, 2, 0, 1, 1, 1, 3, 2, 1, 1.85, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9573, 0, 0, 0, 143880, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 4, 0, 6, 0, 0, '');
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink