[RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

Page 1 of 5 12345 LastLast
Results 1 to 15 of 69
  1. #1
    Newbie LordDan is offline
    MemberRank
    May 2020 Join Date
    4Posts

    idea [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator
    Hello. (Dear HEROES!)


    here is a full database with all content from up until the only private server (Dragon Legend) was shut down due to a DMCA last week. Includes: mobs, items, drops, etc... all you need.


    Not every item on Hero Plus USA or Korea will be included, but you can use this DB to understand their.tbl structure and add that content yourself.
    To setup the server emulator, please refer to the instructions on Syntax Gaming's github. Takes about 15min to setup a working local server, but note that you will NEED to make changes before compiling the server emulator (exp & drop rate, IP, and possible other environment variables).

    Instructions: use DB client and import the file.

    DOWNLOAD LINK https://anonfile.com/VcPbjc13o5/HeroOnline_db *users table, the password must be inserted with SHA256 encryption

    Server emulator: source code can be found HERE (https://github.com/syntaxgame/dragon-legend)

    Client: see comments as I won't provide it. You can use any HERO client but you need to change server.ini to connect to your server (most likely localhost)

    I look forward to seeing new server start up soon and hopefully more customization.

    Best Regards, Shadow
    Last edited by LordDan; 20-05-20 at 09:46 AM. Reason: added line breaks


  2. #2
    Alpha Member john007 is offline
    Alpha MaleRank
    Dec 2005 Join Date
    In MarsLocation
    2,208Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    @LordDan, great work thank you so much for your hard work put into this and it brings hero Online\plus games a good image.

    Cheers :-)

  3. #3
    Registered jjtrancoso21 is offline
    MemberRank
    Oct 2017 Join Date
    5Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    what is a key friend?

  4. #4
    JScoder exe19890522 is offline
    True MemberRank
    Dec 2011 Join Date
    chinaLocation
    441Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    the liberty of linking it again here: https://mega.nz/file/WP5U2K5Z#coTqZd...MyWo6oQyZL3Y1M
    this is broken.
    @as5000tkk @jjtrancoso21
    real is this:
    https://mega.nz/file/rdISAQQa#coTqZd...MyWo6oQyZL3Y1Mhttps://mega.nz/file/rdISAQQa#coTqZd...MyWo6oQyZL3Y1M

    but,there is anyone who can build the emu? i am not good at building code.sorry.
    Last edited by exe19890522; 20-05-20 at 03:13 AM.

  5. #5
    Newbie as5000tkk is offline
    MemberRank
    Mar 2018 Join Date
    3Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    what is a key MEGA ?

  6. #6
    Alpha Member john007 is offline
    Alpha MaleRank
    Dec 2005 Join Date
    In MarsLocation
    2,208Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    Quote Originally Posted by exe19890522 View Post
    the liberty of linking it again here: https://mega.nz/file/WP5U2K5Z#coTqZd...MyWo6oQyZL3Y1M
    this is broken.
    @as5000tkk @jjtrancoso21
    real is this:
    https://mega.nz/file/rdISAQQa#coTqZd...MyWo6oQyZL3Y1Mhttps://mega.nz/file/rdISAQQa#coTqZd...MyWo6oQyZL3Y1M

    but,there is anyone who can build the emu? i am not good at building code.sorry.
    I've successful build and have servers up since source code released but didn't got much time on working with the DBs due to working in real life. I will make a short tutorial when I have spare time.

    By the way, today I noticed dragon legend private servers has turned their patcher off meaning you can't patch the client to latest version. But I have mine client updated and will 7zip it share with those that missed the patches.

  7. #7
    Member Kigobon is offline
    MemberRank
    May 2020 Join Date
    38Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    Nice release buddy!
    For questions, contact me on discord: Kigobon#8264

  8. #8
    Newbie LordDan is offline
    MemberRank
    May 2020 Join Date
    4Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    syntax gaming stopped providing their patches for their older clients. please wait for someone to upload the latest one. or you could use the official hero US client too.. dont think item tbls were shifted but could be some differences with items etc etc.

    Best Regards,
    SHADOW

  9. #9
    Infraction bann├źd xlw00tlx is offline
    True MemberRank
    Aug 2014 Join Date
    outer space!Location
    1,243Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    any tutorial how to setup?
    Signature removed for violating forum rules

  10. #10
    Registered Vulp is offline
    MemberRank
    May 2020 Join Date
    5Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    Sure. I can help. Writing this off memory right now, so let me know if it worked/failed and send the error logs and details of what is NOT working so I can address it
    Disclaimer: This is intended for EDUCATIONAL PURPOSES only. I do not condone usage of this for any commercial means or publication whatsoever. As I am not providing any assets or database files, this post does not constitute infringement of any kind, and thus is covered by basic freedom of speech and expression laws in my country of residence. I strongly distance myself from any and all attempts to use the files and data provided to infringe upon any parties copyright and all rights are held by their lawful owners. The author of this tutorial can therefore not be held accountable or liable for any and all actions that may arise out of the use of this tutorial, and the author strongly condemns any misuse of the information presented herein for personal or commercial gain.

    All credit for the server emulator code goes to Syntax Gaming and their developers, I am just walking you through how to set things up. Please support their work by following their github ( https://github.com/syntaxgame )

    All credit for Hero Online and its assets goes to Mgame CORP and its subsidiaries.


    How To Setup a Local Hero Online Private Server
    readme from syntax:
    ### Requirements
    * Go >= 1.11
    * PostgreSQL
    * Redis [Optional]
    * K8s cluster [Optional]
    * Docker repository [Optional]

    ### Environment
    The following environment variables have to be set on the running environment.

    * POSTGRES_HOST
    * POSTGRES_PORT
    * POSTGRES_USER
    * POSTGRES_PASSWORD
    * POSTGRES_DB
    * SERVER_IP
    * DROP_RATE
    * EXP_RATE
    * REDIS_HOST [Optional]
    * REDIS_PORT [Optional]
    * REDIS_PASSWORD [Optional]
    * REDIS_SCHEME [Optional]
    (you do not need K8s cluster and Docker repo for a local setup, so in that case, please ignore them)

    1. Download & Install Visual Studio Code (=VC), PostgreSQL, and Go redist.

    2. Install the "Go" Extension for VC.

    3. Download "dragon-legend-master" server emulator from syntax's github, and open the folder in VC.
    3.1 Under config>default.go you need to change the database info, or do it via the environment variables.
    3.2. the code has following format: (assuming your db is named postgres and password is herotest, and port is 4510)...
    Code:
    
    package config
    
    import (
    "log"
    "strconv"
    )
    
    var Default = &config{
        Database: Database{
            Driver:          "postgres",
            IP:              "localhost",
            Port:            getPort(),
            User:            "postgres",
    
            Password:        "herotest",
    
            Name:            "postgres",
            ConnMaxIdle:     96,
            ConnMaxOpen:     144,
            ConnMaxLifetime: 10,
            Debug:           false,
            SSLMode:         "disable",
        },
        Server: Server{
    
            IP:   "127.0.0.1",
            Port: 4510,
    
        },
    }
    
    func getPort() int {
    
    sPort := "4510"
    
    port, err := strconv.ParseInt(sPort, 10, 32)
    if err != nil {
            log.Fatalln(err)
        }
    
    return int(port)
    }
    
    
    
    
    3.3 Under database>init.go adjust the EXP_RATE and DROP_RATE to your liking ( I used 10.0)

    4. In the terminal window of VC, type "go build" and the server file will now be compiled. You'll need to run it before launching the client.

    5. Now Install PostgreSQL. Just keep going, make sure you install the ODBC driver (near the end there'll be a dropdown with database drivers, install that). Port and password need to match whatever you have in your server.

    6. Launch your DB either via postgres' own GUI (search for pgadmin.exe) or use DBeaver as recommended by syntax).
    6.1 Import the DB file uploaded by LordDan in this thread. This depends on your client, but usually you can just right-click the DB called postgres>RESTORE (or Import in other clients).. in the file browser, ensure you have "All Files" selected so you can select the user.

    7. Now your DB and Server are done. Let's add a test user:
    7.1 Use the following code (in pgadmin it's rightclick left window "Query Tool") to insert a user. (DO NOT ADD THEM MANUALLY TO THE TABLE!)
    Code:
    INSERT INTO hops.users(user_name,password) VALUES ('admin','9F86D081884C7D659A2FEAA0C55AD015A3BF4F1B2B0B822CD15D6C15B0F00A08');

    This will create a user "admin" with password "test". Passwords are SHA256 encrypted as was posted in the Discord so keep that in mind.
    8. In your local client, change the server.ini IP address to your localhost (127.0.0.1)

    9. Start up your game and login normally. You'll now be connected.

    Troubleshooting: - When in doubt, run the server emulator as administrator.
    - Can't save new server.ini (need admin priv.) - edit it on desktop then paste into client folder, overriding all. you'll be asked for admin priv.
    - Can't access maps after Crystal Summit: Database>maps.go line 15 "unlockedMaps" add all the map IDs you want to make available. The map names and IDs can be found under "tb_ZoneTable.tbl" in the client game files. Use the tbleditor syntax released to turn them into an xlsx file.
    - Can't upgrade higher than +8: this is locked in the source code under database>character.go at line in the function "BSUpgrade" where it says " if item.plus >= 8 ...." just change that number to whatever you want the max to be.
    - Item IDs to spawn? Check the tb_ItemTable_Normal.tbl file and read it in excel.

    Code:
    GM commands: /item   /exp  /gold /tp   /map  /announce  /summon  /upgrade (e.g. /upgrade 11 106 15 = +15 all M6 first item in inv)
    (there are more but I haven't found where they're saved yet)
    Last edited by Vulp; 20-05-20 at 04:25 PM. Reason: had wrong port number in code...

  11. #11
    Alpha Member john007 is offline
    Alpha MaleRank
    Dec 2005 Join Date
    In MarsLocation
    2,208Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    @Vulp, Good Game you beat it me lmao. That's a very detailed guide. Let's wait for a section of Hero Online\plus.
    Cheers

    PS: if ya encounter errors feels free to ask we're here to help.
    PS 2 : looking forward to bring 3rd UI hero Online back to our beloved hero players. Hope we can alter the server source code for that.
    Last edited by john007; 20-05-20 at 03:00 PM.

  12. #12
    Registered Vulp is offline
    MemberRank
    May 2020 Join Date
    5Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    can't edit my original post because ragezone's editor tries to remove all my linebreaks...and it ate a space... anyway the code for default.go should read:
    Code:
    
    package config
    
    import (
    "log"
    "strconv"
    )
    
    var Default = &config{
        Database: Database{
            Driver:          "postgres",
            IP:              "localhost",
            Port:            getPort(),
            User:            "postgres",
    
            Password:        "herotest",
    
            Name:            "postgres",
            ConnMaxIdle:     96,
            ConnMaxOpen:     144,
            ConnMaxLifetime: 10,
            Debug:           false,
            SSLMode:         "disable",
        },
        Server: Server{
    
            IP:   "127.0.0.1",
            Port: 4510,
    
        },
    }
    
    func getPort() int {
    
    sPort := "4510"
    
    port, err := strconv.ParseInt(sPort, 10, 32)
    if err != nil {
            log.Fatalln(err)
        }
    
    return int(port)
    }
    
    Last edited by Vulp; 20-05-20 at 04:24 PM.

  13. #13
    Member Cajkan is offline
    MemberRank
    Jan 2017 Join Date
    41Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    Screenshots / videos of the game ?

  14. #14
    Alpha Member john007 is offline
    Alpha MaleRank
    Dec 2005 Join Date
    In MarsLocation
    2,208Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    as I promise here's the full dragon legend clients with latest patched....
    DragonLegend

    - - - Updated - - -

    Quote Originally Posted by Cajkan View Post
    Screenshots / videos of the game ?
    Here you go. This gameplay from beta
    https://m.youtube.com/watch?v=dgS0-LUCg84

  15. #15
    Hardcore Member Mreinales is offline
    MemberRank
    May 2016 Join Date
    Kuala Lumpur, MLocation
    143Posts

    Re: [RELEASE] Hero Online (Hero Plus) Full Database + Server Emulator

    LOL asking for tutorial lol



Page 1 of 5 12345 LastLast

Advertisement