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 View Post
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