Shaiya EP5

thx ProfNerwosol for your support ..great job

can use the Last Version of "US Client" in this Server Files ?

Quote:

Originally Posted by sandolkakos can use the Last Version of "US Client" in this Server Files ?

Yes this is ep4 and US have Ep4 so it should work fine..

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.

Quote:

Originally Posted by ProfNerwosol I am using Microsoft SQL Server Management Studio Express and MSSQL Server 2005 Express . What I wrote below is based on it. Enjoy.

How did u install sql e? i installed SQLE on my VPS but server don't work :( can u tell me how to install sqle?

I am actually considering making a tutorial based on MSSQL Express 2005 (it's free, doesn't take much space and with Management Studio is great for Shaiya). Most of the experienced users don't help anymore so I guess us unexperienced have to help each other :)

Anyone willing to assist PM me.

Quote:

Originally Posted by Hitaxas Cool stuff. Can we get some screenshots please? I'd love to see this new login and some ingame screens. :)

I forgot to mention. I was using Evolution Closed Beta client. That's why things got messed up. With EP4 client everything is okay.

Would it be possible for you to upload exactly what your using for the server for EP4 in a zip server + DB?.

I can run EP3 with no problems, but with EP4 im constantly getting error 0.

Microsoft SQL Server 2005 Express & SQL Server Management Studio Express

It is possible to run Shaiya on it, regardless of what some might say.

Here's the link:
[Only registered and activated users can see links. Click Here To Register...]


As to uploading. Check other pages of this topic. What you need is here.

Quote:

Originally Posted by ProfNerwosol Microsoft SQL Server 2005 Express & SQL Server Management Studio Express It is possible to run Shaiya on it, regardless of what some might say. Here's the link: [Only registered and activated users can see links. Click Here To Register...] As to uploading. Check other pages of this topic. What you need is here.

100% correct, ive been using SQL express for ep3 without any issues what so ever.

Not sure about EP4 however as i still cant figure out why its disconnecting :(

Hey ProfNerwosol,

I made a tutorial myself a long time ago, i might be intrested to help you if you allow me and tell me what you need, i can debug, configure and repair broken databases, and a few other things.... =P

Let me know what you think.

Danco

Sure!

I sent you a PM. Tell me what you think about it.

Quote:

Originally Posted by eM00 100% correct, ive been using SQL express for ep3 without any issues what so ever. Not sure about EP4 however as i still cant figure out why its disconnecting :(

I am preparing EP4 tutorial and will post my own files here. Nu, no big chages done don't expect fireworks ;). Maybe they'll be of use to you.

Quote:

Originally Posted by ProfNerwosol Sure! I sent you a PM. Tell me what you think about it. I am preparing EP4 tutorial and will post my own files here. Nu, no big chages done don't expect fireworks ;). Maybe they'll be of use to you.

Nice thanks ProfNerwosol,

I look foward to giving it another go xD

SORRY FOR THIS POST.
WAS A NOOB ERROR.
I DONT SEE THAT I WAS WITH LOW SPACE IN MY HD.

----------------
When i run this file, i get error in PS_STATICS_Log.LDF

Here it is people. The tutorial.

[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by ProfNerwosol Here it is people. The tutorial. [Only registered and activated users can see links. Click Here To Register...]

Looking,
Thanks very much for your share and tutorial my friend.

God Bless you and your family.