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 [Only registered and activated users can see links. Click Here To Register...]
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"
And here how to setup Shaiya with EP4
[Only registered and activated users can see links. Click Here To Register...]
From here you can download the EP4 NO-GG game.exe (just need to change ip for 127.0.0.1)
[Only registered and activated users can see links. Click Here To Register...]
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
First here u will see step by step how to Install and configure SQL and SSMSEE
|
|
Theres a better tutorial here [Only registered and activated users can see links. Click Here To Register...]
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"
Here you all can find how to Configure the server and download SHAIYA_LITE_SERVER [Only registered and activated users can see links. Click Here To Register...]Quote:
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
And here how to setup Shaiya with EP4
[Only registered and activated users can see links. Click Here To Register...]
From here you can download the EP4 NO-GG game.exe (just need to change ip for 127.0.0.1)
[Only registered and activated users can see links. Click Here To Register...]
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
