Problem in MAX Lvl Skill . "IMPORTANT"

sherio · Mar 27, 2013

Hello guys

after i made a server i got problem With making The skills Max lvl ,

however i set SRO_CLIENT.exe and SR_GameServer.exe

Cap lvl 110 , Mastery lvl 110 , Party Matching lvl 110 and Pet lvl 110

in these Pics you will see what my problem is .. it should write "MAX" under the skills

but this never happend .

Notice:This happens at the Europ Char too .

Thanks

Sherio :*

arabianfox · Mar 27, 2013

yes.. you will never see MAX word @ this skill..because client see another update line for lvl 12 of this skill

SO:

go to skilldata encrypted files search this skill and remove the lvl 12 line of this skill and go DB disable service for this line too by set ervice = 0

i hope you got it..

good luck

sherio · Mar 27, 2013

thanks alot for your caring bro , i will try it now and i hope it works for me

bro :O , i tried to follow up what you asked me to do , i found out that in order to fix all the skills according to what you told me , i will need like 1 year to fix it . isnt there any short way to make it ?? i hope yes ! .. waiting for your answer , thanks

arabianfox · Mar 30, 2013

well... there is an idea..

1 - extract all skilldata_xxxxenc.txt files from your media.pk2.

2 - decrypt them all to text files.

3 - go to your DB and execute this query on your SHARD DB :

Code:

update _RefSkill set service = 0 where Basic_Level = 12

**Hint: this query will disable every lvl 12 skill in your DB**

4 - now after disable all lvl 12 skills execute this query :

Code:

select * from _RefSkill where Service = 1 and ID <= 4999                     -- for skilldata_5000

select * from _RefSkill where Service = 1 and ID between 5000 and 9999       -- for skilldata_10000

select * from _RefSkill where Service = 1 and ID between 10000 and 14999     -- for skilldata_15000

select * from _RefSkill where Service = 1 and ID between 15000 and 19999     -- for skilldata_20000

select * from _RefSkill where Service = 1 and ID between 20000 and 24999     -- for skilldata_25000

select * from _RefSkill where Service = 1 and ID between 25000 and 29999     -- for skilldata_30000

select * from _RefSkill where Service = 1 and ID >= 30000                    -- for skilldata_35000

**This query will generate 7 groups of results every group is a skilldata text file**

5 - now copy every part to its text file (replace all old lines in each file) and encrypt every file back and everything is OK..

You must be registered to see links

I hope you understand the idea and you can do it without errors..

Serif94 · Mar 31, 2013

did it like you now sro stucks on loading screen no login screen appears ...

sladlejrhfpq · Mar 31, 2013

Serif94 said:
did it like you now sro stucks on loading screen no login screen appears ...

send me your skilldatas, I'll fix them

Serif94 · Mar 31, 2013

sladlejrhfpq sendet u the link and btw used this query for disabling Lv 11 too ...here again link

You must be registered to see links

update _RefSkill set service = 0 where Basic_Level = 11

Problem in MAX Lvl Skill . "IMPORTANT"

sherio

Newbie Spellweaver

arabianfox

Experienced Elementalist

sherio

Newbie Spellweaver

arabianfox

Experienced Elementalist

Serif94

Newbie Spellweaver

sladlejrhfpq

Developer

Serif94

Newbie Spellweaver

Similar threads