Can't train with custom trainer

[Salaramon]

I have created an NPC and have it with id: 10101.
I have added my codes to the database

INSERT INTO `trainer_defs` (entry, required_skill, required_skillvalue, req_class, RequiredRace, RequiredReputation, RequiredReputationValue, trainer_type, trainer_ui_window_message, can_train_gossip_textid, cannot_train_gossip_textid)
VALUES (10101, 0, 0, 8, 0, 0, 0, 10, "Hello, great $c $n! Ready for some extra mage training?", 0, 0);

INSERT INTO `trainer_spells` (entry, cast_spell, learn_spell, spellcost, reqspell, reqskill, reqskillvalue, reqlevel, deletespell, is_prof)
VALUES (10101, 0, 57063, 150000, 0, 0, 0, 10, 0, 0);

When i test and spawn the NPC, click on him, click on learn, and it's empty. :confused:
Anyone that can help me?

[Matis02]

Show us your creature Info. you may not have him set as a trainer.

[Salaramon]

INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`, `isTrainingDummy`, `guardtype`, `summonguard`) 
VALUES (10101, 100, 100, 35, 1000000000, 1000000000, 4294967295, 1.5, 51, 2000, 0, 5000, 15000, 0, 0, 0, 0, 36000, 1, 0, 0, 0, 0, 0, 0, 1.5, 0, '0', 1, 1000000000, 0, 0, 2.5, 8, 14, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`, `questitem1`, `questitem2`, `questitem3`, `questitem4`, `questitem5`, `questitem6`, `waypointid`) 
VALUES (10101, 'Maginor', 'Ultimate Mage Trainer', '', 51, 0, 0, 0, 0, 0, 17865, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0);

[Matis02]

Sorry for the delay.

You need to change your trainer_type from "10" to "2"


BTW thats in your trainer_defs table.

[Salaramon]

Thank you Walshie! . +rep. ^^

Cake and Cookies

more cake

[Matis02]

No problems and thanks for the rep.

[Chrispl57]

Thank you Walshie! . +rep. ^^

Cake and Cookies

more cake

The cakes a lie =P

[Salaramon]

The cakes a lie =P

yeah, i found that out too xD. I wanted that cake so much