[Release] Simple Global Weapon Trainer

[Sounddead]

Just a simple NPC based on SQL to teach every weapon skill.


Screenies:
http://i158.photobucket.com/albums/t...408_160454.jpg

http://i158.photobucket.com/albums/t...408_160522.jpg

I realize that in the screenshots it says "Gobal Weapon Trainer". It is fixed in the SQL. I just didn't clear my Cache.

INSERT INTO creature_names (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `Leader`) VALUES ( '2000001', 'Hun Jin', 'Global Weapon Trainer', '', '7', '0', '0', '6449', '0', '0', '0', '0', NULL);
INSERT INTO creature_proto (`entry`, `minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `auras`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`) VALUES ('2000001', '70', '70', '1767', '100', '100', '100', '1', '17', '1500', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','5011','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','1180','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','15590','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','266','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','196','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','198','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','201','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','200','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','227','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','2567','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','197','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','199','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','202','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','5009','0','0','0','0','0','0','0');
INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','264','0','0','0','0','0','0','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 ('2000001', '0', '0', '0', '0', 'Hi , how can I help you?', '0', '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 ('2000001', '0', '0', '0', '0', 'Hi , how can I help you?', '0', '0')

Download including read-me:
Filebeam - Free Fast File Hosting

[Confucius]

Nice job [+rep]

[Sounddead]

Thanks hapkidomaster

[Confucius]

it not work

[Sounddead]

What does it say? I've tested it on so many DBs..

[Confucius]

it says unsuccessful when I put it in db

[Sounddead]

Could you actually tell me the error report?
Does it say duplicate entry or anything?

[Confucius]

sure [Err] 1062 - Duplicate entry '200001' for key 1
[Err] INSERT INTO creature_names (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `Leader`, `entry`) VALUES ('Hun Jin', 'Global Weapon Trainer', '', '7', '0', '0', '6449', '0', '0', '0', '0', NULL, '200001');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Sounddead]

That means that you already have a NPC with its ID of 200001.
Open up the SQL and change every "200001" To something a different ID that isn't in your DB already.

[Jrgamespot]

nice, ill try this a bit later, if it works +rep

[comet2500]

I get this error..

[Err] 1062 - Duplicate entry '200001' for key 1
[Err] INSERT INTO creature_names (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `Leader`, `entry`) VALUES ('Hun Jin', 'Global Weapon Trainer', '', '7', '0', '0', '6449', '0', '0', '0', '0', NULL, '200001');
[Msg] Finished - Unsuccessfully

I'm aware I have to edit the 2000001's, but where do I do this to change the files? I don't know what to edit..

[Performer]

Find Creature_names in the sql file. and edit where it says 200001 to an entry of your choice.

[Sounddead]

Maybe I'll just change it to something higher >.>

[Sounddead]

There. It's edited.

[comet2500]

Still get the error..

[Err] 1062 - Duplicate entry '2000001' for key 1
[Err] INSERT INTO creature_names (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `Leader`, `entry`) VALUES ('Hun Jin', 'Global Weapon Trainer', '', '7', '0', '0', '6449', '0', '0', '0', '0', NULL, '2000001');
[Msg] Finished - Unsuccessfully
-------------------------------------------------