Simple RanManager for EPX !

[chumleader]

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

[luugu]

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 :
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) !

[ramispo]

welcome back Mr Bingo! ^_^

Well, here's what I knew :
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) !

[chumleader]

Well, here's what I knew :
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) !

so heres the the info i want
Thanks for this

[kennpogi]

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!

[luugu]

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!

[kazuyama]

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?

[luugu]

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 !