API tools faq
paste
Advertisement
Guest User

Dire Maul Challenge SQL

a guest
Aug 1st, 2013
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 13.97 KB | None | 0 0
raw download clone embed print report diff
  1. 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
  2. ('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'),
  3. ('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'),
  4. ('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'),
  5. ('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'),
  6. ('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'),
  7. ('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'),
  8. ('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'),
  9. ('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'),
  10. ('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'),
  11. ('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'),
  12. ('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'),
  13. ('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'),
  14. ('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'),
  15. ('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'),
  16. ('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'),
  17. ('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'),
  18. ('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'),
  19. ('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'),
  20. ('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'),
  21. ('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'),
  22. ('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'),
  23. ('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'),
  24. ('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'),
  25. ('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'),
  26. ('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');
  27.  
  28.  
  29. UPDATE creature_template SET ScriptName='npc_army_ghoul' WHERE entry='24207';
  30. UPDATE creature_template SET TYPE='1' WHERE (entry='88022');
  31. UPDATE creature_template SET TYPE='7' WHERE (entry='88023');
  32. UPDATE creature_template SET TYPE='7' WHERE (entry='80700');
  33. UPDATE creature_template SET TYPE='7' WHERE (entry='88500');
  34. UPDATE creature_template SET unit_class='1' WHERE (entry='88002');
  35. UPDATE creature_template SET unit_class='1' WHERE (entry='88500');
  36. UPDATE `creature_template` SET `ScriptName`='npc_dm_wave_portals' WHERE (`entry`='88501');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!