2.1. Install "
RA Server Controller" and "
RA Server Monitor" from "C:\Runewaker\Tools" folder.
I recommend "C:\Runewaker\RA Server Controller" and "C:\Runewaker\RA Server Monitor" folders.
If you choose recommended folders remember that configuration files (.ini) will be replaced during installation.
You need to unpack them from a zip file again and replace manually.
2.2. Replace all appearances of "
<SQL_USER_PASS>" text in "Global.ini" file by an encoded SQL password.
To encode a SQL password use "C:\Runewaker\Tools\
RAPasswordEncode.exe".
Insert your password to a password field and "
romuser" to an account field (without quotation marks).
Press "Generator" button.
You can modify only one file and then copy it to rest of folders.
Quote:
"C:\Runewaker\Server\Realm_01_Common\Global.ini"
"C:\Runewaker\Server\Realm_01_Service\Global.ini"
"C:\Runewaker\Server\Realm_01_Zone\Global.ini"
2.3. Replace a "
<PROCESS_KEY>" text in the "PlayerCenter.ini" file by encoded
secret code.
To generate a
secret code execute below command in a command line.
Quote:
"C:\Runewaker\Server\Realm_01_Service\PlayerCenter.ini" "playercenter.ini"
An expected "Error" message will be displayed, it contains required code.
Next use "C:\Runewaker\Tools\
RAPasswordEncode.exe" tool to encode the
secret code.
Insert the
secret code to a password field and "
runewaker" to an account field (without quotation marks).
Press "Generator" button.
3.1. Login to the SQL server with admin privileges and create the SQL server account "
romuser".
Set a password at least 6 characters long. Grant this user all privileges. Disconnect from the SQL server.
3.2. Use "
romuser" account to login to the SQL server again.
3.3. Create database
No more database backup files (.bak) with hidden accounts, stored procedures, triggers or data.
SQL text files contain public schema and data.
Attention: Remember to backup your own databases. Next delete your ROM's databases.
3.3.1. SQL files with database schema - open and execute each file in a following order.
By default five databases will be created inside the "
C:\Runewaker\DATA" folder.
Quote:
ROM_Account_schema.sql
ROM_ImportDB_schema.sql
ROM_World_schema.sql
ROM_WorldLog_schema.sql
ROM_GlobalDB_schema.sql
3.3.2. SQL files with primary data - open and execute each file
Quote:
ROM_Account_data.sql
ROM_GlobalDB_data.sql
ROM_ImportDB_data.sql
ROM_World_data.sql
ROM_WorldLog_data.sql
3.3.3. SQL file with ItemShop items - open and execute this file
It contains just an example, modify it at one's own discretion.
The game server should be restarted after each change.
Quote:
table_NewShopInfo_data.sql
Attention: You can choose steps
3.3.4S or
3.3.4F interchangeably.
3.3.4S. (slow) SQL files with data for three biggest tables - open and execute each file
Execution time approximately: 33 minutes, 8 minutes, 6 minutes
Quote:
table_NPCData_data.sql
table_NPC_MoveFlagDB_data.sql
table_ObjNameStringDB_data.sql
-OR-
3.3.4F. (fast) Binary files (.Dat) with data for three biggest tables - open and execute below file
Below file contains queries which will be executed much faster but the data is hidden inside binary files.
My binary files contain exactly the same data like SQL files from
3.3.4S step.
Quote:
three_tables_import_data.sql
3.4. Create a first user account (your own)
Select "New Query", paste below script, change '
accountname' and '
password' to your desired login and pass, execute this script.
Quote:
INSERT INTO [ROM_Account].[dbo].[PlayerAccount]
([Account_ID],[Password],[IsMd5Password],[IsAutoConvertMd5])
VALUES
('accountname','password',0,1)
GO
4.1. Download a full client
6.0.6.2685
Link:
400 Bad Request
4.2. Download three patches up to
6.0.7.2693 version
Link:
400 Bad Request
Quote:
patch_6.0.6.2685.en_6.0.6.2689.en.exe
patch_6.0.6.2689.en_6.0.7.2691.en.exe
patch_6.0.7.2691.en_6.0.7.2693.en.exe
4.3. Install client to selected directory and apply three patches in a correct order
4.4. Replace "
RuneDev.ini" file in the client directory by "C:\Runewaker\Client\RuneDev.ini" file
4.5. Create shortcut to the "Client.exe" file, open properties and add "
NoCheckVersion" at the end of "Target" field, example:
Quote:
"C:\Runewaker\Client\Client.exe" NoCheckVersion
4.6. Copy the
FDB and
WDB folders from your client directory to "C:\Runewaker\
Resource" folder