View difference between Paste ID: cPzBkReE and iYfJZRFQ

 INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `iconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `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`,`spell5`,`spell6`,`spell7`,`spell8`,`PetSpellDataId`,`VehicleId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`HoverHeight`,`Health_mod`,`Mana_mod`,`Armor_mod`,`RacialLeader`,`QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4`,`QuestItem5`,`QuestItem6`,`movementID`,`RegenHealth`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`) VALUES
 ('88002', '0', '0', '0', '0', '0', '18653', '18653', '18653', '18653', 'Mini Blood Guard', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '0.5', '0', '1209', '1414', '0', '212', '1', '1782', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '1', '2.5', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_red_blood_mini', '12340'),
 ('88003', '0', '0', '0', '0', '0', '18653', '18653', '18653', '18653', 'Mini Blood Guard', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '0.5', '0', '781', '834', '0', '212', '1', '1782', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '1', '2.5', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_red_blood_mini', '12340'),
 ('88004', '0', '0', '0', '0', '0', '18653', '18653', '18653', '18653', 'Mini Blood Guard', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '0.5', '0', '781', '982', '0', '212', '1', '1673', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '1', '2.5', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_red_blood_mini', '12340'),
 ('88500', '0', '0', '0', '0', '0', '169', '0', '0', '0', 'Wave Spawn Trigger', null, null, '0', '1', '1', '0', '16', '16', '0', '1', '1.14286', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '128', 'npc_dm_wave_trigger', '12340'),
 ('88501', '0', '0', '0', '0', '0', '27393', '0', '0', '0', 'Portal', null, null, '0', '1', '1', '0', '35', '35', '0', '1', '1.14286', '1', '0', '0', '0', '0', '0', '1', '0', '0', '1', '768', '8', '8', '0', '0', '0', '0', '0', '0', '0', '0', '10', '1024', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '12', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '', '12340'),
 ('88001', '0', '0', '0', '0', '0', '18653', '18653', '18653', '18653', 'Red Blood Guard', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '781', '1021', '0', '332', '1', '2102', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '1', '13', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dire_maul_rb_guard', '12340'),
 ('80700', '0', '0', '0', '0', '0', '0', '28930', '0', '28930', 'Arena Commander', 'Arena Commander', '', '0', '80', '80', '0', '35', '35', '1', '0.91', '1.14286', '1', '3', '4781', '6231', '0', '0', '1', '1900', '80', '1', '1', '0', '8', '8', '0', '0', '0', '0', '0', '0', '0', '100', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '1', '5', '9', '4', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dire_arena_commander', '12340'),
 ('80050', '0', '0', '0', '0', '0', '24842', '0', '0', '0', 'Garm Watcher', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '387', '543', '0', '528', '1', '2000', '0', '1', '32768', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_wave_spawns', '12340'),
 ('80051', '0', '0', '0', '0', '0', '26740', '0', '0', '0', 'Frigid Proto-Drake', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '422', '586', '0', '642', '1', '2000', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_wave_spawns', '12340'),
 ('80052', '0', '0', '0', '0', '0', '25495', '0', '0', '0', 'Osterkil', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '431', '582', '0', '608', '1', '2000', '0', '2', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_wave_spawns', '12340'),
 ('80053', '0', '0', '0', '0', '0', '27541', '0', '0', '0', 'Blight Falconer', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '417', '582', '0', '608', '1', '2000', '0', '2', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_wave_spawns', '12340'),
 ('80054', '0', '0', '0', '0', '0', '27776', '27777', '27778', '27779', 'Converted Hero', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '417', '582', '0', '608', '1', '1992', '0', '2', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_wave_spawns', '12340'),
 ('88011', '0', '0', '0', '0', '0', '27930', '0', '0', '0', 'Hank the Tank', 'Arena Defender', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '2', '341', '454', '0', '343', '1', '1783', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '18', '1', '4', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_hank_the_tank', '12340'),
 ('88012', '0', '0', '0', '0', '0', '17544', '0', '0', '0', 'Field Medic', 'Hank the Tank\'s Guardian', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '2', '189', '232', '0', '0', '1', '2000', '0', '2', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '20', '34', '1', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', 'npc_dm_field_medic', '12340'),
 ('88013', '0', '0', '0', '0', '0', '24918', '0', '0', '0', 'Rogue Initiate', 'Arena Champion', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '1', '331', '546', '0', '112', '1', '1721', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '20', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_main_rogue', '12340'),
 ('88014', '0', '0', '0', '0', '0', '24919', '0', '0', '0', 'Rogue Initiate', 'Minion of the Champ', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '1', '273', '341', '0', '89', '1', '1611', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '16', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_rogue_initiate', '12340'),
 ('88015', '0', '0', '0', '0', '0', '24919', '0', '0', '0', 'Rogue Initiate', 'Minion of the Champ', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '1', '273', '341', '0', '89', '1', '1611', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '16', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_rogue_initiate', '12340'),
 ('88016', '0', '0', '0', '0', '0', '25446', '0', '0', '0', 'The Unholy', 'Arena Gladiator', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '782', '992', '0', '781', '1', '2100', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '22', '1', '3', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_main_unholy', '12340'),
 ('88017', '0', '0', '0', '0', '0', '25496', '0', '0', '0', 'The Unholy Twin', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '681', '893', '0', '677', '1', '2000', '0', '1', '0', '8', '8', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '19', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_unholy_twin', '12340'),
 ('88018', '0', '0', '0', '0', '0', '25467', '0', '0', '0', 'Guin', 'Pet of The Unholy', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '221', '432', '0', '112', '1', '1604', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '13', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_unholy_pet', '12340'),
 ('88019', '0', '0', '0', '0', '0', '25083', '0', '0', '0', 'Riders Guardian', 'Arena Medic', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '1', '331', '341', '0', '32', '1', '1676', '0', '2', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '18', '32', '1', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', 'npc_dm_rider_guardian', '12340'),
 ('88020', '0', '0', '0', '0', '0', '25082', '0', '0', '0', 'Rider Brute', 'Arena Brute', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '1', '1331', '1651', '0', '443', '1', '2000', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '22', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_rider_brute', '12340'),
 ('88021', '0', '0', '0', '0', '0', '25082', '0', '0', '0', 'Rider Brute', 'Arena Brute', null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '822', '920', '0', '443', '1', '2200', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '18', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_rider_brute', '12340'),
 ('88022', '0', '0', '0', '0', '0', '25015', '0', '0', '0', 'Arena Dragon', 'Spawn of Death', null, '0', '82', '82', '0', '16', '16', '0', '1', '1.14286', '1', '4', '273', '663', '0', '544', '1', '1892', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '38', '1', '3.5', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'npc_dm_dragon_final', '12340'),
 ('88023', '0', '0', '0', '0', '0', '169', '0', '0', '0', 'Dragon Boss Trigger', null, null, '0', '80', '80', '0', '16', '16', '0', '1', '1.14286', '1', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '128', '', '1');
 
 
 UPDATE creature_template SET ScriptName='npc_army_ghoul' WHERE entry='24207';
 UPDATE creature_template SET type='1' WHERE (entry='88022');
 UPDATE creature_template SET type='7' WHERE (entry='88023');
 UPDATE creature_template SET type='7' WHERE (entry='80700');
 UPDATE creature_template SET type='7' WHERE (entry='88500');
 UPDATE creature_template SET unit_class='1' WHERE (entry='88002');
 UPDATE creature_template SET unit_class='1' WHERE (entry='88500');
 UPDATE `creature_template` SET `ScriptName`='npc_dm_wave_portals' WHERE (`entry`='88501');