[Release]9.4 Official Files

[glandu2]

If the 9.4 itemresource structure is not valid, you can write it in lua so you don't need Visual C++.
Lua is supported in the latest version v3.0.0 ()

Item94Database.lua is in "RappelzRDBTool-3.0.0-db-lua.zip"

[[DWL]ZONE]

ItemResource 9.4 view finished

RDB Tool


I used 9.5 data for item file name

you need to use epic 9.5 db_item.ref to make the items appear properly

you need to edit the ref file to add a new item

ItemResource View

 Spoiler

USE [Arcadia94]
GO
/****** Object: View [dbo].[ItemResource_94_view] Script Date: 25.10.2017 21:02:12 ZONE ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ItemResource_94_view]
AS
SELECT dbo.ItemResource.id, dbo.ItemResource.name_id, dbo.ItemResource.tooltip_id, dbo.ItemResource.type, dbo.ItemResource.[group], dbo.ItemResource.class, dbo.ItemResource.wear_type,
dbo.ItemResource.set_id, dbo.ItemResource.set_part_flag, dbo.ItemResource.rank, dbo.ItemResource.[level], dbo.ItemResource.enhance, dbo.ItemResource.socket, dbo.ItemResource.status_flag,
dbo.ItemResource.limit_deva, dbo.ItemResource.limit_asura, dbo.ItemResource.limit_gaia, dbo.ItemResource.limit_fighter, dbo.ItemResource.job_depth, dbo.ItemResource.limit_hunter,
dbo.ItemResource.limit_magician, dbo.ItemResource.limit_summoner, dbo.ItemResource.use_min_level, dbo.ItemResource.use_max_level, dbo.ItemResource.range, dbo.ItemResource.weight,
dbo.ItemResource.price, dbo.ItemResource.huntaholic_point, dbo.ItemResource.arena_point, dbo.ItemResource.ethereal_durability, dbo.ItemResource.endurance, dbo.ItemResource.material,
dbo.ItemResource.summon_id, dbo.ItemResource.item_use_flag, dbo.ItemResource.available_period, dbo.ItemResource.decrease_type, dbo.ItemResource.throw_range, dbo.ItemResource.base_type_0,
dbo.ItemResource.base_var1_0, dbo.ItemResource.base_var2_0, dbo.ItemResource.base_type_1, dbo.ItemResource.base_var1_1, dbo.ItemResource.base_var2_1, dbo.ItemResource.base_type_2,
dbo.ItemResource.base_var1_2, dbo.ItemResource.base_var2_2, dbo.ItemResource.base_type_3, dbo.ItemResource.base_var1_3, dbo.ItemResource.base_var2_3, dbo.ItemResource.opt_type_0,
dbo.ItemResource.opt_var1_0, dbo.ItemResource.opt_var2_0, dbo.ItemResource.opt_type_1, dbo.ItemResource.opt_var1_1, dbo.ItemResource.opt_var2_1, dbo.ItemResource.opt_type_2,
dbo.ItemResource.opt_var1_2, dbo.ItemResource.opt_var2_2, dbo.ItemResource.opt_type_3, dbo.ItemResource.opt_var1_3, dbo.ItemResource.opt_var2_3, dbo.ItemResource.effect_id,
dbo.ItemResource.enhance_id, dbo.ItemResource.skill_id, dbo.ItemResource.state_id, dbo.ItemResource.state_level, dbo.ItemResource.state_time, dbo.ItemResource.cool_time,
dbo.ItemResource.cool_time_group, dbo.ItemResource.model_type_dem, dbo.ItemResource.model_type_def, dbo.ItemResource.model_type_asm, dbo.ItemResource.model_type_asf,
dbo.ItemResource.model_type_gam, dbo.ItemResource.model_type_gaf, '0' AS ukn1, dbo.ItemResource.model_type_gaf AS ukn2, dbo.ItemResource.deco_model_change, '0' AS ukn3,
dbo.item_file_name.model_00, dbo.item_file_name.model_01, dbo.item_file_name.model_02, dbo.item_file_name.model_03, dbo.item_file_name.model_04, dbo.item_file_name.model_05,
dbo.item_file_name.model_06, dbo.item_file_name.model_07, dbo.item_file_name.model_08, dbo.item_file_name.model_09, dbo.item_file_name.model_10, dbo.item_file_name.model_11,
dbo.item_file_name.model_12, dbo.item_file_name.model_13, dbo.item_file_name.model_14, dbo.item_file_name.model_15, dbo.item_file_name.model_16, dbo.item_file_name.model_17,
dbo.item_file_name.texture_filename, dbo.item_file_name.drop_type, dbo.ItemResource.icon_id, dbo.item_file_name.icon_filename AS icon_file_name, dbo.ItemResource.group_bit_set, ISNULL(Expr1.effect_id,
0) AS effect_id_01, ISNULL(Expr2.effect_id, 0) AS effect_id_02, ISNULL(Expr1.value_01, 0) AS value_01, ISNULL(Expr1.value_05, 0) AS value_02, ISNULL(Expr1.value_09, 0) AS value_03, ISNULL(Expr1.value_13,
0) AS value_04, ISNULL(Expr1.value_17, 0) AS value_05, ISNULL(Expr1.value_21, 0) AS value_06, ISNULL(Expr1.value_22, 0) AS value_07, ISNULL(Expr1.value_23, 0) AS value_08, ISNULL(Expr1.value_24, 0)
AS value_09, ISNULL(Expr1.value_25, 0) AS value_10, ISNULL(Expr2.value_01, 0) AS value_11, ISNULL(Expr2.value_05, 0) AS value_12, ISNULL(Expr2.value_09, 0) AS value_13, ISNULL(Expr2.value_13, 0)
AS value_14, ISNULL(Expr2.value_17, 0) AS value_15, ISNULL(Expr2.value_21, 0) AS value_16, ISNULL(Expr2.value_22, 0) AS value_17, ISNULL(Expr2.value_23, 0) AS value_18, ISNULL(Expr2.value_24, 0)
AS value_19, ISNULL(Expr2.value_25, 0) AS value_20
FROM dbo.ItemResource LEFT OUTER JOIN
dbo.item_file_name ON dbo.ItemResource.id = dbo.item_file_name.id LEFT OUTER JOIN
dbo.EnhanceEffectResource AS Expr1 ON Expr1.sid = dbo.ItemResource.enhance_id AND Expr1.sub_id = 1 LEFT OUTER JOIN
dbo.EnhanceEffectResource AS Expr2 ON Expr2.sid = dbo.ItemResource.enhance_id AND Expr2.sub_id = 2

GO

[medaion]

Originally Posted by [DWL]ZONE

ItemResource 9.4 view finished

RDB Tool


I used 9.5 data for item file name

you need to use epic 9.5 ref to make the items appear properly

you need to edit the ref file to add a new item

ItemResource View

 Spoiler

USE [Arcadia94]
GO
/****** Object: View [dbo].[ItemResource_94_view] Script Date: 25.10.2017 21:02:12 ZONE ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ItemResource_94_view]
AS
SELECT dbo.ItemResource.id, dbo.ItemResource.name_id, dbo.ItemResource.tooltip_id, dbo.ItemResource.type, dbo.ItemResource.[group], dbo.ItemResource.class, dbo.ItemResource.wear_type,
dbo.ItemResource.set_id, dbo.ItemResource.set_part_flag, dbo.ItemResource.rank, dbo.ItemResource.[level], dbo.ItemResource.enhance, dbo.ItemResource.socket, dbo.ItemResource.status_flag,
dbo.ItemResource.limit_deva, dbo.ItemResource.limit_asura, dbo.ItemResource.limit_gaia, dbo.ItemResource.limit_fighter, dbo.ItemResource.job_depth, dbo.ItemResource.limit_hunter,
dbo.ItemResource.limit_magician, dbo.ItemResource.limit_summoner, dbo.ItemResource.use_min_level, dbo.ItemResource.use_max_level, dbo.ItemResource.range, dbo.ItemResource.weight,
dbo.ItemResource.price, dbo.ItemResource.huntaholic_point, dbo.ItemResource.arena_point, dbo.ItemResource.ethereal_durability, dbo.ItemResource.endurance, dbo.ItemResource.material,
dbo.ItemResource.summon_id, dbo.ItemResource.item_use_flag, dbo.ItemResource.available_period, dbo.ItemResource.decrease_type, dbo.ItemResource.throw_range, dbo.ItemResource.base_type_0,
dbo.ItemResource.base_var1_0, dbo.ItemResource.base_var2_0, dbo.ItemResource.base_type_1, dbo.ItemResource.base_var1_1, dbo.ItemResource.base_var2_1, dbo.ItemResource.base_type_2,
dbo.ItemResource.base_var1_2, dbo.ItemResource.base_var2_2, dbo.ItemResource.base_type_3, dbo.ItemResource.base_var1_3, dbo.ItemResource.base_var2_3, dbo.ItemResource.opt_type_0,
dbo.ItemResource.opt_var1_0, dbo.ItemResource.opt_var2_0, dbo.ItemResource.opt_type_1, dbo.ItemResource.opt_var1_1, dbo.ItemResource.opt_var2_1, dbo.ItemResource.opt_type_2,
dbo.ItemResource.opt_var1_2, dbo.ItemResource.opt_var2_2, dbo.ItemResource.opt_type_3, dbo.ItemResource.opt_var1_3, dbo.ItemResource.opt_var2_3, dbo.ItemResource.effect_id,
dbo.ItemResource.enhance_id, dbo.ItemResource.skill_id, dbo.ItemResource.state_id, dbo.ItemResource.state_level, dbo.ItemResource.state_time, dbo.ItemResource.cool_time,
dbo.ItemResource.cool_time_group, dbo.ItemResource.model_type_dem, dbo.ItemResource.model_type_def, dbo.ItemResource.model_type_asm, dbo.ItemResource.model_type_asf,
dbo.ItemResource.model_type_gam, dbo.ItemResource.model_type_gaf, '0' AS ukn1, dbo.ItemResource.model_type_gaf AS ukn2, dbo.ItemResource.deco_model_change, '0' AS ukn3,
dbo.item_file_name.model_00, dbo.item_file_name.model_01, dbo.item_file_name.model_02, dbo.item_file_name.model_03, dbo.item_file_name.model_04, dbo.item_file_name.model_05,
dbo.item_file_name.model_06, dbo.item_file_name.model_07, dbo.item_file_name.model_08, dbo.item_file_name.model_09, dbo.item_file_name.model_10, dbo.item_file_name.model_11,
dbo.item_file_name.model_12, dbo.item_file_name.model_13, dbo.item_file_name.model_14, dbo.item_file_name.model_15, dbo.item_file_name.model_16, dbo.item_file_name.model_17,
dbo.item_file_name.texture_filename, dbo.item_file_name.drop_type, dbo.ItemResource.icon_id, dbo.item_file_name.icon_filename AS icon_file_name, dbo.ItemResource.group_bit_set, ISNULL(Expr1.effect_id,
0) AS effect_id_01, ISNULL(Expr2.effect_id, 0) AS effect_id_02, ISNULL(Expr1.value_01, 0) AS value_01, ISNULL(Expr1.value_05, 0) AS value_02, ISNULL(Expr1.value_09, 0) AS value_03, ISNULL(Expr1.value_13,
0) AS value_04, ISNULL(Expr1.value_17, 0) AS value_05, ISNULL(Expr1.value_21, 0) AS value_06, ISNULL(Expr1.value_22, 0) AS value_07, ISNULL(Expr1.value_23, 0) AS value_08, ISNULL(Expr1.value_24, 0)
AS value_09, ISNULL(Expr1.value_25, 0) AS value_10, ISNULL(Expr2.value_01, 0) AS value_11, ISNULL(Expr2.value_05, 0) AS value_12, ISNULL(Expr2.value_09, 0) AS value_13, ISNULL(Expr2.value_13, 0)
AS value_14, ISNULL(Expr2.value_17, 0) AS value_15, ISNULL(Expr2.value_21, 0) AS value_16, ISNULL(Expr2.value_22, 0) AS value_17, ISNULL(Expr2.value_23, 0) AS value_18, ISNULL(Expr2.value_24, 0)
AS value_19, ISNULL(Expr2.value_25, 0) AS value_20
FROM dbo.ItemResource LEFT OUTER JOIN
dbo.item_file_name ON dbo.ItemResource.id = dbo.item_file_name.id LEFT OUTER JOIN
dbo.EnhanceEffectResource AS Expr1 ON Expr1.sid = dbo.ItemResource.enhance_id AND Expr1.sub_id = 1 LEFT OUTER JOIN
dbo.EnhanceEffectResource AS Expr2 ON Expr2.sid = dbo.ItemResource.enhance_id AND Expr2.sub_id = 2

GO

Ok thank you, would you be able to have ref 9.5?

[thefear511]

Originally Posted by [DWL]ZONE

ItemResource 9.4 view finished

RDB Tool


I used 9.5 data for item file name

you need to use epic 9.5 ref to make the items appear properly

you need to edit the ref file to add a new item

ItemResource View

 Spoiler

USE [Arcadia94]
GO
/****** Object: View [dbo].[ItemResource_94_view] Script Date: 25.10.2017 21:02:12 ZONE ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ItemResource_94_view]
AS
SELECT dbo.ItemResource.id, dbo.ItemResource.name_id, dbo.ItemResource.tooltip_id, dbo.ItemResource.type, dbo.ItemResource.[group], dbo.ItemResource.class, dbo.ItemResource.wear_type,
dbo.ItemResource.set_id, dbo.ItemResource.set_part_flag, dbo.ItemResource.rank, dbo.ItemResource.[level], dbo.ItemResource.enhance, dbo.ItemResource.socket, dbo.ItemResource.status_flag,
dbo.ItemResource.limit_deva, dbo.ItemResource.limit_asura, dbo.ItemResource.limit_gaia, dbo.ItemResource.limit_fighter, dbo.ItemResource.job_depth, dbo.ItemResource.limit_hunter,
dbo.ItemResource.limit_magician, dbo.ItemResource.limit_summoner, dbo.ItemResource.use_min_level, dbo.ItemResource.use_max_level, dbo.ItemResource.range, dbo.ItemResource.weight,
dbo.ItemResource.price, dbo.ItemResource.huntaholic_point, dbo.ItemResource.arena_point, dbo.ItemResource.ethereal_durability, dbo.ItemResource.endurance, dbo.ItemResource.material,
dbo.ItemResource.summon_id, dbo.ItemResource.item_use_flag, dbo.ItemResource.available_period, dbo.ItemResource.decrease_type, dbo.ItemResource.throw_range, dbo.ItemResource.base_type_0,
dbo.ItemResource.base_var1_0, dbo.ItemResource.base_var2_0, dbo.ItemResource.base_type_1, dbo.ItemResource.base_var1_1, dbo.ItemResource.base_var2_1, dbo.ItemResource.base_type_2,
dbo.ItemResource.base_var1_2, dbo.ItemResource.base_var2_2, dbo.ItemResource.base_type_3, dbo.ItemResource.base_var1_3, dbo.ItemResource.base_var2_3, dbo.ItemResource.opt_type_0,
dbo.ItemResource.opt_var1_0, dbo.ItemResource.opt_var2_0, dbo.ItemResource.opt_type_1, dbo.ItemResource.opt_var1_1, dbo.ItemResource.opt_var2_1, dbo.ItemResource.opt_type_2,
dbo.ItemResource.opt_var1_2, dbo.ItemResource.opt_var2_2, dbo.ItemResource.opt_type_3, dbo.ItemResource.opt_var1_3, dbo.ItemResource.opt_var2_3, dbo.ItemResource.effect_id,
dbo.ItemResource.enhance_id, dbo.ItemResource.skill_id, dbo.ItemResource.state_id, dbo.ItemResource.state_level, dbo.ItemResource.state_time, dbo.ItemResource.cool_time,
dbo.ItemResource.cool_time_group, dbo.ItemResource.model_type_dem, dbo.ItemResource.model_type_def, dbo.ItemResource.model_type_asm, dbo.ItemResource.model_type_asf,
dbo.ItemResource.model_type_gam, dbo.ItemResource.model_type_gaf, '0' AS ukn1, dbo.ItemResource.model_type_gaf AS ukn2, dbo.ItemResource.deco_model_change, '0' AS ukn3,
dbo.item_file_name.model_00, dbo.item_file_name.model_01, dbo.item_file_name.model_02, dbo.item_file_name.model_03, dbo.item_file_name.model_04, dbo.item_file_name.model_05,
dbo.item_file_name.model_06, dbo.item_file_name.model_07, dbo.item_file_name.model_08, dbo.item_file_name.model_09, dbo.item_file_name.model_10, dbo.item_file_name.model_11,
dbo.item_file_name.model_12, dbo.item_file_name.model_13, dbo.item_file_name.model_14, dbo.item_file_name.model_15, dbo.item_file_name.model_16, dbo.item_file_name.model_17,
dbo.item_file_name.texture_filename, dbo.item_file_name.drop_type, dbo.ItemResource.icon_id, dbo.item_file_name.icon_filename AS icon_file_name, dbo.ItemResource.group_bit_set, ISNULL(Expr1.effect_id,
0) AS effect_id_01, ISNULL(Expr2.effect_id, 0) AS effect_id_02, ISNULL(Expr1.value_01, 0) AS value_01, ISNULL(Expr1.value_05, 0) AS value_02, ISNULL(Expr1.value_09, 0) AS value_03, ISNULL(Expr1.value_13,
0) AS value_04, ISNULL(Expr1.value_17, 0) AS value_05, ISNULL(Expr1.value_21, 0) AS value_06, ISNULL(Expr1.value_22, 0) AS value_07, ISNULL(Expr1.value_23, 0) AS value_08, ISNULL(Expr1.value_24, 0)
AS value_09, ISNULL(Expr1.value_25, 0) AS value_10, ISNULL(Expr2.value_01, 0) AS value_11, ISNULL(Expr2.value_05, 0) AS value_12, ISNULL(Expr2.value_09, 0) AS value_13, ISNULL(Expr2.value_13, 0)
AS value_14, ISNULL(Expr2.value_17, 0) AS value_15, ISNULL(Expr2.value_21, 0) AS value_16, ISNULL(Expr2.value_22, 0) AS value_17, ISNULL(Expr2.value_23, 0) AS value_18, ISNULL(Expr2.value_24, 0)
AS value_19, ISNULL(Expr2.value_25, 0) AS value_20
FROM dbo.ItemResource LEFT OUTER JOIN
dbo.item_file_name ON dbo.ItemResource.id = dbo.item_file_name.id LEFT OUTER JOIN
dbo.EnhanceEffectResource AS Expr1 ON Expr1.sid = dbo.ItemResource.enhance_id AND Expr1.sub_id = 1 LEFT OUTER JOIN
dbo.EnhanceEffectResource AS Expr2 ON Expr2.sid = dbo.ItemResource.enhance_id AND Expr2.sub_id = 2

GO

i don't get it :$
what's 9.5 ref ? and why it says check columns names (

nvm i fixed it myself ill stick to .lua it's the same ... thx @ your log helped me alot :P here's the final .lua for the 9.4 enjoy.

"must use RappelzRDBToolQt-3.0.0"

[[DWL]ZONE]

Originally Posted by medaion

Ok thank you, would you be able to have ref 9.5?

yes

Originally Posted by thefear511

i don't get it :$
what's 9.5 ref ? and why it says check columns names (

nvm i fixed it myself ill stick to .lua it's the same ... thx @ your log helped me alot :P here's the final .lua for the 9.4 enjoy.

"must use RappelzRDBToolQt-3.0.0"

db_item.ref

it is necessary to dispose of 9.5 db_item.ref file in your client's resource file

my English is bad

[medaion]

Please can you give us item_ref 9.5
I can not find it & the one I do not work!

[thefear511]

Originally Posted by medaion

Please can you give us item_ref 9.5
I can not find it & the one I do not work!

just use the .lua i gave its easier and no need to do anything in sql

[medaion]

I tested, it loads well, but it is not functional
Look at my picture below ... sorry for my bad english I'm french

 Spoiler

[thefear511]

Originally Posted by medaion

I tested, it loads well, but it is not functional
Look at my picture below ... sorry for my bad english I'm french

 Spoiler

hmm maybe i missed some columns ill see

[medaion]

If it's not you someone will probably not find a solution for 9.4
So that we can code new items for the community.
thanks anyway

[ThunderNikk]

Dump a 9.5 client

Look for a folder named ref

It is the only file in there, not really hard to find.

Now I have taught you to fish and now I am handing you a fish...

ascii hash name

(4~-XpJip)bj!i_)AcIr

Non ascii Hash name

~bWR@(C3!nyus

Non ascii file really does not exist so I am not sure if that will work for anything or not.

[medaion]

When I extracted the client he gave me no ref file in the 9.5.
Just in the 9.4 client I had a ref folder.
Thanks for the ref 9.5 .

Edit: Ok that's why I did not find it if it does not exist in ascii XD

[thefear511]

Originally Posted by ThunderNikk

Dump a 9.5 client

Look for a folder named ref

It is the only file in there, not really hard to find.

Now I have taught you to fish and now I am handing you a fish...

ascii hash name

(4~-XpJip)bj!i_)AcIr

Non ascii Hash name

~bWR@(C3!nyus

Non ascii file really does not exist so I am not sure if that will work for anything or not.

the best fisherman ever :P thx. well, i never thought ref is a format so that's why I was confused.

Originally Posted by medaion

If it's not you someone will probably not find a solution for 9.4
So that we can code new items for the community.
thanks anyway

as long we are trying there's no dead end .... at least we can now load the files and save them but ill see why your body doesn't show even tho the rdbs they do have size and they show the data correctly, I didn't try to edit anything in item resource yet so ill try to add something and see.

[ThunderNikk]

Maybe with the 9.5 ref file in the resource folder the file might work and show the body elements.

[medaion]

I just tested with the ref in the resource folder it does not work either ... I'll try to see tomorrow & make another test ...