API tools faq
paste
Advertisement
carcar21

Creature_1.sql

carcar21
Jul 30th, 2015
1,145
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.12 KB | None | 0 0
raw download clone embed print report
  1. /*updated by carcar21*/
  2. REPLACE INTO creature_template (entry, modelid1, name, subname, minlevel, maxlevel, faction, npcflag, scale) VALUES
  3. ('500000', '18239', 'Alchemy', 'Recipes', '80', '80', '35', '4225', '0.25'),
  4. ('500001', '18239', 'Amulets', 'Armor', '80', '80', '35', '4225', '0.25'),
  5. ('500002', '18239', 'Arena Season 1', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  6. ('500003', '18239', 'Arena Season 2', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  7. ('500004', '18239', 'Arena Season 3', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  8. ('500005', '18239', 'Arena Season 4', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  9. ('500006', '18239', 'Arena Season 5 (Deadly Gladiator)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  10. ('500007', '18239', 'Arena Season 5 (Hateful Gladiator)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  11. ('500008', '18239', 'Arena Season 5 (Savage Gladiator)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  12. ('500009', '18239', 'Arena Season 6', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  13. ('500010', '18239', 'Arena Season 7', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  14. ('500011', '18239', 'Armor Tokens', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  15. ('500012', '18239', 'Bandages', 'Consumbales', '80', '80', '35', '4225', '0.25'),
  16. ('500013', '18239', 'Blacksmithing', 'Recipes', '80', '80', '35', '4225', '0.25'),
  17. ('500014', '18239', 'Blue', 'Gems', '80', '80', '35', '4225', '0.25'),
  18. ('500015', '18239', 'Boocks', 'Recipes', '80', '80', '35', '4225', '0.25'),
  19. ('500016', '18239', 'Bows', 'Weapons', '80', '80', '35', '4225', '0.25'),
  20. ('500017', '18239', 'Cloaks', 'Armor', '80', '80', '35', '4225', '0.25'),
  21. ('500018', '18239', 'Cloth', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  22. ('500019', '18239', 'Commendations', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  23. ('500020', '18239', 'Containers', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  24. ('500021', '18239', 'Cooking', 'Recipes', '80', '80', '35', '4225', '0.25'),
  25. ('500022', '18239', 'Crafting', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  26. ('500023', '18239', 'Crossbows', 'Weapons', '80', '80', '35', '4225', '0.25'),
  27. ('500024', '18239', 'Currency', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  28. ('500025', '18239', 'Daggers', 'Weapons', '80', '80', '35', '4225', '0.25'),
  29. ('500026', '18239', 'Death Knight', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  30. ('500027', '18239', 'Druid', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  31. ('500028', '18239', 'Elemental', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  32. ('500029', '18239', 'Elixirs', 'Consumables', '80', '80', '35', '4225', '0.25'),
  33. ('500030', '18239', 'Enchanting', 'Recipes', '80', '80', '35', '4225', '0.25'),
  34. ('500031', '18239', 'Enchanting', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  35. ('500032', '18239', 'Engineering', 'Recipes', '80', '80', '35', '4225', '0.25'),
  36. ('500033', '18239', 'Epic Mounts', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  37. ('500034', '18239', 'First Aid', 'Recipes', '80', '80', '35', '4225', '0.25'),
  38. ('500035', '18239', 'Fishing', 'Recipes', '80', '80', '35', '4225', '0.25'),
  39. ('500036', '18239', 'Fishing Poles', 'Weapons', '80', '80', '35', '4225', '0.25'),
  40. ('500037', '18239', 'Fist Weapons', 'Weapons', '80', '80', '35', '4225', '0.25'),
  41. ('500038', '18239', 'Flasks', 'Consumables', '80', '80', '35', '4225', '0.25'),
  42. ('500039', '18239', 'Flying Mounts', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  43. ('500040', '18239', 'Gems', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  44. ('500041', '18239', 'Green', 'Gems', '80', '80', '35', '4225', '0.25'),
  45. ('500042', '18239', 'Guns', 'Weapons', '80', '80', '35', '4225', '0.25'),
  46. ('500043', '18239', 'Herbs', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  47. ('500044', '18239', 'Hierlooms', 'Weapons', '80', '80', '35', '4225', '0.25'),
  48. ('500045', '18239', 'Hierlooms', 'Armor', '80', '80', '35', '4225', '0.25'),
  49. ('500046', '18239', 'Hunter', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  50. ('500047', '18239', 'Inscription', 'Recipes', '80', '80', '35', '4225', '0.25'),
  51. ('500048', '18239', 'Inscription', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  52. ('500049', '18239', 'Item Enhancements (Permanent)', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  53. ('500050', '18239', 'Item Enhancements (Temporary)', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  54. ('500051', '18239', 'Jewelcrafting', 'Recipes', '80', '80', '35', '4225', '0.25'),
  55. ('500052', '18239', 'Jewelcrafting', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  56. ('500053', '18239', 'Keys', 'Muscellaneous', '80', '80', '35', '4225', '0.25'),
  57. ('500054', '18239', 'Leather', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  58. ('500055', '18239', 'Leatherworking', 'Recipes', '80', '80', '35', '4225', '0.25'),
  59. ('500056', '18239', 'Legendary', 'Weapons', '80', '80', '35', '4225', '0.25'),
  60. ('500057', '18239', 'Mage', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  61. ('500058', '18239', 'Cooking', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  62. ('500059', '18239', 'Meta', 'Gems', '80', '80', '35', '4225', '0.25'),
  63. ('500060', '18239', 'Metal & Stone', 'Trade Goods', '80', '80', '35', '4225', '0.25'),
  64. ('500061', '18239', 'Mining', 'Recipes', '80', '80', '35', '4225', '0.25'),
  65. ('500062', '18239', 'Mounts', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  66. ('500063', '18239', 'Off-Hand', 'Armor', '80', '80', '35', '4225', '0.25'),
  67. ('500064', '18239', 'One-Hand Axes', 'Weapons', '80', '80', '35', '4225', '0.25'),
  68. ('500065', '18239', 'One-Hand Maces', 'Weapons', '80', '80', '35', '4225', '0.25'),
  69. ('500066', '18239', 'One-Hand Swords', 'Weapons', '80', '80', '35', '4225', '0.25'),
  70. ('500067', '18239', 'Orange', 'Gems', '80', '80', '35', '4225', '0.25'),
  71. ('500068', '18239', 'Paladin', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  72. ('500069', '18239', 'Pets', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  73. ('500070', '18239', 'Polearms', 'Weapons', '80', '80', '35', '4225', '0.25'),
  74. ('500071', '18239', 'Prismatic', 'Gems', '80', '80', '35', '4225', '0.25'),
  75. ('500072', '18239', 'Projectiles', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  76. ('500073', '18239', 'Purple', 'Gems', '80', '80', '35', '4225', '0.25'),
  77. ('500074', '18239', 'Quivers', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  78. ('500075', '18239', 'Raid Tier 1', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  79. ('500076', '18239', 'Raid Tier 2', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  80. ('500077', '18239', 'Raid Tier 3', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  81. ('500078', '18239', 'Raid Tier 4', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  82. ('500079', '18239', 'Raid Tier 5', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  83. ('500080', '18239', 'Raid Tier 6', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  84. ('500081', '18239', 'Raid Tier 7', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  85. ('500082', '18239', 'Raid Tier 7.5', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  86. ('500083', '18239', 'Raid Tier 8', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  87. ('500084', '18239', 'Raid Tier 8.5', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  88. ('500085', '18239', 'Raid Tier 9 (Alliance)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  89. ('500086', '18239', 'Raid Tier 9.5 (Alliance)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  90. ('500087', '18239', 'Raid Tier 9.5 (Alliance-Heroic)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  91. ('500088', '18239', 'Raid Tier 10', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  92. ('500089', '18239', 'Raid Tier 10.5 (Heroic)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  93. ('500090', '18239', 'Raid Tier 10.5 (Heroic)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  94. ('500091', '18239', 'Reagents', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  95. ('500092', '18239', 'Red', 'Gems', '80', '80', '35', '4225', '0.25'),
  96. ('500093', '18239', 'Relics', 'Armor', '80', '80', '35', '4225', '0.25'),
  97. ('500094', '18239', 'Rings', 'Armor', '80', '80', '35', '4225', '0.25'),
  98. ('500095', '18239', 'Rogue', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  99. ('500096', '18239', 'Scrolls', 'Consumables', '80', '80', '35', '4225', '0.25'),
  100. ('500097', '18239', 'Shaman', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  101. ('500098', '18239', 'Shields', 'Armor', '80', '80', '35', '4225', '0.25'),
  102. ('500099', '18239', 'Shirts', 'Armor', '80', '80', '35', '4225', '0.25'),
  103. ('500100', '18239', 'Staves', 'Weapons', '80', '80', '35', '4225', '0.25'),
  104. ('500101', '18239', 'Tabards', 'Armor', '80', '80', '35', '4225', '0.25'),
  105. ('500102', '18239', 'Tailoring', 'Recipes', '80', '80', '35', '4225', '0.25'),
  106. ('500103', '18239', 'Blizzard Collectables', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  107. ('500104', '18239', 'Thrown', 'Weapons', '80', '80', '35', '4225', '0.25'),
  108. ('500105', '18239', 'Trinkets', 'Armor', '80', '80', '35', '4225', '0.25'),
  109. ('500106', '18239', 'Two-Handed Axes', 'Weapons', '80', '80', '35', '4225', '0.25'),
  110. ('500107', '18239', 'Two-Handed Maces', 'Weapons', '80', '80', '35', '4225', '0.25'),
  111. ('500108', '18239', 'Two-Handed Swords', 'Weapons', '80', '80', '35', '4225', '0.25'),
  112. ('500109', '18239', 'Wands', 'Weapons', '80', '80', '35', '4225', '0.25'),
  113. ('500110', '18239', 'Warlock', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  114. ('500111', '18239', 'Warrior', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  115. ('500112', '18239', 'Yellow', 'Gems', '80', '80', '35', '4225', '0.25'),
  116. ('500113', '18239', 'Priest', 'Glyphs', '80', '80', '35', '4225', '0.25'),
  117. ('500114', '18239', 'Arena Season 8', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  118. ('500115', '18239', 'PvP Accessories', 'Armor', '80', '80', '35', '4225', '0.25'),
  119. ('500116', '18239', 'Arena Season 1', 'Weapons', '80', '80', '35', '4225', '0.25'),
  120. ('500117', '18239', 'Arena Season 2', 'Weapons', '80', '80', '35', '4225', '0.25'),
  121. ('500118', '18239', 'Arena Season 3', 'Weapons', '80', '80', '35', '4225', '0.25'),
  122. ('500119', '18239', 'Arena Season 4', 'Weapons', '80', '80', '35', '4225', '0.25'),
  123. ('500120', '18239', 'Arena Season 5', 'Weapons', '80', '80', '35', '4225', '0.25'),
  124. ('500121', '18239', 'Arena Season 6', 'Weapons', '80', '80', '35', '4225', '0.25'),
  125. ('500122', '18239', 'Arena Season 7', 'Weapons', '80', '80', '35', '4225', '0.25'),
  126. ('500123', '18239', 'Arena Season 8', 'Weapons', '80', '80', '35', '4225', '0.25'),
  127. ('500124', '18239', 'Rings II', 'Armor', '80', '80', '35', '4225', '0.25'),
  128. ('500125', '18239', 'Blacksmithing II', 'Recipes', '80', '80', '35', '4225', '0.25'),
  129. ('500126', '18239', 'Enchanting II', 'Recipes', '80', '80', '35', '4225', '0.25'),
  130. ('500127', '18239', 'Tailoring II', 'Recipes', '80', '80', '35', '4225', '0.25'),
  131. ('500128', '18239', 'Leatherworking II', 'Recipes', '80', '80', '35', '4225', '0.25'),
  132. ('500129', '18239', 'Leatherworking III', 'Recipes', '80', '80', '35', '4225', '0.25'),
  133. ('500130', '18239', 'Jewelcrafting II', 'Recipes', '80', '80', '35', '4225', '0.25'),
  134. ('500131', '18239', 'Jewelcrafting III', 'Recipes', '80', '80', '35', '4225', '0.25'),
  135. ('500132', '18239', 'Raid Tier 9 (Horde)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  136. ('500133', '18239', 'Raid Tier 9.5 (Horde)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  137. ('500134', '18239', 'Raid Tier 9.5 (Horde-Heroic)', 'Item Sets', '80', '80', '35', '4225', '0.25'),
  138. ('500135', '18239', 'Potions', 'Consumables', '80', '80', '35', '4225', '0.25'),
  139. ('500136', '18239', 'Weapon Enchant Scrolls', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  140. ('500137', '18239', 'Armor Enchant Scrolls', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  141. ('500138', '18239', 'Armor Enchant Scrolls II', 'Miscellaneous', '80', '80', '35', '4225', '0.25'),
  142. ('500139', '18239', 'Boots', 'Armor', '80', '80', '35', '4225', '0.25'),
  143. ('500140', '18239', 'Boots II', 'Armor', '80', '80', '35', '4225', '0.25'),
  144. ('500141', '18239', 'Belts', 'Armor', '80', '80', '35', '4225', '0.25'),
  145. ('500142', '18239', 'Belts II', 'Armor', '80', '80', '35', '4225', '0.25'),
  146. ('500143', '18239', 'Bracers', 'Armor', '80', '80', '35', '4225', '0.25'),
  147. ('500144', '18239', 'Bracers II', 'Armor', '80', '80', '35', '4225', '0.25');
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!