Cách Thêm ITEM Vào Kho Đồ Chung, Riêng Trên SQL

[huy228866]

Tình Hình Là Cái Cột Chứa ITEM Thì Bị Ẩn Mất Nên Không Biết Cách Add Item Vào Thùng Đồ Riêng Và Chung Nên Ai Biết Chỉ Giúp VỚi Nha

[Only registered and activated users can see links. ][Only registered and activated users can see links. ]

[pikhjn]

Khó lắm à cái này cũng từng đề cập với ông luật
Chịu thôi =,=!!

[huy228866]

khó lắm à cái này cũng từng đề cập với ông luật :p
chịu thôi =,=!!

hehe đang dựa trên cái webshop xem thế nào. định làm cái webshop online như thằng hv

[vanluat1991]

Tình Hình Là Cái Cột Chứa ITEM Thì Bị Ẩn Mất Nên Không Biết Cách Add Item Vào Thùng Đồ Riêng Và Chung Nên Ai Biết Chỉ Giúp VỚi Nha

[Only registered and activated users can see links. ][Only registered and activated users can see links. ]

cái này cũng không khó ,chủ yếu là kiên trì 1 tý

1 Item nó lưu trong Kho là 73 byte ,1 kho có 60 Item thì 4380 byte

do kiểu dữ liệu nó là dạng binary nên SQL nó không hiển thị trực tiếp cho mình xem đâu

muốn xem thì bạn Gõ Câu lệnh này trong Query của Database rxjhgame

Select FLD_ITEM from TBL_XWWL_Warehouse

mà nó cũng chỉ hiển thị khoảng 30 ~ 40% thôi chứ nó dài quá mà

[huy228866]

cái này cũng không khó ,chủ yếu là kiên trì 1 tý

1 item nó lưu trong kho là 88 byte ,1 kho có 60 item thì 5280 byte

do kiểu dữ liệu nó là dạng binary nên sql nó không hiển thị trực tiếp cho mình xem đâu

muốn xem thì bạn gõ câu lệnh này trong query của database rxjhgame

select fld_item from tbl_xwwl_warehouse

mà nó cũng chỉ hiển thị khoảng 30 ~ 40% thôi chứ nó dài quá mà :d

NÓ Hiện TÙM LUM HIỂU CHẾT LIỀN

HIỂU XÍ THÔI LÀ BIK DÙNG RỒI

[Only registered and activated users can see links. ]

[vanluat1991]

NÓ Hiện TÙM LUM HIỂU CHẾT LIỀN

HIỂU XÍ THÔI LÀ BIK DÙNG RỒI

[Only registered and activated users can see links. ]

đây demo cho bạn 1 đoạn :

3C3E02000000000003CD9A3B01000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000003363 0300000000000227B929010000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000A1800200 00000000F1CB9A3B0100000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000A28002000000 0000F2CB9A3B01000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000000000000000A380020000000000 E8CB9A3B010000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000000000000000000000A480020000000000E9CB 9A3B0100000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000A580020000000000EBCB9A3B0100 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000000000F3490200000000003BEB160001000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000DD530100000000000208AF2F01000000520D 03000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000A680020000000000EBCB9A3B0100000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000CC57010000000000B9CA9A3B13010000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00AB80020000000000F1CB9A3B010000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000C3 570100000000006ECA9A3B6100000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000CB5701 00000000008FCA9A3B07000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000A880020000 000000EECB9A3B010000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000083630100000000 0041CB9A3B01000000DC0800000E0000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000A980020000000000EF CB9A3B01000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000000000AA80020000000000F0CB9A 3B010000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000000000000000F1490200000000001C7F1B0001 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000A780020000000000ECCB9A3B010000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000DF7E010000000000DACC9A3B0700000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000D1720300000000001C08AF2F0100000038901E 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000CA5701000000000008BC0D00010000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000F2490200000000001B7F1B000100000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 F4490200000000003BEB160001000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000DC53 01000000000056CA9A3B010000000A2D3101632D3101632D31 01632D3101632D310100000000000000000000000000000000 000000000000000000000000000000000000000001F5490200 000000003E3A4C300100000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000D12003000000 00001CB8E41101000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000C46020000000000 B1929B30010000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000000000003763030000000000C399 053C010000001E943577000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000598603000000000043EEF805 01000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000C4760300000000003C08AF2F0100 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000000000C5760300000000003C08AF2F01000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000035630300000000000227B929010000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000075090500000000000508AF2F0100000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 000000000000000000000000000000000000

nhìn vô bạn biết dc những ji !!??


bạn gõ i chang câu lệnh truy vấn là nó ra như thế này a`

[huy228866]

KHÓ GHÊ TA CHẲNG LẼ KO AI HIỂU

[vanluat1991]

KHÓ GHÊ TA CHẲNG LẼ KO AI HIỂU

mỗi Item sẽ chiếm 73byte .
ví dụ trong đoạn mã trên thì
Item 1 nó sẽ nằm ở 73byte đầu tiên
Item 2 ------------73byte tiếp theo
.
.
.
.
Item cuối cùng.

muốn viết dc trước hết ban phải hiểu kĩ về nó ,chứ không biết ji thì làm sao mà viết dc !!

mình cho bạn cái cấu trúc luôn :
ví dụ cái Item đầu tiên

 3C3E02000000000003CD9A3B0100000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000

đây là cấu trúc của nó :

truct Item
{
  ItemSeries : 8byte 
  ItemId: 4byte
  ItemCount: 4byte
  Magic0:4byte
  Magic1:4byte
  Magic2:4byte
  Magic3:4byte
  Magic4:4Byte
}

ở sau vẫn còn nhiều giá trị nứa VD:Craft ,Khóa Item ,....
Nhưng bạn cứ cài cái struct trên đó là sữa vi vu rồi ,muốn add đồ kiểu nào cũng dc

[vanluat1991]

a` nhầm 1 tý
1 item chiếm 73 byte chứ không phải 88byte nha

[pikhjn]

cái tọa độ của Item "Thổ Linh Phù " thì cũng làm như thế lun hử