daily pastebin goal
26%
SHARE
TWEET

Untitled

a guest Aug 13th, 2017 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Reference class to add some missing spells you get from quest and some others.
  2. SET @Deathknight :=90001;
  3. SET @Druid :=90001; -- Adding missing spell you get from quest.
  4. SET @Shaman :=90001; -- Adding missing spell you get from quest.
  5. SET @Hunter :=90001; -- Adding missing spell you get from quest.
  6. SET @Mage :=90001; -- Adding missing spell you get from quest.
  7. SET @Warlock :=90001; -- Adding missing spell you get from quest.
  8. SET @Warrior :=90001; -- Adding missing spell you get from quest.
  9. SET @GMspells :=90001;
  10. SET @Skills :=90001;
  11. SET @Trainer :=500000;
  12.  
  13. -- Clean Trainer before inserting new NPC,spells & skills.
  14. -- Helps prevent dupe related SQL errors
  15. DELETE FROM `creature` WHERE `id`=@Trainer;  
  16. DELETE FROM `creature_template` WHERE `entry`=@Trainer;
  17. DELETE FROM `npc_trainer` WHERE `entry`=@Trainer;
  18. DELETE FROM `npc_trainer` WHERE `entry`=@Deathknight;
  19. DELETE FROM `npc_trainer` WHERE `entry`=@Druid;
  20. DELETE FROM `npc_trainer` WHERE `entry`=@Mage;
  21. DELETE FROM `npc_trainer` WHERE `entry`=@Priest;
  22. DELETE FROM `npc_trainer` WHERE `entry`=@Rogue;
  23. DELETE FROM `npc_trainer` WHERE `entry`=@Paladin;
  24. DELETE FROM `npc_trainer` WHERE `entry`=@Warlock;
  25. DELETE FROM `npc_trainer` WHERE `entry`=@Warrior;
  26. DELETE FROM `npc_trainer` WHERE `entry`=@Hunter;
  27. DELETE FROM `npc_trainer` WHERE `entry`=@Shaman;
  28. DELETE FROM `npc_trainer` WHERE `entry`=@Skills;
  29.  
  30. -- Create Trainer NPC
  31. 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`,`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`,`Health_mod`,`Mana_mod`,`Armor_mod`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`) VALUES
  32. (@Trainer,        -- entry
  33. 0,                -- difficulty_entry_1
  34. 0,                -- difficulty_entry_2
  35. 0,                -- difficulty_entry_3
  36. 0,                -- KillCredit1
  37. 0,                -- KillCredit2
  38. 22931,            -- modelid1
  39. 0,                -- modelid2
  40. 0,                -- modelid3
  41. 0,                -- modelid4
  42. 'Global Class Trainer',   -- name
  43. 'TonicWoW', -- subname
  44. '',               -- IconeName
  45. 0,                -- gossip_menu_id
  46. 80,               -- minlevel
  47. 80,               -- maxlevel
  48. 0,                -- exp
  49. 35,               -- faction_A
  50. 35,               -- faction_h
  51. 51,               -- npcflag
  52. 1,                -- speed_walk
  53. 1,                -- speed_run
  54. 1,                -- scale
  55. 0,                -- rank
  56. 1755,             -- mindmg
  57. 1755,             -- maxdmg
  58. 0,                -- dmgschool
  59. 1504,             -- attackpower
  60. 1,                -- dmg_multiplier
  61. 1500,             -- baseattacktime
  62. 0,                -- rangeattacktime
  63. 2,                -- unit_class
  64. 0,                -- unit_flags
  65. 0,                -- dynamicflags
  66. 0,                -- family
  67. 2,                -- trainer_type
  68. 0,                -- trainer_spell
  69. 0,                -- trainer_class
  70. 0,                -- trainer_race
  71. 0,                -- minrangedmg
  72. 0,                -- maxrangedmg
  73. 0,                -- rangedattackpower
  74. 7,                -- type
  75. 0,                -- type_flags
  76. 0,                -- lootid
  77. 0,                -- pickpocketloot
  78. 0,                -- skinloot
  79. 0,                -- resistance1
  80. 0,                -- resistance2
  81. 0,                -- resistance3
  82. 0,                -- resistance4
  83. 0,                -- resistance5
  84. 0,                -- resistance6
  85. 0,                -- spell1
  86. 0,                -- spell2
  87. 0,                -- spell3
  88. 0,                -- spell4
  89. 0,                -- spell5
  90. 0,                -- spell6
  91. 0,                -- spell7
  92. 0,                -- spell8
  93. 0,                -- PetSpellDataId
  94. 0,                -- VehicleId
  95. 0,                -- mingold
  96. 0,                -- maxgold
  97. '',               -- AIName
  98. 0,                -- MovementType
  99. 3,                -- InhabitType
  100. 1,                -- Health_mod
  101. 1,                -- Mana_mod
  102. 1,                -- Armor_mod
  103. 0,                -- RacialLeader
  104. 0,                -- questItem1
  105. 0,                -- questItem2
  106. 0,                -- questItem3
  107. 0,                -- questItem4
  108. 0,                -- questItem5
  109. 0,                -- questItem6
  110. 0,                -- movementId
  111. 1,                -- RegenHealth
  112. 0,                -- equipment_id
  113. 0,                -- mechanic_immune_mask
  114. 0,                -- flags_extra
  115. '',               -- ScriptName
  116. 1);               -- WDBVerified
  117.  
  118. -- Make Trainer mounted (Comment this part if you dont want him mounted)
  119. DELETE FROM `creature_template_addon` WHERE `entry`=@Trainer;
  120. INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
  121. (@Trainer,0,24725,0,4096,0,NULL);
  122.  
  123. -- Insert spells to trainer
  124. INSERT INTO `npc_trainer` (`entry`,`spell`) VALUES
  125. (@Trainer,-200001), -- Warrior-Lowlevel
  126. (@Trainer,-200002), -- Warrior-Highlevel
  127. (@Trainer,-200003), -- Paladin-Lowlevel
  128. (@Trainer,-200004), -- Paladin-Highlevel
  129. (@Trainer,-200005), -- Druid-Lowlevel
  130. (@Trainer,-200006), -- Druid-Highlevel
  131. (@Trainer,-200007), -- Mage-Lowlevel
  132. (@Trainer,-200008), -- Mage-Highlevel
  133. (@Trainer,-200009), -- Warlock-Lowlevel
  134. (@Trainer,-200010), -- Warlock-Highlevel
  135. (@Trainer,-200011), -- Priest-Lowlevel
  136. (@Trainer,-200012), -- Priest-Highlevel
  137. (@Trainer,-200013), -- Hunter-Lowlevel
  138. (@Trainer,-200014), -- Hunter-Highlevel
  139. (@Trainer,-200015), -- Rogue-Lowlevel
  140. (@Trainer,-200016), -- Rogue-Highlevel
  141. (@Trainer,-200017), -- Shaman-Lowlevel
  142. (@Trainer,-200018); -- Shaman-Highlevel
  143. -- (@Trainer,-200019); -- Death Knights-Alllevel (Disable because alot of frost spell available to any class. Remade the DK spells and will remove the one trainable by any class)
  144.  
  145. -- DeathKnight Spells
  146. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  147.  
  148. (@Deathknight,48707,0,0,0,55),
  149. (@Deathknight,42650,0,0,0,55),
  150. (@Deathknight,48721,0,0,0,55),
  151. (@Deathknight,48263,0,0,0,55),
  152. (@Deathknight,45529,0,0,0,55),
  153. (@Deathknight,45524,0,0,0,55),
  154. (@Deathknight,56222,0,0,0,55),
  155. (@Deathknight,77606,0,0,0,55),
  156. (@Deathknight,48743,0,0,0,55),
  157. (@Deathknight,49998,0,0,0,55),
  158. (@Deathknight,43265,0,0,0,55),
  159. (@Deathknight,47568,0,0,0,55),
  160. (@Deathknight,85948,0,0,0,55),
  161. (@Deathknight,57330,0,0,0,55),
  162. (@Deathknight,48792,0,0,0,55),
  163. (@Deathknight,87492,0,0,0,55),
  164. (@Deathknight,47528,0,0,0,55),
  165. (@Deathknight,73975,0,0,0,55),
  166. (@Deathknight,49020,0,0,0,55),
  167. (@Deathknight,77575,0,0,0,55),
  168. (@Deathknight,3714,0,0,0,55),
  169. (@Deathknight,50842,0,0,0,55),
  170. (@Deathknight,61999,0,0,0,55),
  171. (@Deathknight,46584,0,0,0,55),
  172. (@Deathknight,56815,0,0,0,55),
  173. (@Deathknight,53341,0,0,0,55),
  174. (@Deathknight,53331,0,0,0,55),
  175. (@Deathknight,53343,0,0,0,55),
  176. (@Deathknight,54447,0,0,0,55),
  177. (@Deathknight,53342,0,0,0,55),
  178. (@Deathknight,54446,0,0,0,55),
  179. (@Deathknight,53323,0,0,0,55),
  180. (@Deathknight,53344,0,0,0,55),
  181. (@Deathknight,70164,0,0,0,55),
  182. (@Deathknight,62158,0,0,0,55),
  183. (@Deathknight,81229,0,0,0,55),
  184. (@Deathknight,47476,0,0,0,55),
  185. (@Deathknight,48265,0,0,0,55),
  186.  
  187. -- Druid Spells
  188.  
  189. (@Druid,1066,0,0,0,55),
  190. (@Druid,22812,0,0,0,55),
  191. (@Druid,5211,0,0,0,55),
  192. (@Druid,5487,0,0,0,55),
  193. (@Druid,768,0,0,0,55),
  194. (@Druid,5209,0,0,0,55),
  195. (@Druid,1082,0,0,0,55),
  196. (@Druid,8998,0,0,0,55),
  197. (@Druid,33786,0,0,0,55),
  198. (@Druid,1850,0,0,0,55),
  199. (@Druid,99,0,0,0,55),
  200. (@Druid,5228,0,0,0,55),
  201. (@Druid,339,0,0,0,55),
  202. (@Druid,770,0,0,0,55),
  203. (@Druid,16857,0,0,0,55),
  204. (@Druid,20719,0,0,0,55),
  205. (@Druid,22568,0,0,0,55),
  206. (@Druid,33943,0,0,0,55),
  207. (@Druid,22842,0,0,0,55),
  208. (@Druid,6795,0,0,0,55),
  209. (@Druid,5185,0,0,0,55),
  210. (@Druid,2637,0,0,0,55),
  211. (@Druid,16914,0,0,0,55),
  212. (@Druid,29166,0,0,0,55),
  213. (@Druid,5570,0,0,0,55),
  214. (@Druid,33745,0,0,0,55),
  215. (@Druid,87505,0,0,0,55),
  216. (@Druid,33763,0,0,0,55),
  217. (@Druid,22570,0,0,0,55),
  218. (@Druid,1126,0,0,0,55),
  219. (@Druid,87491,0,0,0,55),
  220. (@Druid,6807,0,0,0,55),
  221. (@Druid,8921,0,0,0,55),
  222. (@Druid,16689,0,0,0,55),
  223. (@Druid,50464,0,0,0,55),
  224. (@Druid,16864,0,0,0,55),
  225. (@Druid,5215,0,0,0,55),
  226. (@Druid,1822,0,0,0,55),
  227. (@Druid,6785,0,0,0,55),
  228. (@Druid,20484,0,0,0,55),
  229. (@Druid,8936,0,0,0,55),
  230. (@Druid,774,0,0,0,55),
  231. (@Druid,2782,0,0,0,55),
  232. (@Druid,50769,0,0,0,55),
  233. (@Druid,1079,0,0,0,55),
  234. (@Druid,62600,0,0,0,55),
  235. (@Druid,52610,0,0,0,55),
  236. (@Druid,5221,0,0,0,55),
  237. (@Druid,80964,0,0,0,55),
  238. (@Druid,80965,0,0,0,55),
  239. (@Druid,2908,0,0,0,55),
  240. (@Druid,77764,0,0,0,55),
  241. (@Druid,77761,0,0,0,55),
  242. (@Druid,2912,0,0,0,55),
  243. (@Druid,40120,0,0,0,55),
  244. (@Druid,779,0,0,0,55),
  245. (@Druid,62078,0,0,0,55),
  246. (@Druid,18960,0,0,0,55),
  247. (@Druid,467,0,0,0,55),
  248. (@Druid,77758,0,0,0,55),
  249. (@Druid,5217,0,0,0,55),
  250. (@Druid,5225,0,0,0,55),
  251. (@Druid,740,0,0,0,55),
  252. (@Druid,783,0,0,0,55),
  253. (@Druid,88747,0,0,0,55),
  254. (@Druid,88751,0,0,0,55);
  255.  
  256. -- Hunter Spells
  257.  
  258. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  259.  
  260. (@Hunter,5118,0,0,0,55),
  261. (@Hunter,82661,0,0,0,55),
  262. (@Hunter,13615,0,0,0,55),
  263. (@Hunter,13159,0,0,0,55),
  264. (@Hunter,20043,0,0,0,55),
  265. (@Hunter,1462,0,0,0,55),
  266. (@Hunter,83242,0,0,0,55),
  267. (@Hunter,83243,0,0,0,55),
  268. (@Hunter,83244,0,0,0,55),
  269. (@Hunter,83245,0,0,0,55),
  270. (@Hunter,51753,0,0,0,55),
  271. (@Hunter,77767,0,0,0,55),
  272. (@Hunter,5116,0,0,0,55),
  273. (@Hunter,79682,0,0,0,55),
  274. (@Hunter,19263,0,0,0,55),
  275. (@Hunter,871,0,0,0,55),
  276. (@Hunter,2641,0,0,0,55),
  277. (@Hunter,20736,0,0,0,55),
  278. (@Hunter,6197,0,0,0,55),
  279. (@Hunter,13813,0,0,0,55),
  280. (@Hunter,6991,0,0,0,55),
  281. (@Hunter,5384,0,0,0,55),
  282. (@Hunter,1543,0,0,0,55),
  283. (@Hunter,1499,0,0,0,55),
  284. (@Hunter,1130,0,0,0,55),
  285. (@Hunter,13809,0,0,0,55),
  286. (@Hunter,13795,0,0,0,55),
  287. (@Hunter,34026,0,0,0,55),
  288. (@Hunter,53351,0,0,0,55),
  289. (@Hunter,87506,0,0,0,55),
  290. (@Hunter,53271,0,0,0,55),
  291. (@Hunter,87493,0,0,0,55),
  292. (@Hunter,136,0,0,0,55),
  293. (@Hunter,34477,0,0,0,55),
  294. (@Hunter,2643,0,0,0,55),
  295. (@Hunter,82243,0,0,0,55),
  296. (@Hunter,3045,0,0,0,55),
  297. (@Hunter,2973,0,0,0,55),
  298. (@Hunter,1513,0,0,0,55),
  299. (@Hunter,19503,0,0,0,55),
  300. (@Hunter,1978,0,0,0,55),
  301. (@Hunter,34600,0,0,0,55),
  302. (@Hunter,56641,0,0,0,55),
  303. (@Hunter,1515,0,0,0,55),
  304. (@Hunter,1494,0,0,0,55),
  305. (@Hunter,19878,0,0,0,55),
  306. (@Hunter,19879,0,0,0,55),
  307. (@Hunter,19880,0,0,0,55),
  308. (@Hunter,19822,0,0,0,55),
  309. (@Hunter,19885,0,0,0,55),
  310. (@Hunter,19883,0,0,0,55),
  311. (@Hunter,19884,0,0,0,55),
  312. (@Hunter,19801,0,0,0,55),
  313. (@Hunter,77769,0,0,0,55),
  314. (@Hunter,82654,0,0,0,55),
  315. (@Hunter,2974,0,0,0,55);
  316.  
  317. -- Mage
  318. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  319.  
  320. (@Mage,759,0,0,0,55),
  321. (@Mage,30451,0,0,0,55),
  322. (@Mage,1459,0,0,0,55),
  323. (@Mage,1449,0,0,0,55),
  324. (@Mage,5143,0,0,0,55),
  325. (@Mage,1953,0,0,0,55),
  326. (@Mage,10,0,0,0,55),
  327. (@Mage,120,0,0,0,55),
  328. (@Mage,42955,0,0,0,55),
  329. (@Mage,2139,0,0,0,55),
  330. (@Mage,12051,0,0,0,55),
  331. (@Mage,2136,0,0,0,55),
  332. (@Mage,82731,0,0,0,55),
  333. (@Mage,2120,0,0,0,55),
  334. (@Mage,7302,0,0,0,55),
  335. (@Mage,122,0,0,0,55),
  336. (@Mage,116,0,0,0,55),
  337. (@Mage,44614,0,0,0,55),
  338. (@Mage,45438,0,0,0,55),
  339. (@Mage,30455,0,0,0,55),
  340. (@Mage,66,0,0,0,55),
  341. (@Mage,6117,0,0,0,55),
  342. (@Mage,543,0,0,0,55),
  343. (@Mage,1463,0,0,0,55),
  344. (@Mage,86467,0,0,0,55),
  345. (@Mage,55342,0,0,0,55),
  346. (@Mage,30842,0,0,0,55),
  347. (@Mage,118,0,0,0,55),
  348. (@Mage,475,0,0,0,55),
  349. (@Mage,82676,0,0,0,55),
  350. (@Mage,43987,0,0,0,55),
  351. (@Mage,2948,0,0,0,55),
  352. (@Mage,130,0,0,0,55),
  353. (@Mage,30449,0,0,0,55),
  354. (@Mage,80553,0,0,0,55),
  355. (@Mage,89744,0,0,0,55);
  356.  
  357. -- Paladin
  358. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  359.  
  360. (@Paladin,31884,0,0,0,55),
  361. (@Paladin,20217,0,0,0,55),
  362. (@Paladin,19740,0,0,0,55),
  363. (@Paladin,4987,0,0,0,55),
  364. (@Paladin,19746,0,0,0,55),
  365. (@Paladin,26573,0,0,0,55),
  366. (@Paladin,32223,0,0,0,55),
  367. (@Paladin,465,0,0,0,55),
  368. (@Paladin,82326,0,0,0,55),
  369. (@Paladin,54428,0,0,0,55),
  370. (@Paladin,498,0,0,0,55),
  371. (@Paladin,642,0,0,0,55),
  372. (@Paladin,879,0,0,0,55),
  373. (@Paladin,19750,0,0,0,55),
  374. (@Paladin,86150,0,0,0,55),
  375. (@Paladin,853,0,0,0,55),
  376. (@Paladin,24275,0,0,0,55),
  377. (@Paladin,1044,0,0,0,55),
  378. (@Paladin,1022,0,0,0,55),
  379. (@Paladin,62124,0,0,0,55),
  380. (@Paladin,6940,0,0,0,55),
  381. (@Paladin,1038,0,0,0,55),
  382. (@Paladin,635,0,0,0,55),
  383. (@Paladin,82327,0,0,0,55),
  384. (@Paladin,2812,0,0,0,55),
  385. (@Paladin,84963,0,0,0,55),
  386. (@Paladin,20271,0,0,0,55),
  387. (@Paladin,633,0,0,0,55),
  388. (@Paladin,87494,0,0,0,55),
  389. (@Paladin,82242,0,0,0,55),
  390. (@Paladin,87511,0,0,0,55),
  391. (@Paladin,96231,0,0,0,55),
  392. (@Paladin,7328,0,0,0,55),
  393. (@Paladin,19891,0,0,0,55),
  394. (@Paladin,7294,0,0,0,55),
  395. (@Paladin,31789,0,0,0,55),
  396. (@Paladin,25780,0,0,0,55),
  397. (@Paladin,20165,0,0,0,55),
  398. (@Paladin,20164,0,0,0,55),
  399. (@Paladin,20154,0,0,0,55),
  400. (@Paladin,31801,0,0,0,55),
  401. (@Paladin,34767,0,0,0,55),
  402. (@Paladin,69826,0,0,0,55),
  403. (@Paladin,69820,0,0,0,55),
  404. (@Paladin,34769,0,0,0,55),
  405. (@Paladin,10326,0,0,0,55),
  406. (@Paladin,85673,0,0,0,55);
  407.  
  408. -- Priest
  409. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  410.  
  411. (@Priest,32546,0,0,0,55),
  412. (@Priest,528,0,0,0,55),
  413. (@Priest,2944,0,0,0,55),
  414. (@Priest,527,0,0,0,55),
  415. (@Priest,64843,0,0,0,55),
  416. (@Priest,586,0,0,0,55),
  417. (@Priest,6346,0,0,0,55),
  418. (@Priest,2061,0,0,0,55),
  419. (@Priest,2060,0,0,0,55),
  420. (@Priest,2050,0,0,0,55),
  421. (@Priest,14914,0,0,0,55),
  422. (@Priest,15237,0,0,0,55),
  423. (@Priest,64901,0,0,0,55),
  424. (@Priest,588,0,0,0,55),
  425. (@Priest,73413,0,0,0,55),
  426. (@Priest,73325,0,0,0,55),
  427. (@Priest,1706,0,0,0,55),
  428. (@Priest,8129,0,0,0,55),
  429. (@Priest,32375,0,0,0,55),
  430. (@Priest,87495,0,0,0,55),
  431. (@Priest,8092,0,0,0,55),
  432. (@Priest,605,0,0,0,55),
  433. (@Priest,48045,0,0,0,55),
  434. (@Priest,453,0,0,0,55),
  435. (@Priest,73510,0,0,0,55),
  436. (@Priest,2096,0,0,0,55),
  437. (@Priest,89745,0,0,0,55),
  438. (@Priest,21562,0,0,0,55),
  439. (@Priest,17,0,0,0,55),
  440. (@Priest,596,0,0,0,55),
  441. (@Priest,33076,0,0,0,55),
  442. (@Priest,8122,0,0,0,55),
  443. (@Priest,139,0,0,0,55),
  444. (@Priest,2006,0,0,0,55),
  445. (@Priest,9484,0,0,0,55),
  446. (@Priest,27683,0,0,0,55),
  447. (@Priest,32379,0,0,0,55),
  448. (@Priest,589,0,0,0,55),
  449. (@Priest,34433,0,0,0,55);
  450.  
  451. -- Rogue
  452.  
  453. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  454.  
  455. (@Rogue,674,0,0,0,55),
  456. (@Rogue,8676,0,0,0,55),
  457. (@Rogue,53,0,0,0,55),
  458. (@Rogue,2094,0,0,0,55),
  459. (@Rogue,1833,0,0,0,55),
  460. (@Rogue,31224,0,0,0,55),
  461. (@Rogue,74001,0,0,0,55),
  462. (@Rogue,26679,0,0,0,55),
  463. (@Rogue,2836,0,0,0,55),
  464. (@Rogue,1842,0,0,0,55),
  465. (@Rogue,51722,0,0,0,55),
  466. (@Rogue,1725,0,0,0,55),
  467. (@Rogue,32645,0,0,0,55),
  468. (@Rogue,5277,0,0,0,55),
  469. (@Rogue,2098,0,0,0,55),
  470. (@Rogue,8647,0,0,0,55),
  471. (@Rogue,51723,0,0,0,55),
  472. (@Rogue,1966,0,0,0,55),
  473. (@Rogue,703,0,0,0,55),
  474. (@Rogue,1776,0,0,0,55),
  475. (@Rogue,1766,0,0,0,55),
  476. (@Rogue,408,0,0,0,55),
  477. (@Rogue,87504,0,0,0,55),
  478. (@Rogue,87496,0,0,0,55),
  479. (@Rogue,82245,0,0,0,55),
  480. (@Rogue,1804,0,0,0,55),
  481. (@Rogue,921,0,0,0,55),
  482. (@Rogue,73651,0,0,0,55),
  483. (@Rogue,73981,0,0,0,55),
  484. (@Rogue,1943,0,0,0,55),
  485. (@Rogue,1860,0,0,0,55),
  486. (@Rogue,6770,0,0,0,55),
  487. (@Rogue,5938,0,0,0,55),
  488. (@Rogue,5171,0,0,0,55),
  489. (@Rogue,76577,0,0,0,55),
  490. (@Rogue,2983,0,0,0,55),
  491. (@Rogue,1784,0,0,0,55),
  492. (@Rogue,57934,0,0,0,55),
  493. (@Rogue,1856,0,0,0,55);
  494.  
  495. -- Shaman
  496. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  497.  
  498. (@Shaman,2008,0,0,0,55),
  499. (@Shaman,556,0,0,0,55),
  500. (@Shaman,76780,0,0,0,55),
  501. (@Shaman,66843,0,0,0,55),
  502. (@Shaman,66842,0,0,0,55),
  503. (@Shaman,66844,0,0,0,55),
  504. (@Shaman,1064,0,0,0,55),
  505. (@Shaman,421,0,0,0,55),
  506. (@Shaman,51886,0,0,0,55),
  507. (@Shaman,2062,0,0,0,55),
  508. (@Shaman,8042,0,0,0,55),
  509. (@Shaman,2484,0,0,0,55),
  510. (@Shaman,51730,0,0,0,55),
  511. (@Shaman,8184,0,0,0,55),
  512. (@Shaman,6196,0,0,0,55),
  513. (@Shaman,2894,0,0,0,55),
  514. (@Shaman,1535,0,0,0,55),
  515. (@Shaman,8050,0,0,0,55),
  516. (@Shaman,8227,0,0,0,55),
  517. (@Shaman,8024,0,0,0,55),
  518. (@Shaman,8056,0,0,0,55),
  519. (@Shaman,8033,0,0,0,55),
  520. (@Shaman,2645,0,0,0,55),
  521. (@Shaman,77472,0,0,0,55),
  522. (@Shaman,8177,0,0,0,55),
  523. (@Shaman,73920,0,0,0,55),
  524. (@Shaman,5394,0,0,0,55),
  525. (@Shaman,8004,0,0,0,55),
  526. (@Shaman,331,0,0,0,55),
  527. (@Shaman,32182,0,0,0,55),
  528. (@Shaman,51514,0,0,0,55),
  529. (@Shaman,51505,0,0,0,55),
  530. (@Shaman,324,0,0,0,55),
  531. (@Shaman,8190,0,0,0,55),
  532. (@Shaman,87507,0,0,0,55),
  533. (@Shaman,5675,0,0,0,55),
  534. (@Shaman,87497,0,0,0,55),
  535. (@Shaman,73899,0,0,0,55),
  536. (@Shaman,370,0,0,0,55),
  537. (@Shaman,20608,0,0,0,55),
  538. (@Shaman,8017,0,0,0,55),
  539. (@Shaman,3599,0,0,0,55),
  540. (@Shaman,79206,0,0,0,55),
  541. (@Shaman,5730,0,0,0,55),
  542. (@Shaman,8071,0,0,0,55),
  543. (@Shaman,8075,0,0,0,55),
  544. (@Shaman,87718,0,0,0,55),
  545. (@Shaman,36936,0,0,0,55),
  546. (@Shaman,8143,0,0,0,55),
  547. (@Shaman,73680,0,0,0,55),
  548. (@Shaman,131,0,0,0,55),
  549. (@Shaman,52127,0,0,0,55),
  550. (@Shaman,546,0,0,0,55),
  551. (@Shaman,57994,0,0,0,55),
  552. (@Shaman,8512,0,0,0,55),
  553. (@Shaman,8232,0,0,0,55),
  554. (@Shaman,3738,0,0,0,55);
  555.    
  556.    
  557.    
  558. -- Warlock
  559. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  560.  
  561. (@Warlock,693,0,0,0,55),
  562. (@Warlock,980,0,0,0,55),
  563. (@Warlock,603,0,0,0,55),
  564. (@Warlock,710,0,0,0,55),
  565. (@Warlock,80388,0,0,0,55),
  566. (@Warlock,172,0,0,0,55),
  567. (@Warlock,6201,0,0,0,55),
  568. (@Warlock,1714,0,0,0,55),
  569. (@Warlock,702,0,0,0,55),
  570. (@Warlock,1490,0,0,0,55),
  571. (@Warlock,80398,0,0,0,55),
  572. (@Warlock,6789,0,0,0,55),
  573. (@Warlock,687,0,0,0,55),
  574. (@Warlock,77801,0,0,0,55),
  575. (@Warlock,48018,0,0,0,55),
  576. (@Warlock,48020,0,0,0,55),
  577. (@Warlock,689,0,0,0,55),
  578. (@Warlock,1120,0,0,0,55),
  579. (@Warlock,23161,0,0,0,55),
  580. (@Warlock,1098,0,0,0,55),
  581. (@Warlock,126,0,0,0,55),
  582. (@Warlock,5782,0,0,0,55),
  583. (@Warlock,28176,0,0,0,55),
  584. (@Warlock,77799,0,0,0,55),
  585. (@Warlock,5784,0,0,0,55),
  586. (@Warlock,755,0,0,0,55),
  587. (@Warlock,1949,0,0,0,55),
  588. (@Warlock,5484,0,0,0,55),
  589. (@Warlock,348,0,0,0,55),
  590. (@Warlock,29722,0,0,0,55),
  591. (@Warlock,1454,0,0,0,55),
  592. (@Warlock,87498,0,0,0,55),
  593. (@Warlock,86091,0,0,0,55),
  594. (@Warlock,5740,0,0,0,55),
  595. (@Warlock,29893,0,0,0,55),
  596. (@Warlock,698,0,0,0,55),
  597. (@Warlock,5676,0,0,0,55),
  598. (@Warlock,27243,0,0,0,55),
  599. (@Warlock,6229,0,0,0,55),
  600. (@Warlock,47897,0,0,0,55),
  601. (@Warlock,6353,0,0,0,55),
  602. (@Warlock,79268,0,0,0,55),
  603. (@Warlock,19028,0,0,0,55),
  604. (@Warlock,74434,0,0,0,55),
  605. (@Warlock,29858,0,0,0,55),
  606. (@Warlock,18540,0,0,0,55),
  607. (@Warlock,691,0,0,0,55),
  608. (@Warlock,1122,0,0,0,55),
  609. (@Warlock,712,0,0,0,55),
  610. (@Warlock,697,0,0,0,55),
  611. (@Warlock,5697,0,0,0,55);
  612.  
  613. -- Warrior
  614. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  615.  
  616. (@Warrior,6673,0,0,0,55),
  617. (@Warrior,18499,0,0,0,55),
  618. (@Warrior,2458,0,0,0,55),
  619. (@Warrior,1161,0,0,0,55),
  620. (@Warrior,100,0,0,0,55),
  621. (@Warrior,845,0,0,0,55),
  622. (@Warrior,86346,0,0,0,55),
  623. (@Warrior,469,0,0,0,55),
  624. (@Warrior,71,0,0,0,55),
  625. (@Warrior,1160,0,0,0,55),
  626. (@Warrior,676,0,0,0,55),
  627. (@Warrior,55694,0,0,0,55),
  628. (@Warrior,5308,0,0,0,55),
  629. (@Warrior,1715,0,0,0,55),
  630. (@Warrior,6544,0,0,0,55),
  631. (@Warrior,78,0,0,0,55),
  632. (@Warrior,57755,0,0,0,55),
  633. (@Warrior,1134,0,0,0,55),
  634. (@Warrior,20252,0,0,0,55),
  635. (@Warrior,3411,0,0,0,55),
  636. (@Warrior,5246,0,0,0,55),
  637. (@Warrior,87500,0,0,0,55),
  638. (@Warrior,7384,0,0,0,55),
  639. (@Warrior,3127,0,0,0,55),
  640. (@Warrior,87509,0,0,0,55),
  641. (@Warrior,6552,0,0,0,55),
  642. (@Warrior,1719,0,0,0,55),
  643. (@Warrior,772,0,0,0,55),
  644. (@Warrior,20230,0,0,0,55),
  645. (@Warrior,6572,0,0,0,55),
  646. (@Warrior,64382,0,0,0,55),
  647. (@Warrior,72,0,0,0,55),
  648. (@Warrior,2565,0,0,0,55),
  649. (@Warrior,871,0,0,0,55),
  650. (@Warrior,1464,0,0,0,55),
  651. (@Warrior,23920,0,0,0,55),
  652. (@Warrior,12678,0,0,0,55),
  653. (@Warrior,7386,0,0,0,55),
  654. (@Warrior,355,0,0,0,55),
  655. (@Warrior,6343,0,0,0,55),
  656. (@Warrior,34428,0,0,0,55),
  657. (@Warrior,1680,0,0,0,55);
  658.  
  659. -- Skills
  660. INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
  661. (@Skills,33388,0,0,0,0), -- Apprentice Riding
  662. (@Skills,33391,0,33388,0,0), -- Journeyman Riding
  663. (@Skills,34090,0,33391,0,0), -- Expert Riding
  664. (@Skills,34091,0,34090,0,0), -- Artisan Riding
  665. (@Skills,54197,0,34090,0,0), -- Cold Weather Flying
  666. (@Skills,90265,0,34090,0,0), -- Master Riding
  667. (@Skills,90267,0,34090,0,0), -- Flight Master's License
  668. (@Skills,196,10000,0,0,1), -- One-Handed Axes
  669. (@Skills,197,10000,0,0,1), -- Two-Handed Axes
  670. (@Skills,198,10000,0,0,1), -- One-Handed Maces
  671. (@Skills,199,10000,0,0,1), -- Two-Handed Maces
  672. (@Skills,200,10000,0,0,1), -- Polearms
  673. (@Skills,201,10000,0,0,1), -- One-Handed Swords
  674. (@Skills,202,10000,0,0,1), -- Two-Handed Swords
  675. (@Skills,227,10000,0,0,1), -- Staves
  676. (@Skills,264,10000,0,0,1), -- Bows
  677. (@Skills,266,10000,0,0,1), -- Guns
  678. (@Skills,1180,10000,0,0,1), -- Daggers
  679. (@Skills,2567,10000,0,0,1), -- Throwns
  680. (@Skills,5011,10000,0,0,1), -- Crossbows
  681. (@Skills,15590,10000,0,0,1), -- Fists
  682. (@Skills,8737,10000,0,0,40), -- Mail Armor
  683. (@Skills,750,10000,0,0,40); -- Plate Armor
RAW Paste Data
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
 
Top