[Release] Working, Updated SQLite3 DB

[Matt]

Database files were originally found in cmb's thread http://forum.ragezone.com/f1000/rele...lite3-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:
https://goo.gl/QPFZUp

Updated Worldserver:
https://goo.gl/J5o8PV

Database+Worldserver
https://goo.gl/wgcpBY

[MentaL]

[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?

- - - Updated - - -

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.