Enchanted skills

[repxl]

hello where i can check what player have what skill enchanted and how mutch +++
i need delete all enchanted skills becuase i will disable it i will remove all books ...

[janiii]

search on forum. somebody already asked for a sql query how to delete enchanted skills. for info: enchanted skills have skill level > 100. so 101 is +1 enchant route 1, 201 is +1 enchant route 2, etc.

[repxl]

aha so where search it on chakrater_skills ?

or where btw i have no success in search forum

[JIV]

yes in char skills.

[repxl]

btw is a lot of editing :/

janii and when i do delete all skills from chakrakter_skills ?
i have autolearn on my server then all chars will auto learn all skills when enter world ? or noone will have skills ?

and when i change example 101 to 100 it will be +0 or i need to delete this what is > 100 ? or how to make it that it will just go to lvl 0 but no delete skill

vies co myslim aby nezrusilo vsetkym skilly a nebudu mat. ( sorry for other language .)

[repxl]

sorry for dualpost but i have deleted all skills lvl over 100 (> 100) and in game stil some players have enchanted skills example dual mastery swiftless +10

plz help :/

[janiii]

did you deleted it when server was running? you should do changes in database when server is down, never on running server!

[repxl]

yes server was running and i have deleted it and then i restarted .


what now ?

do* som daco ? :/ ( sorry for other language .)

[janiii]

just do the same when the server is off.

[JIV]

+1 warning for "do*". Watch your language.

[disorder35]

How can we set a max for enchant skill like I want to set max to +15. Where do I have to change for this to work?
Thank you

[Tan]

edit every xml?

[disorder35]

what do you mean every xml?
Can you be a bit more clear pls.
Thx

[janiii]

i would say, check table enchant_skill_groups and delete level 15+ .

[disorder35]

Like delete from 15 to 30 or just delete 15?