enchant skill related

[thegman]

i have found a way to limit players ability to OE there skills, but the problem is now how do i get rid of all the enchanted skills they have, in essence i want to delete all players enchanted skills.
thank for help

[janiii]

look up enchanted skills (good to check this after the update script):

Code: Select all

SELECT * FROM character_skills WHERE skill_level > 100;

set all enchanted skill of characters to their base level:

Code: Select all

UPDATE character_skills SET skill_level = (SELECT DISTINCT(base_lvl) FROM enchant_skill_trees WHERE enchant_skill_trees.skill_id = character_skills.skill_id) WHERE skill_level > 100;

[thegman]

sanchiou i hope i'll get this right. and another thing i haven't got a clue how to solve, how can i put enchant skills +10 MAX ?

[janiii]

sanchiou i hope i'll get this right. and another thing i haven't got a clue how to solve, how can i put enchant skills +10 MAX ?

this will delete all enchant skill routes about lvl10:

Code: Select all

DELETE FROM enchant_skill_trees WHERE level % 100 > 10;

but i am not sure if this will not make problems because in xml the skills are defined with 30lvls..

[thegman]

and max resist (all resists wind water earth uatever) how to set them to 90 max?? even if they pus extra stones or buffs, i want all resists max to 90. thx janiii