Trainer Learing spells

[Fumi]

Is there a way to make a npc teach players a spell, like when you train spells, i would like the trainer to teach people this spell Summon Disco Ball - Spell - World of Warcraft

[Chrispee]

yep just make an npc and then into and then go to trainer_spells and add the npc with the spell id in

[Harambeqt]

For TDB: (2.4.3 version)

INSERT INTO 'npc_trainer' VALUES TRAINERID, 50317, GOLD COST, 0, 0, 0;

For 3.3.5 ArcEmu: (maybe wrong structure.)

INSERT INTO `trainer_spells`VALUES (TRAINERID, 0, 50317, 0, 0, 0, 0, 0, 0, 0);

The Arcemu structure i used:

CREATE TABLE `trainer_spells` (
`entry` int(11) unsigned NOT NULL default '0',
`cast_spell` int(11) unsigned NOT NULL default '0',
`learn_spell` int(11) unsigned NOT NULL,
`spellcost` int(11) unsigned NOT NULL default '0',
`reqspell` int(11) unsigned NOT NULL default '0',
`reqskill` int(11) unsigned NOT NULL default '0',
`reqskillvalue` int(11) unsigned NOT NULL default '0',
`reqlevel` int(11) unsigned NOT NULL default '0',
`deletespell` int(11) unsigned NOT NULL default '0',
`is_prof` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`, `cast_spell`, `learn_spell`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trainer System';