Working Druid form trainer and stance!

[Kiev]

Hello mmowned, i have just made this when i got back from school as on alot of servers i see they ask for the stances or forms, well i thought why not make a trainer! Well as sometimes trainers are made to train all, i made sure these only train warrior and druid (not both for forms etc just the warr for stance and druid for form). Just execute into your DB and ingame do .npc spawn 90904, .npc spawn 90905. Also i have put a 100g price on druids Normal flight and 1000g price on the epic.

Link:

Download here

If you dont want to download here are the scripts:

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('90904','Stance Trainer','Stances','0','0','7','0','0','0',NULL,'7111','0','0','0','1','1','1',NULL);
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('90904','70','70','1852','9999999','99999999','0','1','16','1760','999999','999999','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
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('90904','0','0','1','2','Hi , i am the stance trainer','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90904','2468','0','0','0','0','0','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90904','1612','0','0','0','0','0','0','0');

If you get a error inserting just change the NPC ID.

Druid:

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('90905','Druid Form Trainer','Form','0','0','7','0','0','0',NULL,'7111','0','0','0','1','1','1',NULL);
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('90905','70','70','1852','9999999','99999999','0','1','16','1760','999999','999999','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
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('90905','0','0','11','2','Hi , i am the druid form trainer','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90905','1446','0','0','0','0','0','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90905','11594','0','0','0','0','0','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90905','499','0','0','0','0','0','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90905','1441','0','0','0','0','0','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90905','33950','1000000','0','0','0','0','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('90905','40123','10000000','0','0','0','0','0','0');

If that one has same just do as i said above

Credits:
Kard for showing me how to make trainers

[Kiev]

Bump! - no reply :S

[Spartansp]

nice but i prefer knaur trainers lol althou all my trainers are working and i dont even use his lol

[Kiev]

its for them who have the peeps asking for forms/stances

[Kiev]

bump - lack of posts

[*TraPStaR*]

lol dont see my name in credits :| lol