[Tut]Shaiya Private Server Instructions

[ihatehaxor]

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:
[Tut] How to make a Substitute D: Drive

4)

You must be registered to see links

(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

1. Run "PSM_Server\PSM_ServiceMgr.exe".
   
   
   
   
   
   
   
2. Close then re-open Server Patch Config.
   
   
   
   
   
   
   
3. In Menu, Server Setup >> Service Install All.
   
   
   
   
   
   
   
4. Be patient it takes a while for all Shaiya Services to register and be Paused.
   
   
   
   
   
   
   
5. In Menu, Control Service >> Start All Server Service.
   If any fail to start right click on them in the Tree View and click Start.
   
   
   
   
   
   
6. Close version checking:
   Select Logins >> Login01, right click, then Command. Enter "/vchkoff" press Enter.
   (Type "/help" command for more info on available commands).
   
   
   
   
   
   
7. Close NProtect verification:
   Select GameGroups >> GameGroups01 >> Game, right click, then Command. Enter "/nprotectoff" press Enter.
   (Type "/help" command for more info on available commands).
   
   
   
   
   
   
8. 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:
   
   
   
   
   
   
   
   
   
   
   

(continuation from other post)
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:
* Don't make noobish questions, 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.
  [Tut] How to make a Substitute D: Drive
  
• 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!!

Some extra Help :

Just For Anybody having Touble with the 5s Pause and Game Server
Connection Problems

MSSQL 2005 Express Does not work after 3 days of trying
on win xp, win vista and win 7

Win Vista With MSSQL 2005 Standard SP3 Worked First Go

Win 7 With MSSQL 2005 Standard SP3 Worked First Go

MSSQL 2005 Standard Doesnt work in XP Home

Hope this helps

- by jw988

 

[Abry]

Please give credits to where you originally got this guide.

 

[Chieftec]

I tried this setup online i got a problem after a moment all other services except the main services stop again. Its somewhere a db connect issue but i havent found a solution yet so if anybody experienced the same plz let me know how u solved it.
And if i find out why ill post the solution as well.

 

[ihatehaxor]

Can you take a screenshot of the error?
Don't get what you're saying.

edit//
Try to follow this

hello everyone,this time i will teach us how to set up shaiya server..

************************************************** **************************

Stressed, the path should be "D:\SHAIYA_SERVER", because it has a file path is set up well, if on the other disk, or some other folder will result in service not to start up, if friends do not want to put here Please modify "PSM_Client\Config\PSM_Service.ini" path. Keep this in mind!

Of course, need to be reminded that the best of your database is MSSQL Server 2000 and must be marked with the service pack 4.
And then we begin to attach database.

OMG_GameWeb
PS_Statistics
PS_UserData
PS_GameDefs
PS_GameData
PS_Billing
PS_ChatLog
PS_GameLog
PS_GMTool
PS_Monitor

one by one to attach..
.
.
.
.

this time we still have a database to create..not attach,i dont know why but it can't attach..let us restore it..
create database name as "PS_UserLog",then restore it.like me..

Then we create a new user name is Shaiya, the password is kickit.Of course, your password can not be called kickit, but you need to modify a lot of configuration files, the back, we will explain in detail.

Open Query Analyzer,and execute following code.Its role is to establish a database link.

=============================code================= ============
if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'Shaiya','kickit'
================================================== =============

Server options there are five check,choice them.

Now, we need to start a Microsoft's own services..Otherwise, When friends enter the game will be dropped after the case.
"Distributed Transaction Coordinator" Set Startup type to Automatic and start it.

Then we have to do is replace the IP, this time we need to use a tool and it is a Chinese language interface,if friends can not read Chinese, just follow my operation can be okay...

Did you still remember the three batch file under the instal folder? Aware of their role in it? Then will show their Role this time.

First of all, we run "服务安装.bat",Translated into English is "install service.bat",its role is install the services which Shaiya need.Then we running "服务启动. Bat", his role is just to start the service which We have just installed..And another file called "服务停止.bat" is use to stop the serveices(Of course, we don't have to run it now)....

We can running PSM_ServiceMgr.exe under PSM_Server folder after we start the service.
selected Login01,modify IP for your IP, the application of the closure process, and restart the program! Not back to show the red cross!

selected Main,modify Account for your MSSQL account,modify Passwd for your MSSQL password and!
Select GameGroups01 modify IP and server name!
After the election all ready,selected Server Update --- click Update to all server (exe, data files ..

Finally, select the menu [Control Service]->Start All Server Service.When all the services into the Green Triangle,Close version checking..
Close version check
Login01 - Right click,then click Command pop-up dialog box enter "/vchkoff" (Does not include the quotation marks),Press Enter!

close NP verification
Game - Right click,then click Command pop-up dialog box enter "/nprotectoff" (Does not include the quotation marks),Press Enter!

OK, Done!!!!

 

[Chieftec]

Nah found my error.
Was fault in the link server and in the db name from one of the db's. Be secure on the linkage thing the default settings of sql may cause some trouble at least it did for me.

 

[naruto820]

Hi will mssql server 2000 developers edition with sp4 update work?

 

[ZeroSignal]

Actually the only thing you did was copy/paste from another forum, and even then most of the content is broken.

The original Instructions:

You must be registered to see links

Check the Last edited date if you don't believe me.

Last edited by ZeroSignal; 06-30-2009 at 06:41.

 

[Vip3ra]

insted of your local area connection you can use the hamachi 1?

 

[ihatehaxor]

yea, you can use hamachi to connect to another server, but not everyone likes going on hamachi.

 

[JokerStud]

Hi will mssql server 2000 developers edition with sp4 update work?

It should work, give me a few minutes and i'll find out for ya.

 

[ledok]

It should work...

Does not work (bases will not be restored)
Read the tutorial

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

 

[Moonfly]

I know it says Xp sp3 but can it be put to work with Server 2003 enterprise x64?
I have server with that OS and i have 1 other game running on it so i hope it can work in there as well

 

[ihatehaxor]

Yea it should work.
I'm using Windows 7, and its working fine.

 

[Bakuretsu]

Whenever I click "Start all services" they all start but then 5 seconds later they all pause again. What have I done wrong?

 

[jw988]

Just For Anybody having Touble with the 5s Pause and Game Server
Connection Problems

MSSQL 2005 Express Does not work after 3 days of trying
on win xp, win vista and win 7

Win Vista 32bit & 64bit With MSSQL 2005 Standard SP3 Worked First Go

Win 7 32bit & 64bit With MSSQL 2005 Standard SP3 Worked First Go

MSSQL 2005 Standard Doesnt work in XP Home

Hope this helps

 

[ihatehaxor]

Just For Anybody having Touble with the 5s Pause and Game Server
Connection Problems

MSSQL 2005 Express Does not work after 3 days of trying
on win xp, win vista and win 7

Win Vista With MSSQL 2005 Standard SP3 Worked First Go

Win 7 With MSSQL 2005 Standard SP3 Worked First Go

MSSQL 2005 Standard Doesnt work in XP Home

Hope this helps

thanks ~ added to the main thread.

 

[jeannb]

how about MSSQL 2005 DEV?, how can create linking server on it?, i can't do it

 

[ihatehaxor]

Use the MSSQL's that are listed please.

 

[adamkoolkid2]

when i try to run PSM_Server/PSM_ServiceMgr it comes up with a window saying PSM_AgentServer, i click install and a weird message comes up and then quits

Also it says that the SQL does not allow remote connections. Ive set it it up to allow remote connections but its still saying it

 

[cobemongmo123]

How to sever share me