Fix name already used

03/04/2014 19:35 Henokoss#1

Hello,

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:[Only registered and activated users can see links. Click Here To Register...]
and other. But nothing to do.
this is why I can recreate a post is a topic
Thank you in advance.

03/04/2014 21:49 AxelMac#2

Code:

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

Use this...tell me if it works

03/05/2014 17:14 Henokoss#3

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 ^ ^.

03/06/2014 13:52 TeddyBear94#4

Code:

DBCC DBReIndex ('PS_GameData.dbo.Chars')

paste this into sql and run it restart server and sql and it should be fixed.

03/06/2014 18:38 Henokoss#5

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 =)

ps: sorry for my bad english I use a translator

12/01/2016 17:39 theartboom#6

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?

12/01/2016 18:31 GkRock#7

Sends a design image of your chars table

Something like this

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

12/01/2016 19:28 theartboom#8

they are all check, what im going to do?

12/01/2016 19:44 theartboom#9

Quote:

Originally Posted by theartboom

they are all check, what im going to do?

I already edit the radio botton , whats next?

12/02/2016 08:43 beetols#10

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