Modifying AP values of Weapons and Accessory

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 ?