Modifying AP values of Weapons and Accessory

If you want to modify any weapon/accessory to have insane amount of damage. Just look through the 1_longsword - 5_Dagger Browser Data (using sqlite browser) and to look for a specific item just click on index and search the id value of the item (I used bdo database *google it*).

You will want to search for the Row with DDD, RDD, or MDD since i don't know what they stand for... however, I do know what they do.

DDD= phy melee damage

RDD = phy/range damage [most likely range bow uses this]

MDD = magic/range damage

Here is an example:
[Base Value| Enchanment +0]
Kzarka weapon has: (Using Kzarka Langbow for example)
[AP: 18~22]
and the database show it as 1D5+17 this means its 1+17 D 5+17 which is AP: 18~22 (your everyday how to math 101) so what you just want to change is the +[insertvalue] like this 1D5+9999

You can also change the values for other stats as well, but be sure to make a backup of your sqlite file just in case something goes wrong.

Dhit = Melee accuracy
RHit = range Accuracy
Mhit = Magic accuracy

DDV = Phy Evasion
RDV = Range Evasion
MDV = Magic Evasion

HDDV = Phy Damage Evasion (+add)
HRDV = Range Damage Evasion (+add)
HMDV = Magic Damage Evasion (+add)

DPV = Phy Damage Reduction
RPV = Range Damage Reduction
MPV = Magic Damage Reduction

HDPV = Phy Damage Reduction (+add)
HRPV = Range Damage Reduction (+add)
HMPV = Magic Damage Reduction (+add)

Extra:

There are other stats call VariedMaxHP these are the base stats for HP/MP/RecoverHP/RecoverMP/Critical Level [ values 1-5]/ Attack Speed [ values 1-5]/Cast Speed [ values 1-5]/ Movement Speed [ values 1-5]/ Collection Speed (Gathering) [ values 1-5]/ Droprate speed (Luck) [ values 1-5]/ Swiming speed [ values 1-5] and Fishing Speed [ values 1-5]

The one that say speed at the end are max/cap at level 5 going above it won't make a difference, however for HP/MP and recover it can be any values.

Note: Also you won't see the value change on the item itself because the description is written in the client, but the damage value you edit does work its basically *Hidden*

https://i.imgur.com/PbdbjIj.jpg

This doesn't seem to be working for me. You're editing the database in \Server\gameserver\bin\data\sqlite3, correct?
I can find the item and make the changes just fine, but no changes are applied to the server.
I realise I won't see any difference on the actual item, but I tried changing the values by quite a lot without the damage numbers really changing ingame.

Quote:

---

Originally Posted by Lawlo

This doesn't seem to be working for me. You're editing the database in \Server\gameserver\bin\data\sqlite3, correct?
I can find the item and make the changes just fine, but no changes are applied to the server.
I realise I won't see any difference on the actual item, but I tried changing the values by quite a lot without the damage numbers really changing ingame.

---

Yes its from there...

Going to ask some silly questions....

1. Is it your first time using Sqlite Browser?

2. After you finish editing the values did you click on the file and write the database?

3. If you edit the value of a +0 item and try to enchanted ingame your edit value DDD/RDD/MDD will reset (original value of +1~20) unless you edit all values of the DDD/RDD/MDD that is related to that item. For example, 10210 is the kzarka longbow from column 18 - 39 I'll have to edit all the RDD values for all of them if I want to enchanment them.. Then go to file and write to database after that restart the server.

4. Did you read/follow what I did on my post?

5. Did you restart the server?

It shouldn't be difficult to modify the damage value unless you edit it wrong or did not save/write into the database.

Reason is that I am assuming everyone know how to use Sqlite Browser and restart their server after modifying the values....

Not my first time using it.
I've saved the changes, the changes are there after I've restarted the program.
I'm changing the +20 version of Dandelion Crescent Blade, so there shouldn't be any issues with the enchantment.
And yes, I restarted the server.

Have you done anything to remove the AP caps? Maybe I'm having issues due to those

Quote:

---

Originally Posted by Lawlo

Not my first time using it.
I've saved the changes, the changes are there after I've restarted the program.
I'm changing the +20 version of Dandelion Crescent Blade, so there shouldn't be any issues with the enchantment.
And yes, I restarted the server.

Have you done anything to remove the AP caps? Maybe I'm having issues due to those

---

Can you provide me the exact value you use for your Dandelion Crescent Blade? I'll test it out when I back...

Also did you try it out any other weapon like your primary or rings?

I have not remove any ap cap...

Any idea how to change exp rate?

Quote:

---

Originally Posted by achillesdely

Any idea how to change exp rate?

---

Not to be rude... but there is a config in the gameserver called rate.properties
@Lawlo I manage to get the weapon to work properly, but have not try the ap cap area like sausan (have not tested yet).

Dandelion Cresent Blade
[Tested Value for PEN enchantment]
1D10+1000

Quote:

---

Originally Posted by NanayaQ

Not to be rude... but there is a config in the gameserver called rate.properties
@Lawlo I manage to get the weapon to work properly, but have not try the ap cap area like sausan (have not tested yet).

Dandelion Cresent Blade
[Tested Value for PEN enchantment]
1D10+1000

---

I'm using this: https://i.imgur.com/JtH3CoY.png
"18441" "18441" "14762" "단델리온 무신도" "20" "16004" "1" "7850" "0" "0" "100" "10" "100" "10" "10" "10" "0" "0" "0" "10" "10" "200" "0" "250" "0" "10" "5" "5" "5" "5" "5" "50" "5" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1D10+1321" "50" "60" "60" "60" "30" "30" "1D1-1" "0" "0" "0" "0" "0" "0" "1D1-1" "0" "0" "0" "0" "0" "0" "0" "0" "POTENTIAL_EFFECT_START();ALL_AP_INCRE();" "1" "3" "287,23,62,906" "1150000" "21" "0"

Quote:

---

Originally Posted by Lawlo

I'm using this: https://i.imgur.com/JtH3CoY.png
"18441" "18441" "14762" "단델리온 무신도" "20" "16004" "1" "7850" "0" "0" "100" "10" "100" "10" "10" "10" "0" "0" "0" "10" "10" "200" "0" "250" "0" "10" "5" "5" "5" "5" "5" "50" "5" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1D10+1321" "50" "60" "60" "60" "30" "30" "1D1-1" "0" "0" "0" "0" "0" "0" "1D1-1" "0" "0" "0" "0" "0" "0" "0" "0" "POTENTIAL_EFFECT_START();ALL_AP_INCRE();" "1" "3" "287,23,62,906" "1150000" "21" "0"

---

I think i know what you did wrong (maybe) since the blade is melee base try not to touch anything else beside DDD like how i explain my post. Leave everything else as default except DDD and let me know if anything changes...

Note: I am going to assume that if you try to modify other stats eva and/or damage reduction it may be confused? (I haven't touch those stats yet tbh)

Note 2: Also assuming that ADD DDD/RDD/MDD is related to both AP+DP (don't really know since I do not see the DP values.)

Quote:

---

Originally Posted by NanayaQ

I think i know what you did wrong (maybe) since the blade is melee base try not to touch anything else beside DDD like how i explain my post. Leave everything else as default except DDD and let me know if anything changes...

Note: I am going to assume that if you try to modify other stats eva and/or damage reduction it may be confused? (I haven't touch those stats yet tbh)

Note 2: Also assuming that ADD DDD/RDD/MDD is related to both AP+DP (don't really know since I do not see the DP values.)

---

Hmm, I changed it to only being 1D10+2321, but I still see no changes in dmg numbers ingame.
Maybe it's not reading my DB properly

Quote:

---

Originally Posted by Lawlo

Hmm, I changed it to only being 1D10+2321, but I still see no changes in dmg numbers ingame.
Maybe it's not reading my DB properly

---

copy/ replace this file into your folder and give yourself a manos Ruby Ring PEN or enchant one.
let me know if your damage change.

This is a modify Manos Ruby Ring that work on my server.

Quote:

---

Originally Posted by NanayaQ

copy/ replace this file into your folder and give yourself a manos Ruby Ring PEN or enchant one.
let me know if your damage change.

This is a modify Manos Ruby Ring that work on my server.

---

No changes.
When I checked the SQLite file though, the manos ruby ring wasn't modified. What table did you edit the item in?

I highly doubt it I triple check the modification...

https://i.imgur.com/xUy13V5.jpg

is your sqlite on read-only file?

Since idk what is your directory set is like I cannot tell, but one thing is for sure that is no way the file i sent you a clean file with no modification.

Try this again bdo

Quote:

---

Originally Posted by NanayaQ

I highly doubt it I triple check the modification...

https://i.imgur.com/xUy13V5.jpg

is your sqlite on read-only file?

Since idk what is your directory set is like I cannot tell, but one thing is for sure that is no way the file i sent you a clean file with no modification.

Try this again bdo

---

That one worked!
I'll play around with it then, I probably made an illegal edit to a field or something.
Thanks :)

Quote:

---

Originally Posted by Lawlo

That one worked!
I'll play around with it then, I probably made an illegal edit to a field or something.
Thanks :)

---

no problem and good luck!