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!

I stacked a bunch of buffs on a crystal and got similar results with the exception of the major damage buff. Still experimenting, but it's going to be interesting...

Hi!

Wanted to edit the database, but mine looks quite weird (it's in German, but that is not the weird part):
Attachment 162194
It always says "TEXT" instead of specific numbers.

I downloaded the DB Browser for SQLite (DB Browser for SQLite) (only this program) and opened the database file at gameserver\bin\data\sqlite3 just with the DB Browser.

What am I doing wrong?

https://postimg.org/image/i6nikob2j/

Quote:

---

Originally Posted by TwuTu

Hi!

Wanted to edit the database, but mine looks quite weird (it's in German, but that is not the weird part):
Attachment 162194
It always says "TEXT" instead of specific numbers.

I downloaded the DB Browser for SQLite (DB Browser for SQLite) (only this program) and opened the database file at gameserver\bin\data\sqlite3 just with the DB Browser.

What am I doing wrong?

https://postimg.org/image/i6nikob2j/

---

That is because you are in Database Structure go to the next tab/row that say Browse Data I mention this on my post fyi....

Could you tell me where is "VariedMaxHP" and how to change it ? thank you very much ! @NanayaQ

Nice for the weapon edits, but I cannot find any of the accessories...
What table are they under?

Also, with only 1 - 5, what about staves and other weapons and armors / accessories not listed in 1-5?

Quote:

---

Originally Posted by Kukafuchi

Nice for the weapon edits, but I cannot find any of the accessories...
What table are they under?

Also, with only 1 - 5, what about staves and other weapons and armors / accessories not listed in 1-5?

---

Nevermind I found Stave's under longswords and I found armour under blunts. Still haven't found rings and necklaces though.

Had to use a little Google translate to verify Korean item names after finding the item ID (Google)

- - - Updated - - -

Tried to create my own GM item by duplicating an entry then modding item ID and stats. Caused a crash on world entry. Had to delete the item. Still don't know why it didn't work, I can mod the original entry and the mods work fine.

I tried to change items upgrade item needed (accessories instead of needing another one, i changed it to stones) But while in game it wont allow me to put stones in while my accessory is on the enchant window

EDIT: I tried to enchant the normal way but the button doesnt work. It works with lower tiers since i only changed PEN

EDIT2: Tried to change the field EnchantType to the same as weapons but no luck.

Are the other files missing from the sql? I couldn't find armors like Talis or Musken Boots.
I was trying to find a way to increase sockets to 3 in shoes so I could equip another jump height magic stone, or find the magic stones so I could allow jump height to be socketed to chest helm and gloves.

Quote:

---

Originally Posted by NanayaQ

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

---

the seen in the sqlite that for example a weapon has values DDV, RDV, MDV but when verifying the values in bdatabase.com do not leave values as specific as in the sqlite, only evasion that would be that three that I mention, then as I check those values or I repeat the value of evasion in each field DDV, RDV, MDV?

Hello, tell me how to enable the display of damage on the screen ?

Quote:

---

Originally Posted by MastaDan

Hello, tell me how to enable the display of damage on the screen ?

---

In the service.ini file, edit the DamageMeter and put 1 instead of 0.

I downloaded the sqlite program and opened the bdo.sqlite3 file but i can't find the kzarka longbow... the id should be 10210 but i can't find it anywere? silly question now: has the database changed during time? where can i find the kzarka longbow values? see you dudes!

- - - Updated - - -

OMFG!!! i'm totally retarded... found the value. the value is on the "longsword" "channel" thoug... am i right this time? see you dudes!

- - - Updated - - -

strange... i've set the values in the bdo.squlite3 file but values don't change in game. Where i wrong?

- - - Updated - - -

i'm defenetedly retarded! i've set small to see changes in game... all works fine now. some strange behavior persist thoug in game: i've set a huge-insane amount of accuracy for my kzarka longbow but my ranger miss the target a lot of times... well, to say it correct, the shoots hit the enemy npcs but ther's no damage sometimes... other times the hit immediatedly kill the enemy at the first shoot. any idea? or its just the game lag in calculating the hits? using melee weapons that doesn't appare. where do i wrong this time?

Not sure about your issue, but some sqlite3 changes have to be reproduced in the .bexcel file (client side) to be correctly applied... if I'm wrong, correct me !

i've tested all stuff and i found that everything works fine now. it's lag my m8, not a iusse with the messing in the database values but simple lag. How can i tone down this huge lag?

hi , i saw this values on skill tables too so can i change the skill damages with these modifiyings ?