EDITED:
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 (I found one of the ini files is responsible for it, not sure which).
Regarding Virus's post. This seem to be EP4 DB, but it lacks EP4 data. I mean EP4 skills are not configured. PS_GameDefs.Items has less records in it than EP3 one and it's in chinese or korean. I found the EP4 server has older NPC.Sdata file. I extracted mine from Data.saf and copied to server directory
No more problems with NPC's.
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.
[there should be a better way than attaching, if someone knows please tell us]
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. You can use EP3 PS_Game.exe if you wish, however I figured out how to make the new one work. Copy
kr_string.db file to your
PSM_Client\Bin\Data dir. It contains sentences the jungle/desert bosses say. Anyone up for translation?
2) Make backup copies of:
- PS_GameData
- PS_GameLog
- PS_GMTool (unsure about this one, but what the heck)
- PS_UserData
Ok. I have to appologize to anyone who had their server working and lost Chars, accounts etc. Creating backups and restoring databases later flushed all the data except what I had after first server install or I'm too newbie to restore properly. Anyway, there's a simpler and better solution to it. Just rename the EP3 DB's in case you need them. This way you won't get the Error: "Database exists" when attaching a new one.
I encountered a problem with Attaching DB's. When I turn DB server Off and On MSSQL has problems finding them. I'm not sure why, because I didn't change their location.
3)Runing the server at this point will yield an error: Linked server not found.
Two new servers need to be 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
Just run the query twice with different server names.
4) You also need configuration files. The ones found in DATA directory. Such as "Map.ini; Obelisk.ini". Go ahead and replace some but DO make backup copies. One of the files messes up GUI.
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.
Ok. I forgot to add. What I wrote is highly experimental so you are doing it at your own risk. I am still finding errors and bugs. I might post some of them.
If anyone has it working and can test as well it'd be of great help.
can u tell me how to install sqle?
. Maybe they'll be of use to you.
