Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Granado Espada v28.00.72 retail server files

Initiate Mage
Joined
Jun 12, 2021
Messages
7
Reaction score
16
Granado Espada v28.00.72 retail server files + (older) SOURCE

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

Binaries + database:
Source code:

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)

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:
Initiate Mage
Joined
Jan 20, 2021
Messages
1
Reaction score
0
Thanks for sharing
CousinIt - Granado Espada v28.00.72 retail server files - RaGEZONE Forums
CousinIt - Granado Espada v28.00.72 retail server files - RaGEZONE Forums
 
Last edited:
Initiate Mage
Joined
Jun 12, 2021
Messages
7
Reaction score
16
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:
Joined
May 1, 2008
Messages
24
Reaction score
5
* 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?
 
Initiate Mage
Joined
Jun 12, 2021
Messages
7
Reaction score
16
SQL files create databases with appropriate names, you dont need to do anything extra.
 
CATMAGEDDON
Member
Joined
Aug 17, 2014
Messages
1,661
Reaction score
292
does this really use 20 gb ram?any way to like unload maps or something so i can test?i only have 16
 
Back
Top