Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Guide]Analysis of SkillData

Status
Not open for further replies.
Newbie Spellweaver
Joined
Oct 11, 2007
Messages
26
Reaction score
0
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)
 
Newbie Spellweaver
Joined
Jul 6, 2008
Messages
71
Reaction score
5
Re: [info]Analysis of SkillData

uh i can't understand it??? why can't i ?? :((
 
Joined
Sep 16, 2007
Messages
1,206
Reaction score
541
Re: [info]Analysis of SkillData

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?
 
Junior Spellweaver
Joined
Jul 27, 2007
Messages
181
Reaction score
2
Re: [info]Analysis of SkillData

hahaha... i-u i-u i-u.... go team ^__^
 
Junior Spellweaver
Joined
Jul 4, 2008
Messages
193
Reaction score
0
Re: [info]Analysis of SkillData

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
 
Junior Spellweaver
Joined
Feb 3, 2008
Messages
127
Reaction score
48
Re: [info]Analysis of SkillData

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.
 
Experienced Elementalist
Joined
Apr 6, 2007
Messages
248
Reaction score
1
Re: [info]Analysis of SkillData

oh i see.......whoot thanks for the info sir strippher but....im not a genius.....i cant get it though!
 
Joined
Sep 16, 2007
Messages
1,206
Reaction score
541
Re: [info]Analysis of SkillData

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?
 
Junior Spellweaver
Joined
Jan 1, 2008
Messages
170
Reaction score
0
Re: [info]Analysis of SkillData

nice info... big help... i'm almost done with the skills... this will probably help me
 
Junior Spellweaver
Joined
Feb 5, 2008
Messages
117
Reaction score
2
Re: [info]Analysis of SkillData

you can apply multiple data using this script using sql and process tru php
 
Status
Not open for further replies.
Back
Top