I have a problem with character creation.
It turns out that I could create my character dark without any problem but I encounter the bug name already used on my account ligth.
I used the fix name already used but without success.
I use a client ep5.4. I also followed this tutorial:
and other. But nothing to do.
this is why I can recreate a post is a topic
Thank you in advance.
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
Hello,
I just tried this but it still does not work I do not understand why. I already experience this problem and managed to solve it but it did not work from the beginning except that I've created a character (even 2) on my first account.
Thank you for esseyer if you have another idea I'm interested ^ ^.
Hello,
My problem still persists and that the other what his add (cape become invisible, change stuff or stats are not taken into account) I think having done something wrong but I can not see.
I will reinstall the server with server queues and non ep6 5 that I used and also sql 2012. Anyway thank you very much for answering.
Have fun =)
hi sorry to bump this old thread i would like to know, is any one here fix this problem already? i mean experiencing this problem and solve it? and i would like to ask if there is a connection with register.php code to create a character data into dbo.char?
there isn't a connection between dbo.Chars and register.php .
When you create an account the procedure that can give this error is PS_GameData / stored procedure / dbo.usp_Create_Char_R ..if you can't understand it, post here and we can find together the error.
and i wouldn't allow null in dbo.chars for all columns
