Characters Skills

[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

[_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; 

[Nakamoura]

I didnt understand this really sorry...I want to make all skills enchant to 0 what should i do?

[_DS_]

+0 is much harder than +1, really
For +1 replace 120 with 101, 220 with 201, etc.

[momo61]

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

[Mayhem]

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.