Basic Required Stuff before we begin the guide.
1. MSSQL 2000 or SQL 2005
2. The Server Files that i Uploaded
3. Basic sql knowledge
4. Power to follow the step :P
First Unpack the Server Files from the Archive to c:/XiahServer
thats will be our main server folder.
Step 1 : MSSQL 2000 Setup Guide.
Setting up SQL
Run SQL Setup
Select "SQL Server 2000 Components"
1. Click "Install Database Server"
2. Click Next
3. Click dot in Local Computer and Next
4. Click dot in "Create a new instance of SQL Server,or install Client Tools" and
next
5. Put name and company Click Next
6. Click Yes to Agreement
7. Click dot in Server and Client Tools and Next
8. Click dot in Default at top and Click Next
9. Click dot in Typical Click Next
10. Click dot in "Use the same account for each service.Auto start SQL Server
Service"
11. Click dot in "Use the Local System account" Click Next
12. Click dot in "Mixed Mode." and enter a password Click Next
13. Click Next and install
14. When installed reboot so server starts.
Step 2: Restoring Database.
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)
2. Console Root -> Microsoft SQL Servers -> SQL server Group ->
3. Right click (local)(windows) -> Edit SQL server Registration properties
4. Click dot in Use SQL Server authentication -> Login name sa -> leave
password blank -> click dot in Always prompt for login name and password
Now We creating New Databases.
lets start with XIAH database and you will know how to do the others.
5. Create a new database, name it XIAH
6. After that, right click on XIAH database then click all tasks and
then "Restore Database".
7. Click on "From Device" and then click on "Select Devices".
8. Click Add and then choose the destination of the backups to Restore into
XIAH.
9. Press OK 3 times to continue, then press the Options tab.
10. Click dot in "Force restore over existing database",
11. Make sure the path of the MDF and LDF files is the same of your server files
(XIAH_data and XIAH_log)
12. Press OK to import the database.
Do The same with all the other Databases
XIAH_ACCOUNT,XIAH_Log,XIAH_SERVER
13. Console Root -> Microsoft SQL Servers -> SQL server Group ->
(local) (windows)
14. Go to Security -> Login -> Right click -> New Login
15. Put name xiah -> Click dot in sql server authentication
16. use xiah as password -> Choose Master as database
17. Go to tab Database access -> click on database XIAH,XIAH_ACCOUNT,XIAH_Log,XIAH_SERVER
18. In permit in database role click on db_owner -> ok
19. Go to database XIAH,XIAH_ACCOUNT,XIAH_Log,XIAH_SERVER -> Right Click -> Properties -> Permission
Click all of them on user xiah
Step 3 : ODBC Setup.
1. Start Data Sources (ODBC) (Start -> Programs -> Administrative Tools -> Data
Sources (ODBC)), go to System DSN tab then click Add.
2. Select the SQL Server driver(bottom) and click Finish. Choose Xiah for
Name and your SQL Server for Server.
3. Choose sql server authentication -> connect to sql server to obtain settings
Use xiah/xiah as user click Next then Finish and OK.
5. Do the same for Xiah_Account,Xiah_Log,Xiah_Server.
Step 4 : Registry and Services Adding.
now its a Important part of the server setup!
follow the steps and its will works to you!
1. go to the main server files folder(c:/XiahServer)
and you should see "Install Folder" and in it you will see 6 registery script's.
before we editing them we should do more important part of Encrypted
password. get into the main server files folder(c:/XiahServer) you should see
a small tool that called "MakeDBPW.exe" load it.
now write xiah and you will get Encrypted Password.
its should to looks like that. "2FA0D9F35F3043D7FF42161B240D8570"
now we begin to edit the "Registry" files that i said before.
open the them with notepad and you should have to change that 2 lines!
"DBPasswd"="2FA0D9F35F3043D7FF42161B240D8570" <---Encrypted Password
"LocalAddr"="write wan or lan ip's"
now the Registry and the Windows Services are been updated with
the required information!
do the same in all the registry files!.
after you done that step you should have to load the "bat" files that you
should see in the same "Install Folder" they called in the same names!
Watch in the Picture!
-----------------------------------------------------------------------
Step 5 : Editing 2 Tables in Xiah_Server Database.
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)
2. Console Root -> Microsoft SQL Servers -> SQL server Group ->
(local) (windows NT) -> Databases -> XIAH_SERVER -> Tables
Left Click on SERVERCONFIG Table -> Open Table -> Return all Rows
and you should have to edit 3 colunm's
"szServerName" <<--- write your WAN/lan IP
"szIpAddress" <<--- write your WAN/lan IP
"szInstallPath" <<--- Change the path to your server files folder (c:/XiahServer)
Take a look into the Picture."szInstallPath colunm " <<-- its should looks like that C:\XiahServer\MsgSvr.exe C:\XiahServer\UpgradeSvr.exe C:\XiahServer\AuthSvr.exe C:\XiahServer\ControlSvr.exe C:\XiahServer\UnitSvr.exe C:\XiahServer\MapSvr.exe C:\XiahServer\UnitSvr.exe C:\XiahServer\MapSvr.exe
Now do the Same in "SERVER LIST" TABLE!
take a look on the picture
ok the Server Setup is Actually done :P
Part 6 : Server Startup!
1. Open Services (Start -> Control Panel -> Administrative Tools ->
Services
you should see 5 Services!
1. Upgrade
2. Msg
3. Unit
4. Map
5. Auth
right click on them and start! wait until the first one load up
and keep load all the 1-5! do not change the loading list!
keep it like that.
Watch on the Picture.
now the server is up and we left 1 thing before we getting in game.
Step 7 : Client Configuration.
1. unpack the client that i uploaded. <<- (XiahChinaFull(20061116)-v448)
for now its the only client that we success to run with our server files.
2. Unpack the Launcher files that i uploaded into the main client folder.
its will ask you if you want to agree to change to other files push "yes".
3. open zone.ini with notepad and its should looks like that.
127.0.0.1
EliteAk47
Ragezone