Guest User

Untitled

a guest
Jul 19th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.14 KB | None | 0 0
  1. /*
  2. Ticket: #243
  3.  
  4. Trainers IDs: 1317
  5. 3011
  6. 3345
  7. 3606
  8. 4213
  9. 4616
  10. 5157
  11. 5695
  12. 11073
  13. 11074
  14. 16160
  15. 16633
  16. 16725
  17. 18753
  18. 18773
  19. 19251
  20. 19252
  21. 26954
  22. 26980
  23. 26990
  24. 28693
  25. 33583
  26. 33610
  27. 33633
  28. 33676
  29.  
  30. Spell id: 63746
  31.  
  32. Costs: 5000
  33.  
  34. Skill: 333
  35.  
  36. Level: 225
  37.  
  38. MetaNPC: 201009
  39.  
  40. SQL:
  41. INSERT INTO npc_trainer ('spell', 'spellcost', 'reqskill', 'reqskillvalue', 'reqlevel', 'entry') VALUES (63746, 5000, 333, 225, <NPC>)
  42.  
  43. Short SQL:
  44. INSERT INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (201009,63746, 5000, 333, 225, 0);
  45.  
  46. Long SQL:
  47. */
  48. SET @spellid=63746, @costs=5000, @skill=333, @skill_level=225, @level=0;
  49. INSERT INTO `npc_trainer` (`spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`, `entry`) VALUES
  50. (@spellid, @costs, @skill, @skill_level, @level, 3606),
  51. (@spellid, @costs, @skill, @skill_level, @level, 26990),
  52. (@spellid, @costs, @skill, @skill_level, @level, 11073),
  53. (@spellid, @costs, @skill, @skill_level, @level, 26954),
  54. (@spellid, @costs, @skill, @skill_level, @level, 26980),
  55. (@spellid, @costs, @skill, @skill_level, @level, 33583),
  56. (@spellid, @costs, @skill, @skill_level, @level, 18753),
  57. (@spellid, @costs, @skill, @skill_level, @level, 5157),
  58. (@spellid, @costs, @skill, @skill_level, @level, 3345),
  59. (@spellid, @costs, @skill, @skill_level, @level, 11074),
  60. (@spellid, @costs, @skill, @skill_level, @level, 18773),
  61. (@spellid, @costs, @skill, @skill_level, @level, 4616),
  62. (@spellid, @costs, @skill, @skill_level, @level, 1317),
  63. (@spellid, @costs, @skill, @skill_level, @level, 16160),
  64. (@spellid, @costs, @skill, @skill_level, @level, 19252),
  65. (@spellid, @costs, @skill, @skill_level, @level, 16725),
  66. (@spellid, @costs, @skill, @skill_level, @level, 16633),
  67. (@spellid, @costs, @skill, @skill_level, @level, 4213),
  68. (@spellid, @costs, @skill, @skill_level, @level, 3011),
  69. (@spellid, @costs, @skill, @skill_level, @level, 5695),
  70. (@spellid, @costs, @skill, @skill_level, @level, 28693),
  71. (@spellid, @costs, @skill, @skill_level, @level, 33633),
  72. (@spellid, @costs, @skill, @skill_level, @level, 19251),
  73. (@spellid, @costs, @skill, @skill_level, @level, 33610),
  74. (@spellid, @costs, @skill, @skill_level, @level, 33676);
Add Comment
Please, Sign In to add comment