Granado Espada v28.00.72 retail server files

Page 1 of 5 12345 LastLast
Results 1 to 15 of 75
  1. #1
    Registered CousinIt is offline
    MemberRank
    Jun 2021 Join Date
    5Posts

    Granado Espada v28.00.72 retail server files

    Hi there,
    This is a retail server file package modified used by rGE private server.
    It includes everything:
    * Full client
    * Server files
    * Tools for creating patches

    https://mega.nz/folder/TQpjCShT#hcGrCuRm2NMMJFdn2s19JQ

    Hopefully this can start private Granado Espada server community, as there are plenty of game fans out there. Enjoy!

    Setup guide by Solidus:
    Server Setup:

    Required Hardware:
    CPU: I'm not entirely sure what the literal minimum requirement for CPU would be, I've managed to run the server on a system with 4x Intel Xeon E7330, but it was hell to start and stop the server, as well as for the duration of the server's uptime, it was running all 4 CPUs at 90-95% utilization. My server with 2x Intel Xeon E5-2697 v2 has no trouble running the server at only 20% utilization. TLDR: GE server is very CPU-heavy, plan your hardware choices accordingly.

    RAM: The minimum requirement for memory is much clearer than the CPU requirement. After initial server startup, the memory usage tends to be right around 20-25GB. This will, obviously, increase if you add channels to maps and have higher server loads. Development can be done on much less memory, by running only few maps.


    Required Software:
    1. Windows Host OS (Windows 7 or 10 will work fine)
    2. MSSQL Server (A full version is required as far as I can recall correctly. I use MSSQL Server 2019 Enterprise Edition)
    3. Server uses Microsoft DirectX version 9 libraries, so you may wish to install the End-User Runtimes. (optional, but recommended)
    https://www.microsoft.com/en-us/down...s.aspx?id=8109
    4. GE Server files from the original post.


    Server Setup Procedures:
    0. Install Windows OS
    1. Install MSSQL Server, just a basic installation unless you plan to add some other db features.
    2. Extract the GE server files (note that AV may flag ./rGE_server/release/BugTrap.dll and the one on the client files, so you may wish to exempt this from AV). It is recommended to put the extracted rGE_server folder into the root directory of the windows install as some paths may be hardcoded to the server.
    3. Navigate to the ./rGE_server/SQL/ and run 0. ODBC.reg to configure ODBC.
    4. Open SSMS and connect to the MSSQL Server. Open the remaining sql files and run them in their numerical ordering. (should be RESOURCE, RESOURCE_LOG, GE_DATA, GE_LOG, and then DATA) This will set up the database.
    5. In SSMS, you will need to configure the zoneserver to your IP, this can quickly be done by expanding the RESOURCE DB's tables and right clicking dbo.MACHINE and editing top 200 lines. Change the IP for the ZONE@MACHINE1 (second line) to either your LAN ip if you're running the server only for LAN, or to your WAN ip, if you wish the server to be public. (Note: You can skip this step if you plan to run the client on the same machine as the server, but you will not be able to connect from any other computer.)
    6. Open ./rGE_server/server_release/hub.account.xml and modify/add a new line to create your desired credentials to connect via the managerclient.
    7. Open necessary ports. Default configuration uses the following ports. 8000, 8001, 7002-7023, 7030, 7031. These can be changed in the DB or via the ManagerClient.

    Server Startup Procedures:
    1. Launch ./rGE_server/ManagerHub.bat
    2. Launch ./rGE_server/ManagerNode_1.bat and ./rGE_server/ManagerNode_2.bat
    3. Launch ./rGE_server/server_release/ManagerClient_Release.exe ignore the warning and in the top left of the window, click login, and use the credentials you configured on step 6 of setup procedures.
    4. Expand the node list on the left side of the window, and select LOCAL@MACHINE1. Select both daemons. Right click and run these.
    5. Select the ZONE@MACHINE1 and select all zones you wish to start. Right click and run these.
    6. The server should be running now.

    Connecting to the game server with client:
    1. Copy the contents of ./rGE_server/release/ to your client's release folder.
    2. Open client directory, and navigate to the release folder. Edit serverlist.xml and set Server0_IP and Server1_IP to the IP of the server.
    3. Right-click rGE.exe and create a shortcut. In the shortcut's target line, add -SERVICE to the end. This will bypass the need to launch via updater.
    4. Launch the client via the shortcut you created.


    Account Creation:
    In SSMS, you'll need to create a new query (Change values where appropriate):

    Code:
    USE [RESOURCE]
    GO
    INSERT [dbo].[ACCOUNT_INFO] ([MEMBER_ID], [PASS], [CLASS]) VALUES ('Username', 'MD5_Hash_of_Password', 1);
    Add GM status, you'll need to run another query (Again, change values where appropriate):
    Code:
    USE [GE_DATA]
    GO
    INSERT [dbo].[ACCOUNT_LEVEL] ([MEMBER_ID], [LEVEL]) VALUES ('Username', 1);
    GO
    
    USE [RESOURCE]
    GO
    INSERT [dbo].[LEVEL_PERMISSION_IP] ([PERMISSION_IP], [DESC]) VALUES ('IP_Address', 'Description of User/whatever you may want to put here');
    GO
    Last edited by CousinIt; 18-06-21 at 07:08 AM.


  2. #2
    Account Upgraded | Title Enabled! Lemoness is offline
    True MemberRank
    May 2008 Join Date
    269Posts

    Re: Granado Espada v28.00.72 retail server files

    Thank you for the files, it was an amazing run 9 years ago until today <3

  3. #3
    Newbie gooja is offline
    MemberRank
    Jan 2021 Join Date
    1Posts

    Re: Granado Espada v28.00.72 retail server files

    Thanks for sharing
    Last edited by gooja; 12-06-21 at 08:43 PM.

  4. #4
    Newbie seinkami is offline
    MemberRank
    Jun 2021 Join Date
    1Posts

    Re: Granado Espada v28.00.72 retail server files

    if not hard can u explain how to start the server

  5. #5
    Registered CousinIt is offline
    MemberRank
    Jun 2021 Join Date
    5Posts

    Re: Granado Espada v28.00.72 retail server files

    Quote Originally Posted by seinkami View Post
    if not hard can u explain how to start the server
    * Extract archive to C:\
    * Run .reg file in SQL dir
    * Run each SQL file in SQL dir
    * Start bat files

    Edit: More extensive instructions are pending mod approval.
    Last edited by CousinIt; 13-06-21 at 07:35 AM.

  6. #6
    Member sessizbyu is offline
    MemberRank
    Feb 2018 Join Date
    TurkeyLocation
    67Posts

    Re: Granado Espada v28.00.72 retail server files

    pls reupload drive

  7. #7
    Account Upgraded | Title Enabled! Lemoness is offline
    True MemberRank
    May 2008 Join Date
    269Posts

    Re: Granado Espada v28.00.72 retail server files

    Quote Originally Posted by CousinIt View Post
    * Extract archive to C:\
    * Run .reg file in SQL dir
    * Run each SQL file in SQL dir
    * Start bat files

    Edit: More extensive instructions are pending mod approval.

    Do we need to point the DB to a specific table? Or just running it would be fine?

  8. #8
    Registered CousinIt is offline
    MemberRank
    Jun 2021 Join Date
    5Posts

    Re: Granado Espada v28.00.72 retail server files

    SQL files create databases with appropriate names, you dont need to do anything extra.

  9. #9
    Account Upgraded | Title Enabled! Lemoness is offline
    True MemberRank
    May 2008 Join Date
    269Posts

    Re: Granado Espada v28.00.72 retail server files

    -yoink-

  10. #10
    Hardcore Member wahaha is offline
    MemberRank
    Apr 2015 Join Date
    127Posts

    Re: Granado Espada v28.00.72 retail server files

    do you have the game source? @CousinIt

  11. #11
    Member sthaporn12 is offline
    MemberRank
    Sep 2009 Join Date
    96Posts

    Re: Granado Espada v28.00.72 retail server files

    I can confirm that are working fine.





  12. #12
    Registered DeagonNestDev is offline
    MemberRank
    Sep 2015 Join Date
    21Posts

    Re: Granado Espada v28.00.72 retail server files

    Files too old but thanks.

  13. #13
    Newbie rocha123 is offline
    MemberRank
    Oct 2015 Join Date
    2Posts

    Re: Granado Espada v28.00.72 retail server files

    What sql are you using?

    - - - Updated - - -

    Quote Originally Posted by sthaporn12 View Post
    I can confirm that are working fine.




    What sql are you using?

  14. #14
    Member sthaporn12 is offline
    MemberRank
    Sep 2009 Join Date
    96Posts

    Re: Granado Espada v28.00.72 retail server files

    SQL server 2019 develop

  15. #15
    Newbie rocha123 is offline
    MemberRank
    Oct 2015 Join Date
    2Posts

    Re: Granado Espada v28.00.72 retail server files

    Quote Originally Posted by sthaporn12 View Post
    SQL server 2019 develop
    Guide install database in sql help me please thx



Page 1 of 5 12345 LastLast

Advertisement