[Release] Rappelz RDB Tool with tabs

[ilyaslord36]

any software here can he export sql to rdb successfuly without any error im using (glandu - germoire - ... )
the probleme it the same

[Dark Blaze]

Originally Posted by ilyaslord36

any software here can he export sql to rdb successfuly without any error im using (glandu - germoire - ... )
the probleme it the same

That sounds like a user error not a software error.
What's the error message you get?

[ilyaslord36]

my i dont know how to add a new item in my server 9.6 i need a tutorial because im not understand

[c1ph3r]

Originally Posted by ilyaslord36

my i dont know how to add a new item in my server 9.6 i need a tutorial because im not understand

What's your Problem? Please post a screenshot of the errormessage.

What item do you want to add? (weapon, armor, food, soulstone...?) Normally it's enough to copy an existing item and edit the Ids and all other needed values.

[ilyaslord36]

Originally Posted by c1ph3r

What's your Problem? Please post a screenshot of the errormessage.

What item do you want to add? (weapon, armor, food, soulstone...?) Normally it's enough to copy an existing item and edit the Ids and all other needed values.

i try insert item wing in the table dbo.[ItemResource] and dbo.[StringResource]
i dont know why dont insert in the ( View ) item and itemRefernceResource

thats the rdb canot read ( View ) item and itemRefernceResource table

[Dark Blaze]

Originally Posted by ilyaslord36

i try insert item wing in the table dbo.[ItemResource] and dbo.[StringResource]
i dont know why dont insert in the ( View ) item and itemRefernceResource

thats the rdb canot read ( View ) item and itemRefernceResource table

[ilyaslord36]

item_Ref is succes
now the problem it just in the read dbo.Item from sql databses





13/04/2020 19:02:10:996 Error: Unable to load Database description DLL C:/Users/ILYAS/Desktop/Tools/RDB TOOL/Item94Database.dll, last error: 0x0000007e
13/04/2020 19:02:11:002 Error: Unable to load Database description DLL C:/Users/ILYAS/Desktop/Tools/RDB TOOL/ItemReferenceDatabase.dll, last error: 0x0000007e
13/04/2020 19:02:25:601 Error: SQL: SQLExecute error(-1):
13/04/2020 19:02:25:602 Error: SQL: query: SELECT "id", "name_id", "tooltip_id", "type", "group", "class", "wear_type", "set_id", "set_part_flag", "rank", "level", "enhance", "socket", "status_flag", "limit_deva", "limit_asura", "limit_gaia", "job_depth", "limit_fighter", "limit_hunter", "limit_magician", "limit_summoner", "use_min_level", "use_max_level", "range", "weight", "price", "huntaholic_point", "arena_point", "ethereal_durability", "endurance", "material", "summon_id", "item_use_flag", "available_period", "decrease_type", "throw_range", "base_type_0", "base_var1_0", "base_var2_0", "base_type_1", "base_var1_1", "base_var2_1", "base_type_2", "base_var1_2", "base_var2_2", "base_type_3", "base_var1_3", "base_var2_3", "opt_type_0", "opt_var1_0", "opt_var2_0", "opt_type_1", "opt_var1_1", "opt_var2_1", "opt_type_2", "opt_var1_2", "opt_var2_2", "opt_type_3", "opt_var1_3", "opt_var2_3", "effect_id", "enhance_id", "skill_id", "state_id", "state_level", "state_time", "cool_time", "cool_time_group", "model_type_dem", "model_type_def", "model_type_asm", "model_type_asf", "model_type_gam", "model_type_gaf", "deco_model_change", "model_00", "model_01", "model_02", "model_03", "model_04", "model_05", "model_06", "model_07", "model_08", "model_09", "model_10", "model_11", "model_12", "model_13", "model_14", "model_15", "model_16", "model_17", "texture_filename", "drop_type", "icon_id", "icon_file_name", "group_bit_set", "unknownValue1", "unknownValue2", "unknownValue3", "effect_id_01", "effect_id_02", "value_01", "value_02", "value_03", "value_04", "value_05", "value_06", "value_07", "value_08", "value_09", "value_10", "value_11", "value_12", "value_13", "value_14", "value_15", "value_16", "value_17", "value_18", "value_19", "value_20" FROM Arcadia.dbo.Item;
13/04/2020 19:02:25:604 Error: SQL: 42S22:1:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue1'.
13/04/2020 19:02:25:607 Error: SQL: 42S22:2:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue2'.
13/04/2020 19:02:25:607 Error: SQL: 42S22:3:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue3'.
13/04/2020 19:02:25:607 Error: SQL: 42S22:4:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect_id_01'.
13/04/2020 19:02:25:608 Error: SQL: 42S22:5:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect_id_02'.
13/04/2020 19:02:25:609 Error: SQL: 42S22:6:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_01'.
13/04/2020 19:02:25:609 Error: SQL: 42S22:7:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_02'.
13/04/2020 19:02:25:610 Error: SQL: 42S22:8:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_03'.
13/04/2020 19:02:25:611 Error: SQL: 42S22:9:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_04'.
13/04/2020 19:02:25:611 Error: SQL: 42S22:10:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_05'.
13/04/2020 19:02:25:611 Error: SQL: 42S22:11:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_06'.
13/04/2020 19:02:25:612 Error: SQL: 42S22:12:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_07'.
13/04/2020 19:02:25:612 Error: SQL: 42S22:13:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_08'.
13/04/2020 19:02:25:613 Error: SQL: 42S22:14:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_09'.
13/04/2020 19:02:25:613 Error: SQL: 42S22:15:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_10'.
13/04/2020 19:02:25:613 Error: SQL: 42S22:16:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_11'.
13/04/2020 19:02:25:614 Error: SQL: 42S22:17:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_12'.
13/04/2020 19:02:25:614 Error: SQL: 42S22:18:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_13'.
13/04/2020 19:02:25:615 Error: SQL: 42S22:19:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_14'.
13/04/2020 19:02:25:615 Error: SQL: 42S22:20:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_15'.
13/04/2020 19:02:25:615 Error: SQL: 42S22:21:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_16'.
13/04/2020 19:02:25:616 Error: SQL: 42S22:22:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_17'.
13/04/2020 19:02:25:616 Error: SQL: 42S22:23:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_18'.
13/04/2020 19:02:25:617 Error: SQL: 42S22:24:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_19'.
13/04/2020 19:02:25:617 Error: SQL: 42S22:25:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_20'.
13/04/2020 19:02:25:618 Error: SQL: 42000:26:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
13/04/2020 19:02:54:897 Error: RowManipulator: Column named "nv10" not found
13/04/2020 19:02:54:898 Error: RowManipulator: Column named "nv11" not found
13/04/2020 19:02:54:898 Error: RowManipulator: Column named "nv12" not found
13/04/2020 19:02:54:899 Error: RowManipulator: Column named "nv13" not found
13/04/2020 19:02:54:899 Error: RowManipulator: Column named "nv14" not found

[ilyaslord36]

the item give in client "The instrument is not specified" with
Mark in red

[c1ph3r]

What Files do you use? Looks like your Database ItemResource Structure does not match to the ItemResource Structure in the DLL.

[ilyaslord36]

Originally Posted by c1ph3r

What Files do you use? Looks like your Database ItemResource Structure does not match to the ItemResource Structure in the DLL.

Im use files 9.6
Yes i think that is probleme just in structures
How i cant find structures with work DLL for files 9.6

[Dark Blaze]

Originally Posted by ilyaslord36

Im use files 9.6
Yes i think that is probleme just in structures
How i cant find structures with work DLL for files 9.6

For 9.6 you have to write the structure yourself, you can edit the one for 9.1 and adjust it for 9.6 based on your table.

[ilyaslord36]

Originally Posted by Dark Blaze

For 9.6 you have to write the structure yourself, you can edit the one for 9.1 and adjust it for 9.6 based on your table.

but me i dont understand and i never work in programing for create a new structures can you create me one plz ?

[medaion]

Good evening,
Did anyone succeed in exporting new items for 9.6?
I have several new items to import in my client but each time it's impossible for me to locate the item because they have still modified the export table in epic 9.6.

[ilyaslord36]

Originally Posted by medaion

Good evening,
Did anyone succeed in exporting new items for 9.6?
I have several new items to import in my client but each time it's impossible for me to locate the item because they have still modified the export table in epic 9.6.

also use 9.6 i try to export with ItemResource9.5 in glandu rdb tool but any item show in client

[medaion]

Good evening,
Somebody please have the itemresource9.6.lua & view to extract with the gladu tool the new items created because I would like to be able to import in my 9.6 client my new items.

Because I know that some servers have managed to extract new items.