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);
Bookmarks