API tools faq
paste
Advertisement
Guest User

Start Spells / Skills.

a guest
Apr 19th, 2013
534
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.54 KB | None | 0 0
raw download clone embed print report
  1. -- Delete any spells for no errors.
  2. DELETE FROM `playercreateinfo_spell` WHERE `note`='Hunter Spell';
  3. DELETE FROM `playercreateinfo_spell` WHERE `note`='Priest Spell';
  4. DELETE FROM `playercreateinfo_spell` WHERE `note`='Warlock Spell';
  5. DELETE FROM `playercreateinfo_spell` WHERE `note`='Deathknight Spell';
  6. DELETE FROM `playercreateinfo_spell` WHERE `note`='Mage Spell';
  7. DELETE FROM `playercreateinfo_spell` WHERE `note`='Druid Spell';
  8. DELETE FROM `playercreateinfo_spell` WHERE `note`='Paladin Spell';
  9. DELETE FROM `playercreateinfo_spell` WHERE `note`='Warrior Spell';
  10. DELETE FROM `playercreateinfo_spell` WHERE `note`='Rogue Spell';
  11. DELETE FROM `playercreateinfo_spell` WHERE `note`='Shaman Spell';
  12. DELETE FROM `playercreateinfo_spell` WHERE `note`='Mage portal - Horde';
  13. DELETE FROM `playercreateinfo_spell` WHERE `note`='Mage portal - Alliance';
  14.  
  15. -- Warrior Spells
  16.  
  17. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '7384', 'Warrior Spell');
  18. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '3127', 'Warrior Spell');
  19. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47436', 'Warrior Spell');
  20. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47450', 'Warrior Spell');
  21. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '11578', 'Warrior Spell');
  22. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47465', 'Warrior Spell');
  23. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47502', 'Warrior Spell');
  24. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '34428', 'Warrior Spell');
  25. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '1715', 'Warrior Spell');
  26. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '2687', 'Warrior Spell');
  27. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '71', 'Warrior Spell');
  28. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '7386', 'Warrior Spell');
  29. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '355', 'Warrior Spell');
  30. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '72', 'Warrior Spell');
  31. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47437', 'Warrior Spell');
  32. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '57823', 'Warrior Spell');
  33. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '694', 'Warrior Spell');
  34. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '2565', 'Warrior Spell');
  35. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '676', 'Warrior Spell');
  36. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47520', 'Warrior Spell');
  37. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '20230', 'Warrior Spell');
  38. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '12678', 'Warrior Spell');
  39. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47471', 'Warrior Spell');
  40. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '1161', 'Warrior Spell');
  41. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '871', 'Warrior Spell');
  42. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '2458', 'Warrior Spell');
  43. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '20252', 'Warrior Spell');
  44. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47475', 'Warrior Spell');
  45. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '18499', 'Warrior Spell');
  46. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '1680', 'Warrior Spell');
  47. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '6552', 'Warrior Spell');
  48. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47488', 'Warrior Spell');
  49. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '1719', 'Warrior Spell');
  50. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '23920', 'Warrior Spell');
  51. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '47440', 'Warrior Spell');
  52. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '3411', 'Warrior Spell');
  53. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '64382', 'Warrior Spell');
  54. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '55694', 'Warrior Spell');
  55. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '57755', 'Warrior Spell');
  56. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '5246', 'Warrior Spell');
  57. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1', '3124', 'Warrior Spell');
  58.  
  59. -- Paladin Spells
  60.  
  61. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48932', 'Paladin Spell');
  62. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '19752', 'Paladin Spell');
  63. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '31801', 'Paladin Spell');
  64. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '19746', 'Paladin Spell');
  65. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '3127', 'Paladin Spell');
  66. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48942', 'Paladin Spell');
  67. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48782', 'Paladin Spell');
  68. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '20271', 'Paladin Spell');
  69. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '498', 'Paladin Spell');
  70. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '853', 'Paladin Spell');
  71. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '1152', 'Paladin Spell');
  72. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '10278', 'Paladin Spell');
  73. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48788', 'Paladin Spell');
  74. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '53408', 'Paladin Spell');
  75. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48950', 'Paladin Spell');
  76. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48936', 'Paladin Spell');
  77. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '31789', 'Paladin Spell');
  78. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '62124', 'Paladin Spell');
  79. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '54043', 'Paladin Spell');
  80. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '25780', 'Paladin Spell');
  81. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '1044', 'Paladin Spell');
  82. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '20217', 'Paladin Spell');
  83. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48819', 'Paladin Spell');
  84. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48801', 'Paladin Spell');
  85. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48785', 'Paladin Spell');
  86. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '5502', 'Paladin Spell');
  87. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '20164', 'Paladin Spell');
  88. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '10326', 'Paladin Spell');
  89. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '1038', 'Paladin Spell');
  90. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '53407', 'Paladin Spell');
  91. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48943', 'Paladin Spell');
  92. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '20165', 'Paladin Spell');
  93. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48945', 'Paladin Spell');
  94. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '642', 'Paladin Spell');
  95. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48947', 'Paladin Spell');
  96. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '20166', 'Paladin Spell');
  97. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '4987', 'Paladin Spell');
  98. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48806', 'Paladin Spell');
  99. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '6940', 'Paladin Spell');
  100. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48817', 'Paladin Spell');
  101. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48934', 'Paladin Spell');
  102. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '48938', 'Paladin Spell');
  103. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '25898', 'Paladin Spell');
  104. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '32223', 'Paladin Spell');
  105. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '31884', 'Paladin Spell');
  106. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '54428', 'Paladin Spell');
  107. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '61411', 'Paladin Spell');
  108. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '53601', 'Paladin Spell');
  109. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '33388', 'Paladin Spell');
  110. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '33391', 'Paladin Spell');
  111. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '34769', 'Paladin Spell');
  112. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '34767', 'Paladin Spell');
  113. INSERT INTO `playercreateinfo_spell` VALUES ('0', '2', '5589', 'Paladin Spell');
  114.  
  115. -- Hunter Spells
  116.  
  117. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '1494', 'Hunter Spell');
  118. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '13163', 'Hunter Spell');
  119. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '48996', 'Hunter Spell');
  120. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '49001', 'Hunter Spell');
  121. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '49045', 'Hunter Spell');
  122. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '53338', 'Hunter Spell');
  123. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '5116', 'Hunter Spell');
  124. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '27044', 'Hunter Spell');
  125. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '883', 'Hunter Spell');
  126. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '2641', 'Hunter Spell');
  127. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '6991', 'Hunter Spell');
  128. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '982', 'Hunter Spell');
  129. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '1515', 'Hunter Spell');
  130. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19883', 'Hunter Spell');
  131. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '20736', 'Hunter Spell');
  132. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '48990', 'Hunter Spell');
  133. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '2974', 'Hunter Spell');
  134. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '6197', 'Hunter Spell');
  135. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '1002', 'Hunter Spell');
  136. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '14327', 'Hunter Spell');
  137. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '5118', 'Hunter Spell');
  138. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '49056', 'Hunter Spell');
  139. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '53339', 'Hunter Spell');
  140. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '49048', 'Hunter Spell');
  141. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19884', 'Hunter Spell');
  142. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '34074', 'Hunter Spell');
  143. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '781', 'Hunter Spell');
  144. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '14311', 'Hunter Spell');
  145. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '1462', 'Hunter Spell');
  146. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19885', 'Hunter Spell');
  147. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19880', 'Hunter Spell');
  148. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '13809', 'Hunter Spell');
  149. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '13161', 'Hunter Spell');
  150. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '5384', 'Hunter Spell');
  151. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '1543', 'Hunter Spell');
  152. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19878', 'Hunter Spell');
  153. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '49067', 'Hunter Spell');
  154. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '3034', 'Hunter Spell');
  155. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '13159', 'Hunter Spell');
  156. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19882', 'Hunter Spell');
  157. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '58434', 'Hunter Spell');
  158. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '49071', 'Hunter Spell');
  159. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '49052', 'Hunter Spell');
  160. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19879', 'Hunter Spell');
  161. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19263', 'Hunter Spell');
  162. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '19801', 'Hunter Spell');
  163. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '34026', 'Hunter Spell');
  164. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '34600', 'Hunter Spell');
  165. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '34477', 'Hunter Spell');
  166. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '61006', 'Hunter Spell');
  167. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '61847', 'Hunter Spell');
  168. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '53271', 'Hunter Spell');
  169. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '60192', 'Hunter Spell');
  170. INSERT INTO `playercreateinfo_spell` VALUES ('0', '4', '62757', 'Hunter Spell');
  171.  
  172. -- Rogue Spells
  173.  
  174. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '3127', 'Rogue Spell');
  175. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '674', 'Rogue Spell');
  176. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48668', 'Rogue Spell');
  177. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48638', 'Rogue Spell');
  178. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1784', 'Rogue Spell');
  179. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48657', 'Rogue Spell');
  180. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '921', 'Rogue Spell');
  181. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1776', 'Rogue Spell');
  182. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '26669', 'Rogue Spell');
  183. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '51724', 'Rogue Spell');
  184. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '6774', 'Rogue Spell');
  185. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '11305', 'Rogue Spell');
  186. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1766', 'Rogue Spell');
  187. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48676', 'Rogue Spell');
  188. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48659', 'Rogue Spell');
  189. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1804', 'Rogue Spell');
  190. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '8647', 'Rogue Spell');
  191. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48691', 'Rogue Spell');
  192. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '51722', 'Rogue Spell');
  193. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48672', 'Rogue Spell');
  194. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1725', 'Rogue Spell');
  195. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '26889', 'Rogue Spell');
  196. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '2836', 'Rogue Spell');
  197. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1833', 'Rogue Spell');
  198. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1842', 'Rogue Spell');
  199. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '8643', 'Rogue Spell');
  200. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '2094', 'Rogue Spell');
  201. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '1860', 'Rogue Spell');
  202. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '57993', 'Rogue Spell');
  203. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '48674', 'Rogue Spell');
  204. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '31224', 'Rogue Spell');
  205. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '5938', 'Rogue Spell');
  206. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '57934', 'Rogue Spell');
  207. INSERT INTO `playercreateinfo_spell` VALUES ('0', '8', '51723', 'Rogue Spell');
  208.  
  209. -- Priest Spells
  210.  
  211. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '2053', 'Priest Spell');
  212. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48161', 'Priest Spell');
  213. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48123', 'Priest Spell');
  214. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48125', 'Priest Spell');
  215. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48066', 'Priest Spell');
  216. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '586', 'Priest Spell');
  217. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48068', 'Priest Spell');
  218. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48127', 'Priest Spell');
  219. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48171', 'Priest Spell');
  220. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48168', 'Priest Spell');
  221. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '10890', 'Priest Spell');
  222. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '6064', 'Priest Spell');
  223. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '988', 'Priest Spell');
  224. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48300', 'Priest Spell');
  225. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '6346', 'Priest Spell');
  226. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48071', 'Priest Spell');
  227. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48135', 'Priest Spell');
  228. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48078', 'Priest Spell');
  229. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '453', 'Priest Spell');
  230. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '9484', 'Priest Spell');
  231. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '10909', 'Priest Spell');
  232. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '8129', 'Priest Spell');
  233. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48073', 'Priest Spell');
  234. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '605', 'Priest Spell');
  235. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48072', 'Priest Spell');
  236. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48169', 'Priest Spell');
  237. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '552', 'Priest Spell');
  238. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '1706', 'Priest Spell');
  239. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48063', 'Priest Spell');
  240. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48162', 'Priest Spell');
  241. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48170', 'Priest Spell');
  242. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48074', 'Priest Spell');
  243. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48158', 'Priest Spell');
  244. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48120', 'Priest Spell');
  245. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '34433', 'Priest Spell');
  246. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '48113', 'Priest Spell');
  247. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '32375', 'Priest Spell');
  248. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '64843', 'Priest Spell');
  249. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '64901', 'Priest Spell');
  250. INSERT INTO `playercreateinfo_spell` VALUES ('0', '16', '53023', 'Priest Spell');
  251.  
  252. -- Death Knight Spells
  253.  
  254. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '3124', 'Deathknight Spell');
  255. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '50842', 'Deathknight Spell');
  256. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '49941', 'Deathknight Spell');
  257. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '49930', 'Deathknight Spell');
  258. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '47476', 'Deathknight Spell');
  259. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '45529', 'Deathknight Spell');
  260. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '3714', 'Deathknight Spell');
  261. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '56222', 'Deathknight Spell');
  262. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '48743', 'Deathknight Spell');
  263. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '48263', 'Deathknight Spell');
  264. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '49909', 'Deathknight Spell');
  265. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '47528', 'Deathknight Spell');
  266. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '45524', 'Deathknight Spell');
  267. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '48792', 'Deathknight Spell');
  268. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '57623', 'Deathknight Spell');
  269. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '56815', 'Deathknight Spell');
  270. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '47568', 'Deathknight Spell');
  271. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '49895', 'Deathknight Spell');
  272. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '50977', 'Deathknight Spell');
  273. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '49921', 'Deathknight Spell');
  274. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '46584', 'Deathknight Spell');
  275. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '49938', 'Deathknight Spell');
  276. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '48707', 'Deathknight Spell');
  277. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '48265', 'Deathknight Spell');
  278. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '61999', 'Deathknight Spell');
  279. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '42650', 'Deathknight Spell');
  280. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '53428', 'Deathknight Spell');
  281. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '53331', 'Deathknight Spell');
  282. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '54447', 'Deathknight Spell');
  283. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '53342', 'Deathknight Spell');
  284. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '54446', 'Deathknight Spell');
  285. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '53323', 'Deathknight Spell');
  286. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '53344', 'Deathknight Spell');
  287. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '70164', 'Deathknight Spell');
  288. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '62158', 'Deathknight Spell');
  289. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '48778', 'Deathknight Spell');
  290. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '51425', 'Deathknight Spell');
  291. INSERT INTO `playercreateinfo_spell` VALUES ('0', '32', '49924', 'Deathknight Spell');
  292.  
  293. -- Shaman Spells
  294.  
  295. INSERT INTO `playercreateinfo_spell` VALUES ('11', '64', '32182', 'Shaman spell');
  296. INSERT INTO `playercreateinfo_spell` VALUES ('8', '64', '2825', 'Shaman spell');
  297. INSERT INTO `playercreateinfo_spell` VALUES ('6', '64', '2825', 'Shaman spell');
  298. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49273', 'Shaman Spell');
  299. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49238', 'Shaman Spell');
  300. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '10399', 'Shaman Spell');
  301. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49231', 'Shaman Spell');
  302. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58753', 'Shaman Spell');
  303. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '2484', 'Shaman Spell');
  304. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49281', 'Shaman Spell');
  305. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58582', 'Shaman Spell');
  306. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49233', 'Shaman Spell');
  307. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58790', 'Shaman Spell');
  308. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58704', 'Shaman Spell');
  309. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58643', 'Shaman Spell');
  310. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49277', 'Shaman Spell');
  311. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '61657', 'Shaman Spell');
  312. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '8012', 'Shaman Spell');
  313. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '526', 'Shaman Spell');
  314. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '2645', 'Shaman Spell');
  315. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '57994', 'Shaman Spell');
  316. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '8143', 'Shaman Spell');
  317. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49236', 'Shaman Spell');
  318. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58796', 'Shaman Spell');
  319. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58757', 'Shaman Spell');
  320. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49276', 'Shaman Spell');
  321. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '57960', 'Shaman Spell');
  322. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '131', 'Shaman Spell');
  323. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58745', 'Shaman Spell');
  324. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '6196', 'Shaman Spell');
  325. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58734', 'Shaman Spell');
  326. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58774', 'Shaman Spell');
  327. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58739', 'Shaman Spell');
  328. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58656', 'Shaman Spell');
  329. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '546', 'Shaman Spell');
  330. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '556', 'Shaman Spell');
  331. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '66842', 'Shaman Spell');
  332. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '51994', 'Shaman Spell');
  333. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '8177', 'Shaman Spell');
  334. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58749', 'Shaman Spell');
  335. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '20608', 'Shaman Spell');
  336. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '36936', 'Shaman Spell');
  337. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '58804', 'Shaman Spell');
  338. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '49271', 'Shaman Spell');
  339. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '8512', 'Shaman Spell');
  340. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '6495', 'Shaman Spell');
  341. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '8170', 'Shaman Spell');
  342. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '66843', 'Shaman Spell');
  343. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '55459', 'Shaman Spell');
  344. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '66844', 'Shaman Spell');
  345. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '3738', 'Shaman Spell');
  346. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '2894', 'Shaman Spell');
  347. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '60043', 'Shaman Spell');
  348. INSERT INTO `playercreateinfo_spell` VALUES ('0', '64', '51514', 'Shaman Spell');
  349.  
  350. -- Mage Spells
  351.  
  352. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42995', 'Mage Spell');
  353. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42833', 'Mage Spell');
  354. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '27090', 'Mage Spell');
  355. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42842', 'Mage Spell');
  356. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '33717', 'Mage Spell');
  357. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42873', 'Mage Spell');
  358. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42846', 'Mage Spell');
  359. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '12826', 'Mage Spell');
  360. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '28271', 'Mage Spell');
  361. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '61780', 'Mage Spell');
  362. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '61721', 'Mage Spell');
  363. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '28272', 'Mage Spell');
  364. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '61305', 'Mage Spell');
  365. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42917', 'Mage Spell');
  366. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43015', 'Mage Spell');
  367. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '130', 'Mage Spell');
  368. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42921', 'Mage Spell');
  369. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42926', 'Mage Spell');
  370. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43017', 'Mage Spell');
  371. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '475', 'Mage Spell');
  372. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '1953', 'Mage Spell');
  373. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42940', 'Mage Spell');
  374. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '12051', 'Mage Spell');
  375. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43010', 'Mage Spell');
  376. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43020', 'Mage Spell');
  377. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43012', 'Mage Spell');
  378. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42859', 'Mage Spell');
  379. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '2139', 'Mage Spell');
  380. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42931', 'Mage Spell');
  381. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42985', 'Mage Spell');
  382. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43008', 'Mage Spell');
  383. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '45438', 'Mage Spell');
  384. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43024', 'Mage Spell');
  385. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43002', 'Mage Spell');
  386. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '43046', 'Mage Spell');
  387. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42897', 'Mage Spell');
  388. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42914', 'Mage Spell');
  389. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '66', 'Mage Spell');
  390. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '58659', 'Mage Spell');
  391. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '30449', 'Mage Spell');
  392. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '42956', 'Mage Spell');
  393. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '47610', 'Mage Spell');
  394. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '61316', 'Mage Spell');
  395. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '61024', 'Mage Spell');
  396. INSERT INTO `playercreateinfo_spell` VALUES ('0', '128', '55342', 'Mage Spell');
  397.  
  398. -- Warlock Spells
  399.  
  400. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '696', 'Warlock Spell');
  401. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47811', 'Warlock Spell');
  402. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47809', 'Warlock Spell');
  403. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '688', 'Warlock Spell');
  404. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47813', 'Warlock Spell');
  405. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '50511', 'Warlock Spell');
  406. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '57946', 'Warlock Spell');
  407. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47864', 'Warlock Spell');
  408. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '6215', 'Warlock Spell');
  409. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47878', 'Warlock Spell');
  410. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47855', 'Warlock Spell');
  411. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '697', 'Warlock Spell');
  412. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47856', 'Warlock Spell');
  413. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47857', 'Warlock Spell');
  414. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '5697', 'Warlock Spell');
  415. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47884', 'Warlock Spell');
  416. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47815', 'Warlock Spell');
  417. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47889', 'Warlock Spell');
  418. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47820', 'Warlock Spell');
  419. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '698', 'Warlock Spell');
  420. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '712', 'Warlock Spell');
  421. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '126', 'Warlock Spell');
  422. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '5138', 'Warlock Spell');
  423. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '5500', 'Warlock Spell');
  424. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '11719', 'Warlock Spell');
  425. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '132', 'Warlock Spell');
  426. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '60220', 'Warlock Spell');
  427. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '18647', 'Warlock Spell');
  428. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '61191', 'Warlock Spell');
  429. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47823', 'Warlock Spell');
  430. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '691', 'Warlock Spell');
  431. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47865', 'Warlock Spell');
  432. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47891', 'Warlock Spell');
  433. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47888', 'Warlock Spell');
  434. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '17928', 'Warlock Spell');
  435. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47860', 'Warlock Spell');
  436. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47825', 'Warlock Spell');
  437. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '1122', 'Warlock Spell');
  438. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47867', 'Warlock Spell');
  439. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '18540', 'Warlock Spell');
  440. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47893', 'Warlock Spell');
  441. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47838', 'Warlock Spell');
  442. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '29858', 'Warlock Spell');
  443. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '58887', 'Warlock Spell');
  444. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '47836', 'Warlock Spell');
  445. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '61290', 'Warlock Spell');
  446. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '48018', 'Warlock Spell');
  447. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '48020', 'Warlock Spell');
  448. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '33388', 'Warlock Spell');
  449. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '33391', 'Warlock Spell');
  450. INSERT INTO `playercreateinfo_spell` VALUES ('0', '256', '23161', 'Warlock Spell');
  451.  
  452. -- Druid Spells
  453.  
  454. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48378', 'Druid Spell');
  455. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48469', 'Druid Spell');
  456. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48461', 'Druid Spell');
  457. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48463', 'Druid Spell');
  458. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48441', 'Druid Spell');
  459. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '53307', 'Druid Spell');
  460. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '53308', 'Druid Spell');
  461. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '5487', 'Druid Spell');
  462. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48560', 'Druid Spell');
  463. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '6795', 'Druid Spell');
  464. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48480', 'Druid Spell');
  465. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '53312', 'Druid Spell');
  466. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '18960', 'Druid Spell');
  467. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '5229', 'Druid Spell');
  468. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48443', 'Druid Spell');
  469. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '50763', 'Druid Spell');
  470. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '8983', 'Druid Spell');
  471. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '8946', 'Druid Spell');
  472. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48562', 'Druid spell');
  473. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '783', 'Druid Spell');
  474. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '770', 'Druid Spell');
  475. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '16857', 'Druid Spell');
  476. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '18658', 'Druid Spell');
  477. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '768', 'Druid Spell');
  478. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '1082', 'Druid Spell');
  479. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '16979', 'Druid Spell');
  480. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '49376', 'Druid Spell');
  481. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '5215', 'Druid Spell');
  482. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48477', 'Druid Spell');
  483. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '49800', 'Druid Spell');
  484. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48465', 'Druid Spell');
  485. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48572', 'Druid Spell');
  486. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '26995', 'Druid Spell');
  487. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48574', 'Druid Spell');
  488. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '2782', 'Druid Spell');
  489. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '50213', 'Druid Spell');
  490. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '2893', 'Druid Spell');
  491. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '33357', 'Druid Spell');
  492. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '5209', 'Druid Spell');
  493. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48575', 'Druid Spell');
  494. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48447', 'Druid Spell');
  495. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48577', 'Druid Spell');
  496. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48579', 'Druid Spell');
  497. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '5225', 'Druid Spell');
  498. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '22842', 'Druid Spell');
  499. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '49803', 'Druid Spell');
  500. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '9634', 'Druid Spell');
  501. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '20719', 'Druid Spell');
  502. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48467', 'Druid Spell');
  503. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '29166', 'Druid Spell');
  504. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '62600', 'Druid Spell');
  505. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '22812', 'Druid Spell');
  506. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48470', 'Druid Spell');
  507. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48564', 'Druid Spell');
  508. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48566', 'Druid Spell');
  509. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '33943', 'Druid Spell');
  510. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '49802', 'Druid Spell');
  511. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48451', 'Druid Spell');
  512. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48568', 'Druid Spell');
  513. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '33786', 'Druid Spell');
  514. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '40120', 'Druid Spell');
  515. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '62078', 'Druid Spell');
  516. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '52610', 'Druid Spell');
  517. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '50464', 'Druid Spell');
  518. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '48570', 'Druid Spell');
  519. INSERT INTO `playercreateinfo_spell` VALUES ('0', '1024', '1066', 'Druid Spell');
  520.  
  521. -- Mage Portal Spells
  522.  
  523. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '32271', 'Mage Portal - Alliance');
  524. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '49359', 'Mage Portal - Alliance');
  525. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '3565', 'Mage Portal - Alliance');
  526. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '33690', 'Mage Portal - Alliance');
  527. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '3562', 'Mage Portal - Alliance');
  528. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '3561', 'Mage Portal - Alliance');
  529. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '11419', 'Mage Portal - Alliance');
  530. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '32266', 'Mage Portal - Alliance');
  531. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '11416', 'Mage Portal - Alliance');
  532. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '33691', 'Mage Portal - Alliance');
  533. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '11059', 'Mage Portal - Alliance');
  534. INSERT INTO `playercreateinfo_spell` VALUES ('1', '128', '49360', 'Mage Portal - Alliance');
  535. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '32271', 'Mage Portal - Alliance');
  536. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '49359', 'Mage Portal - Alliance');
  537. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '3565', 'Mage Portal - Alliance');
  538. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '33690', 'Mage Portal - Alliance');
  539. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '3562', 'Mage Portal - Alliance');
  540. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '3561', 'Mage Portal - Alliance');
  541. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '11419', 'Mage Portal - Alliance');
  542. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '32266', 'Mage Portal - Alliance');
  543. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '11416', 'Mage Portal - Alliance');
  544. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '33691', 'Mage Portal - Alliance');
  545. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '11059', 'Mage Portal - Alliance');
  546. INSERT INTO `playercreateinfo_spell` VALUES ('7', '128', '49360', 'Mage Portal - Alliance');
  547. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '32271', 'Mage Portal - Alliance');
  548. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '49359', 'Mage Portal - Alliance');
  549. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '3565', 'Mage Portal - Alliance');
  550. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '33690', 'Mage Portal - Alliance');
  551. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '3562', 'Mage Portal - Alliance');
  552. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '3561', 'Mage Portal - Alliance');
  553. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '11419', 'Mage Portal - Alliance');
  554. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '32266', 'Mage Portal - Alliance');
  555. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '11416', 'Mage Portal - Alliance');
  556. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '33691', 'Mage Portal - Alliance');
  557. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '11059', 'Mage Portal - Alliance');
  558. INSERT INTO `playercreateinfo_spell` VALUES ('11', '128', '49360', 'Mage Portal - Alliance');
  559. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '3567', 'Mage Portal - Horde');
  560. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '35715', 'Mage Portal - Horde');
  561. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '3566', 'Mage Portal - Horde');
  562. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '49358', 'Mage Portal - Horde');
  563. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '32272', 'Mage Portal - Horde');
  564. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '3563', 'Mage Portal - Horde');
  565. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '11417', 'Mage Portal - Horde');
  566. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '35717', 'Mage Portal - Horde');
  567. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '32267', 'Mage Portal - Horde');
  568. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '49361', 'Mage Portal - Horde');
  569. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '11420', 'Mage Portal - Horde');
  570. INSERT INTO `playercreateinfo_spell` VALUES ('5', '128', '11418', 'Mage Portal - Horde');
  571. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '3567', 'Mage Portal - Horde');
  572. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '35715', 'Mage Portal - Horde');
  573. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '3566', 'Mage Portal - Horde');
  574. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '49358', 'Mage Portal - Horde');
  575. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '32272', 'Mage Portal - Horde');
  576. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '3563', 'Mage Portal - Horde');
  577. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '11417', 'Mage Portal - Horde');
  578. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '35717', 'Mage Portal - Horde');
  579. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '32267', 'Mage Portal - Horde');
  580. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '49361', 'Mage Portal - Horde');
  581. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '11420', 'Mage Portal - Horde');
  582. INSERT INTO `playercreateinfo_spell` VALUES ('8', '128', '11418', 'Mage Portal - Horde');
  583. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '3567', 'Mage Portal - Horde');
  584. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '35715', 'Mage Portal - Horde');
  585. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '3566', 'Mage Portal - Horde');
  586. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '49358', 'Mage Portal - Horde');
  587. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '32272', 'Mage Portal - Horde');
  588. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '3563', 'Mage Portal - Horde');
  589. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '11417', 'Mage Portal - Horde');
  590. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '35717', 'Mage Portal - Horde');
  591. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '32267', 'Mage Portal - Horde');
  592. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '49361', 'Mage Portal - Horde');
  593. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '11420', 'Mage Portal - Horde');
  594. INSERT INTO `playercreateinfo_spell` VALUES ('10', '128', '11418', 'Mage Portal - Horde');
  595.  
  596. -- Delete Weapon Skills
  597.  
  598. DELETE FROM `playercreateinfo_spell` WHERE `Note` IN('Polearms', 'Swords', 'Daggers', 'Two-Handed Axes', 'One-Handed Axes', 'Two-Handed Swords', 'Two-Handed Maces', 'Maces', 'Thrown', 'Throw', 'Bows', 'Guns', 'Axes', 'Polearms', 'Fist Weapons', 'Crossbows', 'Mail Armor', 'Plate Armor', 'Staves', 'Dual-Wield');
  599.  
  600. -- Warrior Skills
  601.  
  602. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  603. (0, 1, 201,'Swords'),
  604. (0, 1, 1180,'Daggers'),
  605. (0, 1, 197,'Two-Handed Axes'),
  606. (0, 1, 199,'Two-Handed Maces'),
  607. (0, 1, 202,'Two-Handed Swords'),
  608. (0, 1, 198,'Maces'),
  609. (0, 1, 196,'Axes'),
  610. (0, 1, 200,'Polearms'),
  611. (0, 1, 2567,'Thrown'),
  612. (0, 1, 2764,'Throw'),
  613. (0, 1, 264,'Bows'),
  614. (0, 1, 266,'Guns'),
  615. (0, 1, 5011,'Crossbows'),
  616. (0, 1, 15590,'Fist Weapons'),
  617. (0, 1, 227,'Staves'),
  618. (0, 1, 674, 'Dual-Wield'),
  619. (0, 1, 750, 'Plate Armor');
  620.  
  621. -- Paladin Skills
  622.  
  623. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  624. (0, 2, 200,'Polearms'),
  625. (0, 2, 198,'Maces'),
  626. (0, 2, 201,'Swords'),
  627. (0, 2, 202,'Two-Handed Swords'),
  628. (0, 2, 197,'Two-Handed Axes'),
  629. (0, 2, 199,'Two-Handed Maces'),
  630. (0, 2, 196,'Axes'),
  631. (0, 2, 750, 'Plate Armor');
  632.  
  633. -- Hunter Skills
  634.  
  635. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  636. (0, 4, 200,'Polearms'),
  637. (0, 4, 196, 'One-Handed Axes'),
  638. (0, 4, 674, 'Dual-Wield'),
  639. (0, 4, 15590, 'Fist Weapons'),
  640. (0, 4, 2567, 'Thrown'),
  641. (0, 4, 2764, 'Throw'),
  642. (0, 4, 264,'Bows'),
  643. (0, 4, 266,'Guns'),
  644. (0, 4, 5011,'Crossbows'),
  645. (0, 4, 201,'Swords'),
  646. (0, 4, 227,'Staves'),
  647. (0, 4, 202,'Two-Handed Swords'),
  648. (0, 4, 197,'Two-Handed Axes'),
  649. (0, 4, 1180,'Daggers'),
  650. (0, 4, 8737, 'Mail Armor');
  651.  
  652. -- Rogue Skills
  653.  
  654. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  655. (0, 8, 1180,'Daggers'),
  656. (0, 8, 2567,'Thrown'),
  657. (0, 8, 2764,'Throw'),
  658. (0, 8, 201,'Swords'),
  659. (0, 8, 198,'Maces'),
  660. (0, 8, 196,'Axes'),
  661. (0, 8, 264,'Bows'),
  662. (0, 8, 266,'Guns'),
  663. (0, 8, 5011,'Crossbows'),
  664. (0, 8, 15590,'Fist Weapons');
  665.  
  666. -- Priest Skills
  667.  
  668. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  669. (0, 16, 1180,'Daggers'),
  670. (0, 16, 198,'Maces'),
  671. (0, 16, 227,'Staves');
  672.  
  673. -- Death Knight Skills
  674.  
  675. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  676. (0, 32, 199,'Two-Handed Maces'),
  677. (0, 32, 198,'Maces');
  678.  
  679. -- Shaman Skills
  680.  
  681. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  682. (0, 64, 1180, 'Daggers'),
  683. (0, 64, 227,'Staves'),
  684. (0, 64, 198,'Maces'),
  685. (0, 64, 199,'Two-Handed Maces'),
  686. (0, 64, 196,'Axes'),
  687. (0, 64, 197,'Two-Handed Axes'),
  688. (0, 64, 15590,'Fist Weapons'),
  689. (0, 64, 8737, 'Mail Armor');
  690.  
  691. -- Mage Skills
  692.  
  693. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  694. (0, 128, 1180,'Daggers'),
  695. (0, 128, 201,'Swords'),
  696. (0, 128, 227,'Staves');
  697.  
  698. -- Warlock Skills
  699.  
  700. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  701. (0, 256, 1180,'Daggers'),
  702. (0, 256, 201,'Swords'),
  703. (0, 256, 227,'Staves');
  704.  
  705. -- Druid Skills
  706.  
  707. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  708. (0, 1024, 198,'Maces'),
  709. (0, 1024, 199,'Two-Handed Maces'),
  710. (0, 1024, 227,'Staves'),
  711. (0, 1024, 200,'Polearms');
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!