Page 1 of 1
enchant skill related
Posted: Tue Jun 23, 2009 9:23 am
by 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
Re: enchant skill related
Posted: Tue Jun 23, 2009 9:43 am
by 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;
Re: enchant skill related
Posted: Tue Jun 23, 2009 11:01 am
by 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 ?
Re: enchant skill related
Posted: Tue Jun 23, 2009 11:13 am
by janiii
thegman wrote: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..
Re: enchant skill related
Posted: Tue Jun 23, 2009 12:18 pm
by 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