[Release] Working, Updated SQLite3 DB

[Matt]

Database files were originally found in cmb's thread http://forum.ragezone.com/f1000/release-updated-bdo-sqlite3-1143266/
I had to edit the source files and change some of the tables in the database to make it compatible with our files.


KNOWN ISSUES
- Certain skills crash your game client, not the server. Has to do with CMDoAction packet and applying buffs. Searching for solution.


MY CHANGES
- The FindTargetType field is different in the new database, it was all 0's in old database, new DB is all strings, strings are found and already set in EAIFindTargetType.java.

- I had to removed 4 item types that were not set in EVehicleType.java.
-- Consumer personal trading ship
-- Scarecrow for training of black spirit
-- Senior scarecrow for training of black spirit
-- Summer Events _ Hammer
(Google translate ftw)

- I had to remove 2 servant types that were not set in EServantKind.java
--Private carriage
--Old Bartali Sailboat

- Challenge_Table is the only original table left.

Other than that, this database adds over 1300 items to the game, the kamasylvia region data is in the game, some kama items and npcs aswell. Plus a whole shitload of other things. If you "/pc openmap" when you're in game, you will be able to see it. I have not found a way to access it yet.

RENAME "worldserver.jar" to "gameserver.jar" if you have gameserver.jar

Database:

To view the content, you need to sign in or register

Updated Worldserver:

To view the content, you need to sign in or register

Database+Worldserver

To view the content, you need to sign in or register

 

[mor339k]

worldserver = gameserver? where do i need to put it? thanks

 

[Matt]

Yeah, just rename worldserver.jar to gameserver.jar

 

[mor339k]

Works great thanks a lot! do you think this should fix skill balancing issues aswell?



only one problem, after a while as you stated in the post, you can't enter your character again. makes it sadly unplayable :\

 

[Matt]

It's working for everyone on the discord, and they can still access their old characters. Are you sure you installed it correctly?

 

[drost]

Throws upon entering the world .

 

[Elssair]

Yeah ty Matt your files working on my server without error and I can use my chars of old bdo.sqlite.

Greetings,
Elssair.

 

[kbnnlan]

Quest bug meeting protoco when u take that Quest u char get stuck and cant login

 

[Matt]

What quest... can't really help you with no information.

 

[kbnnlan]

Quest name is Princess of Serendia at Western Guard Camp.

 

[gorkn]

Using SPP Repack and the original HomeGuild BDO client and this new Database + Gameserver works and I can use my old characters. Nice work!

 

[altamash]

Can you briefly list what 1300 items were added ?

Like I tried to add Tungrad belt id: 12237 and it still hangs. But other tungrad items like earrings and necklace spawn without issues.

 

[lodude1234]

Works great for me, thanks so much!!

 

[kindablue]

When I try to connect to server, it gives me an error "connection to server lost" and kicks me back out to login screen. The game server log is giving me this error:

Any ideas on how to fix this?

 

[Matt]

That image doesn't give me much information. Log files are located in worldserver/log/ (or gameserver, whatever version you have)

Is this your first time setting up the server? Looks like a config error to me.

 

[kindablue]

So I was able to connect to server after I deleted the existing accounts on the database. However now I cannot create a new character. After I click on the creation complete button in the character creation screen. Nothing happens. the game just hangs there. there's no errors showing up in the console window either. it just seems that the Creation complete button does absolutely nothing when I click on it.

Edit: I fixed the issue. It seems that for some reason after the gameserver was started, it deleted the bdo.sqlite3 file. I copied over a new version of the sq DB and then restarted everything. Now i can create a character and enter the game. Thank you for the release.

 

[mor339k]

Quest name is Princess of Serendia at Western Guard Camp.

I think there are more quests like this, that make you crash with no error and unable to enter on character selection, after selecting a quest reward and completing it, but i tried making a completely new account with no admin rights and see how it goes.

 

[wapaklez]

Using SPP Repack and the original HomeGuild BDO client and this new Database + Gameserver works and I can use my old characters. Nice work!

How? Just replace the Database and the Gameserver on the SPP Repack?

 

[kindablue]

We still cannot create t9 horse with this update right?

 

[kbnnlan]

more Quest bug .now Quest at heidel