[Guide]Analysis of SkillData

As the title goes, we'll breaking down this 1 skill into its meaningful data
so here we go..

LEGEND:
AAAA = Initial Skill Data
BBBB = Skill Counter
CCCC = Padding??
DDDD = Main ID
EEEE = Sub ID
FFFF = Skill Level
GGGG = Skill Type (passive or active) i forgot...lolz
DATA:
0x0001000008000000010000001F00020004003700

0x0001000008000000 -> this is the initial value if there's no skill inserted or when the skill is deleted
0100 -> must be equal to the count of skills inserted
0000 -> not so sure about this so lets jst call it padding ... lolz
1F00 -> MainID of the skill which is 31 in dec
0200 -> SubID of the skill in this case it's 02 in dec
0400 -> skill level 0-8 master
3700 -> i think this is for passive or active skill, not so sure...

you can insert this in your database making the data as string (ex: update chainfo SET ChaSkills = "0x0001000008000000010000001F00020004003700" WHERE { insert your criteria here}.. please take note when using update statement, it will overwrite old data with the new data..

now for the next data or skill, you can just append the last four data 1F00020004003700 updating the skill counter your data now should like 0x0001000008000000020000001F000200040037001F00030004003700

now you can start coding gmce for yourself
i already finished mine same functionalities as the old gmce
so you can also make it, ill be helping you...

i am not a pro so this info may contain errors, anyway corrections are welcome..

NOTE: All are in WORD format (16 bits(2 bytes)) and stored in little endian format ex: data 001F when stored will be 1F00

-hope my little guide/explanation enlightens your mind
-next, will be the item inventory
-strippher (i-udergroundtEam)

uh i can't understand it??? why can't i ?? :((

thx for the info

dude,,,
is this a SQL scripT that sets a skill learned?

can u give 1 example of script that inserting a skill?

btw. dude,, as you say to me in YM :D you will share your GMC?

This is the binary data for the skills. It is the breakdown on how to understand the binary data. Nice one strippher!

hahaha... i-u i-u i-u.... go team ^__^

yeah i made own gmc by using this.

if you wanna add skills
just use this sql script

Update ChaInfo Set ChaSkills = ChaSkills + 0x010000001F00020004003700 where ChaNum = ?

remeber if your adding data to a binary dont put quotes.

If you run the query and get something about image type then just change your chaskill column to varbinary

Quote:

---

Originally Posted by `CcyClOnE`

yeah i made own gmc by using this.

if you wanna add skills
just use this sql script

Update ChaInfo Set ChaSkills = ChaSkills + 0x010000001F00020004003700 where ChaNum = ?

remeber if your adding data to a binary dont put quotes.

If you run the query and get something about image type then just change your chaskill column to varbinary

---

as an add ups you can use store procedure + SQL Query using PHP. this is an alternative solution.

oh i see.......whoot thanks for the info sir strippher but....im not a genius.....i cant get it though!

Quote:

---

Originally Posted by `CcyClOnE`

yeah i made own gmc by using this.

if you wanna add skills
just use this sql script

Update ChaInfo Set ChaSkills = ChaSkills + 0x010000001F00020004003700 where ChaNum = ?

remeber if your adding data to a binary dont put quotes.

If you run the query and get something about image type then just change your chaskill column to varbinary

---

dude how to add multiple skills by using that script?

nice info... big help... i'm almost done with the skills... this will probably help me

sorry for bumping sir authis..

but, ^____^ can anyone answer my question??

Quote:

---

Originally Posted by Seifer13

dude how to add multiple skills by using that script?

---

you can apply multiple data using this script using sql and process tru php

^
^
^
can we develop it denver^_^?

Success?