- Joined
- Dec 22, 2006
- Messages
- 5
- Reaction score
- 0
We assort codes of things:
HEX/DEC Methods, scripts, the description, explanations, etc.
---------------------------------------------------------------------------------------------------------
As a working example we shall take a database "MuOnline" and its table "Character". Well and the field "Inventory" this table is concrete.
* In this floor the information on all lays that is at the character, but we shall consider while only that that is dressed.
# Here, that turns out as a result:
# The received result - a code of this or that thing in a database: "0x2400FF001B88CF400070000000000000"
HEX/DEC Methods, scripts, the description, explanations, etc.
---------------------------------------------------------------------------------------------------------
As a working example we shall take a database "MuOnline" and its table "Character". Well and the field "Inventory" this table is concrete.
* In this floor the information on all lays that is at the character, but we shall consider while only that that is dressed.
Code:
-- We declare variables for processing string Inventory
declare @Lstr varbinary(254), --
@s1 varbinary(32), --item1
@s2 varbinary(32), --item2
@s3 varbinary(32), --item3
@s4 varbinary(32), --item4
@s5 varbinary(32), --item5
@s6 varbinary(32), --item6
@s7 varbinary(32), --item7
@s8 varbinary(32) --item 8
-- We read actually line Inventory from table Character
set @Lstr=(select inventory from character where accountid='Noob' and name='Noob[Elf]')
-- We deduce a line for viewing
select @Lstr [full sting Inventory]
-- We break a line into items
-- Hand
set @s1=substring(@Lstr, 1, 16)
select @s1 [Right Hand ]
-- Hand
set @s2=substring(@Lstr, 17, 16)
select @s2 [left Hand ]
--helm
set @s3=substring(@Lstr, 33, 16)
select @s3 helm
--armor
set @s4=substring(@Lstr, 49, 16)
select @s4 armor
--Pants
set @s5=substring(@Lstr, 65, 16)
select @s5 Pants
--Glovers
set @s6=substring(@Lstr, 81, 16)
select @s6 Glovers
--Boots
set @s7=substring(@Lstr, 97, 16)
select @s7 Boots
--Wings
set @s8=substring(@Lstr, 113, 16)
select @s8 Wings
select @Lstr
select @s1+@s2+@s3+@s4+@s5+@s6+@s7+@s8# Here, that turns out as a result:
Code:
full string Inventory
------------------------------------------------------------------
0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF2400FF001B88CF4000700000000000002400FF001B88CE4000800000000000002400FF001B88D04000900000000000002400FF001B88D14000A00000000000002400FF001B88D24000B00000000000000000FF001B88D34000C0000000000000
(1 row(s) affected)
Right Hand
------------------------------------------------------------------
0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
(1 row(s) affected)
left Hand
------------------------------------------------------------------
0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
(1 row(s) affected)
helm
------------------------------------------------------------------
0x2400FF001B88CF400070000000000000
(1 row(s) affected)
Armor
------------------------------------------------------------------
0x2400FF001B88CE400080000000000000
(1 row(s) affected)
Pants
------------------------------------------------------------------
0x2400FF001B88D0400090000000000000
(1 row(s) affected)
Glovers
------------------------------------------------------------------
0x2400FF001B88D14000A0000000000000
(1 row(s) affected)
Boots
------------------------------------------------------------------
0x2400FF001B88D24000B0000000000000
(1 row(s) affected)
Wings
------------------------------------------------------------------
0x0000FF001B88D34000C0000000000000
(1 row(s) affected)
Credits go to SharedNoob[BoR].
* So, I spread intermediate result of the table of conformity with a script of its filling.
* Attention! Meanwhile a unique log known to me in below the presented script, this wrong definition +add in the right hand of character therefore as it there differs because of +add on shield if I am not mistaken. There goes not up to 28, and up to 35. In the rest all works like correct. If will find any logs/bugs write!
* Updatings of value of categories. In the previous messages mistakes which became visible only at last stages of decoding are admitted!
Pants
------------------------------------------------------------------
1 2 3 4 5 6 7 8 8 10 11 12 13 14 15 16
0x 24 30 FF 00 1C 50 69 00 00 90 00 00 00 00 00 00
1 First category designates number of group in which to be a thing.
10 tenth category designates number of a thing in group.
----------------------- The description------------------------------------------------
Numbers of groups and categories are in files of a server, in file Items (*) .txt.
* For example:
//swords
0
0 0 0 1 2 1 1 1 "Kris" ...
1 0 0 1 3 1 1 1 "Short Sword" ...
2 0 0 1 3 1 1 1 "Rapier" ...
3 0 20 1 3 1 1 1 "Katana" ...
..........................
end
Where
0 and end - The beginning and the end of group 0 in which lay swords
----------------------------------------------------------------
0
1
2 Accordingly codes of things in this group
3
4
----------------------------------------------------------------
That is two these of the category, designate, which thing is coded in a code.
* further the Sum of categories 4, 5, 6, 7, 8 - Serial number of the given thing.
* And actually the most interesting:
Categories 2, 8
-------------------the Description-----------------------------------------------------
Values of these categories also forms everything, that is on a current thing not pressing especially in a detail, Below the script of creation of the table of conformity of the given categories and properties of a thing will be resulted. Category 2 in the table is written down in floor KeyHex1 Category 8 in the table written down in floor KeyHex2
We search for a line in which your values coincide with values in the table
we See, that on this thing is, and that is not present. For the full description of a thing, it will be necessary to create one more script, for loading file Items (*) .txt in table SQL of a server. Otherwise it is necessary to dig all time in .txt files.* Attention! I warn for early, search in the table "HANDS" can to not result in what therefore as in the table of conformity after its filling will be hardly less than 29 000 rows. Therefore to search better scripts!
Scripts of search and sample are in a rudimentary kind, that is for sample on the specified name of the Account and the Character. But I yet shall not lay out these scripts, yet I shall not finish to mind.
In a script of conformity there are 2 tables.
* the First Table: It is set EXL of codes for things:
Code:
C1 C2 C3 C4 C5 C6 ExCode Comment
----------- ----------- ----------- ----------- ----------- ----------- ----------- -------------------------------
0 0 0 0 0 0 0 Нет EXL опций..
1 0 0 0 0 0 1 EXL опции: 1.
0 2 0 0 0 0 2 EXL опции: 2.
1 2 0 0 0 0 3 EXL опции: 1, 2.
0 0 4 0 0 0 4 EXL опции: 3.
1 0 4 0 0 0 5 EXL опции: 1, 3.
0 2 4 0 0 0 6 EXL опции: 2, 3.
1 2 4 0 0 0 7 EXL опции: 1, 2, 3.
0 0 0 8 0 0 8 EXL опции: 4.
1 0 0 8 0 0 9 EXL опции: 1, 4.
0 2 0 8 0 0 10 EXL опции: 2, 4.
1 2 0 8 0 0 11 EXL опции: 1, 2, 4.
0 0 4 8 0 0 12 EXL опции: 3, 4.
1 0 4 8 0 0 13 EXL опции: 1, 3, 4.
0 2 4 8 0 0 14 EXL опции: 2, 3, 4.
1 2 4 8 0 0 15 EXL опции: 1, 2, 3, 4.
0 0 0 0 16 0 16 EXL опции: 5.
1 0 0 0 16 0 17 EXL опции: 1, 5.
0 2 0 0 16 0 18 EXL опции: 2, 5.
1 2 0 0 16 0 19 EXL опции: 1, 2, 5.
0 0 4 0 16 0 20 EXL опции: 3, 5.
1 0 4 0 16 0 21 EXL опции: 1, 3, 5.
0 2 4 0 16 0 22 EXL опции: 2, 3, 5.
1 2 4 0 16 0 23 EXL опции: 1, 2, 3, 5.
0 0 0 8 16 0 24 EXL опции: 4, 5.
1 0 0 8 16 0 25 EXL опции: 1, 4, 5.
0 2 0 8 16 0 26 EXL опции: 2, 4, 5.
1 2 0 8 16 0 27 EXL опции: 1, 2, 4, 5.
0 0 4 8 16 0 28 EXL опции: 3, 4, 5.
1 0 4 8 16 0 29 EXL опции: 1, 3, 4, 5.
0 2 4 8 16 0 30 EXL опции: 2, 3, 4, 5.
1 2 4 8 16 0 31 EXL опции: 1, 2, 3, 4, 5.
0 0 0 0 0 32 32 EXL опции: 6.
1 0 0 0 0 32 33 EXL опции: 1, 6.
0 2 0 0 0 32 34 EXL опции: 2, 6.
1 2 0 0 0 32 35 EXL опции: 1, 2, 6.
0 0 4 0 0 32 36 EXL опции: 3, 6.
1 0 4 0 0 32 37 EXL опции: 1, 3, 6.
0 2 4 0 0 32 38 EXL опции: 2, 3, 6.
1 2 4 0 0 32 39 EXL опции: 1, 2, 3, 6.
0 0 0 8 0 32 40 EXL опции: 4, 6.
1 0 0 8 0 32 41 EXL опции: 1, 4, 6.
0 2 0 8 0 32 42 EXL опции: 2, 4, 6.
1 2 0 8 0 32 43 EXL опции: 1, 2, 4, 6.
0 0 4 8 0 32 44 EXL опции: 3, 4, 6.
1 0 4 8 0 32 45 EXL опции: 1, 3, 4, 6.
0 2 4 8 0 32 46 EXL опции: 2, 3, 4, 6.
1 2 4 8 0 32 47 EXL опции: 1, 2, 3, 4, 6.
0 0 0 0 16 32 48 EXL опции: 5, 6.
1 0 0 0 16 32 49 EXL опции: 1, 5, 6.
0 2 0 0 16 32 50 EXL опции: 2, 5, 6.
1 2 0 0 16 32 51 EXL опции: 1, 2, 5, 6.
0 0 4 0 16 32 52 EXL опции: 3, 5, 6.
1 0 4 0 16 32 53 EXL опции: 1, 3, 5, 6.
0 2 4 0 16 32 54 EXL опции: 2, 3, 5, 6.
1 2 4 0 16 32 55 EXL опции: 1, 2, 3, 5, 6.
0 0 0 8 16 32 56 EXL опции: 4, 5, 6.
1 0 0 8 16 32 57 EXL опции: 1, 4, 5, 6.
0 2 0 8 16 32 58 EXL опции: 2, 4, 5, 6.
1 2 0 8 16 32 59 EXL опции: 1, 2, 4, 5, 6.
0 0 4 8 16 32 60 EXL опции: 3, 4, 5, 6.
1 0 4 8 16 32 61 EXL опции: 1, 3, 4, 5, 6.
0 2 4 8 16 32 62 EXL опции: 2, 3, 4, 5, 6.
1 2 4 8 16 32 63 EXL опции: 1, 2, 3, 4, 5, 6.причем соответственно С1=1 опция, С2=2 опция и так далее. Сумма значений
этих опций, присутствующих в шмотке прибавляется к значению разряда 8.
То есть возьмем, к примеру, строку:
*In columns C1... C6 the attribute of presence of this or that EXL options at a belonging, and accordingly C1=1 an option, C2=2 an option and so on lays. The sum of values of these options which are present at a belonging increases to value of category 8. That is we shall take, for example, a line:
С1 С2 С3 С4 С5 С6 ExlCode
1 0 0 8 16 0 25 EXL опции: 1, 4, 5.
If in a belonging there will be this ExcCode, means, at it is 1-
Last edited by a moderator:
