0 FighterBoss Posted June 10, 2011 Posted June 10, 2011 not in mysql but just sql :P UPDATE npcskills SET skillid='idOfSkill' Quote
0 kostantinosftw Posted June 10, 2011 Author Posted June 10, 2011 not in mysql but just sql :P UPDATE npcskills SET skillid='idOfSkill' This is going to replace all NPC skills with this one? Quote
0 FighterBoss Posted June 10, 2011 Posted June 10, 2011 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. Quote
0 kostantinosftw Posted June 10, 2011 Author Posted June 10, 2011 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) Quote
0 Trance Posted June 10, 2011 Posted June 10, 2011 INSERT INTO `npcskills` VALUES ('npc id', '23072', '1'); Quote
0 kostantinosftw Posted June 10, 2011 Author Posted June 10, 2011 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? Quote
0 Trance Posted June 10, 2011 Posted June 10, 2011 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. Quote
0 kostantinosftw Posted June 10, 2011 Author Posted June 10, 2011 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 Quote
Question
kostantinosftw
which command should I type in mySQL?
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.