[question] how to remove the durability from all items

10/05/2018 14:34 claro28111#1

Hello guys
i was playing in my local server tables and i wanted to remove the durability from items to make them unable to be destroyed and i changed the values in both
Arcadia, item resources in column ethereal durability to 0
and
telecaster , item in column ethereal durability to 0

but i found that my items were destroyed
and when i spawn any item that used to has durability it spawn destroyed and i can't even fix it

so if there any help would be good :)

10/05/2018 18:34 ThunderNikk#2

Did you make new RDBs for the client?

10/05/2018 23:23 thefear511#3

after you changed that, you'll have to convert the itemresource.dbo to a .rdb file, to do that you'll have to use an RDB program, glandu2 has been very kind to publish a series of updated version you can head up and download, also silentwisdom has created a new version of his rdb called Rmod.

once you got the one you want find itemresource option and load it , then export it as hashed file and put it into your client, that should update the client to be able to see the new edited items which has 0 dura.
p.s "you might face trouble loading the 9.4 itemresource refer to this [Only registered and activated users can see links. Click Here To Register...]"
sorry if my boring explaining was hard to read, but I did that because I see you're new to developing.

10/06/2018 04:47 claro28111#4

Quote:

Originally Posted by ThunderNikk

Did you make new RDBs for the client?

no :P lol
if there is a tutorial it would be helpful :)

Quote:

Originally Posted by thefear511

after you changed that, you'll have to convert the itemresource.dbo to a .rdb file, to do that you'll have to use an RDB program, glandu2 has been very kind to publish a series of updated version you can head up and download, also silentwisdom has created a new version of his rdb called Rmod.

once you got the one you want find itemresource option and load it , then export it as hashed file and put it into your client, that should update the client to be able to see the new edited items which has 0 dura.
p.s "you might face trouble loading the 9.4 itemresource refer to this [Only registered and activated users can see links. Click Here To Register...]"
sorry if my boring explaining was hard to read, but I did that because I see you're new to developing.

oh thanks

Quote:

Originally Posted by thefear511

after you changed that, you'll have to convert the itemresource.dbo to a .rdb file, to do that you'll have to use an RDB program, glandu2 has been very kind to publish a series of updated version you can head up and download, also silentwisdom has created a new version of his rdb called Rmod.

once you got the one you want find itemresource option and load it , then export it as hashed file and put it into your client, that should update the client to be able to see the new edited items which has 0 dura.
p.s "you might face trouble loading the 9.4 itemresource refer to this [Only registered and activated users can see links. Click Here To Register...]"
sorry if my boring explaining was hard to read, but I did that because I see you're new to developing.

to be honest i'm really self educated in developing and i used to make rappelz P. server to play with my friends back when i was 15 lol

Quote:

Originally Posted by thefear511

after you changed that, you'll have to convert the itemresource.dbo to a .rdb file, to do that you'll have to use an RDB program, glandu2 has been very kind to publish a series of updated version you can head up and download, also silentwisdom has created a new version of his rdb called Rmod.

once you got the one you want find itemresource option and load it , then export it as hashed file and put it into your client, that should update the client to be able to see the new edited items which has 0 dura.
p.s "you might face trouble loading the 9.4 itemresource refer to this [Only registered and activated users can see links. Click Here To Register...]"
sorry if my boring explaining was hard to read, but I did that because I see you're new to developing.

Update lol i failed :P

i get this error
"couldn't load the database file: can't run SQL quer, check that columns names exist(error code 22 )

Code:

06/10/2018 05:55:48:071 Info: Reading Arcadia.dbo.ItemResource
06/10/2018 05:55:48:078 Info: SQL: SQLDriverConnect additional info(1):
06/10/2018 05:55:48:078 Info: SQL: query: 
06/10/2018 05:55:48:078 Info: SQL: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.
06/10/2018 05:55:48:078 Info: SQL: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
06/10/2018 05:55:48:560 Error: SQL: SQLExecute error(-1):
06/10/2018 05:55:48:561 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.ItemResource;
06/10/2018 05:55:48:565 Error: SQL: 42S22:1:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue1'.
06/10/2018 05:55:48:569 Error: SQL: 42S22:2:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue2'.
06/10/2018 05:55:48:570 Error: SQL: 42S22:3:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue3'.
06/10/2018 05:55:48:570 Error: SQL: 42S22:4:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect_id_01'.
06/10/2018 05:55:48:571 Error: SQL: 42S22:5:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect_id_02'.
06/10/2018 05:55:48:572 Error: SQL: 42S22:6:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_01'.
06/10/2018 05:55:48:573 Error: SQL: 42S22:7:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_02'.
06/10/2018 05:55:48:573 Error: SQL: 42S22:8:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_03'.
06/10/2018 05:55:48:574 Error: SQL: 42S22:9:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_04'.
06/10/2018 05:55:48:575 Error: SQL: 42S22:10:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_05'.
06/10/2018 05:55:48:575 Error: SQL: 42S22:11:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_06'.
06/10/2018 05:55:48:576 Error: SQL: 42S22:12:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_07'.
06/10/2018 05:55:48:577 Error: SQL: 42S22:13:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_08'.
06/10/2018 05:55:48:577 Error: SQL: 42S22:14:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_09'.
06/10/2018 05:55:48:578 Error: SQL: 42S22:15:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_10'.
06/10/2018 05:55:48:579 Error: SQL: 42S22:16:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_11'.
06/10/2018 05:55:48:579 Error: SQL: 42S22:17:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_12'.
06/10/2018 05:55:48:580 Error: SQL: 42S22:18:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_13'.
06/10/2018 05:55:48:581 Error: SQL: 42S22:19:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_14'.
06/10/2018 05:55:48:581 Error: SQL: 42S22:20:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_15'.
06/10/2018 05:55:48:582 Error: SQL: 42S22:21:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_16'.
06/10/2018 05:55:48:583 Error: SQL: 42S22:22:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_17'.
06/10/2018 05:55:48:584 Error: SQL: 42S22:23:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_18'.
06/10/2018 05:55:48:584 Error: SQL: 42S22:24:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_19'.
06/10/2018 05:55:48:585 Error: SQL: 42S22:25:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_20'.
06/10/2018 05:55:48:585 Error: SQL: 42000:26:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

update i fixed it now i have both files
db_item.rdb
db_item.ref

what next ?

10/06/2018 19:05 ThunderNikk#5

They need to be hashed for your launche arguments and placed in your resource folder of the client.

Depending on whether you launch ascii or code page in your .bat file if in doubt make copies hash the file names both ways and place all four in the resource folder.

Examples...

db_item.rdb becomes U{W.Y(_ZdT!JV

db_item.ref becomes (4~-XpJip)bj!i_)AcIr

db_item(ascii).rdb becomes O4bGlpCmt`KodmF`A {C

db_item(ascii).ref becomes (4~-XpJip)bj!i_)AcIr

10/06/2018 21:29 thefear511#6

Quote:

Originally Posted by claro28111

no :P lol
if there is a tutorial it would be helpful :)

oh thanks

to be honest i'm really self educated in developing and i used to make rappelz P. server to play with my friends back when i was 15 lol

Update lol i failed :P

i get this error
"couldn't load the database file: can't run SQL quer, check that columns names exist(error code 22 )

Code:

06/10/2018 05:55:48:071 Info: Reading Arcadia.dbo.ItemResource
06/10/2018 05:55:48:078 Info: SQL: SQLDriverConnect additional info(1):
06/10/2018 05:55:48:078 Info: SQL: query: 
06/10/2018 05:55:48:078 Info: SQL: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.
06/10/2018 05:55:48:078 Info: SQL: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
06/10/2018 05:55:48:560 Error: SQL: SQLExecute error(-1):
06/10/2018 05:55:48:561 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.ItemResource;
06/10/2018 05:55:48:565 Error: SQL: 42S22:1:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue1'.
06/10/2018 05:55:48:569 Error: SQL: 42S22:2:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue2'.
06/10/2018 05:55:48:570 Error: SQL: 42S22:3:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'unknownValue3'.
06/10/2018 05:55:48:570 Error: SQL: 42S22:4:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect_id_01'.
06/10/2018 05:55:48:571 Error: SQL: 42S22:5:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect_id_02'.
06/10/2018 05:55:48:572 Error: SQL: 42S22:6:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_01'.
06/10/2018 05:55:48:573 Error: SQL: 42S22:7:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_02'.
06/10/2018 05:55:48:573 Error: SQL: 42S22:8:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_03'.
06/10/2018 05:55:48:574 Error: SQL: 42S22:9:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_04'.
06/10/2018 05:55:48:575 Error: SQL: 42S22:10:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_05'.
06/10/2018 05:55:48:575 Error: SQL: 42S22:11:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_06'.
06/10/2018 05:55:48:576 Error: SQL: 42S22:12:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_07'.
06/10/2018 05:55:48:577 Error: SQL: 42S22:13:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_08'.
06/10/2018 05:55:48:577 Error: SQL: 42S22:14:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_09'.
06/10/2018 05:55:48:578 Error: SQL: 42S22:15:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_10'.
06/10/2018 05:55:48:579 Error: SQL: 42S22:16:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_11'.
06/10/2018 05:55:48:579 Error: SQL: 42S22:17:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_12'.
06/10/2018 05:55:48:580 Error: SQL: 42S22:18:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_13'.
06/10/2018 05:55:48:581 Error: SQL: 42S22:19:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_14'.
06/10/2018 05:55:48:581 Error: SQL: 42S22:20:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_15'.
06/10/2018 05:55:48:582 Error: SQL: 42S22:21:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_16'.
06/10/2018 05:55:48:583 Error: SQL: 42S22:22:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_17'.
06/10/2018 05:55:48:584 Error: SQL: 42S22:23:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_18'.
06/10/2018 05:55:48:584 Error: SQL: 42S22:24:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_19'.
06/10/2018 05:55:48:585 Error: SQL: 42S22:25:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value_20'.
06/10/2018 05:55:48:585 Error: SQL: 42000:26:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

update i fixed it now i have both files
db_item.rdb
db_item.ref

what next ?

hash them using the same rdb file or manually edit the name to the hashed names, put them into your client folder "resource" and run your game.

10/07/2018 08:13 claro28111#7

Fixed thank youu :)

05/02/2023 07:35 tanos77#8

i want to remove dungeons restrictions, example roa can enter any lvl. ( why cant start mission at dd6, npc dont letme in.