Shaiya Private Server - Instructions - English

ZeroSignal · 05/06/2009, 17:25

Shaiya Private Server

REQUIREMENTS:
1) Minimum Operating System Windows XP Professional Service Pack 3

2) Minimum M$ SQL Server 2005 (Needs to have Mixed Mode Authentication Win NT & SQL Authentication).

3) Make a D: Virtual Partition if u don't already have one:

4)

(Episode 3, Ep4 clients work but buggy).

INSTRUCTIONS:
Install Win XP SP3 and SQL Server 2005 or higher.

Copy the Shaiya Test Server to "D:\SHAIYA_SERVER\SERVER".

Note - Must use exact path or it will not work!!

Install_Server
1) Run "Install_Server.bat".

SQL Authentication
User: "Shaiya", Password: "shaiya123"

Game Login Admin
User: "admin", Password: "admin123"

2) Server Patch Config.

Go to Server Setup >> Apply to Windows Registry, exit.

Then Computer will Restart.

Server Patch Config

Run "PSM_Server\PSM_ServiceMgr.exe".
Close then re-open Server Patch Config.
In Menu, Server Setup >> Service Install All.
Be patient it takes a while for all Shaiya Services to register and be Paused.
In Menu, Control Service >> Start All Server Service.
If any fail to start right click on them in the Tree View and click Start.
Close version checking:
Select Logins >> Login01, right click, then Command. Enter "/vchkoff" press Enter.
(Type "/help" command for more info on available commands).
Close NProtect verification:
Select GameGroups >> GameGroups01 >> Game, right click, then Command. Enter "/nprotectoff" press Enter.
(Type "/help" command for more info on available commands).
Note - The Server Patch Config Application is buggy!!
I've found that it does not change the ini files correctly sometimes causing Game Server crashes.
If it happens look through "PSM_Client\Bin\Config\*.ini" files and check that all settings are correct.

What I found to be wrong was:
ps_login.ini, line 13, 1st Argument should be your Game Server name, not "Game".

Hopefully if you have done everything correctly now your Server should be running.

Final Configuration for Local Server:

SETUP US CLIENT FOR SERVER:
Open up the game.exe client in a hex editor, use find and enter "72.55.177.194". When it's found change it to your Login Server IP Address. Make sure all bytes are preserved (insert over), fill with null bytes. I recommend using HxD (free) or Hex Workshop.
Create shortcut with arguments added to end of Target "start game".

COMMENTS:
* Research any issues, if you don't bother doing any research and tutorials on Databases, SQL, Configuration Files, we won't help you. Google is your friend.

FAQ

I have no D: Drive
Well make a virtual one.
PSM_Server_Mgr.exe: Cannot apply Server Update >> Update to all Server
Go to Server Setup >> Apply to Windows Registry, exit and restart Computer.
Client does not match Error.
PSM_Server_Mgr.exe: In Server List, expand Login, right-click on Login01, click command, enter "/vchkoff" (without quotes).
Type "/help" for other commands.
Client Disconnects after a minute.
PSM_Server_Mgr.exe: In Server List, expand GameGroups >> GameGroups01, right-click on Game, click command, enter "/nprotectoff" (without quotes).
Type "/help" for other commands.

CREDITS:
yn126 - Thanks for the Server S/W, and Instructions.
nubsy - Made the effort to help me out with elaborated Instructions.
Twilight - Assisted in clean DB.
And anyone else who has contributed!!

REFERENCES:

wanteds · 05/07/2009, 00:50

hello,

i get server up without issues, i have edited my game.exe and i connect to my own server, login , select game server then i get an error "Cannot connect to game server!!!" error...
i'm using teh US client.
i don't see any errors in server logs.

(about userLog.ini fault , when i fix it from userData to userLog, i see 2 sp not found errors ... and all 30 tables in UserLog are empty?)

i have tried it in couple ways i still get "cannot connect to game server" error after selecting my server.

any idea?

ZeroSignal · 05/07/2009, 04:13

Quote:

Originally Posted by wanteds

hello,

i get server up without issues, i have edited my game.exe and i connect to my own server, login , select game server then i get an error "Cannot connect to game server!!!" error...
i'm using teh US client.
i don't see any errors in server logs.

(about userLog.ini fault , when i fix it from userData to userLog, i see 2 sp not found errors ... and all 30 tables in UserLog are empty?)

i have tried it in couple ways i still get "cannot connect to game server" error after selecting my server.

any idea?

Yes check all the ini files, that the Public IP address has been changed to your Private IP Address and is correct, and all the other information.
I had the same issue and it was due to corrupt ini files. Post each ini file between code tags here and I will take a brief look for you (labelling each one).
D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\*.in i

Please note that posting a Private IP Address is not really exposing any security risks, if you posted a Public static IP Address then it would be a security concern.

wanteds · 05/07/2009, 12:32

Ok so i tried many stuff, but still wont work so here are teh ini files

PS_dbAgent.ini

Code:

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, sa, E87CD06124E9A7291C6A2A681466E626DACA9242EABEB48F00989D33804015EED6D8E01A652F9E2EED9472CE5DA67C31C229D9EECF163B258CB5D0DD4A9FD2A60C72764F9EF9CA76CAF760D7119DC502232ED050E99C2E7DD9AB0DB405133E5A6EEAEE87328F09465E2B582EF0766139DB49431666D37371B1263CFC12D4F13A
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_game.ini

Code:

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=150
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, sa, E87CD06124E9A7291C6A2A681466E626DACA9242EABEB48F00989D33804015EED6D8E01A652F9E2EED9472CE5DA67C31C229D9EECF163B258CB5D0DD4A9FD2A60C72764F9EF9CA76CAF760D7119DC502232ED050E99C2E7DD9AB0DB405133E5A6EEAEE87328F09465E2B582EF0766139DB49431666D37371B1263CFC12D4F13A
GameData=127.0.0.1, PS_GameData, sa, E87CD06124E9A7291C6A2A681466E626DACA9242EABEB48F00989D33804015EED6D8E01A652F9E2EED9472CE5DA67C31C229D9EECF163B258CB5D0DD4A9FD2A60C72764F9EF9CA76CAF760D7119DC502232ED050E99C2E7DD9AB0DB405133E5A6EEAEE87328F09465E2B582EF0766139DB49431666D37371B1263CFC12D4F13A
[GAMEINFO]
GameName=rAvePWNZ
GamePublicIP=127.0.0.1
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_gamelog.ini

Code:

[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, sa, E87CD06124E9A7291C6A2A681466E626DACA9242EABEB48F00989D33804015EED6D8E01A652F9E2EED9472CE5DA67C31C229D9EECF163B258CB5D0DD4A9FD2A60C72764F9EF9CA76CAF760D7119DC502232ED050E99C2E7DD9AB0DB405133E5A6EEAEE87328F09465E2B582EF0766139DB49431666D37371B1263CFC12D4F13A
DBChat01=127.0.0.1, PS_ChatLog, sa, E87CD06124E9A7291C6A2A681466E626DACA9242EABEB48F00989D33804015EED6D8E01A652F9E2EED9472CE5DA67C31C229D9EECF163B258CB5D0DD4A9FD2A60C72764F9EF9CA76CAF760D7119DC502232ED050E99C2E7DD9AB0DB405133E5A6EEAEE87328F09465E2B582EF0766139DB49431666D37371B1263CFC12D4F13A
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

ps_login.ini

Code:

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=150
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, sa, E87CD06124E9A7291C6A2A681466E626DACA9242EABEB48F00989D33804015EED6D8E01A652F9E2EED9472CE5DA67C31C229D9EECF163B258CB5D0DD4A9FD2A60C72764F9EF9CA76CAF760D7119DC502232ED050E99C2E7DD9AB0DB405133E5A6EEAEE87328F09465E2B582EF0766139DB49431666D37371B1263CFC12D4F13A
[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=rAvePWNZ


[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_session.ini

Code:

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=rAvePWNZ

[LOGFILE]
Replace=0
Append=1

[MONITOR]
Enable=0
Port=50000

ps_userlog.ini

Code:

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, sa, E87CD06124E9A7291C6A2A681466E626DACA9242EABEB48F00989D33804015EED6D8E01A652F9E2EED9472CE5DA67C31C229D9EECF163B258CB5D0DD4A9FD2A60C72764F9EF9CA76CAF760D7119DC502232ED050E99C2E7DD9AB0DB405133E5A6EEAEE87328F09465E2B582EF0766139DB49431666D37371B1263CFC12D4F13A
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

there u go, i seem to be overlooking something, i dno

wanteds · 05/07/2009, 13:26

ok soooo

in ps_game.ini i changed the version to "0x08022100" instead of "0x00000000" (which isn't supposed to matter)
and GamePublicIP to "192.168.2.5" instead of "127.0.0.1"

i had changed the name in all config files as u see, but in mngr i still saw the chinese name! i changed taht aswel, installed all, and started server ... now i can login, select server and go on, problem solved!

NEW EDIT : now i get ingame, no mobs spawned, /getitem dont work, and mmake says not authorized all weird :s

destroyer667 · 05/07/2009, 20:03

What if i cant put stuff in D:/ ... i only have C:/ , D:/ is my CD-Rom or w.e unless you guys are doing something different then me.

D:\SHAIYA_SERVER\SERVER <--- cant do that

this is what i have
"C:\Documents and Settings\Name\Desktop"

any tips? or can i put it in D:\ some how

I tried Extracting the folders to D:\ but it says "Cannot create folder D:\"

~~~ Also i found this SQL 2000 , Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A

i couldn't find the one u told me about on the other thread so im gonna try installing that one and updating it to Service pack 4 (SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE) from the MS site so.. i hope im on the right track. i have seriously looked for just SQL 2000 and other versions for atleast 4 days trying different names torrents ect... everything i really cant find it so thats the only one i found and im really good at using google, its just a hard program to find -.-

wanteds · 05/07/2009, 22:35

some dude posted one on r - a - g -ezone

and when u put it somewhere else , like most of us, then u just have to change all teh paths in ini files ^^

ZeroSignal · 05/08/2009, 10:26

@destroyer667
You can move the drive name of your CD-ROM, in Windows, Control Panel >> Administrative Tools >> Computer Management. Storage, Disk Management.

Also can create a virtual drive, by opening Command prompt and typing:

Code:

mkdir C:\D_Drive
subst D: C:\D_Drive

use subst /? For manual.

destroyer667 · 05/08/2009, 14:50

i got that part working ect... my only problem is SQL 2000 can someone zip it and put it on rapidshare or something i honestly cant find it at all... i've searched everywhere torrents... google... i looked on the MS site and the one i told you about above well it was a virus so can someone zip the one they have and post it here? it would go good with the tutorial you set up

ZeroSignal · 05/08/2009, 23:32

Quote:

Originally Posted by destroyer667

i got that part working ect... my only problem is SQL 2000 can someone zip it and put it on rapidshare or something i honestly cant find it at all... i've searched everywhere torrents... google... i looked on the MS site and the one i told you about above well it was a virus so can someone zip the one they have and post it here? it would go good with the tutorial you set up

klugor · 05/09/2009, 00:19

hello has all which IP is necessary it to change? ^^

blastered · 05/09/2009, 00:29

Quote:

Originally Posted by klugor

hello has all which IP is necessary it to change? ^^

SETUP US CLIENT FOR SERVER:
Open up the game.exe client in a hex editor, use find and enter "72.55.177.194". When it's found change it to your Login Server IP Address. Make sure all bytes are preserved (insert over), fill with null bytes. I recommend using HxD (free) or Hex Workshop.
Create shortcut with arguments added to end of Target "start game".

klugor · 05/09/2009, 00:39

sorry I have the customer francais and therefore this is not doubtless the meme IP merçi for the rapidider of your reponse when meme

destroyer667 · 05/10/2009, 11:12

Thanks for the link Zero

destroyer667 · 05/10/2009, 11:15

Klugor try the 72.55.177.190 ip but i also see the 72.55.177.194 ip in there as well, or u could download the US version