[question] how to remove the durability from all items
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
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 "
sorry if my boring explaining was hard to read, but I did that because I see you're new to developing.
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 "
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 "
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 "
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
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.
[Request Help] Remove mobs / remove eur items / remove npc 02/15/2013 - SRO Private Server - 0 Replies Iam sure all now saies this guy is mad :D why not remove the db
i want to know how i can remove mobs from samrkand and add alex mobs there and remove eur item from npc and drobs
and remove some npcs
ty guys
_________________________
I see that there is too much help here
it's my topic no.2
without any answer
[Release] Durability remove (5165 LOTF) 07/23/2010 - CO2 PServer Guides & Releases - 13 Replies Hi hi!
maybe isn't a good code... but it works... i tested : D
if you wan't to change the chance to reduce ... be free for say if is there something wrong..... : D
make a new class at Extra folder and name it Durability.cs... the copy and paste :
using System;
using System.Collections.Generic;
![[question] how to remove the durability from all items](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/question-how-remove-durability-all-items_ltr.gif){kind=small}
[question] how to remove the durability from all items
"
