- Joined
- Dec 27, 2004
- Messages
- 108
- Reaction score
- 16
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
Item is exactly 10 str in binary length and 20 in varchar (not more , not less !)
--------------------------------------------------
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:
Vault:
Credits: [CzF] Savoy
hf
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
Item is exactly 10 str in binary length and 20 in varchar (not more , not less !)
Understanding Character Inventory Item locations
Lets explain which is whichMuse 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:
Hex:
Code:
[B]0x8F28EA0000000000000094EFFF00275F0A7F0000F86FFF00275EF57F0000186FFF00275EF5FF0010386FFF00275EF5FF0000586FFF00275EF5FF0000786FFF00275EF5FF00FF836FFF00275EF7FF0071A300FF003A6C32802822AC6BFF001C4ABEFF000FA86BFF000562D9FF0000A96BFF001EC60CC00900FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF8F28FF000000000000FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF[/B]
--------------------------------------------------
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:
Code:
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:
Code:
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
Last edited: