Rappelz Private Server / Sustainability ecc.

11/27/2013 01:11 ciccioxd#1
Hello, I apologize for this topic:
Some time ago I wrote a problem in the'' Help'' Thread Rappelz Private Server. I have not had any response, then try again here, maybe read before ..

----------------------------------|
I would have another problem,
When attacking a dummy, or someone in the PK
The equip is my opponent breaks, removing much Equip sustainability
Even when I kill a mob, you drop so many gold bars ..
How do I remove them?

How can I fix?

I would also like to lower the rate of objects, such as a weapon +20 ago without failure, taming the same thing!


THANKS FOR HELP! :-)
11/27/2013 01:31 ThunderNikk#2
Quote:
Originally Posted by ciccioxd View Post
When attacking a dummy, or someone in the PK
The equip is my opponent breaks, removing much Equip sustainability
It is right in the .opt file...

S game.base_ethereal_durability_consumption:.35

Quote:
Originally Posted by ciccioxd View Post
Even when I kill a mob, you drop so many gold bars ..
How do I remove them?
No idea what you mean by this you must be using someones repack. You should ask them in their repack thread.

Quote:
Originally Posted by ciccioxd View Post
I would also like to lower the rate of objects, such as a weapon +20 ago without failure, taming the same thing!
Enchantment rates are handled in the database...

dbo.EnhanceResource

Tame rates also but there have been SQL releases to adjust tame rates like this one if you had searched the forums...

Code:
Use Arcadia
-- Sala
UPDATE MonsterResource
SET taming_percentage = 0.250
WHERE monster_group = 3023
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 3023
go
UPDATE MonsterResource
SET taming_id = 1901
WHERE monster_group = 3023
go
-- Kenta
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 5011
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 5011
go
UPDATE MonsterResource
SET taming_id = 1701
WHERE monster_group = 5011
go
-- Angel
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 5021
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 5021
go
UPDATE MonsterResource
SET taming_id = 2001
WHERE monster_group = 5021
go
-- Wolf
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103049
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103049
go
UPDATE MonsterResource
SET taming_id = 2901
WHERE monster_group = 103049
go
-- windsong
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103022
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103022
go
UPDATE MonsterResource
SET taming_id = 3301
WHERE monster_group = 103022
go
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103020
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103020
go
UPDATE MonsterResource
SET taming_id = 3301
WHERE monster_group = 103020
go
-- eimus
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 103091
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103091
go
UPDATE MonsterResource
SET taming_id = 3401
WHERE monster_group = 103091
go
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 103092
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103092
go
UPDATE MonsterResource
SET taming_id = 3401
WHERE monster_group = 103092
go
-- octopus
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103086
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103086
go
UPDATE MonsterResource
SET taming_id = 3502
WHERE monster_group = 103086
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103087
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103087
go
UPDATE MonsterResource
SET taming_id = 3502
WHERE monster_group = 103087
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103088
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103088
go
UPDATE MonsterResource
SET taming_id = 3502
WHERE monster_group = 103088
go
-- Genie
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103106
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103106
go
UPDATE MonsterResource
SET taming_id = 3701
WHERE monster_group = 103106
go
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103107
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103107
go
UPDATE MonsterResource
SET taming_id = 3701
WHERE monster_group = 103107
go
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103108
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103108
go
UPDATE MonsterResource
SET taming_id = 3701
WHERE monster_group = 103108
go
-- ifrit
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103111
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103111
go
UPDATE MonsterResource
SET taming_id = 3801
WHERE monster_group = 103111
go
-- Unicorn
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_id = 3901
WHERE monster_group = 103125
go
-- Nightmare
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_id = 4001
WHERE monster_group = 103125
go
-- Blue Pixie
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1052
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1052
go
UPDATE MonsterResource
SET taming_id = 1021
WHERE monster_group = 1052
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1053
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1053
go
UPDATE MonsterResource
SET taming_id = 1021
WHERE monster_group = 1053
go
-- Skelly
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1032
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1032
go
UPDATE MonsterResource
SET taming_id = 2401
WHERE monster_group = 1032
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1033
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1033
go
UPDATE MonsterResource
SET taming_id = 2401
WHERE monster_group = 1033
go
-- other
UPDATE MonsterResource
SET taming_id = 3901
WHERE name_id = 83006
go
UPDATE MonsterResource
SET taming_id = 3901
WHERE name_id = 84005
go
UPDATE MonsterResource
SET taming_id = 3901
WHERE name_id = 85006
go
Use Arcadia
UPDATE MonsterResource
SET taming_id = 4001
WHERE name_id = 121002
go
UPDATE MonsterResource
SET taming_id = 4001
WHERE name_id = 120003
go
UPDATE MonsterResource
SET taming_id = 4001
WHERE name_id = 122001
They may not all be in there but at least you should get enough of an idea to work out the newer creatures on your own.

Quote:
Originally Posted by ciccioxd View Post
Hello, I apologize for this topic:
Some time ago I wrote a problem in the'' Help'' Thread Rappelz Private Server. I have not had any response, then try again here, maybe read before
Next time please use the help thread.

If someone wants to reply to you they will, if they do not want to reply then you may have to figure out some things on your own.

Feel free to post again if no one answers you, but post again in the help thread.
11/27/2013 02:07 ciccioxd#3
Ok fix..

With regard to bullion, I meant that ..
When I kill a mob out 1,2,3 GOLD bullion
How do I remove it?

I do not know how to change things in Dbo ..

Could you explain how to do?
11/27/2013 03:13 ThunderNikk#4
Quote:
Originally Posted by ciccioxd View Post
With regard to bullion, I meant that ..
When I kill a mob out 1,2,3 GOLD bullion
How do I remove it?
You must be using someones repack for server files.

When I kill a mob it does not drop gold bars.

Whoever made the repack must have made those drop by adding them to the drop tables.

Ask whoever you got the server files from how to remove it from the drop tables. Or just write a little SQL for the item ID like this...

Code:
select * from arcadia.dbo.dropgroupresource where drop_item_id_00 = 602701  or drop_item_id_01 = 602701 or drop_item_id_02 = 602701  or drop_item_id_03 = 602701 or drop_item_id_04 = 602701 or drop_item_id_05 = 602701 or drop_item_id_06 = 602701 or drop_item_id_07 = 602701 or drop_item_id_08 = 602701 or drop_item_id_09 = 602701
Or monster drop group resource

Code:
select * from arcadia.dbo.MonsterDropTableResource where drop_item_id_00 = 602701  or drop_item_id_01 = 602701 or drop_item_id_02 = 602701  or drop_item_id_03 = 602701 or drop_item_id_04 = 602701 or drop_item_id_05 = 602701 or drop_item_id_06 = 602701 or drop_item_id_07 = 602701 or drop_item_id_08 = 602701 or drop_item_id_09 = 602701
Find out where it is and fix it.

Code:
Update arcadia.dbo.dropgroupresource set drop_percentage_00 = 0 where drop_item_id_00 = 602701
 Update arcadia.dbo.dropgroupresource set drop_percentage_01 = 0 where drop_item_id_01 = 602701
  Update arcadia.dbo.dropgroupresource set drop_percentage_02 = 0 where drop_item_id_02 = 602701
Repeat for all drop groups up to _09

Or if it is in monster drop table resource

Code:
Update arcadia.dbo.MonsterDropTableResource set drop_percentage_00 = 0 where drop_item_id_00 = 602701
 Update arcadia.dbo.MonsterDropTableResource set drop_percentage_01 = 0 where drop_item_id_01 = 602701
  Update arcadia.dbo.MonsterDropTableResource set drop_percentage_02 = 0 where drop_item_id_02 = 602701
And again repeat for all drop groups up to _09

If you are going to work with SQL you are going to have to learn some SQL
11/27/2013 12:32 xTheMuslimx#5
you're using royal reapack
so... you would find in the arcadia DB an extra table called MonsterResource_copy (Or something like that) , delete the MonsterResource table (The Original One) and change the name of "MonsterResource_copy" into "MonsterResource" .
that's all :)