Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Ticket: #243
- Trainers IDs: 1317
- 3011
- 3345
- 3606
- 4213
- 4616
- 5157
- 5695
- 11073
- 11074
- 16160
- 16633
- 16725
- 18753
- 18773
- 19251
- 19252
- 26954
- 26980
- 26990
- 28693
- 33583
- 33610
- 33633
- 33676
- Spell id: 63746
- Costs: 5000
- Skill: 333
- Level: 225
- MetaNPC: 201009
- SQL:
- INSERT INTO npc_trainer ('spell', 'spellcost', 'reqskill', 'reqskillvalue', 'reqlevel', 'entry') VALUES (63746, 5000, 333, 225, <NPC>)
- Short SQL:
- INSERT INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (201009,63746, 5000, 333, 225, 0);
- Long SQL:
- */
- SET @spellid=63746, @costs=5000, @skill=333, @skill_level=225, @level=0;
- INSERT INTO `npc_trainer` (`spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`, `entry`) VALUES
- (@spellid, @costs, @skill, @skill_level, @level, 3606),
- (@spellid, @costs, @skill, @skill_level, @level, 26990),
- (@spellid, @costs, @skill, @skill_level, @level, 11073),
- (@spellid, @costs, @skill, @skill_level, @level, 26954),
- (@spellid, @costs, @skill, @skill_level, @level, 26980),
- (@spellid, @costs, @skill, @skill_level, @level, 33583),
- (@spellid, @costs, @skill, @skill_level, @level, 18753),
- (@spellid, @costs, @skill, @skill_level, @level, 5157),
- (@spellid, @costs, @skill, @skill_level, @level, 3345),
- (@spellid, @costs, @skill, @skill_level, @level, 11074),
- (@spellid, @costs, @skill, @skill_level, @level, 18773),
- (@spellid, @costs, @skill, @skill_level, @level, 4616),
- (@spellid, @costs, @skill, @skill_level, @level, 1317),
- (@spellid, @costs, @skill, @skill_level, @level, 16160),
- (@spellid, @costs, @skill, @skill_level, @level, 19252),
- (@spellid, @costs, @skill, @skill_level, @level, 16725),
- (@spellid, @costs, @skill, @skill_level, @level, 16633),
- (@spellid, @costs, @skill, @skill_level, @level, 4213),
- (@spellid, @costs, @skill, @skill_level, @level, 3011),
- (@spellid, @costs, @skill, @skill_level, @level, 5695),
- (@spellid, @costs, @skill, @skill_level, @level, 28693),
- (@spellid, @costs, @skill, @skill_level, @level, 33633),
- (@spellid, @costs, @skill, @skill_level, @level, 19251),
- (@spellid, @costs, @skill, @skill_level, @level, 33610),
- (@spellid, @costs, @skill, @skill_level, @level, 33676);
Add Comment
Please, Sign In to add comment