How to make Ran Offline Here! (EP3)
First, download and install prerequisites
Microsoft .NET Framework Version 1.1 Redistributable Package
Microsoft SQL Server Management Studio Express
SQL Server 2005 Express Edition
Ran Client (New Link! (Credits to the owner of the client))
Ran Server
Ran Server(Mirror)
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
JeremyTRD
Ragezone