Hex code

Hey RAGEZONE,
I have a question for the speciallists here :ott1:
DO you know how can i check/ find out what is the hex code if each item? ..
I want to edit stuff on the query and I need hex codes for that, thx for helpers

I do not understand your exact needs ? you want to add items in your main.exe for best stability?

Quote:

---

Originally Posted by murlock

I do not understand your exact needs ? you want to add items in your main.exe for best stability?

---

Hey back,
Well my question is : how do I check the HEX code that I can put in the query?

Example of hex code S4 +
I don't work with older seasons, sorry

1BFF6FXXXXXXXX7F05883FFFFFFFFFFF

(HEX->DEC)

1B = Item ID
FF = Item Level/Skill/Luck/Option
6F = Item Durablity
XXXXXXXX = Item Serial
7F = Exc option/Option
05 = Ancient
8 = Item type
8 = Pink option
3F = Harmony option
FF FF FF FF FF = Socket Options (Slots 1,2,3,4,5)


So you can calculate Item ID / Type opts ur self

or

a) you can write hex generator
b) use programs like mumaker for reading hex codes
c) you can get hex codes from ware/inve using following sql querys


Helpful query for print ware & inventory hex codes
For different db/seasons recheck @inventory & @ware varbinary lenght in design table.

Open Sql Query Analyzer -> Login -> select MuOnline -> paste & hit F5

Inventory

Code:

---

declare @inventory varbinary(3776),
@nick varchar(10);
set @nick=('nickname');

set @inventory=(select [Inventory] from [Character] where [Name]=@nick);
print @inventory;

---

Warehouse

Code:

---

declare @ware varbinary(3840),
@account varchar(10);
set @account=('login');

set @ware=(select [Items] from [warehouse] where [AccountId]=@account);
print @ware;

---

Query for adding items in ware Item1 Item2 etc

Code:

---

Update warehouse set items = 0x1BFF6F000000007F000000FFFFFFFFFF1BFF6F000000007F000000FFFFFFFFFF where AccountId = 'login'

---

Awesome! thx.. i will try that as soon as I can.
And btw the season is fine.
One last question if you don't mind :) I don't understand much about the game. I mean this is my first edit, so where do I check the item's id? and item serial( if needed ), ..ill be greatfullllll .

Quote:

---

Originally Posted by tommor666

Awesome! thx.. i will try that as soon as I can.
And btw the season is fine.
One last question if you don't mind :) I don't understand much about the game. I mean this is my first edit, so where do I check the item's id? and item serial( if needed ), ..ill be greatfullllll .

---

Item ids & type you can find on Server files/data/lang/kor(or lang you use)/Item(xxx).txt

then transfer ID/Type to Hex using calculator (dec->hex)

example

Code:

---

//Index        ItemSlot        Skill        X        Y        Serial        Drop        ItemName                        ItemLvl        Defense        MagDef        Dur        ReqLvl        Str        Agi        Ene        Vit        Com        Type        DW/SM        DK/BK        Elf/ME        MG        DL        SUM        RF
5 <- Item Type
0 <- ID          0            0            1        3        1        1        1        "Skull Staff"                        6        3        4        20        0        20        6        0        40        0        0        0        0        3        1        0        0        1        0        1        0

---

ID = 0 (hex = 00)
Type = 5 (hex = 5)

0000123456780000005000FFFFFFFFFF


example 2

Code:

---

//Index        ItemSlot        Skill        X        Y        Serial        Drop        ItemName                        ItemLvl        Defense        MagDef        Dur        ReqLvl        Str        Agi        Ene        Vit        Com        Type        DW/SM        DK/BK        Elf/ME        MG        DL        SUM        RF
11 <- Item Type
(...)
52 <- ID                6        0        2        2        1        1        1        "Hades Boots"                        94        34        0        86        380        60        15        181        0        0        0        1        0        0        0        0        0        0

---

340012345678000000B000FFFFFFFFFF

ID = 52 (hex = 34)
Type = 11 (hex = B)



Item serial matters only when you have antidupe protection (2 same serial = dc)
So use 00000000 serial or generate unique for every new item if you want to trace that item later.

Thx 4funer.. Can i ask you one more question? ... how do I make it to be the standart for all of the accounts?