{templates and guide} to creating a all in one trainer

[*TraPStaR*]

OK this guide comes with templates to work with

what it will do when done correctly

it will create a trainer to teach cool unclassed unattainable spells that only gms
can teach to you you can also put class spells on here for cross class spells like self rez for a shaman to a priest and vice verse

but all that a side lets go

here are the templates every thing in green needs changed red you don't have to but you can and blue you can change but if you do you need to link it to the others as in anything in blue needs to be the same and if its not colored dont touch it

if you copy paste all these and don't change them you will have a weak trainer that will teach all class/races arcnine intellect

#1 creature names the blue text is its id the red text is its name and subname all the rest of the stuff you dont have to change but you can and if you do you must have it right or it might not work and the rest is mainly its display and how it acts boss non boss ect if you know the stuff change it if not dont

 insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('90900','mytest','tester','0','0','7','0','0','0',NULL,'1432','0','0','0','1','1','1',NULL);

#2 creature proto blue text is its id and the red is the combat spec change it if you know it if not leave it alone

 insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `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`) values('90900','25','25','12','1240','1240','0','1','16','1760','30','43','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');

#3 trainer defs
change the class to what you want then run the qurey
if you want it to train more than one class you have to run it again the class's are 0'1'2'3'4'5'7'8'9'11 i'm not sure what they are but -0 is all class's and there are some guides on what they are here blue is its id and the green is its req_class its set to train all class/race's

 insert into `trainer_defs` (`entry`, `required_skill`, `required_skillvalue`, `req_class`, `trainer_type`, `trainer_ui_window_message`, `can_train_gossip_textid`, `cannot_train_gossip_textid`) values('90900','0','0','-0,'2','Hi , how can I help you?','0','0');

#4 trainer spells blue text is its id green text is its spell that it teaches and the red text is its cost class race ect if you know it change it if not leave it alone

 insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90900','1472','0','0','0','0','0','0','0');

please let me know if i missed or can do anything better

[Illidan1]

WoW mate, that is really nice good job, easy to read, noob friendly, +Rep x8 Great!

[*TraPStaR*]

thanks :} hope to be as good as you one day :P

[latruwski]

verry nice ! + rep

[*TraPStaR*]

update i tested it on some unique spells they must have a learn spell id like the learn spell id for Arcane Intellect is 1472 but its cast spell id is 1459 so say you run a server and some one needs it its .learn 1459 not 1472 that will make it let them teach anyone it