sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20260714012158_world.sql
T
schell244 51fde6f6f0 Correct creature data based on 1.10 wdb files.
2026-07-14 10:17:03 +02:00

168 lines
60 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`='20260714012158');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20260714012158');
-- Add your query below.
-- Argent Rider
UPDATE `creature_template` SET `rank` = 0, `health_multiplier`=1, `damage_multiplier`=1 WHERE `entry`=11102 && `patch`=0;
-- Silicate Feeder
DELETE FROM `creature_template` WHERE `entry`=15333;
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15333, 7, 'Silicate Feeder', '', 55, 55, 7, 0, 0, 13509, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 10, 0, 0, 1, 1, 2, 1, 1, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15333, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 2155876352, 0, 0, 'mob_silicate_feeder');
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15333, 9, 'Silicate Feeder', '', 55, 55, 7, 0, 0, 13509, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 1, 0, 0, 1, 1, 2, 1, 1, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15333, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 2155876352, 0, 0, 'mob_silicate_feeder');
-- Scarshield Worg
DELETE FROM `creature_template` WHERE `entry`=9416;
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (9416, 0, 'Scarshield Worg', 'Scarshield Legion', 53, 54, 40, 0, 0, 741, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 1, 1, 0, 1, 1, 1.3, 1, 1, 2.5, 0.14, 0, 1500, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9416, 0, 9416, 0, 0, 0, 8297, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, '');
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (9416, 10, 'Scarshield Worg', 'Scarshield Legion', 53, 54, 40, 0, 0, 11420, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 1, 1, 0, 1, 1, 1.3, 1, 1, 2.5, 0.14, 0, 1500, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9416, 0, 9416, 0, 0, 0, 8297, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, '');
-- Irondeep mobs were made non elite in 1.11.
DELETE FROM `creature_template` WHERE `entry` IN (10987, 11600, 11602, 13080, 13081, 13098, 13099, 13396, 13397, 13540, 13541, 13542, 13543, 13544, 13545, 13552, 13553, 13554, 13555, 13556, 13557);
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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
(10987, 3, 'Irondeep Trogg', NULL, 52, 53, 59, 0, 0, 10285, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1.5, 1, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10987, 0, 0, 152, 761, 109870, 0, 0, 0, NULL, 'EventAI', 0, 1, 0, 0, 10987, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(11600, 3, 'Irondeep Shaman', NULL, 53, 54, 59, 0, 0, 10285, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3, 1.5, 0.95, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116000, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11600, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(11602, 3, 'Irondeep Skullthumper', NULL, 54, 55, 59, 0, 0, 10285, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1.5, 1, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116020, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11602, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(13080, 3, 'Irondeep Guard', NULL, 54, 55, 1216, 0, 0, 13311, 13313, 13312, 13314, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 2.4, 1, 1.25, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130800, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13080, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13081, 3, 'Irondeep Raider', NULL, 54, 55, 1214, 2, 0, 13434, 13435, 13436, 13437, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 2.4, 1, 1, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130810, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13081, 0, 0, 0, 0, 0, 524292, 0, 0, 'AV_mines'),
(13098, 3, 'Irondeep Surveyor', NULL, 54, 55, 1216, 0, 0, 13315, 13317, 13316, 13318, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 2.4, 2, 1.25, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130980, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13098, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13099, 3, 'Irondeep Explorer', NULL, 54, 55, 1214, 0, 0, 13430, 13431, 13432, 13433, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 2.4, 2, 0.95, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13099, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13396, 3, 'Irondeep Miner', NULL, 52, 53, 1216, 2, 0, 556, 308, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2, 0, 0.666668, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 1.8, 0.4, 1.25, 1.3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13396, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(13397, 3, 'Irondeep Peon', NULL, 52, 53, 1214, 2, 0, 13335, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 1.8, 1, 1, 1.3, 0.14, 0, 2000, 2000, 0, 15, 15, 15, 15, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13397, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13540, 3, 'Seasoned Irondeep Explorer', NULL, 56, 57, 1214, 0, 0, 13769, 13770, 13771, 13772, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3, 1, 1, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135400, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13540, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13541, 3, 'Veteran Irondeep Explorer', NULL, 58, 59, 1214, 0, 0, 13773, 13774, 13775, 13776, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3.6, 2, 0.9, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135410, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13541, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13542, 3, 'Champion Irondeep Explorer', NULL, 60, 60, 1214, 2, 0, 13777, 13778, 13779, 13780, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 4.2, 1, 1, 1.7, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135420, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13542, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13543, 3, 'Seasoned Irondeep Raider', NULL, 56, 57, 1214, 0, 0, 13590, 13591, 13592, 13593, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1, 1.05, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135430, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13543, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13544, 3, 'Veteran Irondeep Raider', NULL, 58, 59, 1214, 0, 0, 13594, 13595, 13596, 13597, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3.6, 1, 0.95, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135440, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13544, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13545, 3, 'Champion Irondeep Raider', NULL, 60, 60, 1214, 2, 0, 13598, 13599, 13600, 13601, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 4.2, 1, 1, 1.7, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135450, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13545, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13552, 3, 'Seasoned Irondeep Guard', NULL, 56, 57, 1216, 0, 0, 13781, 13782, 13783, 13784, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1, 1.25, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135520, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13552, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13553, 3, 'Veteran Irondeep Guard', NULL, 58, 59, 1216, 0, 0, 13785, 13787, 13786, 13788, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3.6, 1, 1.25, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135530, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13553, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13554, 3, 'Champion Irondeep Guard', NULL, 60, 60, 1216, 0, 0, 13789, 13791, 13790, 13792, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 4.2, 1, 1.25, 1.7, 0.14, 0, 2000, 1310, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135540, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13554, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13555, 3, 'Seasoned Irondeep Surveyor', NULL, 56, 57, 1216, 0, 0, 13795, 13796, 13797, 13798, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3, 2, 1.25, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135550, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13555, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13556, 3, 'Veteran Irondeep Surveyor', NULL, 58, 59, 1216, 0, 0, 13799, 13800, 13801, 13802, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3.6, 2, 1.25, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135560, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13556, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13557, 3, 'Champion Irondeep Surveyor', NULL, 60, 60, 1216, 0, 0, 13803, 13804, 13805, 13806, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 4.2, 2, 1.25, 1.7, 0.09, 0, 2000, 1347, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135570, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13557, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(10987, 9, 'Irondeep Trogg', NULL, 52, 53, 59, 0, 0, 10285, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1.5, 1, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10987, 0, 0, 152, 761, 109870, 0, 0, 0, NULL, 'EventAI', 0, 1, 0, 0, 10987, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(11600, 9, 'Irondeep Shaman', NULL, 53, 54, 59, 0, 0, 10285, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.5, 1.5, 0.95, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116000, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11600, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(11602, 9, 'Irondeep Skullthumper', NULL, 54, 55, 59, 0, 0, 10285, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1.5, 1, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116020, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11602, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(13080, 9, 'Irondeep Guard', NULL, 54, 55, 1216, 0, 0, 13311, 13313, 13312, 13314, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.4, 1, 1.25, 0.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130800, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13080, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13081, 9, 'Irondeep Raider', NULL, 54, 55, 1214, 2, 0, 13434, 13435, 13436, 13437, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.4, 1, 1, 0.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130810, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13081, 0, 0, 0, 0, 0, 524292, 0, 0, 'AV_mines'),
(13098, 9, 'Irondeep Surveyor', NULL, 54, 55, 1216, 0, 0, 13315, 13317, 13316, 13318, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.4, 2, 1.25, 0.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130980, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13098, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13099, 9, 'Irondeep Explorer', NULL, 54, 55, 1214, 0, 0, 13430, 13431, 13432, 13433, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.4, 2, 0.95, 0.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13099, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13396, 9, 'Irondeep Miner', NULL, 52, 53, 1216, 2, 0, 556, 308, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2, 0, 0.666668, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.3, 0.4, 1.25, 0.3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13396, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(13397, 9, 'Irondeep Peon', NULL, 52, 53, 1214, 2, 0, 13335, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.3, 1, 1, 0.3, 0.14, 0, 2000, 2000, 0, 15, 15, 15, 15, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13397, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13540, 9, 'Seasoned Irondeep Explorer', NULL, 56, 57, 1214, 0, 0, 13769, 13770, 13771, 13772, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.5, 1, 1, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135400, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13540, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13541, 9, 'Veteran Irondeep Explorer', NULL, 58, 59, 1214, 0, 0, 13773, 13774, 13775, 13776, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.6, 2, 0.9, 0.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135410, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13541, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13542, 9, 'Champion Irondeep Explorer', NULL, 60, 60, 1214, 2, 0, 13777, 13778, 13779, 13780, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.7, 1, 1, 0.7, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135420, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13542, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13543, 9, 'Seasoned Irondeep Raider', NULL, 56, 57, 1214, 0, 0, 13590, 13591, 13592, 13593, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1, 1.05, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135430, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13543, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13544, 9, 'Veteran Irondeep Raider', NULL, 58, 59, 1214, 0, 0, 13594, 13595, 13596, 13597, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.6, 1, 0.95, 0.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135440, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13544, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13545, 9, 'Champion Irondeep Raider', NULL, 60, 60, 1214, 2, 0, 13598, 13599, 13600, 13601, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.7, 1, 1, 0.7, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135450, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13545, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13552, 9, 'Seasoned Irondeep Guard', NULL, 56, 57, 1216, 0, 0, 13781, 13782, 13783, 13784, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1, 1.25, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135520, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13552, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13553, 9, 'Veteran Irondeep Guard', NULL, 58, 59, 1216, 0, 0, 13785, 13787, 13786, 13788, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.6, 1, 1.25, 0.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135530, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13553, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13554, 9, 'Champion Irondeep Guard', NULL, 60, 60, 1216, 0, 0, 13789, 13791, 13790, 13792, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.7, 1, 1.25, 0.7, 0.14, 0, 2000, 1310, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135540, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13554, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13555, 9, 'Seasoned Irondeep Surveyor', NULL, 56, 57, 1216, 0, 0, 13795, 13796, 13797, 13798, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.5, 2, 1.25, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135550, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13555, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13556, 9, 'Veteran Irondeep Surveyor', NULL, 58, 59, 1216, 0, 0, 13799, 13800, 13801, 13802, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.6, 2, 1.25, 0.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135560, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13556, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13557, 9, 'Champion Irondeep Surveyor', NULL, 60, 60, 1216, 0, 0, 13803, 13804, 13805, 13806, 0, 0, 0, 0, 25, 25, 25, 25, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.7, 2, 1.25, 0.7, 0.09, 0, 2000, 1347, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135570, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13557, 0, 0, 0, 0, 0, 4718596, 0, 0, '');
-- Whitewhisker mobs were made non elite in 1.11.
DELETE FROM `creature_template` WHERE `entry` IN (10982, 11603, 11604, 11605);
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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
(10982, 3, 'Whitewhisker Vermin', NULL, 52, 53, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1.5, 1, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10982, 0, 0, 152, 761, 109820, 0, 0, 0, NULL, '', 0, 1, 0, 0, 10982, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(11603, 3, 'Whitewhisker Digger', NULL, 52, 53, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1.5, 1, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11603, 0, 0, 152, 761, 0, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11603, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(11604, 3, 'Whitewhisker Geomancer', NULL, 53, 54, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3, 0.5, 0.95, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116040, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11604, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(11605, 3, 'Whitewhisker Overseer', NULL, 54, 55, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 4.2, 1.5, 1, 1.7, 0.14, 0, 2400, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116050, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11605, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(10982, 9, 'Whitewhisker Vermin', NULL, 52, 53, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1.5, 1, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10982, 0, 0, 152, 761, 109820, 0, 0, 0, NULL, '', 0, 1, 0, 0, 10982, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(11603, 9, 'Whitewhisker Digger', NULL, 52, 53, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1.5, 1, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11603, 0, 0, 152, 761, 0, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11603, 0, 0, 0, 0, 0, 524288, 0, 0, ''),
(11604, 9, 'Whitewhisker Geomancer', NULL, 53, 54, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.5, 0.5, 0.95, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116040, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11604, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(11605, 9, 'Whitewhisker Overseer', NULL, 54, 55, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.6, 1.5, 1, 0.7, 0.14, 0, 2400, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116050, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11605, 0, 0, 0, 0, 0, 524292, 0, 0, '');
-- Coldmine mobs were made non elite in 1.11.
DELETE FROM `creature_template` WHERE `entry` IN (13087, 13089, 13096, 13097, 13316, 13317, 13534, 13535, 13536, 13537, 13538, 13539, 13546, 13547, 13548, 13549, 13550, 13551);
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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
(13087, 3, 'Coldmine Invader', NULL, 54, 55, 1216, 0, 0, 13326, 13328, 13630, 13631, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 2.4, 1, 1.25, 1.4, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130870, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13087, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13089, 3, 'Coldmine Guard', NULL, 54, 55, 1214, 0, 0, 13322, 13323, 13325, 13562, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 2.4, 1, 1, 1.55, 0.14, 0, 2800, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130890, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13089, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13096, 3, 'Coldmine Explorer', NULL, 54, 55, 1216, 0, 0, 13895, 13896, 13552, 13553, 1.15, 1.15, 1.15, 1.15, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 2.4, 2, 1.25, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13096, 0, 0, 147, 737, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13096, 0, 0, 0, 0, 0, 4718592, 0, 0, 'AV_mines'),
(13097, 3, 'Coldmine Surveyor', NULL, 54, 55, 1214, 0, 0, 13330, 13331, 13540, 13537, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 2.4, 2, 1, 1.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130970, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13097, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13316, 3, 'Coldmine Peon', NULL, 52, 53, 1214, 0, 0, 13334, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 1.8, 1, 1, 1.3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13316, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13317, 3, 'Coldmine Miner', NULL, 52, 53, 1216, 0, 0, 556, 308, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2, 0, 0.666668, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 1.8, 1, 1.25, 1.3, 0.14, 0, 2000, 1292, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13317, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(13534, 3, 'Seasoned Coldmine Guard', NULL, 56, 57, 1214, 2, 0, 13567, 13568, 13569, 13570, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1, 1, 1.7, 0.14, 0, 2800, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135340, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13534, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13535, 3, 'Veteran Coldmine Guard', NULL, 58, 59, 1214, 2, 0, 13571, 13572, 13573, 13574, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3.6, 1, 0.95, 1.8, 0.14, 0, 2800, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135350, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13535, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13536, 3, 'Champion Coldmine Guard', NULL, 60, 60, 1214, 2, 0, 13563, 13564, 13565, 13566, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 4.2, 1, 1.1, 1.9, 0.14, 0, 2800, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135360, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13536, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13537, 3, 'Seasoned Coldmine Surveyor', NULL, 56, 57, 1214, 2, 0, 13544, 13546, 13548, 13550, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3, 2, 1, 1.5, 0.14, 0, 2000, 1338, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135370, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13537, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13538, 3, 'Veteran Coldmine Surveyor', NULL, 58, 59, 1214, 2, 0, 13554, 13555, 13556, 13557, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3.6, 2, 1, 1.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135380, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13538, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13539, 3, 'Champion Coldmine Surveyor', NULL, 60, 60, 1214, 2, 0, 13558, 13559, 13560, 13561, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 4.2, 2, 1.35, 1.7, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135390, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13539, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13546, 3, 'Seasoned Coldmine Explorer', NULL, 56, 57, 1216, 0, 0, 13891, 13892, 13538, 13539, 1.15, 1.15, 1.15, 1.15, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3, 2, 1.25, 1.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13546, 0, 0, 152, 761, 135460, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13546, 0, 0, 0, 0, 0, 4718592, 0, 0, ''),
(13547, 3, 'Veteran Coldmine Explorer', NULL, 58, 59, 1216, 0, 0, 13893, 13894, 13547, 13549, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 3.6, 2, 0.95, 1.6, 0.14, 0, 2000, 1329, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135470, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13547, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13548, 3, 'Champion Coldmine Explorer', NULL, 60, 60, 1216, 0, 0, 13889, 13890, 13533, 13534, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 4.2, 2, 1.35, 1.7, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135480, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13548, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13549, 3, 'Seasoned Coldmine Invader', NULL, 56, 57, 1216, 0, 0, 13636, 13637, 13638, 13639, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3, 1, 1.25, 1.5, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135490, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13549, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13550, 3, 'Veteran Coldmine Invader', NULL, 58, 59, 1216, 0, 0, 13640, 13641, 13642, 13643, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 3.6, 1, 1.25, 1.6, 0.14, 0, 2000, 1320, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135500, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13550, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13551, 3, 'Champion Coldmine Invader', NULL, 60, 60, 1216, 0, 0, 13632, 13633, 13634, 13635, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 4.2, 1, 1.25, 1.7, 0.14, 0, 2000, 1292, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135510, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13551, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13087, 9, 'Coldmine Invader', NULL, 54, 55, 1216, 0, 0, 13326, 13328, 13630, 13631, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.4, 1, 1.25, 0.4, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130870, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13087, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13089, 9, 'Coldmine Guard', NULL, 54, 55, 1214, 0, 0, 13322, 13323, 13325, 13562, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.4, 1, 1, 0.55, 0.14, 0, 2800, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130890, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13089, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13096, 9, 'Coldmine Explorer', NULL, 54, 55, 1216, 0, 0, 13895, 13896, 13552, 13553, 1.15, 1.15, 1.15, 1.15, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.4, 2, 1.25, 0.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13096, 0, 0, 147, 737, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13096, 0, 0, 0, 0, 0, 4718592, 0, 0, 'AV_mines'),
(13097, 9, 'Coldmine Surveyor', NULL, 54, 55, 1214, 0, 0, 13330, 13331, 13540, 13537, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.4, 2, 1, 0.4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130970, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13097, 0, 0, 0, 0, 0, 4718596, 0, 0, 'AV_mines'),
(13316, 9, 'Coldmine Peon', NULL, 52, 53, 1214, 0, 0, 13334, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.3, 1, 1, 0.3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13316, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13317, 9, 'Coldmine Miner', NULL, 52, 53, 1216, 0, 0, 556, 308, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2, 0, 0.666668, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.3, 1, 1.25, 0.3, 0.14, 0, 2000, 1292, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13317, 0, 0, 0, 0, 0, 524292, 0, 0, ''),
(13534, 9, 'Seasoned Coldmine Guard', NULL, 56, 57, 1214, 2, 0, 13567, 13568, 13569, 13570, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1, 1, 0.7, 0.14, 0, 2800, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135340, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13534, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13535, 9, 'Veteran Coldmine Guard', NULL, 58, 59, 1214, 2, 0, 13571, 13572, 13573, 13574, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.6, 1, 0.95, 0.8, 0.14, 0, 2800, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135350, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13535, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13536, 9, 'Champion Coldmine Guard', NULL, 60, 60, 1214, 2, 0, 13563, 13564, 13565, 13566, 0, 0, 1.35, 1.25, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.7, 1, 1.1, 0.9, 0.14, 0, 2800, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135360, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13536, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13537, 9, 'Seasoned Coldmine Surveyor', NULL, 56, 57, 1214, 2, 0, 13544, 13546, 13548, 13550, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.5, 2, 1, 0.5, 0.14, 0, 2000, 1338, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135370, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13537, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13538, 9, 'Veteran Coldmine Surveyor', NULL, 58, 59, 1214, 2, 0, 13554, 13555, 13556, 13557, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.6, 2, 1, 0.6, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135380, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13538, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13539, 9, 'Champion Coldmine Surveyor', NULL, 60, 60, 1214, 2, 0, 13558, 13559, 13560, 13561, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.7, 2, 1.35, 0.7, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135390, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13539, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13546, 9, 'Seasoned Coldmine Explorer', NULL, 56, 57, 1216, 0, 0, 13891, 13892, 13538, 13539, 1.15, 1.15, 1.15, 1.15, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.5, 2, 1.25, 0.5, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13546, 0, 0, 152, 761, 135460, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13546, 0, 0, 0, 0, 0, 4718592, 0, 0, ''),
(13547, 9, 'Veteran Coldmine Explorer', NULL, 58, 59, 1216, 0, 0, 13893, 13894, 13547, 13549, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.6, 2, 0.95, 0.6, 0.14, 0, 2000, 1329, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135470, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 13547, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13548, 9, 'Champion Coldmine Explorer', NULL, 60, 60, 1216, 0, 0, 13889, 13890, 13533, 13534, 0, 0, 0, 0, 1, 1, 1, 1, 4, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 0.7, 2, 1.35, 0.7, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135480, 0, 0, 0, NULL, 'EventAI', 1, 3, 0, 0, 13548, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13549, 9, 'Seasoned Coldmine Invader', NULL, 56, 57, 1216, 0, 0, 13636, 13637, 13638, 13639, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.5, 1, 1.25, 0.5, 0.14, 0, 2000, 1301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135490, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13549, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13550, 9, 'Veteran Coldmine Invader', NULL, 58, 59, 1216, 0, 0, 13640, 13641, 13642, 13643, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.6, 1, 1.25, 0.6, 0.14, 0, 2000, 1320, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135500, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13550, 0, 0, 0, 0, 0, 4718596, 0, 0, ''),
(13551, 9, 'Champion Coldmine Invader', NULL, 60, 60, 1216, 0, 0, 13632, 13633, 13634, 13635, 0, 0, 0, 0, 40, 40, 10, 10, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 0.7, 1, 1.25, 0.7, 0.14, 0, 2000, 1292, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 135510, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13551, 0, 0, 0, 0, 0, 4718596, 0, 0, '');
-- Mine bosses in AV were made non elite in 1.11.
DELETE FROM `creature_template` WHERE `entry` IN (11657, 13078, 13079, 11677, 13086, 13088);
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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
(11657, 3, 'Morloch', NULL, 58, 58, 59, 0, 0, 5945, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 5, 2, 1, 3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11657, 0, 0, 157, 786, 116570, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11657, 0, 0, 1011483136, 0, 0, 524288, 0, 0, ''),
(11677, 3, 'Taskmaster Snivvle', NULL, 58, 58, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 2, 1, 5, 1, 1, 3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 116770, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11677, 0, 0, 1011483136, 0, 0, 524292, 0, 0, ''),
(13078, 3, 'Umi Thorson', NULL, 58, 58, 1216, 0, 0, 13299, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 5, 1, 1.25, 3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13078, 0, 0, 157, 786, 130780, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13078, 0, 0, 1011483136, 0, 0, 4718592, 0, 0, ''),
(13079, 3, 'Keetar', NULL, 58, 58, 1214, 0, 0, 13300, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 5, 1, 1.25, 3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130790, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13079, 0, 0, 1011483136, 0, 0, 4718596, 0, 0, ''),
(13086, 3, 'Aggi Rumblestomp', NULL, 58, 58, 1216, 0, 0, 13298, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 5, 1, 1.3, 3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130860, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13086, 0, 0, 1011483136, 0, 0, 4718596, 0, 0, ''),
(13088, 3, 'Masha Swiftcut', NULL, 58, 58, 1214, 0, 0, 13305, 0, 0, 0, 0, 0, 0, 0, 25, 0, 0, 0, 25, 0, 1, 1.14286, 18, 5, 0, 7, 0, 1, 1, 1, 5, 1, 1.3, 3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130880, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13088, 0, 0, 1011483136, 0, 0, 4718596, 0, 0, ''),
(11657, 9, 'Morloch', NULL, 58, 58, 59, 0, 0, 5945, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 1, 1, 2, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11657, 0, 0, 157, 786, 116570, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11657, 0, 0, 1011483136, 0, 0, 524288, 0, 0, ''),
(11677, 9, 'Taskmaster Snivvle', NULL, 58, 58, 26, 0, 0, 371, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 2, 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, 116770, 0, 0, 0, NULL, 'EventAI', 1, 1, 0, 0, 11677, 0, 0, 1011483136, 0, 0, 524292, 0, 0, ''),
(13078, 9, 'Umi Thorson', NULL, 58, 58, 1216, 0, 0, 13299, 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.25, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13078, 0, 0, 157, 786, 130780, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13078, 0, 0, 1011483136, 0, 0, 4718592, 0, 0, ''),
(13079, 9, 'Keetar', NULL, 58, 58, 1214, 0, 0, 13300, 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, 1, 1.25, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130790, 0, 0, 0, NULL, '', 0, 3, 0, 0, 13079, 0, 0, 1011483136, 0, 0, 4718596, 0, 0, ''),
(13086, 9, 'Aggi Rumblestomp', NULL, 58, 58, 1216, 0, 0, 13298, 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, 1, 1.3, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130860, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13086, 0, 0, 1011483136, 0, 0, 4718596, 0, 0, ''),
(13088, 9, 'Masha Swiftcut', NULL, 58, 58, 1214, 0, 0, 13305, 0, 0, 0, 0, 0, 0, 0, 25, 0, 0, 0, 25, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1.3, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130880, 0, 0, 0, NULL, '', 1, 3, 0, 0, 13088, 0, 0, 1011483136, 0, 0, 4718596, 0, 0, '');
-- Tranquil Mechanical Yeti
DELETE FROM `creature_template` WHERE `entry`=15699;
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15699, 7, 'Tranquil Mechanical Yeti', NULL, 1, 1, 35, 0, 0, 10269, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 9, 0, 0, 1, 1, 1, 1, 1, 1.3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 2, '');
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15699, 10, 'Tranquil Mechanical Yeti', NULL, 1, 1, 35, 0, 0, 10269, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 1, 0, 0, 1, 1, 1, 1, 1, 1.3, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 2, '');
-- Lieutenant Murp
DELETE FROM `creature_template` WHERE `entry`=13146;
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (13146, 3, 'Lieutenant Murp', NULL, 59, 59, 1214, 2, 0, 1693, 0, 0, 0, 2, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 20, 5, 0, 7, 0, 1, 1, 1, 8, 4, 1, 4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13146, 0, 0, 1, 858, 131460, 0, 0, 0, NULL, '', 1, 1, 0, 0, 13146, 0, 0, 1011483136, 0, 0, 4718592, 0, 0, '');
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (13146, 9, 'Lieutenant Murp', NULL, 59, 59, 1214, 2, 0, 1693, 0, 0, 0, 2, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 20, 5, 0, 6, 0, 1, 1, 1, 8, 4, 1, 4, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13146, 0, 0, 1, 858, 131460, 0, 0, 0, NULL, '', 1, 1, 0, 0, 13146, 0, 0, 1011483136, 0, 0, 4718592, 0, 0, '');
-- Winter Reindeer
DELETE FROM `creature_template` WHERE `entry`=15706;
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15706, 6, 'Winter Reindeer', '', 1, 1, 4, 0, 0, 15904, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 10, 0, 0, 1, 1, 1, 1, 1, 0.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, NULL, '', 0, 3, 0, 0, 0, 0, 0, 16384, 0, 0, 6, 0, 2, '');
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15706, 10, 'Winter Reindeer', '', 1, 1, 4, 0, 0, 15904, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 1, 0, 0, 1, 1, 1, 1, 1, 0.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, NULL, '', 0, 3, 0, 0, 0, 0, 0, 16384, 0, 0, 6, 0, 2, '');
-- Mechanical Chicken
DELETE FROM `creature_template` WHERE `entry`=8376;
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (8376, 0, 'Mechanical Chicken', NULL, 1, 1, 35, 0, 0, 7920, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 9, 0, 0, 1, 1, 1, 1, 1, 6.65, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 16384, 0, 0, 6, 0, 2, '');
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (8376, 10, 'Mechanical Chicken', NULL, 1, 1, 35, 0, 0, 7920, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 1, 0, 0, 1, 1, 1, 1, 1, 6.65, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 16384, 0, 0, 6, 0, 2, '');
-- Ouro Scarab
DELETE FROM `creature_template` WHERE `entry`=15718;
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15718, 7, 'Ouro Scarab', '', 60, 60, 16, 0, 0, 15682, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2.14286, 20, 5, 0, 10, 0, 1, 1, 1, 3, 1, 1, 2.5, 0.14, 0, 1000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2155872262, 0, 0, 'npc_ouro_scarab');
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_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `totem_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 (15718, 8, 'Ouro Scarab', '', 60, 60, 16, 0, 0, 11108, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2.14286, 20, 5, 0, 10, 0, 1, 1, 1, 3, 1, 1, 2.5, 0.14, 0, 1000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2155872262, 0, 0, 'npc_ouro_scarab');
-- 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