|
You last visited: Today at 18:23
Advertisement
[question] how to remove the durability from all items
Discussion on [question] how to remove the durability from all items within the Rappelz Private Server forum part of the Rappelz category.
10/05/2018, 14:34
|
#1
|
elite*gold: 0 
Join Date: Mar 2012
Posts: 53
Received Thanks: 1
|
[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
so if there any help would be good 
|
|
|
|
10/05/2018, 18:34
|
#2
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,779
Received Thanks: 1,461
|
Did you make new RDBs for the client?
|
|
|
|
10/05/2018, 23:23
|
#3
|
elite*gold: 0
Join Date: Nov 2012
Posts: 920
Received Thanks: 234
|
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.
|
|
|
|
|
10/06/2018, 04:47
|
#4
|
elite*gold: 0
Join Date: Mar 2012
Posts: 53
Received Thanks: 1
|
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 "
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
what next ?
|
|
|
|
|
10/06/2018, 19:05
|
#5
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,779
Received Thanks: 1,461
|
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
|
#6
|
elite*gold: 0
Join Date: Nov 2012
Posts: 920
Received Thanks: 234
|
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
|
#7
|
elite*gold: 0
Join Date: Mar 2012
Posts: 53
Received Thanks: 1
|
Fixed thank youu
|
|
|
|
|
05/02/2023, 07:35
|
#8
|
elite*gold: 0
Join Date: Apr 2009
Posts: 109
Received Thanks: 10
|
i want to remove dungeons restrictions, example roa can enter any lvl. ( why cant start mission at dd6, npc dont letme in.
|
|
|
|
Similar Threads
|
[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;
|
All times are GMT +2. The time now is 18:23.
|
|
![[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}
