How do I make a Global Trainer

[dragonowner]

I know there has to be a way to pull all trainer spells from one specific class trainer and insert them into one big trainer, but I don't know how. Also ONE BIIIIIIIIG Problem I'lll come across is the spells you need to do quests for (druids, shamans, hunters, ect.) How do I make those classes have the ability to learn those spells without the quest req.?

[marcelo_20xx]

Is all DB related, you can start by telling us what is your core and database, if it is Arcemu you need to alter the trainer_spells, search for a class trainer, copy paste their spells using insert queries, rinse and repeat.

[dragonowner]

Yeah its arcemu. I need help forming the queries to get me going.

[marcelo_20xx]

Is pretty much straight, find the trainer, target him and get the npc entry with the command .npc info, then search that entry in the trainer_spells table, you will see that entry in at least 20 rows. Now you can make the following query:

INSERT INTO trainer_spells values ("put here the trainers info values of the columns you want always separated by a comma");

Copy paste the rows and replace the values in the query above. The column names are pretty self explanatory you just need to insert new spells using the existing npc entry and replacing anything else.

And for the quest spells you can also insert them the same way, first look at websites like wowhead to know the spell's id and repeat the process.

[dragonowner]

Is pretty much straight, find the trainer, target him and get the npc entry with the command .npc info, then search that entry in the trainer_spells table, you will see that entry in at least 20 rows. Now you can make the following query:

INSERT INTO trainer_spells values ("put here the trainers info values of the columns you want always separated by a comma");

Copy paste the rows and replace the values in the query above. The column names are pretty self explanatory you just need to insert new spells using the existing npc entry and replacing anything else.

And for the quest spells you can also insert them the same way, first look at websites like wowhead to know the spell's id and repeat the process.

Doing it that way is horribly inefficient and long. It would be easier to select those spells and insert them into another npcId I know its possible because I use a query to call specific items to add to my vendors.... The setup will be different and I'm confused on a couple things since the vendor template is extremely extremely easy.

[Frostic]

lua script.... write one for the gossip menus and make it cast the spells on them to learn it best way!!!

and this makes training free!!! ftw woot is all free hehehe

[marcelo_20xx]

Sorry there is no easy way to this, unless you like messing with duplicate-entry primary keys.