Hi Luugu
Can you tell me how to read the Binary Data of ChaInven?
- - - Updated - - -
Hi Luugu
can you tell me how to read Binary data of chainven
Printable View
Hi Luugu
Can you tell me how to read the Binary Data of ChaInven?
- - - Updated - - -
Hi Luugu
can you tell me how to read Binary data of chainven
Well, here's what I knew :Quote:
Originally Posted by chumleader
There first 12 bytes used for the header :
0-1 : version of data (Ran's episode)
2-3 : dont know
4-5 : size of Item slot
6-7 : dont know
8-9 : Number of items in the inventory
10-11 : dont know
After the header is the array of item slot with size indicated in the header for each.
the item slot structure you can find in the file GLitem.h (Ran source) !
welcome back Mr Bingo! ^_^
Quote:
Originally Posted by luugu
so heres the the info i wantQuote:
Originally Posted by luugu
Thanks for this
At User Error: invalid column name 'UserSQ' and 'UserSA'
At ChaInven and DB Tool Fix Database Errors: Invalid Column name 'ItemSec' , 'ItemPrice' , 'ItemCtg' , 'Itemexp' , 'ItemIco' , 'ItemSS' , 'date'.
Event not opening. Help please Thank You!
I dont remember where I get the base DB before upgrade to EPX.
So, pls add those column following :
- RanUser / UserInfo
UserSQ , varchar (50) , allow null
UserSA, varchar (50), allow null
- RanShop :
Delete the DB ShopItemMap then run the script below :
USE [RanShop]
GO
/****** Object: Table [dbo].[ShopItemMap] Script Date: 12/12/2016 8:33:42 Chiều ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ShopItemMap](
[ProductNum] [int] IDENTITY(1,1) NOT NULL,
[ItemMain] [int] NULL,
[ItemSub] [int] NULL,
[ItemName] [varchar](100) NULL,
[ItemSec] [int] NULL,
[ItemPrice] [varchar](100) NULL,
[Itemstock] [varchar](100) NULL,
[ItemCtg] [int] NULL,
[Itemexp] [varchar](100) NULL,
[ItemIco] [varchar](100) NULL,
[ItemSS] [varchar](100) NULL,
[date] [datetime] NOT NULL CONSTRAINT [DF_ShopItemMap_date] DEFAULT (getdate())
) ON [PRIMARY]
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[ShopItemMap] ADD [Duration] [varchar](50) NULL
ALTER TABLE [dbo].[ShopItemMap] ADD [Category] [int] NULL
ALTER TABLE [dbo].[ShopItemMap] ADD [ItemImage] [varchar](300) NULL
CONSTRAINT [PK_ShopItemMap] PRIMARY KEY CLUSTERED
(
[ProductNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
- - - Updated - - -
Pls complete use DB Tool fix to get the right item name in the tab Character Inventory manager ! But if you dont need to see the right name, and the Main ID and Sub ID is enough for you so forget the DB Tool!
hei sir @luugu
why i get this eror when i open CharInvent Editor...
Invalid Column Name "Duration"
Invalid Column Name "Category"
Invalid Column Name "ItemImage"
Cant Open CharInvent editor :( can you help me?
Lookback the reply just above your question, drop the ShopItemMap then recreate it with sql query !Quote:
Originally Posted by kazuyama