Auto skilldata

[Tryout]

I successfully manage to work on other classes except for the Force Blader class which I can't manage to make it work, SkillData is already added on cabal_new_character_data but it's not working in the game, not like other classes.

I am using the query below.

UPDATE cabal_new_character_data SET SkillData = 0x02000100004D010146005E010148005F010149009A01014B00FC00012100D001014E00D101014F00D201015000D301015100A501016600A601016700DA01016800FA01016900FB01016A00FC01016B00A301014700A401014400C401014500E001014A00FD01016C00FE01016D00
where classtype = 6

Fixed! I don't know what happened but I just restarted my server side.

 

[Drav3n]

Try to set the SkillData to "0x" to check if the stored procedure table fetching the classtype 6.
Let me know after you created a force blader your skill must be clean or zero.

Additional:
I split your SkillData, you can check if those skill IDs listed are force blader skills.

 

[Tryout]

Try to set the SkillData to "0x" to check if the stored procedure table fetching the classtype 6.
Let me know after you created a force blader your skill must be clean or zero.

Additional:
I split your SkillData, you can check if those skill IDs listed are force blader skills.

It's already fixed but all I did is to re-exec the query after I restarted the server.

 

[momochi]

I successfully manage to work on other classes except for the Force Blader class which I can't manage to make it work, SkillData is already added on cabal_new_character_data but it's not working in the game, not like other classes.

I am using the query below.

UPDATE cabal_new_character_data SET SkillData = 0x02000100004D010146005E010148005F010149009A01014B00FC00012100D001014E00D101014F00D201015000D301015100A501016600A601016700DA01016800FA01016900FB01016A00FC01016B00A301014700A401014400C401014500E001014A00FD01016C00FE01016D00
where classtype = 6

Fixed! I don't know what happened but I just restarted my server side.

how to create auto skill data query also for other class?

0x02000100004 <--- how to make this one where can we find some list of skill data to make this one sir? like skill book 1880 [whirlwind] [wa] how can we convert that to set data in db ? sorry im newbie

 

[Drav3n]

how to create auto skill data query also for other class?

I am not 100% sure how cabal writes the varbinary into SQL.
But the most important is you need to know how to read the varbinary.

Example:
0x4D01014600

4D01 = 014D (switch the 2 bytes position then convert from HEX to DEC to get the Skill ID)
014D = Skill ID: 333
01 = Skill Option or level
46 = Skill Slot ID
00 = I have no idea what is the last bytes, I guess it's reserved for the future???

 

[momochi]

I am not 100% sure how cabal writes the varbinary into SQL.
But the most important is you need to know how to read the varbinary.

Example:
0x4D01014600

4D01 = 014D (switch the 2 bytes position then convert from HEX to DEC to get the Skill ID)
014D = Skill ID: 333
01 = Skill Option or level
46 = Skill Slot ID
00 = I have no idea what is the last bytes, I guess it's reserved for the future???

thnx sir for explanation

 

[Drav3n]

0x02000100004 <--- how to make this one where can we find some list of skill data to make this one sir? like skill book 1880 [whirlwind] [wa] how can we convert that to set data in db ? sorry im newbie

the skillbook is a different story, it's just a client and server-side synchronization to learn the skill using the skillbook. Once the skill is successfully learned, the skill data of the character will be stored on the database with a varbinary data types.