If you are using trinityDB
1. Report it on their bug tracker.
2. Update to the latest rev.
3. Reload DB or restart server.
4. Test.
If you are using a repack:
1. Use a Db editor e.g. navicat to insert a sql query that makes the trainers able taught it to players.
2. Reload DB or restart server.
3. Test.
WRITING A QUERY**
INSERT INTO npc_trainer VALUES (NPCID ,SPELLID, COST, REQSPELLID, REQSKILLLVL, REQLVL);
NPC ID: Creature ID ex(5928582)
Spell ID: SPELL ID ex(15715815815815)
Training COST (in cooper)
1 = 1C
100 = 1S
10076 = 10S 76C
10000 = 1G
Req Spell: If you need e.g. charge before you may learn this spell put the charge spell id here.
Req Skill Level: Example 450 enchanting, leave it to null or '0'
Req Level: if player's level < this value, player won't be able to learn this spell...
These queries may work:
Code:
Tarlhir <Warrior Trainer> 50018 Faction: The Scryers
INSERT INTO npc_trainer VALUES (50018, 355, 10076, 0, 0, 12);
Code:
Bratu <Warrior Trainer> 50025 Faction: The Aldor
INSERT INTO npc_trainer VALUES (50025 , 355, 10076, 0, 0, 12);
[!] The queries may not work with your DB version i might be using an older or newer rev than you are.
Regards, Dawn.