DELETE FROM `creature_template` WHERE (`entry`=100084);
REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`,`KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questitem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`)
VALUES ('100084', '0', '0', '0', '0', '0', '27015', '0', '27015', '0', 'Tier 9', 'Immortal Sunrise', null, '0', '200', '20000', '20000', '20000', '20000', '20000', '20000', '35', '35', '4224', '1', '1.14286', '1', '0', '13', '17', '0', '42', '1', '2000', '0', '1', '512', '0', '0', '0', '0', '0', '0', '9', '13', '100', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '2', '0', '2', '');
DELETE FROM `npc_vendor` WHERE (`entry`=100084);
replace into `npc_vendor` VALUES
(100084, 47758, 0, 0, 0),
(100084, 47759, 0, 0, 0),
(100084, 47760, 0, 0, 0),
(100084, 47761, 0, 0, 0),
(100084, 47762, 0, 0, 0),
(100084, 47763, 0, 0, 0),
(100084, 47764, 0, 0, 0),
(100084, 47765, 0, 0, 0),
(100084, 47766, 0, 0, 0),
(100084, 47767, 0, 0, 0),
(100084, 47788, 0, 0, 0),
(100084, 47789, 0, 0, 0),
(100084, 47790, 0, 0, 0),
(100084, 47791, 0, 0, 0),
(100084, 47792, 0, 0, 0),
(100084, 47793, 0, 0, 0),
(100084, 47794, 0, 0, 0),
(100084, 47795, 0, 0, 0),
(100084, 47796, 0, 0, 0),
(100084, 47797, 0, 0, 0),
(100084, 48029, 0, 0, 0),
(100084, 48031, 0, 0, 0),
(100084, 48033, 0, 0, 0),
(100084, 48035, 0, 0, 0),
(100084, 48037, 0, 0, 0),
(100084, 48057, 0, 0, 0),
(100084, 48058, 0, 0, 0),
(100084, 48059, 0, 0, 0),
(100084, 48060, 0, 0, 0),
(100084, 48061, 0, 0, 0),
(100084, 48138, 0, 0, 0),
(100084, 48139, 0, 0, 0),
(100084, 48140, 0, 0, 0),
(100084, 48141, 0, 0, 0),
(100084, 48142, 0, 0, 0),
(100084, 48143, 0, 0, 0),
(100084, 48144, 0, 0, 0),
(100084, 48145, 0, 0, 0),
(100084, 48146, 0, 0, 0),
(100084, 48147, 0, 0, 0),
(100084, 48228, 0, 0, 0),
(100084, 48229, 0, 0, 0),
(100084, 48230, 0, 0, 0),
(100084, 48231, 0, 0, 0),
(100084, 48232, 0, 0, 0),
(100084, 48238, 0, 0, 0),
(100084, 48239, 0, 0, 0),
(100084, 48240, 0, 0, 0),
(100084, 48241, 0, 0, 0),
(100084, 48242, 0, 0, 0),
(100084, 48260, 0, 0, 0),
(100084, 48261, 0, 0, 0),
(100084, 48262, 0, 0, 0),
(100084, 48263, 0, 0, 0),
(100084, 48264, 0, 0, 0),
(100084, 48265, 0, 0, 0),
(100084, 48266, 0, 0, 0),
(100084, 48267, 0, 0, 0),
(100084, 48268, 0, 0, 0),
(100084, 48269, 0, 0, 0),
(100084, 48290, 0, 0, 0),
(100084, 48291, 0, 0, 0),
(100084, 48292, 0, 0, 0),
(100084, 48293, 0, 0, 0),
(100084, 48294, 0, 0, 0),
(100084, 48305, 0, 0, 0),
(100084, 48306, 0, 0, 0),
(100084, 48307, 0, 0, 0),
(100084, 48308, 0, 0, 0),
(100084, 48309, 0, 0, 0),
(100084, 48381, 0, 0, 0),
(100084, 48382, 0, 0, 0),
(100084, 48383, 0, 0, 0),
(100084, 48384, 0, 0, 0),
(100084, 48385, 0, 0, 0),
(100084, 48466, 0, 0, 0),
(100084, 48467, 0, 0, 0),
(100084, 48468, 0, 0, 0),
(100084, 48469, 0, 0, 0),
(100084, 48470, 0, 0, 0),
(100084, 48481, 0, 0, 0),
(100084, 48482, 0, 0, 0),
(100084, 48483, 0, 0, 0),
(100084, 48484, 0, 0, 0),
(100084, 48485, 0, 0, 0),
(100084, 48486, 0, 0, 0),
(100084, 48487, 0, 0, 0),
(100084, 48488, 0, 0, 0),
(100084, 48489, 0, 0, 0),
(100084, 48490, 0, 0, 0),
(100084, 48491, 0, 0, 0),
(100084, 48492, 0, 0, 0),
(100084, 48493, 0, 0, 0),
(100084, 48494, 0, 0, 0),
(100084, 48495, 0, 0, 0),
(100084, 48589, 0, 0, 0),
(100084, 48590, 0, 0, 0),
(100084, 48591, 0, 0, 0),
(100084, 48592, 0, 0, 0),
(100084, 48593, 0, 0, 0),
(100084, 48612, 0, 0, 0),
(100084, 48613, 0, 0, 0),
(100084, 48614, 0, 0, 0),
(100084, 48615, 0, 0, 0),
(100084, 48616, 0, 0, 0);