Whatever that is it has different Login screen. I managed to make it work somehow, patched it all up with files from tutorial and it works. Although loading bar is off synch as are other bars in game.
Before you start playing do backup copy of your current DB's, just in case something goes wrong.
Here's what I did:
Attached most of the DB's that didn't come with tutorial. I'm using MSSQLExpress 2005, there's an option 'Attach' when you right click on DATABASES.
CAUTION!!
Ok, this is tricky because if you don't know what you are doing, you'll have to install your old server from scratch.
I am using Microsoft SQL Server Management Studio Express and MSSQL Server 2005 Express . What I wrote below is based on it.
1) Do backups of all executable files in PSM_Client. I mean the PS_******.exe ones. Copy PS_***** ones from the EP4 server you downloaded from here. Except PS_Game.exe Leave the old EP3 one.
2) Make backup copies of:
- PS_GameData
- PS_GameLog
- PS_GMTool (unsure about this one, but what the heck)
- PS_UserData
Now, when you made backup's delete the databases ( UNSELECT THE OPTION: DELETE ALL BACKUPS!!), chose "Close all existing connection" and proceed. Right click on DATABASES and 'ATTACH'. Then just add the above databases and the ones you didn't have before.
3)Runing the server at this point will yield an error: Linked server not found.
There need to be two new created. Use the .... config.sql .... file from the tutorial. It's in "SHAIYA_SERVER\SERVER\Batch". There is a command adding linked servers. Copy it, paste as New_Query.
Quote:
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';
|
This. Everywhere where is 'game' change to:
1st server: PS_DEFINEDB
2nd server: PS_USERDB01
That should be all. Won't work? Scroll through logs. That's how I figured it out.
Btw, there is an user there already. User: 44003112, same PSWD.
Enjoy.
Shaiya EP4
