1. Description of Mu Server i~DLo3
A. JoinServer i~DLo3
i. For account authentication and (Billing system when commercial service) i~DLo3
B. GameServer i~DLo3
i. Connected to client, actually the game applied server i~DLo3
C. ConnectServer i~DLo3
i. For Client Update(version) management and game server list management i~DLo3
D. DataServer i~DLo3
i. For game character information and DB save/load i~DLo3
E. ExDB i~DLo3
i. For Guild and friend management DB i~DLo3
F. ChatServer i~DLo3
i. Connected to client to control chat during users i~DLo3
G. RankingServer i~DLo3
i. For ranking of Devil Square and Blood Castle i~DLo3
H. EventServer i~DLo3
i. For gift management from event i~DLo3
I. WzFsGate i~DLo3
i. Data management of game server i~DLo3
i~DLo3
2. Installation of Mu Server System sequence (For each server installation, refer to each server installation below this topic) i~DLo3
1> . Execute WzFsGate, then check it works or not i~DLo3
Refer to installation of WzFsGate i~DLo3
2> . Install Authentic DB and Authentic Server i~DLo3
Refer to installation of JoinServer i~DLo3
3> . Install Connect server list and Connect server. i~DLo3
Refer to installation of ConnectServer i~DLo3
4> . Install Game Data. i~DLo3
Refer to installation of DataServer, ExDB i~DLo3
5> . Install GameDB, Data Server, and EXDB. i~DLo3
Refer to installation of DataServer, ExDB i~DLo3
6> . Install Chat Server. i~DLo3
Refer to installation of ChatServer i~DLo3
7> . Install EventDB and EventServer. i~DLo3
Refer to installation of EventServer i~DLo3
8> . Install RankingDB and Rangking Server. i~DLo3
Refer to installation of RankingServer i~DLo3
9> . Install Game Server. i~DLo3
Refer to installation of GameServer i~DLo3
10> . Perform Map Server divided (For Castle Siege) i~DLo3
Refer to appendix of Castle Siege (not included in this document) i~DLo3
11> . Execute them, following by the sequence i~DLo3
File Transfer Server : WzFsGate.exe i~DLo3
Authentic Server : JoinServer.exe i~DLo3
Connect Server : CS.exe i~DLo3
Data Server : DataServer.exe i~DLo3
EXDB : ExDB.exe i~DLo3
Chat Server : ChatServer.exe i~DLo3
Ranking Server, Event Server : MU_RANKING_DB_SERVER.exe, WZ_MU2003_EVENT_SERVER.exe i~DLo3
Game Server : GameServer.exe i~DLo3
i~DLo3
3. Installation JoinServer / DB i~DLo3
A. Execute MS-SQL Enterprise Manager (EM) i~DLo3
B. Execute Query Analyzer i~DLo3
C. Check the running of SQL Server Agent i~DLo3
D. Making Me_MuOnline DB i~DLo3
i. DB for user’s account information. i~DLo3
ii. Choose master DB i~DLo3
iii. In Query Analyzer, open \\DBScript\JoinServer\Me_Muonline Me_Muonline_CreateDB.sql, Me_MuOnline.sql , and execute it i~DLo3
1. File Structure i~DLo3
\\DbScript\Me_Muonline\Default_ODBC.txt i~DLo3
\\DbScript\Me_Muonline\Me_Muonline.sql i~DLo3
\\DbScript\Me_Muonline\Me_Muonline_CreateDB.sql i~DLo3
i~DLo3
iv. Check if Me_MuOnline DB is created and Table, SP are created also. i~DLo3
v. Refer to DB related document for the Table and SP i~DLo3
i~DLo3
E. Install MD5 for JoinDB to make account encryption. MD5 module is extended save procedure type, so that it can be used on SQL server directly. i~DLo3
i. Host where JoinDB in SQL server installed, open C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ folder, and then search a patch file named \\MD5_EXSP_DLL\WZ_MD5_MOD.dll, then copy. i~DLo3
1. File Structure i~DLo3
\\MD5_EXSP_DLL\WZ_MD5_MOD.dll : Encryption extended save procedure DLL i~DLo3
\\MD5_EXSP_DLL\UserDefinedFunction.sql : user definition function which help using Encryption of Extended save procedure i~DLo3
\\MD5_EXSP_DLL\readme.txt : Installation of Encryption of extended save procedure i~DLo3
i~DLo3
ii. Refer to file \\MD5_EXSP_DLL\readme.txt, install it. i~DLo3
iii. Caution : You MUST install user definition function of \\MD5_EXSP_DLL\UserDefinedFunction.sql on Me_Muonline DB above. (NEVER INSTALL IT ON master DB) i~DLo3
i~DLo3
i~DLo3
F. Installation of MuLog DB i~DLo3
i. DB for gamer user connect/disconnect and game time involved information i~DLo3
ii. Execute Query Analyzer i~DLo3
iii. Choose master DB i~DLo3
iv. In Query Analyzer, open the folder \\DBScript\MuLog 폴더내에 MuLog_CreateDB.sql, MuLogCreate.sql, and then execute it. i~DLo3
1. File Structure i~DLo3
\\DbScript\MuLog\Default_ODBC.txt i~DLo3
\\DbScript\MuLog\MuLog_CreateDB.sql i~DLo3
\\DbScript\MuLog\MuLogSchedule.sql i~DLo3
i~DLo3
2. To execute it, SQL Agent must be running (!!!.IMPORTANT) i~DLo3
v. Check the creation of MuLog DB, and schedule is running properly i~DLo3
vi. Table is made on 23:00 everyday, for tomorrow one i~DLo3
G. Create administrator account i~DLo3
i. Create “MuOnlineAdmin” DataBase account i~DLo3
i~DLo3
H. Installation of JoinServer i~DLo3
i. File Structure i~DLo3
\\JoinServer\JoinServer.exe : Authentic server execution file i~DLo3
\\JoinServer\Log : Folder where Authentic server log is saved (Folder must be made before the performance!) i~DLo3
&'k(v(>n,
ii. ODBC Setup &'k(v(>n,
1. Me_MuOnline DB ODBC Setup &'k(v(>n,
a. Refer to \\DBScript\JoinServer\Me_Muonline\Default_ODBC.txt &'k(v(>n,
2. MuLog DB ODBC Setup &'k(v(>n,
a. Refer to \\DBScript\JoinServer\MuLog\Default_ODBC.txt &'k(v(>n,
&'k(v(>n,
iii. Installation of JoinServer &'k(v(>n,
1. Program for user authentication and billing process &'k(v(>n,
2. Make shortcut of JoinServer.exe and extention &'k(v(>n,
a. /p : JoinServer port (default is 55970) &'k(v(>n,
b. /ca : ConnectServer IP (required) &'k(v(>n,
c. /cp : ConnectServer의 Port (default is 55557) &'k(v(>n,
d. You must put /ca(ConnectServer IP) all the time &'k(v(>n,
e. Example) &'k(v(>n,
“C:\MuOnline\JoinServer\JoinServer.exe /ca172.16.100.3” &'k(v(>n,
&'k(v(>n,
&'k(v(>n,
4. Installation of DataServer, ExDB, DB &'k(v(>n,
A. Execute EM &'k(v(>n,
B. Execute Query Analyzer &'k(v(>n,
C. Creation of MuOnline DB &'k(v(>n,
i. DB for Game data management &'k(v(>n,
ii. Choose master DB &'k(v(>n,
iii. On Query Analyzer, open the folder \\DBScript\MuOnline, and execute MuOnline_CreateDB.sql, MuOnline.sql &'k(v(>n,
1. File Structure &'k(v(>n,
\\DBScript\MuOnline\Default_ODBC.txt &'k(v(>n,
\\DBScript\MuOnline\MuOnline_CreateDB.sql &'k(v(>n,
\\DBScript\MuOnline\MuOnline.sql &'k(v(>n,
\\DBScript\MuOnline\GameServer_Init_Data.sql &'k(v(>n,
&'k(v(>n,
iv. Check MuOnline DB is created and Table, SP are created &'k(v(>n,
v. Refer to related document for Table and SP in DB &'k(v(>n,
vi. Check if the number of GameServerInfo table is 0, 0, 0 as initial -> Put it directly through EM, or use the query in GameServer_Init_Data.sql by the execution of Query Analyzer &'k(v(>n,
&'k(v(>n,
D. Create Administrator account &'k(v(>n,
i. “Admin” DataBase account creation -> Refer to \\DBScript\MuOnline\Default_ODBC.txt &'k(v(>n,
&'k(v(>n,
&'k(v(>n,
&'k(v(>n,
E. Installation of DataServer, ExDB &'k(v(>n,
i. ODBC Setup &'k(v(>n,
1. Refer to \\DBScript\JoinServer\MuOnline\Default_ODBC.txt &'k(v(>n,
ii. Installation of DataServer &'k(v(>n,
1. File Structure &'k(v(>n,
\\DataServer\DataServer.exe : Data Server &'k(v(>n,
\\DataServer\Log : Folder where the data server log is saved (Folder must be made and rady) &'k(v(>n,
&'k(v(>n,
2. Cooperate with GameServer, and works as user data save and load. &'k(v(>n,
3. Make shortcut of DataServer.exe with extension &'k(v(>n,
4. Extension is set for the DataServer port number, and window location &'k(v(>n,
5. 예) &'k(v(>n,
a. 1st DataServer.exe : set as “C:\MuOnline\DataServer\Dataserver.exe 55960 1” &'k(v(>n,
b. 2nd DataServer.exe : set as “C:\MuOnline\DataServer\Dataserver.exe 55962 2” &'k(v(>n,
&'k(v(>n,
6. \Data Folder &'k(v(>n,
a. File structure &'k(v(>n,
commonserver.cfg It has game server option. If it is modified, it affects the game (Primary subjects must be modified while server setting) &'k(v(>n,
dataserver.inidataserver.ini.dat It contains options for DB Server. &'k(v(>n,
eventitembagX.txt Item list which is used on (Golden Budge Dragon) &'k(v(>n,
gate.txt Movement information while using move &'k(v(>n,
item(Vie).txt Item information &'k(v(>n,
message_tai.wtf Server Text &'k(v(>n,
Monster.txt Monster Information &'k(v(>n,
MonsterSetBase.txt Monster location information &'k(v(>n,
ServerInfo.data Gameserver execution information &'k(v(>n,
ShopX.txt Item list of 0 to N, which are sold in the shop &'k(v(>n,
Skil.txt Magic and Skill information &'k(v(>n,
TerrainX.att The property of Map 1 to N &'k(v(>n,
badsyntax.txt File to check unwanted words to be used in character DB server. &'k(v(>n,
※ . there are more data files are available &'k(v(>n,
&'k(v(>n,
b. Use them in DataServer, ExDB, GameServer &'k(v(>n,
c. GameServer is shared as M drive (this Data folder must be shared, after the setup of DataServer on the host.) &'k(v(>n,
&'k(v(>n,
&'k(v(>n,
iii. Installation of ExDB &'k(v(>n,
1. File structure &'k(v(>n,
\\ExDB\Exdb.exe : ExDB execution file &'k(v(>n,
\\ExDB\exdb.ini : ExDB setting file &'k(v(>n,
\\ExDB\exdb.ini.dat : ExDB setting file (encrypted) &'k(v(>n,
\\ExDB\LogProc.dll : Required DLL &'k(v(>n,
\\ExDB\LOG : ExDB Folder where the log is saved (it must be made before using) &'k(v(>n,
&'k(v(>n,
2. Manage the guild and my friend required data &'k(v(>n,
3. Make shortcut of Ex.ex and extension added &'k(v(>n,
4. Extension has ChatServer Public IP &'k(v(>n,
a. GameServer brings IP of ChatServer from ExDB, then tells Client &'k(v(>n,
5. Example) &'k(v(>n,
a. Set as “C:\MuOnline\ExDB\ExDB.exe xxx.xxx.xxx.xxx” &'k(v(>n,
&'k(v(>n,
5. Installation of GameServer &'k(v(>n,
A. File Structure &'k(v(>n,
\\GameServer\GameServer\GameServer.zip : Game server execution file (normal) &'k(v(>n,
\\GameServer\GameServer\GameServer_CS.zip : Game server execution file (for Castle Siege) &'k(v(>n,
\\GameServer\GameServer\WzAG.dll : required DLL &'k(v(>n,
\\GameServer\GameServer\mumsg.dll : required DLL &'k(v(>n,
\\GameServer\GameServer\ggsrvdll.dll : Game guard DLL (reserved) &'k(v(>n,
\\GameServer\GameServer\ggauth.dll : Game guard DLL (reserved) &'k(v(>n,
\\GameServer\GameServer\Log\ : Folder where the Gameserver log is saved (It must be made before using) &'k(v(>n,
\\GameServer\Data\ServerInfo.dat : Game server unique code, PK server on/off is saved on the data file (Each server has own unique code -> Not like Data folder in DataServer, it is available on the upper folder of Data folder) &'k(v(>n,
&'k(v(>n,
B. Share the Data folder as M drive, from DataServer &'k(v(>n,
C. Check the information in \GameServer\Data, ServerInfo.dat &'k(v(>n,
[GameServerInfo] &'k(v(>n,
ServerName = 1-1 // Each server has unique code just like ServerCode &'k(v(>n,
ServerCode = 0 // Code for Data\ ServerList.dat in CS. Each server has own unique code (IMPORTANT!!!) &'k(v(>n,
NonPK = 0 // PK server seting (0:PK / 1:NonPK) &'k(v(>n,
D. Check the information in \\Data\lang\phi\commonlog.cfg &'k(v(>n,
[ConnectServerInfo] &'k(v(>n,
IP = 10.1.1.1 ; ConnectServer address &'k(v(>n,
PORT = 55557 ; ConnectServer Port &'k(v(>n,
&'k(v(>n,
E. Unzip and setup Normal game server. GameServer.zip, and Castle Siege server, GameServer_CS.zip. To describe the Normal game server and Castle Siege server, Castle Siege server is available only 1 for each group. If there are 4 server group, (Server group which shares GameDB) Each server group has 1 C.S server, therefore it means 4 C.S server total. See the diagram. (White is normal game server, yellow is C.S server) &'k(v(>n,
&'k(v(>n,
F. Each server group must be set the MapServerInfo.dat in M drive. This file is the map structure table, and is owned by each server group. If this file has wrong setting, then Castle Siege will be played. To set this file, refer the file below. &'k(v(>n,
\\Document\CastleSiege_Setting.doc &'k(v(>n,
\\Document\MapServerData_SettingExam.doc &'k(v(>n,
&'k(v(>n,
G. Make shortcut of GameServer.exe &'k(v(>n,
i. Extension setup : JoinServerIP JoinServerPort DataServerIP DataServerPort GameServerPort &'k(v(>n,
ii. Example) &'k(v(>n,
1. “10.1.224.217 55970 10.1.1.23 55960 55901 &'k(v(>n,
&'k(v(>n,
&'k(v(>n,
6. Installation of ChatServer &'k(v(>n,
A. File structure &'k(v(>n,
\\ChatServer\ChatServer.exe : Chat server execution file &'k(v(>n,
\\ChatServer\LogProc.dll : required DLL &'k(v(>n,
\\ChatServer\WZSock.dll : required DLL &'k(v(>n,
\\ChatServer\Log\ : Folder where the chat server log is saved (it must be made before using) &'k(v(>n,
&'k(v(>n,
B. Make shortcut of ChatServer.exe &'k(v(>n,
i. Extension setting : set as ExDB private IP &'k(v(>n,
ii. example) &'k(v(>n,
1. “C:\MuOnline\ChatServer\ ChatServer.exe xxx.xxx.xxx.xxx” &'k(v(>n,
&'k(v(>n,
7. Installation of WzFsGate &'k(v(>n,
A. File Structure &'k(v(>n,
\\WzFsGate\WzFsGate.exe : &'k(v(>n,
\\WzFsGate\Log\ : Folder where WzFsGate server log is saved (It must be made before using) &'k(v(>n,
&'k(v(>n,
B. Data management for GameServer &'k(v(>n,
C. O/S, in Windows Server subfolder, open ‘C:\WINDOWS\system32\drivers\etc\hosts’, and then put below subjects &'k(v(>n,
218.38.44.100 gsauth.muonline.co.kr &'k(v(>n,
D. Above IP is the game authentic server in Korea, and 55909 port is used. Therefore please check using be telnet on WzFsGate server host, and check as the method below. &'k(v(>n,
telnet gsauth.muonline.co.kr 55909 &'k(v(>n,
E. Execute WzFsGate.exe to check if it receives data properly. &'k(v(>n,
&'k(v(>n,
8. Installation of Connect Server &'k(v(>n,
A. File Structure &'k(v(>n,
\\ConnectServer\CS.exe : Connect Server execution file &'k(v(>n,
\\ConnectServer\DATA\ServerInfo.dat : Connect server information file &'k(v(>n,
\\ConnectServer\DATA\ ServerList.dat : Game server list information file &'k(v(>n,
&'k(v(>n,
B. Check the \CS\Data, ServerList.dat &'k(v(>n,
1. “Servercode, Servername, Serveraddress, Serverport check(“SHOW”/”HIDE”)” &'k(v(>n,
2. example) &'k(v(>n,
a. “0 "GameServer1-1" "10.1.100.4" 55901 "SHOW"” &'k(v(>n,
3. Severcode is the unique data in each game server, defined in ServerInfo.dat &'k(v(>n,
4. If serverIP which is sent as UDP data, to Connect server, and Servercode is not same, then game server is not added on the connect server list. &'k(v(>n,
&'k(v(>n,
C. Check \ConnectServer\Data, ServerInfo.dat &'k(v(>n,
[FtpServerInfo] &'k(v(>n,
Address = xxx.xxx.xxx.xxx ;Client Auth Patch FTP address &'k(v(>n,
Port = 21 ; FTP Port &'k(v(>n,
ID = MuUpdate ; FTP account &'k(v(>n,
PASS = MuUpdate &'k(v(>n,
&'k(v(>n,
[GameServerInfo] &'k(v(>n,
ClientVersion = 00.98.03 ; Client Normal server version &'k(v(>n,
ClientVersion_TEST = 00.98.03 ; Client Test server version &'k(v(>n,
VersionFileName = version.wvd ; version information file p__wBUB
p__wBUB
p__wBUB
9. Installation of Ranking Server p__wBUB
A. File Structure p__wBUB
\\RankingServer\MU_RANKING_DB_SERVER.exe : Ranking server execution file p__wBUB
\\RankingServer\svconfig.ini : Ranking server setting file p__wBUB
p__wBUB
B. Ranking server is available only 1 in total game server system(except China) It saves the ranking from DevilSquare, BloodCastle. p__wBUB
p__wBUB
C. Creation of Ranking DB p__wBUB
i. DB for event ranking information management. p__wBUB
ii. Choose master DB p__wBUB
iii. Using Query Analyzer, find the folder \\DbScript\Ranking , then open and execute Ranking_CreateDB.sql, Ranking.sql p__wBUB
1. File Structure p__wBUB
\\DbScript\Ranking\Default_ODBC.txt p__wBUB
\\DbScript\Ranking\Ranking.sql p__wBUB
\\DbScript\Ranking\Ranking_CreateDB.sql p__wBUB
p__wBUB
iv. Check the availability of Ranking DB and Table and SP p__wBUB
v. Table and SP which are created in DB, please refer to the document. p__wBUB
p__wBUB
D. ODBC setup p__wBUB
Refer to \\DbScript\Ranking\Default_ODBC.txt p__wBUB
p__wBUB
E. Check the information in \RankingServer\Data, svconfig.ini p__wBUB
p__wBUB
[odbc_setting] p__wBUB
dbname=Ranking p__wBUB
odbc_dsn=RANKING_DATA p__wBUB
odbc_uid=MuOnlineAdmin p__wBUB
odbc_pass=wkfwkRnfRnf p__wBUB
odbc_con_count=40 p__wBUB
p__wBUB
p__wBUB
[pim_setting] p__wBUB
queue_no=4 p__wBUB
workerthread_no=10 p__wBUB
p__wBUB
p__wBUB
10. Installation of Event Server p__wBUB
A. File Structure p__wBUB
\\EventServer\WZ_MU2003_EVENT_SERVER.exe : event server execution file p__wBUB
\\EventServer\DATA\svconfig.ini : event server setting file p__wBUB
\\EventServer\DATA\MU2003_MUTTO_NUMBER.TXT : event server data file p__wBUB
p__wBUB
B. Event server is available only one in total game server system (except China). This server has the function for saving user data while event, and restoring prize information. p__wBUB
p__wBUB
C. MU2003_EVENT_DATA DB setup p__wBUB
i. DB for event information management p__wBUB
ii. Choose master DB p__wBUB
iii. On Query Analyzer, find the folder \\DbScript\Event, MU2003_EVENT_DATA_CreateDB.sql, and then open and execute MU2003_EVENT_DATA.sql p__wBUB
1. File Structure p__wBUB
\\DbScript\Event\Default_ODBC.txt p__wBUB
\\DbScript\Event\MU2003_EVENT_DATA.sql p__wBUB
\\DbScript\Event\MU2003_EVENT_DATA_CreateDB.sql p__wBUB
p__wBUB
iv. Check the availability of MU2003_EVENT_DATA DB, Table and SP p__wBUB
v. Refer to the document about DB if you want to know about Table and SP p__wBUB
p__wBUB
D. ODBC setting p__wBUB
Refer to \\DbScript\Event\Default_ODBC.txt p__wBUB
p__wBUB
E. Check the folder \EventServer\DATA, and then svconfig.ini p__wBUB
p__wBUB
[pim_setting] p__wBUB
queue_no=4 p__wBUB
workerthread_no=4 p__wBUB
p__wBUB
[odbc_connection] p__wBUB
mu2003_dbname = MU2003_EVENT_DATA p__wBUB
mu2003_dsn = MU2003_EVENT_DB p__wBUB
mu2003_uid = MuOnlineAdmin p__wBUB
mu2003_pass = wkfwkRnfRnf