Altering Item Effects via SQL tables

[Ranma014]

hmm I wasnt sure if i should post it here or over at

It might help some people, if they wanna mod items, like me. The goal is to reduce cool downs, prolong effects, or just add new ones, like gettin gbuffs by consuming a red potion. this is what you do if you wanna alter an already present effect:

Method 1
You search for the item name inside [Arcadia].[dbo].[StringResource] (its the "value" field)
When you find it, you search for the name_id in [Arcadia].[dbo].[ItemResource] (its the "code" field from [StringResource])
There you gotta look for the field "opt_var1_0".
This will give you the the id for which you gotta look inside [Arcadia].[dbo].[SkillResource]. There you can alter the effect, like adjust the cooldown (field: "delay_cast") or the effect length (field: "state_second")

side note: what I did find out was, that "opt_type_0" of the item is "5", which might indicate, that its a usable item giving a skill effect, but I am not sure about that.

Method 2
alternately you can try to search for the effect name in [Arcadia].[dbo].[StringResource].
You might see in the "name" field something like "name_skill_xxxxxx"
The last numbers are the "id" for which you gotta look inside [Arcadia].[dbo].[SkillResource]
Then proceed as written above.

Example
I wanted to prolong the effect of the luna chips, cause I was getting tired hitting the button every 10 seconds. First you will use this sql command to search for the name:

SELECT    name, group_id, code, value
FROM         [Arcadia].[dbo].[StringResource]
WHERE     (value LIKE '%Luna Chip%')

You will find something like that:

The green arrow indicated the skill mentioned in method 2. The needed skill id is 6010.
The orange arrow indicates the state "Luna Chip" which is applied to the mob when using a chip. Its just marked for reference.
The red arrow marks the items name you will look for in method 1. Here I used "Rank 4 Luna Chip". You now copy the code of that item and use to find the item inside [Arcadia].[dbo].[ItemResource] by using

SELECT     *
FROM         [Arcadia].[dbo].[ItemResource]
WHERE     (name_id = 10690204)

There you will find one entry. Look for opt_var1_0, like shown in the picture.

The is the needed skill id, which we couldve gotten by using method 2. Its shown in the first picture.
Now for the last part, which is identical in both methods. Use this id and look inside [Arcadia].[dbo].[SkillResource] by using:

SELECT     *
FROM         [Arcadia].[dbo].[SkillResource]
WHERE     (id = 6010)

There you can find all the info about that specific skill. We wanted to prolong the effect, so we look for "state_second". The length is stored in seconds (who wouldve guessed), just raise it and were good to go.

Start the server and have fun. I entered 600 seonds:

[wisp66]

you posted fine ill post this in my thread for you as well with full credit of course Good Work^^ and now it wont get lost in the spam wave

[frisky22]

would be handy to edit r7 chips so they constantly work on 190 boss.. would be easier then creating r8 chips

[Ranma014]

Seach for id = 690207 in [Arcadia].[dbo].[ItemResource]
Thats the rank 7 luna chip. There look for the field opt_var2_0. change it from 7 to 8. I guess thats the limit of those chips, since r6 got a "6" there, r5 a "5" and so on. Alternately you can try to edit the field "rank", but i dont think thats the effect, just the level limit one can use the item. I didnt test that, but you could just try it. if it fails, just revert the numbers to their originals. let me now if it works, so in that case i can add another field to my index

EDIT: Yep the first value is working. Alter opt_var2_0" from "7" to "8", thats the rank limitation. i just used a r1 luna chip as a r7 chip on a lv 147 mob, so with that you can use r7 luna chips as r8 chips.

general info: the db is poorly structured and extremely poorly named. without a proper name table its almost impossible toknow what all those fields do. the routine that reads them and applies the correct effect is probably in one of those server script files (not the lua ones). it may even be possible, that the server doesnt know what to do with value "8" and raising the max level r7 applies to is not possible by editing the databse, at least i didnt find that information yet in there.

[ironhammer500]

great work ranma hopefully someone gets the 3d model files for items now and we can truly start modding rappelz and making it better then before =)

[hassuny]

up up