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!

How to make Ran Offline Here! (EP3)

Initiate Mage
Joined
Jun 19, 2017
Messages
1
Reaction score
0
Link are broken, please give me another link for Ran Client and Ran Server, Please give me
 
Initiate Mage
Joined
Sep 10, 2017
Messages
5
Reaction score
0
Re: [Guide] How to make Ran Offline Here! (EP3)

dapat ung name ng sql server mo ung name ng pc mo for example namengpc/SQLEXPRESS
 
Initiate Mage
Joined
Mar 28, 2019
Messages
6
Reaction score
0
Re: [Guide] How to make Ran Offline Here! (EP3)

I can't download the link below

 
Initiate Mage
Joined
Aug 17, 2022
Messages
72
Reaction score
1
First, download and install prerequisites













After downloading all the required files I suggest you make a folder called Development and then inside that folder create another 2 folders named:

*Ran Server
*Ran Client

Extract Ran Server to Ran Server folder
Extract Ran Client to Ran Client folder


Open Folder Ran Server with SQL 2005

Double Click RanLog1_2k5.sql when he did not open SQL, Click execute wait after analyze. Similarly do the RanShop1_2k5.sql nyo, RanUser1_2k5.sql, and RanGame1_2k5.sql.

Copy all these folders from data folder in the ran client:

glogic
object
skinobject
gui
skin
effect
map
skeleton
editor
animation
piece

Then create a folder inside Ran Server then call it data then paste.


Copy this code to notepad:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.INI]

[HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.INI \ ODBC Data Sources]
"RanGame1" = "SQL Server"
"RanLog" = "SQL Server"
"RanShop" = "SQL Server"
"RanUser" = "SQL Server"

[HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.INI \ RanGame1]
"Driver" = "C: \ WINDOWS \ \ system32 \ \ sqlsrv32.dll"
"Server" = "(local)"
"Database" = "RanGame1"
"LastUser" = "on"
"Trusted_Connection" = "Yes"

[HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.INI \ RanLog]
"Driver" = "C: \ WINDOWS \ \ system32 \ \ sqlsrv32.dll"
"Server" = "(local)"
"Database" = "RanLog"
"LastUser" = "on"
"Trusted_Connection" = "Yes"

[HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.INI \ RanShop]
"Driver" = "C: \ WINDOWS \ \ system32 \ \ sqlsrv32.dll"
"Server" = "(local)"
"LastUser" = "on"
"Trusted_Connection" = "Yes"
"Database" = "RanShop"

[HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.INI \ RanUser]
"Driver" = "C: \ WINDOWS \ \ system32 \ \ sqlsrv32.dll"
"Server" = "(local)"
"LastUser" = "on"
"Trusted_Connection" = "Yes"
"Database" = "RanUser"

and save as odbc2k3.reg

Right Click then merge.

Open Ran Client folder then find param.ini and param.cfg then set your IP (tip: find all IP addresses inside the file and replace it with 127.0.0.1 which is an offline IP) .

Click Start, Control Panel, Performance and Maintenance. Click Administrative Tools then Data Sources (ODBC)

ODBC Data Source Administrator

User DSN Tab

Configuring RanGame1 Server Name Change locally appearing just before you connect to SQL (Ex.: NAME \ SQLEXPRESS not NAME / SQLEXPRESS) Finish then click OK.
Similarly do the RanLog,RanShop and RanUser

Open the SQL mgt studio,connect then expand the database, ranuser, table. servergroup you take a good look, then right click open table

Just copy

SGNum: 1
SGName: (anything)
OdbcName: RanGame1
OdbcUserID: in
OdbcPassword: 1234
OdbcLogName: RanLog
OdbcLogUserID: in
OdbcLogPassword: 1234

execute

ServerInfo also done well just copy

SGNum: 1
SvrNum: 1
SvrType: 4

execute

UserInfo also done, you take care to input here packing the usertype 30

Username
UserID
UserPass
UserPass2
Usertype: 30

execute

GMCharEdit to open RanServer Folder
Just copy this:

First field: RanUser
Second field: in
Third field: 1234
Fourth field: 1234

Right Click Ran Client Folder game.exe to send to then desktop
Right Click game.exe Shortcuts on the desktop then properties
add target to: / app_run
(Ex.: C: \ Documents and Settings \ Name \ Desktop \ RanOfflineClient \ game.exe "/ app_run)

Open server files (Must be in order): 1.) SessionSrv.exe 2.) LoginSrv.exe 3.) FieldSrv.exe 4.) AgentSrv.exe
Game.exe double click the desktop and login

Due to insistent public demand I decided to continue updating this thread :D

i dont know how i install the MICROSOFT SQL SERVER 2005 SETUP when i click the link is not showing also i cant fint it where should i get that?
 
Initiate Mage
Joined
Nov 3, 2022
Messages
24
Reaction score
0
i dont know how i install the MICROSOFT SQL SERVER 2005 SETUP when i click the link is not showing also i cant fint it where should i get that?
you can google MSSQL 2005 EXPRESS download..
 
Back
Top