Trainer Problem

[Badcobra10]

Hey. I have problem. I made GM spell trainer but it only can teach 2 GM Spells, but i needs teach 30+ spells. How to make it train all spells to all classes and races?
Any1 who give answer will get 2x REP

I used this tutorial: But doesn't work: http://www.mmowned.com/forums/ascent...r-3-steps.html

[bueslum]

Where it says req_class put -1 or 0.

[Badcobra10]

I have 0 in it but it still doesn't work. Only warlocks can get 2 demonology spells with 2 gm spells

[bueslum]

Try -1 and restart the server.

[Badcobra10]

I get "SQL Error: Out of Range value adjusted for column 'reg_class' at row 1" when i try import it to database.
I'm not sure about it, that do i need add values to 'can_train_gossip_textid' and 'cannot_train_gossip_textid' columns.

I edited can_train_gossip_ID to 538 and cannot_train_gossip_ID to 539 but it didn't work.

[bueslum]

If the req_class is set to 0 it SHOULD be working. Check the other columns and make sure everything is right.

[Badcobra10]

req_class is set to 0, but it doesn't work. I don't know but only 5 "real" GM spells can be learnable. Also shaman gets Gift of the Water spell but...

[Badcobra10]

If any1 have ready GM Spell trainer and want to share it, will get +REP

[bueslum]

If it isn't working it means you either have the spell ids or the creature entry ids wrong just look instead of being lazy.

[Badcobra10]

It's right. Entry id is 99004 and i have over 30 'learn_spell' ids, and trainer says; Hi $N, Ready to learn GM secrets? I can't find any wrong ids or any other things.
Do i need fill 'trainerspelloverride' table?

[bueslum]

If you could then copy paste the sql rows in code tags and I'll look at it.

[Badcobra10]

Here is trainer_defs:

entry,required_skill,required_skillvalue,req_class,trainer_type,trainer_ui_window_message,can_train_gossip_textid,cannot_train_gossip_textid
99004,0,0,0,1,Hi $N, Ready to learn GM secrets?,0,0

Here is Trainer_spells:

entry,cast_spell,learn_spell,spellcost,reqspell,reqskill,reqskillvalue,reqlevel,deletespell,is_prof
99004,0,26035,0,0,0,0,1,0,0
99004,0,22865,0,0,0,0,1,0,0
99004,0,7621,0,0,0,0,1,0,0
99004,0,24843,0,0,0,0,1,0,0
99004,0,712,0,0,0,0,1,0,0
99004,0,697,0,0,0,0,1,0,0
99004,0,1885,0,0,0,0,1,0,0
99004,0,747,0,0,0,0,1,0,0
99004,0,25805,0,0,0,0,1,0,0
99004,0,691,0,0,0,0,1,0,0
99004,0,25947,0,0,0,0,1,0,0
99004,0,27604,0,0,0,0,1,0,0
99004,0,518,0,0,0,0,1,0,0
99004,0,25322,0,0,0,0,1,0,0
99004,0,261,0,0,0,0,1,0,0
99004,0,1881,0,0,0,0,1,0,0
99004,0,3428,0,0,0,0,1,0,0
99004,0,26027,0,0,0,0,1,0,0
99004,0,41377,0,0,0,0,1,0,0
99004,0,25033,0,0,0,0,1,0,0
99004,0,26546,0,0,0,0,1,0,0
99004,0,26339,0,0,0,0,1,0,0
99004,0,3499,0,0,0,0,1,0,0
99004,0,2603,0,0,0,0,1,0,0
99004,0,3527,0,0,0,0,1,0,0
99004,0,26540,0,0,0,0,1,0,0
99004,0,40884,0,0,0,0,1,0,0
99004,0,26139,0,0,0,0,1,0,0
99004,0,26025,0,0,0,0,1,0,0
99004,0,30362,0,0,0,0,1,0,0
99004,0,26024,0,0,0,0,1,0,0
99004,0,25812,0,0,0,0,1,0,0
99004,0,3655,0,0,0,0,1,0,0
99004,0,25772,0,0,0,0,1,0,0
99004,0,785,0,0,0,0,1,0,0
99004,0,25260,0,0,0,0,1,0,0
99004,0,38538,0,0,0,0,1,0,0
99004,0,29973,0,0,0,0,1,0,0
99004,0,38010,0,0,0,0,1,0,0
99004,0,41410,0,0,0,0,1,0,0
99004,0,30522,0,0,0,0,1,0,0
99004,0,29879,0,0,0,0,1,0,0
99004,0,40832,0,0,0,0,1,0,0
99004,0,38917,0,0,0,0,1,0,0
99004,0,41276,0,0,0,0,1,0,0
99004,0,39835,0,0,0,0,1,0,0
99004,0,37897,0,0,0,0,1,0,0
99004,0,38905,0,0,0,0,1,0,0
99004,0,26093,0,0,0,0,1,0,0
99004,0,41937,0,0,0,0,1,0,0
99004,0,41545,0,0,0,0,1,0,0
99004,0,40322,0,0,0,0,1,0,0
99004,0,37284,0,0,0,0,1,0,0
99004,0,30383,0,0,0,0,1,0,0
99004,0,31258,0,0,0,0,1,0,0
99004,0,39594,0,0,0,0,1,0,0
99004,0,34355,0,0,0,0,1,0,0
99004,0,30874,0,0,0,0,1,0,0
99004,0,40685,0,0,0,0,1,0,0
99004,0,29487,0,0,0,0,1,0,0
99004,0,34436,0,0,0,0,1,0,0
99004,0,30168,0,0,0,0,1,0,0
99004,0,30533,0,0,0,0,1,0,0
99004,0,33916,0,0,0,0,1,0,0
99004,0,39329,0,0,0,0,1,0,0
99004,0,37538,0,0,0,0,1,0,0
99004,0,37729,0,0,0,0,1,0,0
99004,0,32932,0,0,0,0,1,0,0
99004,0,28531,0,0,0,0,1,0,0
99004,0,33463,0,0,0,0,1,0,0
99004,0,37991,0,0,0,0,1,0,0
99004,0,265,0,0,0,0,1,0,0
99004,0,39258,0,0,0,0,1,0,0
99004,0,35182,0,0,0,0,1,0,0
99004,0,5,0,0,0,0,1,0,0
99004,0,11,0,0,0,0,1,0,0
99004,0,38505,0,0,0,0,1,0,0
99004,0,1908,0,0,0,0,1,0,0
99004,0,35886,0,0,0,0,1,0,0
99004,0,23189,0,0,0,0,1,0,0
99004,0,27819,0,0,0,0,1,0,0
99004,0,38777,0,0,0,0,1,0,0
99004,0,33836,0,0,0,0,1,0,0
99004,0,43218,0,0,0,0,1,0,0
99004,0,40861,0,0,0,0,1,0,0
99004,0,35919,0,0,0,0,1,0,0
99004,0,6061,0,0,0,0,1,0,0
99004,0,38632,0,0,0,0,1,0,0
99004,0,40395,0,0,0,0,1,0,0
99004,0,30449,0,0,0,0,1,0,0
99004,0,36073,0,0,0,0,1,0,0
99004,0,39029,0,0,0,0,1,0,0
99004,0,1302,0,0,0,0,1,0,0
99004,747,0,0,0,0,0,1,0,0
99004,0,17178,0,0,0,0,1,0,0
99004,26339,0,0,0,0,0,1,0,0

[Badcobra10]

FIXED!! Trainer_type must be 2.