Thread: Riding Trainer

Credits to [Only registered and activated users can see links. ]

Code:

delete from creature_names where entry = '1';
delete from creature_proto where entry = '1';
delete from trainer_defs where entry = '1';
delete from trainer_spells where entry = '1';

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 ('1', 'RidingTrainer', 'LunarSCR', '', '0', '7', '0', '0', '0', '0', '24072', '0', '0', '0', '1.0', '1.0', NULL, '0');

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`) VALUES ('1', '60', '60', '1741', '2442', '2442', '2434', '1.0', '51', '2000', '0', '142.0', '190.0', '0', '0', '0.0', '0.0', '360000', '3814', '0', '0', '0', '0', '0', '0', '1.5', '0.383', '0', '0', '4120', '0', '0', '2.5', '8.0', '14.0', '0', '0', '0', '0', '0', '0', '0');

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 ('1', '0', '0', '-1', '0', '0', '0', '0', 'Hello, $c! Ready for some training?', '3974', '3976');

/*Mounts*/;
insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values 
(1,0,34091,0,0,0,0,70,0,0),
(1,0,54197,0,0,0,0,70,0,0);

thank you