For ArcEmu 3.3.5:
Trainer_spells table structure
Code:
INSERT INTO `trainer_spells`VALUES (NPCTRAINERID, CASTSPELL, SPELLID, LEARNCOST, REQSPELL, REQSKILL, REQSKILLVALUE, REQLEVEL, DELETESPELL, IS_PROF);
This query will add "Summon Disco Ball" to a npc trainer with the id "13337" and it will require the player to be level 10 or higher and it will cost 10 gold.
Code:
INSERT INTO `trainer_spells`VALUES (13337, 0, 50317, 100000, 0, 0, 10, 0, 0,
0);
Trinity, Mangos & OregonCore 3.3.5:
Npc_trainer table structure
Code:
INSERT INTO 'npc_trainer' VALUES NPCTRAINERID, SPELLID, LEARNCOST, REQSKILL, REQSKILLVALUE, REQLEVEL;
This query will add "Summon Disco Ball" to a npc trainer with the id "13337" and it will require the player to be level 10 or higher and it will cost 10 gold.
Code:
INSERT INTO 'npc_trainer' VALUES 13337, 50317, 100000, 0, 0, 10;