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
Top