Skill Mastery

[Mr.Awesome1337]

Hello, I've been trying to add more than 1 extra mastery. Its working perfectly if I add only 1 new, trying to add the 2nd one makes sro_client crash once i add the skill mastery via sql, any ideas?

[JoleChow*]

Check if there's duplicated ID in skill mastery
and check refskill IDs in the right new mastery page ( the new skills you added in your new mastery ) UI_SkillTab, SkillPage,SkillColumn and Skill row and of course in your skilldata enc

If everything is fine so you can use this query
to remove all skills and mastery from specific character and test to login
update me if didn't work got another option

 Spoiler

update _ClientConfig
set Data = '0'

DELETE FROM [dbo].[_CharSkill]
WHERE SKillID NOT LIKE '1' and SKillID NOT LIKE '2' and SKillID NOT LIKE '40'
and SKillID NOT LIKE '70' and SKillID NOT LIKE '8421' and SKillID NOT LIKE '8419'
and SKillID NOT LIKE '8420' and SKillID NOT LIKE '9354' and SKillID NOT LIKE '9355'
and SKillID NOT LIKE '9944' and SKillID NOT LIKE '10625' and SKillID NOT LIKE '11162'
and SKillID NOT LIKE '11526'
GO

UPDATE [dbo].[_CharSkillMastery]
SET
[Level] = '0'


---
UPDATE [dbo].[_Char]
SET RemainSkillPoint = RemainSkillPoint + 10000000
WHERE CharName16 = 'CHARNAME'

[Mr.Awesome1337]

Originally Posted by JoleChow*

Check if there's duplicated ID in skill mastery
and check refskill IDs in the right new mastery page ( the new skills you added in your new mastery ) UI_SkillTab, SkillPage,SkillColumn and Skill row and of course in your skilldata enc

If everything is fine so you can use this query
to remove all skills and mastery from specific character and test to login
update me if didn't work got another option

 Spoiler

update _ClientConfig
set Data = '0'

DELETE FROM [dbo].[_CharSkill]
WHERE SKillID NOT LIKE '1' and SKillID NOT LIKE '2' and SKillID NOT LIKE '40'
and SKillID NOT LIKE '70' and SKillID NOT LIKE '8421' and SKillID NOT LIKE '8419'
and SKillID NOT LIKE '8420' and SKillID NOT LIKE '9354' and SKillID NOT LIKE '9355'
and SKillID NOT LIKE '9944' and SKillID NOT LIKE '10625' and SKillID NOT LIKE '11162'
and SKillID NOT LIKE '11526'
GO

UPDATE [dbo].[_CharSkillMastery]
SET
[Level] = '0'


---
UPDATE [dbo].[_Char]
SET RemainSkillPoint = RemainSkillPoint + 10000000
WHERE CharName16 = 'CHARNAME'

I tried even to add it empty (without skills) it didn't work however the old one works perfectly with/without skills.
also I don't see that a query to delete charskills would change anything since I have no skills added in that mastery.
About the IDs, there is no duplicates also when i delete the mastery from a char i can log in normally but the crashes starts when i add the mastery to a char via sql.

[JoleChow*]

It was just an effort to try because sometimes when i update the skill the character crash until i remove the skills

Anyway, spots you have to look for your mastery w/w.o skills is
DB Side:

 Spoiler

Refskill
RefRefSkillGroup
RefSkillMastery

Media Side:

SkillMasterydata
SkillGroup
And of course names files