[Video Tutorials] Shaiya EP4 Private Server By Omega

[Wmollyxs]

So i have another problem >.< >.< >.<
i start all server then they go back to pausei start all server then they go back to pausei start all server then they go back to pausei start all server then they go back to pause ç_ç
lol what i must to do?
Thnks^^ (i'm a noob don't use complicated words xDDDDD)

[JohnHeatz]

Would you even mind reading complete threads? that question has been asked and answered hundreds of times already, start using the search, if you can't set a server up with all the tutorials and fixes for pretty much every error you get, then there is a huge problem because when you get your server, if you get it, i assure you that you will get unexpected errors and if you are not able to fix them by yourself your server won't last long at all

[iowaguy86]

Originally Posted by Wmollyxs

So i have another problem >.< >.< >.<
i start all server then they go back to pausei start all server then they go back to pausei start all server then they go back to pausei start all server then they go back to pause ç_ç
lol what i must to do?
Thnks^^ (i'm a noob don't use complicated words xDDDDD)

When they turn back to ||, right click them and click start. You may have to keep doing this until they all stay >. This happens to me every time I start up the server. Just keep trying and they'll eventually all stay >.

ALSO, I beg of you, before you make another single post.. read every single post on this thread. When you run into the disconnect problem or the "account does not exist" problem (which you most likely will), you'll know where to look before creating another post.

[Wmollyxs]

Originally Posted by iowaguy86

When they turn back to ||, right click them and click start. You may have to keep doing this until they all stay >. This happens to me every time I start up the server. Just keep trying and they'll eventually all stay >.

ALSO, I beg of you, before you make another single post.. read every single post on this thread. When you run into the disconnect problem or the "account does not exist" problem (which you most likely will), you'll know where to look before creating another post.

Yep i know, but really i have read posts on this topic, so i didn' understand ç_ç...xP
so, the process to start the server is virtually infinite, but i try : P

the problem perxsist....nothing to do =(...i readed posts but i don't understand.

[Svinseladden]

i have fixed 20 servers in here now with the same prob. they changed from sql 2005 to sql 2008r2. might fix it. but not 100% sure. but fixed all i tried it on.

[darkpepo]

Hi first of all ty so much for this fantastic post ^^.

I follow all the steps and do every single thing in the vids. All running perfect but the minute I enter in the shaiya game, i type the default user and pass, I select the server and start to load but an error message come out and says " Faliled to connect to server !!! ".

Whast am I doing wrong ???

Ty again ^^.

PS: I use windows 7, and i tried nearly all solutions :S, I read al 45 pages of this threat I even used de SEARCH BUTTON , im desperate :S.

[Wmollyxs]

I'm really sorry but i have another problem...when i want to axeed server appear this: failed to connect game sever
ç_ç plsss help me...

[JohnHeatz]

And that is exactly another common issue that has been adressed already on other porsts, search for them with the Search Engine

[Bendix 2]

hi i have the problem " failed to conect to game server !!!"
pls help

[midicreation]

Try this :

go to \PSM_Client\Bin\Config

open up ps_game.ini

look for the line GamePublicIP=whatismyip.com and replace whatismyip.com with ip address of the game server (127.0.0.1 if you're running client on the same computer as the server, local ip address of server computer (i.e. 192.168.1.45) if running server on a different computer than you are running the client or external ip address if you have a remote server).

Save the file and restart your server

[Bendix 2]

I can log in but wenn i creat a char says: name already in used

pls help me again ^^

[Wmollyxs]

ok now i post a problef i think no one post U.U......when i select my character, he say: Charachtern name already in use
Thank u......(this is my last problem U.u) ((i think))

[paltano3]

name already in use :S

[Wmollyxs]

Originally Posted by paltano3

name already in use :S

lol i've the same problem

[JohnHeatz]

The fix for the "name already in use" has been adressed plenty of times.

This is the SQL Query you need to run to fix the issue:

USE [PS_GameData]
GO
drop procedure [dbo].[usp_Save_Char_Item_Add_E]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/


CREATE Proc usp_Save_Char_Item_Add_E

@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@MaketimeZ varchar(50),
@Maketype char(1)

AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)
--SET NOCOUNT ON

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

--SET NOCOUNT OFF



GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

credits to arutema