[HELP]how can I add a common skill to all NPC?

[kostantinosftw]

which command should I type in mySQL?

[FighterBoss]

not in mysql but just sql :P

 

UPDATE npcskills
SET skillid='idOfSkill'

 

[kostantinosftw]

not in mysql but just sql :P

 

UPDATE npcskills
SET skillid='idOfSkill'

This is going to replace all NPC skills with this one?

 

[FighterBoss]

 

Yes,what you ask for but just change the "idOfSkill" with the id that you want.

Btw if you want to change the level also you should do something more.

[kostantinosftw]

I dont think I were clear enough. :/ I need a command which adds 1 skill to all mobs.

btw this command UPDATE 'npcskills' SET skillid='23072';  it creates me an error (I mean it can't run)

[Trance]

INSERT INTO `npcskills` VALUES ('npc id', '23072', '1');

[kostantinosftw]

INSERT INTO `npcskills` VALUES ('npc id', '23072', '1');

That suppose to add this skill to all NPC? or I should type them one by one?

[Trance]

That suppose to add this skill to all NPC? or I should type them one by one?

 

Maybe can you replace npc id with smith like "*" / "*.*" I can't remember exactly or another row command. You have to play with your query from navicat.

[kostantinosftw]

Maybe can you replace npc id with smith like "*" / "*.*" I can't remember exactly or another row command. You have to play with your query from navicat.

maybe someone can show me how. :S

[kostantinosftw]

bamp