Understanding Item HEX Code

[themad]

CzF Guide: Understanding item's db code

E.x. Item: 1400FF003A605E008310 (Knight Blade +0 +0 no luck , no skill , no serial , non exl, 255 dur)

Lets define

• 14
  • 1: item type ( 1 is for swords - you can check them urself to see which is which)
  • 4: item id ( 4 is for the Knight Blade )
• 00: Item Level/Luck/Skill/Option Level
• FF: Durability (FF is 255)
• 00: Ancient Item Code (00: non ancient)
• 3A605E: Item Serial (Increases with every dropped/added item - UNIQUE, if matches - item is either added by an admin that doesn't know what he is doing or item's dupe)
• 00: item excellent options (00 is non exl)
• 8310: still do not know exactly what this means but changes every time smh in the item(level/exl opt/anc/skill/dur -everything) and does not effect the item

If items takes more than one slot its code will be normal except after the item there should be "FFFFFFFFFFFFFFFFFFFF" - blank field. If two items stack one under another and the first one is two horizontal slotted slotted the second item will disapear (never even appear) once the inventory or vault was opened by the user.

Item is exactly 10 str in binary length and 20 in varchar (not more , not less !)

Understanding Character Inventory Item locations

Muse Elf Equipted with: Nature ste +13+28 Full opt, viper bow, ring of ice, ring of poison, pendant of lighting, bolts, wings of spirits, dinorant
Hex:

0x8F28EA0000000000000094EFFF00275F0A7F0000F86FFF00275EF57F0000186FFF00275EF5FF0010386FFF00275EF5FF0000586FFF00275EF5FF0000786FFF00275EF5FF00FF836FFF00275EF7FF0071A300FF003A6C32802822AC6BFF001C4ABEFF000FA86BFF000562D9FF0000A96BFF001EC60CC00900FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF8F28FF000000000000FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

Lets explain which is which
--------------------------------------------------
8F28EA00000000000000 - Bolts+5 (First hand Slot)
94EFFF00275F0A7F0000 - Viper Bow (Second hand Slot)
F86FFF00275EF57F0000 - Red Spirit Helm (Helm Slot)
186FFF00275EF5FF0010 - Red Spirit Armor (Armor Slot)
386FFF00275EF5FF0000 - Red Spirit Pants (Pants Slot)
586FFF00275EF5FF0000 - Red Spirit Gloves (Gloves Slot)
786FFF00275EF5FF00FF - Red Spirit Boots (Boots Slot)
836FFF00275EF7FF0071 - Wings Of Spirit (Wing/Cape Slot)
A300FF003A6C32802822 - Dinorant (Guardian slot)
AC6BFF001C4ABEFF000F - Pendant Of Lighting (Pendant slot)
A86BFF000562D9FF0000 - Ring Of Ice (Ring1 slot)
A96BFF001EC60CC00900 - Ring Of poison (Ring2 slot)
FFFFFFFFFFFFFFFFFFFF - inventory slot 1x1 Blank
FFFFFFFFFFFFFFFFFFFF - inventory slot 2x1 Blank
FFFFFFFFFFFFFFFFFFFF - inventory slot 3x1 Blank
FFFFFFFFFFFFFFFFFFFF - inventory slot 4x1 Blank
8F28FF000000000000FE - inventory slot 5x1 Bolts+5 (255)
FFFFFFFFFFFFFFFFFFFF - inventory slot 6x1 Blank
etc...


code to retreive full items from warehouse/inventory(usually retreives only first slots in select case)
Inventory:

declare @items varbinary(1200),
@charname varchar(10);
/* Your character's name here */
set @charname=('CHARNAME_HERE'); 

set @items=(select [inventory] from [Character] where [Name]=@charname);
print @items;

Vault:

declare @items varbinary(1200),
@accname varchar(10);
/* Your account's name here */
set @accname=('ACC_HERE'); 

set @items=(select [Items] from [warehouse] where [AccountId]=@accname);
print @items;

Credits: [CzF] Savoy

hf ;)

[MentaL]

[Dios]

Nice, this is extremely good for new people.

Helps understand MuEditor a lot better.

[edwo]

Thank you so much for this! one question: all versions have the same way for hex codes? This works for 1.02K?

[aspire219]

i have a problem with the setnumber of new items for season2

[themad]

Thank you so much for this! one question: all versions have the same way for hex codes? This works for 1.02K?

DB side item codes are the same for all versions

[C4liph]

Very Useful man , excellent guide ^^ :clap_1:

[didi3d]

themad you are the best man thx a lot for the explanation, but 1 question:

how to update sets in the db using the hex code a example :

F86FFF00275EF57F0000 - Red Spirit Helm
only 2 first characters identify the item right.

how to this update all Spirit helm to another helm? example Silk Helm

186FFF00275EF5FF0010 (i know this not a hex code for silk helm it

[limpamesa]

Version 996xt does not work like this in ancient and serial part:

Pendant of Lightining:AC6BFF0202227AC00900 = ancient
Pendant of Lightining:AC6BFF0202227AFF0000 = full

0202227A=serial

[didi3d]

Themad your sites are the best and tou help too, but little question for you :

in my BD i have this code : F86FFF00275EF57F0000
only 2 first caracters say this item is a Red Spirit Helm, right !

now the question, how to modify all Red Spirit Helm in BD (warehouse and Inventory) for a Wind Helm using a SQL function or procedure ?

it

[didi3d]

Themad your sites are the best and tou help too, but little question for you :

in my BD i have this code : F86FFF00275EF57F0000
only 2 first caracters say this item is a Red Spirit Helm, right !

now the question, how to modify all Red Spirit Helm in BD (warehouse and Inventory) for a Wind Helm using a SQL function or procedure ?

it

[SlavOOn]

How insert to warehouse jewel though PHP?

[Mulegend]

themad nice guide :) but i see many error, plz correct me if not

1484FF000BFF6A000000000000000000 = Knight Blade + 0 + luck + Skill - Dur 255

1484FF > Item
000BFF6A > Serial
000000000000000000 = Index Type (and others i dont know)

1484FF:
14 = Item Num 20
8 = Skill
4 = Luck
FF = Dur 255
000BFF6A > Serial Number
000000000000000000 > Item Index
0 = 0

SlavOOn in php:

$item="0D0001000BFF710000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"; // Jewel of Bless Durability 1
$creaitem=mssql_query("update warehouse SET Items = 0x".$item." where AccountID='Mulegend'");


Bye...

[themad]

The bumping of old threads is needed? I don't even feel like editing a guide like this... its rly messed up and...i'll leave it this way...not to talk that the code you are entering is a season II code..and the guide is for the classic (s1 versions)

[Mulegend]

aps, oks..

[devil940]

wow really nice

[grantz]

thanks man it really help me a lot...

[Ebanawka]

Hello, can some1 explain how to get codes like this one??

0D0001000BFF710000E0000000000000

I can' t use CzF mueditor, just db is on other PC...

maybe any decoder script....


Tried items generator but got

CD5CFF00000000C004DD for bless

[Hidden]

06-10-2007
This is way outdated, you shouldn't have bumped this.

[Robotic]

great guide !

[Ebanawka]

omg outdated - outdated...

Can't u just help?? I can't find newer guide...

[MuIsBest]

Please do not bump threads like this, it was like 1 year old. You could have pmed themad.

[lekov90]

Hello! I want to ask you how i can add items in character inventory emptyslot not to weapon place?

Thank You