SQL Code for lvl 380 + Jewel of Harmony Options

[DissObey]

This info should be usefull for server admins who accept donations for full option items. Currently there is no support for either the Jewel of Harmony option or the Lvl 380 Chaos machine options.


====================
! ! ! READ ME ! ! !
====================

Before i continue this dev/guide server admins should take note this method directly changes your database, if you make a mistake and your database screws up i cannot be held responsible.

====================
! ! ! READ ME ! ! !
====================

The following info is the result of about 2 hours after downloading a 1.0.16 server files so if i wrong on anything please correct me, i havent played around with server files since version 0.97b/d

1. Understanding the warehouse SQL

This query overwrites everything in your warehouse and places the item in the top left hand corner, all item in there will disapear so make sure your warehouse is empty first.

UPDATE warehouse SET Items = 0x0EEFFF00002F6B7F0028000000000000 WHERE AccountID = 'DissObey'

If you run this in SQL Query manager inside the vault of the account 'DissObey' should be an exc Solay Scepter+13+lvl 380 Option

You must replace '0EEFFF00002F6B7F0028000000000000' with the code for the item you want and replace 'DissObey' with the Acount name.

2. Understanding the item hex string

As you can see the item code is 32 characters long, each pair of characters is responsible for altering the item.

0E EF FF 00 00 2F 6B 7F 00 28 00 00 00 00 00 00

0E = Item Hex number
EF = Item level/luck/skill/option
FF = Durability (FF is max 255)
00 = Unknown at present
00 = Unknown at present
2F = Unknown at present [Maybe serial]
6B = Unknown
7F = Exc options/options/luck/skill/level
00 = Unknown
28 = Level 380 option
00 = Jewel of Harmony Options The first character is for the option the second is for the strength of the option. You can only have ONE Jewel of Harmony option on any item
00 = Unknown
00 = Unknown
00 = Unknown
00 = Unknown
00 = Unknown

If someone knows any of these unknown values would you mind posting what they do, i know some of them must be for acient types but i dont know which

Check these screenshots to see what you can do.

Lastly but not least the Credits

Thanks to:
Webzen for making MU
CzF for the Latest MuEditor
Me for working this out
laciano for his 1.0.16 server files

Maybe if someone could add this to MuEdit it would be very helpfull =D

 

[Liselotte]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

nice man, keep it up

 

[DissObey]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

>.< i'll write more on it tommorow, i put all my research into notepad and had a server restart >.< i hate it when that happens.

Ah well...

Next revision will be detailed harmony option codes for defensive items (Shield-Armor-Helm--Glove-Boot-Pant) with their maximum ability

 

[DissObey]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

Ok after working these out again here are the Jewel of Harmony option codes for defensive items only, offensive items are giving me some trouble.

1 = Defence increase
2 = Max Ag Increase
3 = Max Hp Increase
4 = Life auto regenration <- Regens X hp every 5 seconds, stacks with Rings/Pendats/Wings. Just imagine a Dark Lord with 2 rings+3% hp regen, cape+hp regen, pendant+3% hp regen and a full set of armor and sheild +hp regen thats 61% hp regen every 5 seconds
5 = Mana auto regenration <- works like hp regen
6 = Defence Success Rate v PVP
7 = Dammage Decrease <- Just like the exc option
8 = SD Increase

 

[peter15]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

Wow..Very Nice!!

 

[wolfulus]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

Adamantine Boots (section 11, index 26)

1A 00 FF 00002FB2 00 00 B0 000000000000

1A = item index
00 = level, option, luck, skill
FF = durability
00002FB2 = serial
00 = exc options
00 = ancient options
B = item section, 0 = ?
00 = harmony options
0000000000 = ?

 

[FT1FT1]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

Hello Everyone
We have little missunderstanding here
slot usage on item codes are as follow:
0 - Item Number
1 - Skill (80h) + Luck (04h) + Base Option (Option Mod 4)
2 - Item Durability (up to FFh)
3 - Item Serial (MSB)
4 - Item Serial
5 - Item Serial
6 - Item Serial (LSB)
7 - Excelent Option (01h~20h) + High Option Flag (if(BaseOption>3)40h)
8 - Ancient Option (don't know this one)
9 - Item Family (Family Id * 16)
A - Harmony Options
B - Unused (00h filled)
C - Unused (00h filled)
D - Unused (00h filled)
E - Unused (00h filled)
F - Unused (00h filled)

So the missundestanding is on the 28h value at position 9.
That slot is used to store family id, so the posible values are {00h,10h,20h,30h,40h,50h,60h,70h,80h,90h,A0h,B0h,C0h,D0h,E0h,F0h} so your 28h value stand for a Mace or Schepter and not for an Armor, on which case the value must be 80h
Also the Sunlight Armor is item 33 (22h) and not item 14 (0Eh) as your example shown

Please clarify your data so everyone can learn from your effort

 

[Saint]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

Keep it up dude.

 

[elche27]

Re: [Dev] SQL Code for lvl 380 + Jewel of Harmony Options

Hello Everyone
We have little missunderstanding here
slot usage on item codes are as follow:
0 - Item Number
1 - Skill (80h) + Luck (04h) + Base Option (Option Mod 4)
2 - Item Durability (up to FFh)
3 - Item Serial (MSB)
4 - Item Serial
5 - Item Serial
6 - Item Serial (LSB)
7 - Excelent Option (01h~20h) + High Option Flag (if(BaseOption>3)40h)
8 - Ancient Option (don't know this one)
9 - Item Family (Family Id * 16)
A - Harmony Options
B - Unused (00h filled)
C - Unused (00h filled)
D - Unused (00h filled)
E - Unused (00h filled)
F - Unused (00h filled)

So the missundestanding is on the 28h value at position 9.
That slot is used to store family id, so the posible values are {00h,10h,20h,30h,40h,50h,60h,70h,80h,90h,A0h,B0h,C0h,D0h,E0h,F0h} so your 28h value stand for a Mace or Schepter and not for an Armor, on which case the value must be 80h
Also the Sunlight Armor is item 33 (22h) and not item 14 (0Eh) as your example shown

Please clarify your data so everyone can learn from your effort

At always giving class of coding i thought u was leave all this stuff hahaha!
loads of hugs FT1FT1