[Guide]Xiah Server Configuration

[EliteAk47]

Hey friends. i am making that guide to provide you guys all what needed to setup your own server. but its not the point...
we need to work together to get the best performed of developing.
we have much work to complete before its will be playable!
much translation work and bug fix. we have for what to expect in the feature.
its a great mmorpg game with a good story. mental now you have a good reason to give us our section .


Basic Required Stuff before we begin the guide.
1.

To view the content, you need to sign in or register

or

To view the content, you need to sign in or register

2. The Server Files that i Uploaded
3. Basic sql knowledge
4. Power to follow the step

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)

"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

Take a look into the Picture.

Now do the Same in "SERVER LIST" TABLE!
take a look on the picture

ok the Server Setup is Actually done

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

 

[Kolliper]

Re: Xiah Server Configuration Guide[Updated]

ok,

but elite what you forgot is that they also need to port forward there router otherwise your friend cant joine.

search on google how to port forward your own router.

ports to forward:
~8100
~8500
~8600
~9800
~9000
~9500

without the ~!!

also for the ip you need to enter is =

To view the content, you need to sign in or register

 

[zarut]

Re: Xiah Server Configuration Guide[Updated]

To add databases faster do first mssql installion like ak said and after that when you need add databases do it like this, go to tools->SQL Query Analyzer and paste this there:

USE [master]
GO
CREATE DATABASE [xiah] ON
( FILENAME = N'C:\Databases\XIAH.mdf' ),
( FILENAME = N'C:\Databases\XIAH_log.ldf' )
FOR ATTACH

USE [master]
GO
CREATE DATABASE [xiah_server] ON
( FILENAME = N'C:\Databases\XIAH_SERVER.mdf' ),
( FILENAME = N'C:\Databases\XIAH_SERVER_log.ldf' )
FOR ATTACH

USE [master]
GO
CREATE DATABASE [xiah_account] ON
( FILENAME = N'C:\Databases\XIAH_ACCOUNT_Data.mdf' ),
( FILENAME = N'C:\Databases\XIAH_ACCOUNT_Log.ldf' )
FOR ATTACH

USE [master]
GO
CREATE DATABASE [xiah_log] ON
( FILENAME = N'C:\Databases\XIAH_LOG.mdf' ),
( FILENAME = N'C:\Databases\XIAH_LOG_log.ldf' )
FOR ATTACH

And press the green play button.
NOTE! you must have Databases folder on C: driver and that folder must have those files in... makes steps 5-12 alot faster and easier.

 

[terzo]

Re: Xiah Server Configuration Guide[Updated]

Nice post Elite.

 

[Kolliper]

Re: Xiah Server Configuration Guide[Updated]

well now we need our own xiah section and starting developing

 

[zarut]

Re: Xiah Server Configuration Guide[Updated]

Ive found way to sniff packets, but dont know how to decrypt so terzo, ak i need you guys add me to msn 56uruiro6t and we see what we can do ill tell more in msn

 

[Kolliper]

Re: Xiah Server Configuration Guide[Updated]

now we only need our own section and we can start develop hardcore

 

[zarut]

Re: Xiah Server Configuration Guide[Updated]

Translate monsters in less than 5minuts!!
start Query Analyzer, fill infos if it ask (db account and password) then do this:

UPDATE NPCLIST
SET szName = 'Bull'
WHERE bNpcType = '2'

So now it changes every monster name that type is 2 to Bull, theres only one problem that is it even make bull leader to have name bull but u can try do it like this

UPDATE NPCLIST
SET szName = 'Bull'
WHERE bNpcType = '2' and dwJobPattern = 0

dunno if that work but try, if it does work you gotta find bulls whit chinese names manually and change to bosses...
heres list of all monsters in china xiah if some monsters miss tell me

Look NPC text file how to translate every NPC...

 

[Kolliper]

Re: Xiah Server Configuration Guide[Updated]

zarut this would work for the npc's
but since we have special mobs like wandering wild boar or wild mad dog, we will need a age taking process called: Searching. ofcourse this is very handy for the normal npc's ofcourse we have different fallen man people so they should be searched aswell.

currently i translated mad dogs/wild boars/fighting bull/archers(still some have numbers)/

 

[zarut]

Re: Xiah Server Configuration Guide[Updated]

zarut this would work for the npc's
but since we have special mobs like wandering wild boar or wild mad dog, we will need a age taking process called: Searching. ofcourse this is very handy for the normal npc's ofcourse we have different fallen man people so they should be searched aswell.

currently i translated mad dogs/wild boars/fighting bull/archers(still some have numbers)/

UPDATE NPCLIST
SET szName = 'Bull'
WHERE bNpcType = '2' and dwJobPattern = 0

use that code it doesnt name any monster that is in game wandering boar and so on just normal ones, so after u used that its named every other monster but left chinese names for wild maddogs and so on you can easily go to npclist and change their names to asdasd1234 and then go in game to see what it is in reality ;D

 

[Kolliper]

Re: Xiah Server Configuration Guide[Updated]

hello all,

i made this application within c++ console to search for the x and y coordinates for adding new npc's to your database.

ok this works on prairie and volcano so i think it will work on all maps.
if you find bugs please pm them to me

To view the content, you need to sign in or register

its clean but if you don't beleave me scan it yourself

To view the content, you need to sign in or register

 

[zarut]

Re: Xiah Server Configuration Guide[Updated]

Exp/tp working now fine, download these again if u did download the earlier ones they are crappy and dont work so good..

 

[zarut]

Re: Xiah Server Configuration Guide[Updated]

I just decrypted chinese xiahclient, what means we can start translating client string finaly.

Heres the decrypted client, use hex editors as ultraedit32 and so on to translate it once i finish translating my client i post it here too but heres decrypted client in chinese.

 

[EvilInDeed]

Re: Xiah Server Configuration Guide[Updated]

I just decrypted chinese xiahclient, what means we can start translating client string finaly.

Heres the decrypted client, use hex editors as ultraedit32 and so on to translate it once i finish translating my client i post it here too but heres decrypted client in chinese.

Heh nice work Zara

 

[legenda1]

Re: Xiah Server Configuration Guide[Updated]

can some one entry in My Pc with Winvnc or Radmin to create the server ?
:kisss:

 

[EliteAk47]

Re: Xiah Server Configuration Guide[Updated]

can some one entry in My Pc with Winvnc or Radmin to create the server ?
:kisss:

all already explained in the Guide.

Update -
Monster names Translated 100%
NPC's Name Translated 100%

i still waiting for bakabug for decryption (xiah us exe....)

 

[legenda1]

Re: Xiah Server Configuration Guide[Updated]

Man i have a problem with this
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.


get Erors

 

[changming22x]

Re: Xiah Server Configuration Guide[Updated]

all already explained in the Guide.

Update -
Monster names Translated 100%
NPC's Name Translated 100%

i still waiting for bakabug for decryption (xiah us exe....)

Elite Can u post a small tut on how to make the server with SQL 2005 version because MSSQL 2000 dont seem to install on my comp.... thank you

 

[pippin125]

Re: Xiah Server Configuration Guide[Updated]

etetetet

 

[Kolliper]

Re: Xiah Server Configuration Guide[Updated]

guys dont go spamming within this topic i will try to make a new server(old server was in mssql2000)with sql 2005.

lol i cant even can do the setup of sql 2005 get errors like no tomorrow. so i will go back on the mssql 2000