Page 1 of 1
Characters Skills
Posted: Wed Mar 03, 2010 11:24 am
by Nakamoura
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision
3973 :
L2JDP Revision
7127:
Hello All...I need some info on how can i remove from database all characters skills + and not one by one from ingame..For example how can i make the skills from +10 to 0..
-Thanks In Advance John
Re: Characters Skills
Posted: Wed Mar 03, 2010 11:28 am
by _DS_
This query will cap all skills to +20.
+1 -> +1
+19 -> +19
+20 -> +20
+25 -> +20
Code: Select all
UPDATE character_skills SET skill_level=120 WHERE skill_level > 120 AND skill_level < 201;UPDATE character_skills SET skill_level=220 WHERE skill_level > 220 AND skill_level < 301;UPDATE character_skills SET skill_level=320 WHERE skill_level > 320 AND skill_level < 401;UPDATE character_skills SET skill_level=420 WHERE skill_level > 420 AND skill_level < 501;UPDATE character_skills SET skill_level=520 WHERE skill_level > 520 AND skill_level < 601;UPDATE character_skills SET skill_level=620 WHERE skill_level > 620 AND skill_level < 701;UPDATE character_skills SET skill_level=720 WHERE skill_level > 720 AND skill_level < 801;UPDATE character_skills SET skill_level=820 WHERE skill_level > 820 AND skill_level < 901;
Re: Characters Skills
Posted: Wed Mar 03, 2010 11:39 am
by Nakamoura
I didnt understand this really sorry...I want to make all skills enchant to 0 what should i do?
Re: Characters Skills
Posted: Wed Mar 03, 2010 2:07 pm
by _DS_
+0 is much harder than +1, really
For +1 replace 120 with 101, 220 with 201, etc.
Re: Characters Skills
Posted: Wed Mar 03, 2010 2:37 pm
by momo61
Nakamoura wrote:I didnt understand this really sorry...I want to make all skills enchant to 0 what should i do?
Just delete the whole character_skills table o_O
When players log in, they will get fresh +0 skills
Re: Characters Skills
Posted: Wed Mar 03, 2010 2:49 pm
by Mayhem
momo61 wrote:Just delete the whole character_skills table o_O
When players log in, they will get fresh +0 skills
What about Divine Inspiration skills and Forgotten Scrolls skills? If they are not automatic they won't learn them again automatically.