Name already in use...

[Sh1nra]

Hello i have a problem every time i tried to chreate a new char i get the message name already in use...
I aready tried this fix:



and this:


Here is a log maybe it help

 Spoiler

2013-06-22 11:41:12 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int., SQL STATE: 22003, NATIVE ERROR: 8115 (0x1FB3)

2013-06-22 11:41:12 ::CreateCharacter 0 dasssss retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Shinra',1,'dasssss', 0,0,3,0,0,2,0,1, 1,0,0, 14,12,9,8,15,7, 352,110,257, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2013-06-22 11:41:12 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

[{Skrillex}]

Vielleicht den gleichen error wie Kalle gehabt?

LoginStatus Zeile auf KEINE KULLS erlauben gesetzt aber kein Default?

[Sh1nra]

Originally Posted by Sh1nra

and this:

Already tried

[{Skrillex}]

Originally Posted by ϟƘƦƖןןΣ✘

Vielleicht den gleichen error wie Kalle gehabt?

LoginStatus Zeile auf KEINE KULLS erlauben gesetzt aber kein Default?

^!

Selbst gemerkt,dann geändert^^

[Sh1nra]

Habe garkein LoginStatus

[andr3y_you96]

 Spoiler

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,
@Maketime datetime,
@Maketype char(1)

AS

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

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 06/22/2013 14:05:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R 스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER Proc [dbo].[usp_Create_Char_R]

@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,

@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,


/* 여기까지 인자값 주어져야 함 */

/* SP 내부 참조용 변수 */

@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int
IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 126
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 28
END
ELSE IF @Job = 1
BEGIN
SET @rec = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @luc = 27
END
ELSE IF @job = 4
BEGIN
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @wis = 28
END

END

ELSE IF @Grow = 1 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 30
SET @StatPoint = 261
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 43
END
ELSE IF @Job = 1
BEGIN
SET @rec = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @luc = 42
END
ELSE IF @job = 4
BEGIN
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @wis = 43
END

END

ELSE IF @Grow = 2 -- Hard mode
BEGIN
SET @Grow = 3
SET @Level = 60
SET @StatPoint = 531
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END


END


ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 1
SET @StatPoint = 0
SET @SkillPoint = 0
SET @money = 0

IF @Job = 0
BEGIN
SET @Str = 0
END
ELSE IF @Job = 1
BEGIN
SET @rec = 0
END
ELSE IF @Job = 2
BEGIN
SET @dex = 0
END
ELSE IF @Job = 3
BEGIN
SET @luc = 0
END
ELSE IF @job = 4
BEGIN
SET @int = 0
END
ELSE IF @job = 5
BEGIN
SET @wis = 0
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0



SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

IF(@NameCnt <> 0)
BEGIN
RETURN -2
END
ELSE
BEGIN
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
BEGIN
RETURN -2
END

BEGIN TRANSACTION

INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)

VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow,
@Hair, @Face, @Size, @Job, @Sex, @Level, @StatPoint, @SkillPoint,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money,
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)

IF( @@ERROR=0 )
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
RETURN -1
END

SET @CharID = IDENT_CURRENT('Chars')
END

RETURN @CharID

SET NOCOUNT OFF

try this i tooked it from my db i dont have any problem creating new chars
oh i forgot i have instant leveling enabled you may want to change it

[Sh1nra]

I have instant leveling too but level 125 may this is the problem?

and ps_game.exe just lv 90..

[andr3y_you96]

na i dont think so i was just saying about the second proc usp_Create_Char_R that i posted you may want to edit it because it have instant leveling for 15 30 and 60

[Sh1nra]

I found the problem the problem was the column money only have the datatype int so you can't set the money more than 2.147.483.647 .

I set the money now on 2kkk thankyou very much !

can be closed