[Guide]How Split Server?

[Magenik]

Hello Guy here a simple guide about how to split server on 2 computer (or more)
for our example we go use my server config for you can see how it's setup :

server file use in this example without modification : MEGAUPLOAD - The leading online storage and file delivery service
this server file don't have db you can use search button and get db shared on this forum for ran
Server 1 :

• OS : Windows server Enterprise
• CPU : Dual Xeon Dual Core 3.0 ghz (8 cpu)
• Ram : 8 Giga Bits
• MSSQL 2000 : login sa:123456
• IP For example ( 192.168.1.1 )
• Session Server | Login Server | FieldServer1 | FieldServer2 | AgentServer

Server 2 :

• OS : Windows server Enterprise
• CPU : Dual Xeon Dual Core 3.0 ghz (8 cpu)
• Ram : 8 Giga Bits
• MSSQL 2000 : optional (can split DB too if you want for Ranlog if it's too bigger) > not use here for this example
• IP For example ( 192.168.1.2 )
• FieldServer3 | FieldServer4 | (additional Field if you want less lag)

Setup Server 1 (192.168.1.1)

1. Install MSSQL Server 2000 ( use in this example : mssql 2000 enterprise, I don't like mssql 2005), here we go use sa:123456 for setup server and ODBC
2. Restore your 4 DB on this server ( we can split DB on the 2 server but here we put all in the server 1) here the basic server setup http://forum.ragezone.com/f248/guide...r-here-193104/
3. Setup ODBC on Server 1

• rangame1

[IMG]http://www.**********.com/images/odbc01.jpg[/IMG]
[IMG]http://www.**********.com/images/odbc00.jpg[/IMG]
[IMG]http://www.**********.com/images/odbc02.jpg[/IMG]
[IMG]http://www.**********.com/images/odbc03.jpg[/IMG]
[IMG]http://www.**********.com/images/odbc04.jpg[/IMG] 

for ranlog / ranshop / ranuser you need do the same setup on the server 1 (192.168.1.1)

4. Edit server file and Config

• FieldServer 1 : just edit the aerver.cfg with your ip

// ////////////////////////////////////////////////////////////////////////////
// Fieldserver1 cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name Field
server_max_client 2000 // edit your max player here
server_ip 192.168.1.1
server_service_port 5103
server_control_port 6002

// ////////////////////////////////////////////////////////////////////////////
// Field Server PK Setting
// pk [on/off]
// 1 on
// 0 off
pk 1

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 3
heartbeat 1
max_thread 4

// ////////////////////////////////////////////////////////////////////////////
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3
server_group 0 // game server group
server_number 0 // game server number
server_channel 0 // Channel number
server_field 0 // field number

// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server session 192.168.1.1 6001 ran ran

// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server Agent 192.168.1.1

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10

• FieldServer 2 : just edit the berver.cfg with your ip

// ////////////////////////////////////////////////////////////////////////////
// Fieldserver2 cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name Field1
server_max_client 2000 // edit your max player here
server_ip 192.168.1.1
server_service_port 5103
server_control_port 6002

// ////////////////////////////////////////////////////////////////////////////
// Field Server PK Setting
// pk [on/off]
// 1 on
// 0 off
pk 1

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 3
heartbeat 1
max_thread 4

// ////////////////////////////////////////////////////////////////////////////
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3
server_group 0 // game server group
server_number 0 // game server number
server_channel 0 // Channel number
server_field 0 // field number

// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server session 192.168.1.1 6001 ran ran

// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server Agent 192.168.1.1

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10

• Loginserver : just edit the lerver.cfg with this

// ////////////////////////////////////////////////////////////////////////////
// Loginserver cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name login
server_max_client 2000
server_ip 192.168.1.1
server_service_port 5001
server_control_port 6002

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 3
max_thread 4

// /////////////////////////////////////////////////////////////////////////////
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 1
server_group 0 // server group
server_number 0 // server number

// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server session 192.168.1.1 6001 ran ran

• AgentServer Config edit server.cfg

// ////////////////////////////////////////////////////////////////////////////
// Agentserver cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name Agent
server_max_client 2000
server_max_channel_client 2000
server_channel_number 1
server_ip 192.168.1.1
server_service_port 6000
server_control_port 6002

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 3
heartbeat 1
max_thread 4

// /////////////////////////////////////////////////////////////////////////////
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 4
server_group 0 // game server group
server_number 0 // game server number

// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server session 192.168.1.1 6001 ran ran

// ////////////////////////////////////////////////////////////////////////////
// Channel Setting
// channel [number] [pk on/off]
// 1 on
// 0 off
channel 0 1
//channel 1 0
//channel 2 0
//channel 3 0
//channel 4 0
//channel 5 0
//channel 6 0
//channel 7 0
//channel 8 0
//channel 9 0

// ////////////////////////////////////////////////////////////////////////////
// Field server list
// field_server [channel] [field num] [server_name] [ip] [port]
field_server 0 0 Field 192.168.1.1 5103
field_server 0 1 Field1 192.168.1.1 5104
field_server 0 2 Field2 192.168.1.2 5105
field_server 0 3 Field3 192.168.1.2 5106


// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10

• SessionServer Edit sserver.cfg

// ////////////////////////////////////////////////////////////////////////////
// Sessionserver cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name session
server_max_client 2000
server_ip 192.168.1.1
server_service_port 16000
server_control_port 6003

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 3
max_thread 4

// /////////////////////////////////////////////////////////////////////////////
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 2
server_group 0 // server group
server_number 0 // server number

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10


// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

Setup Server 2 (192.168.1.2) upload same server file than server 1

1. Setup ODBC on Server 2

doing same setting like server 1
but edit this part in odbc with the server 1 ip and not server 2 ip

[IMG]http://www.**********.com/images/odbc05.jpg[/IMG]

2. edit server config for fieldserver 3 and field server 4

• FieldServer 3 : just edit the cerver.cfg

// ////////////////////////////////////////////////////////////////////////////
// Fieldserver3 cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name Field2
server_max_client 2000 // edit your max player here
server_ip 192.168.1.2
server_service_port 5103
server_control_port 6002

// ////////////////////////////////////////////////////////////////////////////
// Field Server PK Setting
// pk [on/off]
// 1 on
// 0 off
pk 1

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 3
heartbeat 1
max_thread 4

// ////////////////////////////////////////////////////////////////////////////
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3
server_group 0 // game server group
server_number 0 // game server number
server_channel 0 // Channel number
server_field 0 // field number

// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server session 192.168.1.1 6001 ran ran

// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server Agent 192.168.1.1

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10

• FieldServer 4 : just edit the derver.cfg
• you need first copy one fieldserver.exe then edit it with your favorite hex editor search ".cfg" and edit the #erver.cfg here it will be derver.cfg it same thing for whole other field you will add and don't forget copy the cfg file and change his seting always

// ////////////////////////////////////////////////////////////////////////////
// Fieldserver4 cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name Field3
server_max_client 2000 // edit your max player here
server_ip 192.168.1.2
server_service_port 5103
server_control_port 6002

// ////////////////////////////////////////////////////////////////////////////
// Field Server PK Setting
// pk [on/off]
// 1 on
// 0 off
pk 1

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 3
heartbeat 1
max_thread 4

// ////////////////////////////////////////////////////////////////////////////
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3
server_group 0 // game server group
server_number 0 // game server number
server_channel 0 // Channel number
server_field 0 // field number

// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server session 192.168.1.1 6001 ran ran

// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server Agent 192.168.1.1

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10

map setting (glogic.rcc) in server 1 & server 2

now we need setup the field server with their respective map for each server

here mine setting from my server (maps.list)

// [MAPNAME] [M,S] [F-SVR] [FLAGS] [NAME] [BGM]
// peace
// | commission free
// | | pk enable
// | | | free pk
// | | | | item drop
// | | | | |
innerzone_01.lev [0,0] [0] [1,0,0,0,1] [SG_Campus1F] outdoor.ogg
w_school_01.Lev [2,0] [0] [0,0,0,0,1] [SG_Campus] m7a.ogg
w_school_01_in_08.Lev [100,0] [3] [0,0,0,0,1] [StudyRoom1] m7a.ogg
w_school_01_in_08_2.Lev [101,0] [0] [0,0,0,0,1] [StudyRoom2] m7a.ogg
w_school_01_in_14.Lev [103,0] [3] [0,0,0,0,1] [StudyRoom3] m7a.ogg
w_school_01_in_14_2.Lev [104,0] [0] [0,0,0,0,1] [HistoryCentre] m7a.ogg
w_school_01_in_17.Lev [105,0] [3] [0,0,0,0,1] [Library] m7a.ogg
w_school_01_in_22.Lev [106,0] [3] [0,0,0,0,1] [SocietyRoom] m7a.ogg
w_school_01_in_31.Lev [107,0] [3] [0,0,0,0,1] [ScienceCentre] m7a.ogg
w_school_01_trash.Lev [102,0] [0] [0,0,0,0,1] [Dormitory] m7a.ogg
w_city_s_01.Lev [3,0] [0] [0,0,1,0,1] [SacredGateHole] m7a.ogg

innerzone_21.lev [4,0] [1] [1,0,0,0,1] [MP_Campus1F] outdoor.ogg
w_school_02.Lev [5,0] [1] [0,0,0,0,1] [MP_Campus] m7a.ogg
w_school_02_in_08.Lev [120,0] [3] [0,0,0,0,1] [StudyRoom2] m7a.ogg
w_school_02_in_08_2.Lev [121,0] [0] [0,0,0,0,1] [StudyRoom1] m7a.ogg
w_school_02_in_17.Lev [123,0] [3] [0,0,0,0,1] [ArtCentre] m7a.ogg
w_school_02_in_22.Lev [122,0] [3] [0,0,0,0,1] [Library] m7a.ogg
w_school_02_in_31.Lev [124,0] [3] [0,0,0,0,1] [StudentCentre1] m7a.ogg
w_school_02_in_33.Lev [125,0] [3] [0,0,0,0,1] [StudentCentre2] m7a.ogg
w_school_02_trash.Lev [126,0] [3] [0,0,0,0,1] [Dormitory] m7a.ogg
w_school_02_trash2.Lev [128,0] [1] [0,0,0,0,1] [2nd Dormitory] m7a.ogg
w_city_s_02.Lev [6,0] [1] [0,0,1,0,1] [MysticPeakHole] m7a.ogg

innerzone_31.lev [7,0] [2] [1,0,0,0,1] [PhoenixCampus1F] outdoor.ogg
w_school_03.Lev [8,0] [2] [0,0,0,0,1] [PhoenixCampus] m7a.ogg
w_school_03_in_08.Lev [130,0] [3] [0,0,0,0,1] [StudyRoom2] m7a.ogg
w_school_03_in_08_2.Lev [131,0] [0] [0,0,0,0,1] [StudyRoom1] m7a.ogg
w_school_03_in_14.Lev [136,0] [3] [0,0,0,0,1] [RenovationCentre] m7a.ogg
w_school_03_in_17.Lev [135,0] [3] [0,0,0,0,1] [ScienceCentre] m7a.ogg
w_school_03_in_22.Lev [137,0] [0] [0,0,0,0,1] [Laboratory] m7a.ogg
w_school_03_in_22_2.Lev [138,0] [0] [0,0,0,0,1] [PracticeRoom] m7a.ogg
w_school_03_in_31.Lev [141,0] [3] [0,0,0,0,1] [SuppliesRoom] m7a.ogg
w_school_03_in_33.Lev [142,0] [3] [0,0,0,0,1] [Library] m7a.ogg
w_school_03_trash.Lev [134,0] [2] [0,0,0,0,1] [Dormitory] m7a.ogg
w_city_s_03.Lev [9,0] [2] [0,0,1,0,1] [PhoenixHole] m7a.ogg

w_school_04.Lev [10,0] [0] [0,0,1,0,1] [LeonineCampus] s1.ogg
w_school_04_in_1f.Lev [11,0] [0] [0,0,1,0,1] [LeonineCampus1F] s1.ogg
w_school_04_in_2f.Lev [12,0] [1] [0,0,1,0,1] [LeonineCampus2F] s1.ogg
w_school_04_in_3f.Lev [13,0] [1] [0,0,1,0,1] [LeonineCampus3F] s1.ogg
w_school_04_in_b1.Lev [14,0] [2] [0,0,1,0,1] [LeonineCampusB1] s1.ogg
w_school_04_in_b2.Lev [15,0] [2] [0,0,1,0,1] [LeonineCampusB2] s1.ogg
w_school_04_in_b3.Lev [30,0] [0] [0,0,1,0,1] [LeonineCampusB3] s1.ogg

w_city_s_tunnel.Lev [17,0] [0] [0,0,1,0,1] [SG HolePassage] m7a.ogg
w_city_C_01.Lev [16,0] [1] [0,0,1,0,1] [TradingHole] m7a.ogg
ev_underpark.Lev [161,0] [1] [0,0,1,0,1] [Carpark 1] m7a.ogg
ev_underpark2.Lev [162,0] [2] [0,0,1,0,1] [Carpark 2] m7a.ogg
w_city_D_01.lev [18,0] [2] [0,0,1,0,1] [WharfPassage] m7a.ogg
w_blue_in_1F.Lev [19,0] [0] [0,0,1,0,1] [Hangout 1F_Ch1] m6a.ogg
w_blue_in_2F.Lev [20,0] [0] [0,0,1,0,1] [Hangout 2F_Ch1] m6a.ogg
w_blue_in_3F.Lev [21,0] [1] [0,0,1,0,1] [Hangout 3F_Ch1] m6a.ogg
w_blue_in_1F_ch2.Lev [150,0] [1] [0,0,1,0,1] [Hangout 1F_Ch2] m6a.ogg
w_blue_in_2F_ch2.Lev [152,0] [2] [0,0,1,0,1] [Hangout 2F_Ch2] m6a.ogg
w_blue_in_3F_ch2.Lev [154,0] [2] [0,0,1,0,1] [Hangout 3F_Ch2] m6a.ogg
w_blue_in_1F_ch3.Lev [151,0] [0] [0,0,1,0,1] [Hangout 1F_Ch3] m6a.ogg
w_blue_in_2F_ch3.Lev [153,0] [0] [0,0,1,0,1] [Hangout 2F_Ch3] m6a.ogg
w_blue_in_3F_ch3.Lev [155,0] [1] [0,0,1,0,1] [Hangout 3F_Ch3] m6a.ogg

W_Tunnel_3.Lev [26,0] [1] [0,0,1,0,1] [Trading3Passage] s1.ogg
w_Prison_01.Lev [27,0] [2] [0,0,1,0,1] [Prison] s1.ogg
w_city_E1.lev [28,0] [2] [0,0,1,0,1] [Middle Hole] m7a.ogg
w_city_E2.lev [29,0] [0] [0,0,1,0,1] [Root Hole] m7a.ogg

w_tradezone1.Lev [22,0] [0] [1,1,0,0,1] [MarketPlace] school.ogg
w_Total_suryun.lev [23,0] [1] [0,0,0,0,1] [PracticingYard] m7a.ogg
w_Wedding.lev [31,0] [2] [1,1,0,0,1] [WeddingHall] NULL
//
w_club_s_out.Lev [201,0] [0] [0,0,1,0,1] [SG E-Room Front] war.ogg
w_club_s_in.Lev [211,0] [0] [0,0,1,0,1] [SG E-Room] guild_war_2.ogg
//
w_club_h_out.Lev [202,0] [1] [0,0,1,0,1] [MP E-Room Front] war.ogg
w_club_h_in.Lev [212,0] [1] [0,0,1,0,1] [MP E-Room] guild_war_2.ogg
//
w_club_b_out.Lev [203,0] [2] [0,0,1,0,1] [Pnx E-Room Front] war.ogg
w_club_b_in.Lev [213,0] [2] [0,0,1,0,1] [Phoenix E-Room] guild_war_2.ogg
//
w_club_c_out.Lev [204,0] [0] [0,0,1,0,1] [Trd E-Room Front] war.ogg
w_club_c_in.Lev [214,0] [0] [0,0,1,0,1] [Trading E-Room] guild_war_2.ogg
//
prison_undercave.Lev [32,0] [1] [0,0,1,0,1] [PrisonTestZone] s1.ogg
undercave_bossroom.Lev [33,0] [1] [0,0,1,0,1] [Labatory7] s1.ogg
//
w_ep3_saintB_1F.Lev [46,0] [2] [0,0,1,0,1] [ep3_saintB_1F] s1.ogg
w_ep3_saintB_30F.Lev [35,0] [2] [0,0,1,0,1] [ep3_saintB_30F] s1.ogg
w_ep3_saintB_50F.Lev [36,0] [0] [0,0,1,0,1] [ep3_saintB_50F] s1.ogg
w_ep3_saintB_90F.Lev [37,0] [0] [0,0,1,0,1] [ep3_saintB_90F] s1.ogg
w_ep3_saintB_left.Lev [38,0] [1] [0,0,1,0,1] [ep3_saintB_left] s1.ogg
w_ep3_saintB_right.Lev [39,0] [1] [0,0,1,0,1] [ep3_saintB_right] s1.ogg
w_ep3_saintB_boss1.Lev [40,0] [2] [0,0,1,0,1] [ep3_saintB_boss1] s1.ogg
w_ep3_saintB_boss2.Lev [41,0] [2] [0,0,1,0,1] [ep3_saintB_boss2] s1.ogg
w_ep3_saintB_1B.Lev [42,0] [0] [0,0,1,0,1] [ep3_saintB_1B] s1.ogg
w_ep3_another_1.Lev [43,0] [3] [0,0,1,0,1] [ep3_another_1] s1.ogg
w_ep3_another_2.Lev [44,0] [3] [0,0,1,0,1] [ep3_another_2F] s1.ogg
w_ep3_another_3.Lev [45,0] [3] [0,0,1,0,1] [ep3_another_3F] s1.ogg
//
w_ep3_saintB_51F.Lev [51,0] [2] [0,0,1,0,1] [ep3_saintB_51F] m7a.ogg
w_ep3_saintB_52F.Lev [52,0] [2] [0,0,1,0,1] [ep3_saintB_52F] m7a.ogg
w_city_turnal_kangsi.Lev[74,0] [3] [0,0,1,0,1] [TerrorPassageI] m7a.ogg
w_city_turnal_kangs2.Lev[111,0] [3] [0,0,1,0,1] [TerrorPassageIII] m7a.ogg
w_city_turnal_kangs3.Lev[222,0] [3] [0,0,1,0,1] [TerrorPassageIV] m7a.ogg
w_sibuya_new.Lev [34,0] [2] [0,0,1,0,1] [Shibuya] m7a.ogg
w_event_uhaha.Lev [73,0] [3] [0,0,1,0,1] [TerrorPassageII] m7a.ogg

[0] = fieldserver1
[1] = fieldserver2
[2] = fieldserver3
[3] = fieldserver4

now when all is done start in order

1. sessionserver (server 1 : 192.168.1.1)
2. loginserver (server 1 : 192.168.1.1)
3. field1 (server 1 : 192.168.1.1)
4. field2 (server 1 : 192.168.1.1)
5. field3 (server 2 : 192.168.1.2)
6. field4 (server 2 : 192.168.1.2)
7. agentserver (server 1 : 192.168.1.1)

you have done hope this guide will help you for make less lag and more player in you server don't forget repack the glogic and of course update client with the glogic or player wont able play new map
(in my server all map is open some map have hight exp so becarefull if you want open more map)

[MentaL]

[smarkies]

Added to Sticky Section.

Thank you.

[Magenik]

Added to Sticky Section.

Thank you.

you are welcome

[Dyaomapha]

Thanks A lot Magenik ! You made a complete Guide!

[Magenik]

Thanks A lot Magenik ! You made a complete Guide!

no problem and if someone say it's not working so it's impossible haha cause its my server setting :d just i have 6 field server and here for this example it's only 4 field

for those who will try make more field first you need more ram and good cpu like i have i tested before with 6 giga ram i can't host it
with 8 giga ram sure this dedicaced server is expansive but when you want more than 1000 players you need pay server for it :trumpet: then make your donation system work for get a good donation and pay server :sweatdrop

[HELL_IN_HEAVEN]

the problem here in the philippines, we cant afford to pay big bandwidth hosting ^^..eventhough we can afford to buy the server pc, the main problem is the DSL SPEED HOSTING, too expensive

[Magenik]

the problem here in the philippines, we cant afford to pay big bandwidth hosting ^^..eventhough we can afford to buy the server pc, the main problem is the DSL SPEED HOSTING, too expensive

i know it i was in ph and know your internet speed
but you can do something for make it better in ph that i told some of my friend
you can go check the biggest cafe in manila or makati and ask them host the server by spliting why? because in local the speed will be faster and if you are near those cafe you can also put one exe server in each cafe and share the intra-internet connection in ph
i already test in in mauritius island when i installing hospot in some big town and i can guaranty you the speed is share and lag free
so if you need more info about this idea i can help you for setting up this

[netcheck]

@magenik

NICE AGAIN!!!

but am i required to install SQL server in PC 2 or i can make without?

[Dyaomapha]

The only thing i have a problem is using hamachi. Im forced to use hamachi because I am using modem/router prolink 9300G. I alrready did port forward of all ports found on cfg files. The client pc succesfully found the channel of the server in the game but failed to connect. Magenik can you teach me what is lacking to make ran online behind modem/router?

thanks.

[heavenzel]

@netcheck, yes if you want to split databases too.. like rangame1,ranshop, ranuser, inm pc1 and ranlog in PC2.. but if you dont want to split databases, no no need sql in pc2

[lourence8]

question... bcoz my ran is only offline can i use 4 field server in 1 PC?
what is the best to use... 1, 2 , 3 ,4 field server?

[reinfrooze]

why im getting bind error??? what is wrong????

[Magenik]

I do a mass answer for all :

like i wrote here if you don't want split Database you don't need install mssql on both server but you can if you want but it's not necessary

now if you want split database the only thing important is ODBC
when you setup the IP of Database it's here you need put the IP of where is situate your DB
Don't ask me about Hamachi i never try it or use it in my whole life i just know it from reading you all here on this forum haha

For use router you need open TCP port just read all port in Config and setup them in your router for you can put one of your computer in DMZ then from it you can control other computer via windows firewall
but don't forget if you setup your router, you have also your computer firewall to setup
don't open port 1433 for wan

if you have a webserver you need make a custom rules in windows firewall or your favorite firewall software i explain how setup it

first open your windows firewall windows

first we need add a new rules for mssql we want setup an open port for a specific fix ip
here example we have a website on a webserver with ip 72.1.1.1 (fake ip for our example)
and your wan ip is 68.1.1.1 (supposed fix ip for your server)
and your home ip is a range ip (ip dynamique with range ) 121.1.0.0/255.255.0.0 or if you prefert 121.1.0.0/16 this is your range ip since in ph the range ip is so large but all player in this range ip will able to connect to your mssql if they know it or better for you have a fix ip (expensive i know)

now after clic on add port you will clic on that one :" change scope "

by default all rules in firewall open the port for "any computer = all computer can connect to the port"

now choose custom list and we will make our rules for allow only the webserver and your home ip to connect to mssql

(it's same rules for make your remote desktop if you see what i mean)

the rules we want is allow 72.1.1.1 and the range ip 121.1.0.0/255.255.0.0

so here the rules you need put :
72.1.1.1/255.255.255.255,121.1.0.0/255.255.0.0
then clic ok for all and here your rules is create

it's same rules in firewall sofware

hope this will help many ppl for understand how protect your server

edit : here the info about subnet mask hope will help you understand more the network
Netmasks

Netmask Netmask (binary) CIDR Notes
255.255.255.255 11111111.11111111.11111111.11111111 /32 Host (single addr)
255.255.255.254 11111111.11111111.11111111.11111110 /31 Unuseable
255.255.255.252 11111111.11111111.11111111.11111100 /30 2 useable
255.255.255.248 11111111.11111111.11111111.11111000 /29 6 useable
255.255.255.240 11111111.11111111.11111111.11110000 /28 14 useable
255.255.255.224 11111111.11111111.11111111.11100000 /27 30 useable
255.255.255.192 11111111.11111111.11111111.11000000 /26 62 useable
255.255.255.128 11111111.11111111.11111111.10000000 /25 126 useable
255.255.255.0 11111111.11111111.11111111.00000000 /24 "Class C" 254 useable
255.255.254.0 11111111.11111111.11111110.00000000 /23 2 Class C's
255.255.252.0 11111111.11111111.11111100.00000000 /22 4 Class C's
255.255.248.0 11111111.11111111.11111000.00000000 /21 8 Class C's
255.255.240.0 11111111.11111111.11110000.00000000 /20 16 Class C's
255.255.224.0 11111111.11111111.11100000.00000000 /19 32 Class C's
255.255.192.0 11111111.11111111.11000000.00000000 /18 64 Class C's
255.255.128.0 11111111.11111111.10000000.00000000 /17 128 Class C's
255.255.0.0 11111111.11111111.00000000.00000000 /16 "Class B"

255.254.0.0 11111111.11111110.00000000.00000000 /15 2 Class B's
255.252.0.0 11111111.11111100.00000000.00000000 /14 4 Class B's
255.248.0.0 11111111.11111000.00000000.00000000 /13 8 Class B's
255.240.0.0 11111111.11110000.00000000.00000000 /12 16 Class B's
255.224.0.0 11111111.11100000.00000000.00000000 /11 32 Class B's
255.192.0.0 11111111.11000000.00000000.00000000 /10 64 Class B's
255.128.0.0 11111111.10000000.00000000.00000000 /9 128 Class B's
255.0.0.0 11111111.00000000.00000000.00000000 /8 "Class A"
254.0.0.0 11111110.00000000.00000000.00000000 /7
252.0.0.0 11111100.00000000.00000000.00000000 /6
248.0.0.0 11111000.00000000.00000000.00000000 /5
240.0.0.0 11110000.00000000.00000000.00000000 /4
224.0.0.0 11100000.00000000.00000000.00000000 /3
192.0.0.0 11000000.00000000.00000000.00000000 /2
128.0.0.0 10000000.00000000.00000000.00000000 /1
0.0.0.0 00000000.00000000.00000000.00000000 /0 IP space

Here is an example:

192.168.1.0/25 would include all address between 192.168.1.0 and 192.168.1.127

while 192.168.1.128/25 would include 192.168.1.128 and 192.168.1.255


Net bit | Subnet mask | total-addresses
/20 255.255.240.0 4096
/21 255.255.248.0 2048
/22 255.255.252.0 1024
/23 255.255.254.0 512
/24 255.255.255.0 256
/25 255.255.255.128 128
/26 255.255.255.192 64
/27 255.255.255.224 32
/28 255.255.255.240 16
/29 255.255.255.248 8
/30 255.255.255.252 4

[netcheck]

@magenik]
@heavenzel

in my SQL server.. i dont use the username and password...

how can i make in PC2 if i dont have password..

i tried it but i cant connect in PC1...

[Magenik]

you just need create a security login in your mssql and put it on the database you want for it



from image 2 you select all db of ran and put owner
then in your whole config you need setup and replace sa by randb with the new password