Shaiya Private Server Video Tutorial

[arutema]

Hi all i'm new here and not the kind of guy who talks in forums... Anyway i see alot of post asking about the server not working or why i have red cross etc. So i make this Video tutorial to help all ppl here and make life easy for everyone.

First here u will see step by step how to Install and configure SQL and SSMSEE

Theres a better tutorial here

Here it will show how to setup the server and shows how to fix the "name in use" too

Part 1

Part 2

Now here is the code to fix the "Name in use"

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

Here you all can find how to Configure the server and download SHAIYA_LITE_SERVER

And here how to setup Shaiya with EP4


From here you can download the EP4 NO-GG game.exe (just need to change ip for 127.0.0.1)


Hope this can help ALOT of ppl here and i will just say i'm just a noob so don't ask things because i'm sure i will not be able of answer...


I want to say thx to ProfNerwosol and ZeroSignal for their guides it helped me alot.
And thx to KaliKid for his Video and guide about SQL and SSMSEE.

COMMENTS: I'm using windows UE because of that i had to start the process manually but i had done that on windows xp Profesional and it worked without doing that

PS: a friend of mine gave me the code so idk to who belongs but anyway i will give thx because of that person now i can fix that problem.
And sorry for my english is not my main language

[XXXShaiyaXXX]

How can i open PS_GameData?

EDIT: Opened in SQL and pasted that code but doestn work. Btw are you german?^^

[arutema]

No im not german... did u see the video tutorial part 2 min 7-8 u need to execute the script and see if it show u any errors.
If u can post why kind of problem do u have maybe i can try to help but im not a expert on this just a noob trying to help ppl lol

[XXXShaiyaXXX]

Yeah i saw it i did it like you after saving a window appeart that is like the one u got in your video i pressed ok or yes and started my server but i still got the problem.

EDIT: forgot to execute xDDD now my server is running fine TY YOU VERY MUCH BRO!

[buckyisdalegend]

need all the help i can get can u put some more steps

[arutema]

more steps? i recorded all the steps theres no more to do... what kind of problem do u have?

[buckyisdalegend]

well it goes to the green arrows for about 5 secs then goes bak to green puase got any ideas

[arutema]

did u tried to start the proces manually? from my experience trying to config the server maybe u have not installed SQL and SSMSEE like the first Video try to uninstall and install all again following the videos step by step...

[buckyisdalegend]

ok ty for ur help
but ihave reinstalled 3 times now
but it says need to allow remote connections
any ideas

[Danco1990]

Going back to green ( > ) state while server files are non edited, 99% of the time this is to blame on SQL. Turn the tcp/ip named pipes whatever there is on, and try again after a reboot.

[winforce]

nice post nice good man

[KaliKid]

First of all, you should ask permission before posting my video or at least give credit for it, instead of saying you made it.

[paketon]

men tienes skype ?

[arutema]

about what video u talking about? if u talking about the SQL and SSMSEE srry i did not know if the owner was still active in youtube... but if u talking about the part 1 and 2 video u must be kidding because i recorded that
and btw if u post something in youtube ALOT of ppl will use it and post it next time put ur video in private

[KaliKid]

Originally Posted by arutema

about what video u talking about? if u talking about the SQL and SSMSEE srry i did not know if the owner was still active in youtube... but if u talking about the part 1 and 2 video u must be kidding because i recorded that
and btw if u post something in youtube ALOT of ppl will use it and post it next time put ur video in private