character_skills cleanup

[momo61]

Hey guys,

What is the best way to delete all the existing regular skills that are NOT enchanted from the character_skills table?

The reason for doing this is 1) cleanup the whole gameserver database and 2) ensure that characters dont have stacked skills.

So again, best way to delete regular skills from the character_skills table that are NOT enchanted (power, chance, mana, elemental etc.)

[Notorious]

Maybe this:

Code: Select all

DELETE FROM character_skills WHERE skill_level < 101;

[mgbhard]

That would also erase forgotten scroll skills, bad idea

I've ask about this but didn't get any response.

I don't remind in what chronicle, but l2j use to have a skill cleaning script before. Is really usefull, specially when every day 3 - 5 chars, get bugged while adding or changing their subclass

[janiii]

That would also erase forgotten scroll skills, bad idea

I've ask about this but didn't get any response.

I don't remind in what chronicle, but l2j use to have a skill cleaning script before. Is really usefull, specially when every day 3 - 5 chars, get bugged while adding or changing their subclass

check old-forum . there was a script for skill cleaning, but would need a rework for gracia.

[mgbhard]

That would also erase forgotten scroll skills, bad idea

I've ask about this but didn't get any response.

I don't remind in what chronicle, but l2j use to have a skill cleaning script before. Is really usefull, specially when every day 3 - 5 chars, get bugged while adding or changing their subclass

check old-forum . there was a script for skill cleaning, but would need a rework for gracia.

I've check but couldn't find it, could you plz give us a link?
Thx janiii

[janiii]

http://l2jserver.com/old-forum/thread.p ... adid=32650

[momo61]

i have forgotten skills as auto-learn skills. so, should i go ahead and use Notorious' SQL query ?

[mgbhard]

i have forgotten skills as auto-learn skills. so, should i go ahead and use Notorious' SQL query ?

I guess yes, but a backup is your best friend.



Janiii why wasn't this feauture commited, any side effect?

[_DS_]

This feature was not committed due to: forgotten scrolls, subclass cert skills.

[mgbhard]

This feature was not committed due to: forgotten scrolls, subclass cert skills.

I've applied the patch by hand, added the skills (forgotten and subclass) at the allowed list, and it seems to work well, i'll test it on live tomorrow, and paste the list here so any who wants it can use it.

[_DS_]

Useless with so many skills non-checked.

[blacksea]

http://l2jserver.com/old-forum/thread.p ... adid=32650

this script it was very good to find characters with 2 class skills, now even with flood protection i still find from time to time characters with skills from another class.

[mgbhard]

Useless with so many skills non-checked.

Anyway, it's better that 50 chars, with stacked subs...
At least till that problem is solved.