Hex code

[tommor666]

Hey RAGEZONE,
I have a question for the speciallists here
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

[MentaL]

[murlock]

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

[tommor666]

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?

[2009x2014]

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

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

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

Warehouse

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

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

[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 .

[2009x2014]

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

//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

//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.

[tommor666]

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