[Release]9.4 Official Files

Quote:

Originally Posted by [DWL]ZONE ItemResource 9.4 view finished RDB Tool [Only registered and activated users can see links. Click Here To Register...] 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

Quote:

Originally Posted by [DWL]ZONE ItemResource 9.4 view finished RDB Tool [Only registered and activated users can see links. Click Here To Register...] 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

Quote:

Originally Posted by medaion Ok thank you, would you be able to have ref 9.5?

Quote:

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 @[Only registered and activated users can see links. Click Here To Register...] your log helped me alot :P here's the final .lua for the 9.4 enjoy. "must use RappelzRDBToolQt-3.0.0"

Quote:

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

Quote:

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 [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]

Quote:

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.

Quote:

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