[Release] Working, Updated SQLite3 DB

Page 1 of 3 123 LastLast
Results 1 to 15 of 33
  1. #1
    I love dubstep <3 Matt is offline
    Alpha MaleRank
    Aug 2006 Join Date
    Ontario, CanadaLocation
    1,775Posts

    [Release] Working, Updated SQLite3 DB


    RaGEZONE Recommends

    RaGEZONE Recommends

    Database files were originally found in cmb's thread [Release] Updated bdo.sqlite3
    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
    Last edited by Matt; 5 Days Ago at 01:59 AM. Reason: Link's fucked up
    Seasoned PHP Developer.
    - Need something done? PM Me.


  2. #2
    Hardcore Member mor339k is online now
    MemberRank
    Feb 2011 Join Date
    105Posts

    Re: [Release] Working, Updated SQLite3 DB

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

  3. #3
    I love dubstep <3 Matt is offline
    Alpha MaleRank
    Aug 2006 Join Date
    Ontario, CanadaLocation
    1,775Posts

    Re: [Release] Working, Updated SQLite3 DB

    Yeah, just rename worldserver.jar to gameserver.jar
    Seasoned PHP Developer.
    - Need something done? PM Me.

  4. #4
    Hardcore Member mor339k is online now
    MemberRank
    Feb 2011 Join Date
    105Posts

    Re: [Release] Working, Updated SQLite3 DB

    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 :\

  5. #5
    I love dubstep <3 Matt is offline
    Alpha MaleRank
    Aug 2006 Join Date
    Ontario, CanadaLocation
    1,775Posts

    Re: [Release] Working, Updated SQLite3 DB

    It's working for everyone on the discord, and they can still access their old characters. Are you sure you installed it correctly?
    Seasoned PHP Developer.
    - Need something done? PM Me.

  6. #6
    Registered drost is offline
    MemberRank
    Sep 2013 Join Date
    18Posts

    Re: [Release] Working, Updated SQLite3 DB

    Throws upon entering the world .

  7. #7
    Account Upgraded | Title Enabled! Elssair is offline
    True MemberRank
    Dec 2013 Join Date
    284Posts

    Re: [Release] Working, Updated SQLite3 DB

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

    Greetings,
    Elssair.

  8. #8
    Account Upgraded | Title Enabled! kbnnlan is online now
    True MemberRank
    Feb 2016 Join Date
    297Posts

    Re: [Release] Working, Updated SQLite3 DB

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

  9. #9
    I love dubstep <3 Matt is offline
    Alpha MaleRank
    Aug 2006 Join Date
    Ontario, CanadaLocation
    1,775Posts

    Re: [Release] Working, Updated SQLite3 DB

    What quest... can't really help you with no information.
    Seasoned PHP Developer.
    - Need something done? PM Me.

  10. #10
    Account Upgraded | Title Enabled! kbnnlan is online now
    True MemberRank
    Feb 2016 Join Date
    297Posts

    Re: [Release] Working, Updated SQLite3 DB

    Quest name is Princess of Serendia at Western Guard Camp.

  11. #11
    Registered gorkn is online now
    MemberRank
    Dec 2016 Join Date
    11Posts

    Re: [Release] Working, Updated SQLite3 DB

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

  12. #12
    Registered altamash is offline
    MemberRank
    Dec 2017 Join Date
    14Posts

    Re: [Release] Working, Updated SQLite3 DB

    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.

  13. #13
    Master Motherlover lodude1234 is offline
    True MemberRank
    Jan 2007 Join Date
    283Posts

    Re: [Release] Working, Updated SQLite3 DB

    Works great for me, thanks so much!!

  14. #14
    Registered kindablue is offline
    MemberRank
    May 2017 Join Date
    22Posts

    Re: [Release] Working, Updated SQLite3 DB

    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?

  15. #15
    I love dubstep <3 Matt is offline
    Alpha MaleRank
    Aug 2006 Join Date
    Ontario, CanadaLocation
    1,775Posts

    Re: [Release] Working, Updated SQLite3 DB

    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.
    Seasoned PHP Developer.
    - Need something done? PM Me.




Page 1 of 3 123 LastLast

Advertisement