All Toon Names Don't Exist!

02/05/2013 11:17 MrComodoDragon#1
Hey..

Well the problem i am facing is when i go to pick a character name
an enter it , every single name i try enter does is already in use

How do i fix this problem...

Cheers :)
02/05/2013 12:08 TeddyBear94#2
u fix that problem by simply using the search engine. How often do we need to tell u that?
[Only registered and activated users can see links. Click Here To Register...] if the first quiery isnt working use the fix i posted on page 2
02/05/2013 13:15 MrComodoDragon#3
Quote:
Originally Posted by TeddyBear94 View Post
u fix that problem by simply using the search engine. How often do we need to tell u that?
[Only registered and activated users can see links. Click Here To Register...] if the first quiery isnt working use the fix i posted on page 2
BTW i have read all that , The query's don't work ..
Yes i read it , but why release a query whats to fix ur own
problem an not explain it too others ? Can you explain a bit more about this fix an how to fix it
in a little bit more detail..

Cheers :)
02/05/2013 17:07 Sh1nra#4
You tried this?

Quote:
Originally Posted by TeddyBear94 View Post
DBCC DBReIndex ('PS_GameData.dbo.Chars')
Just start a new Query in sql, past this and click on execute
02/05/2013 17:25 MrComodoDragon#5
Quote:
Originally Posted by Sh1nra View Post
You tried this?



Just start a new Query in sql, past this and click on execute
I have tried this Query already , for some reason that i cannot understand it
still persists too tell me the same thing..
02/05/2013 22:01 Philipp_#6
It might help if you show us your logs, but remember to put them in spoilers, please.
02/06/2013 00:43 MrComodoDragon#7
This is the error log ..

02/06/2013 07:14 Philipp_#8
The problem is not in the dbo.Chars table, as stated above, it is in the usp_Create_Char_R procedure. I bet you tried to edit it and made a mistake.. Run the following query to fix the problem - It will reset your procedure to default.
Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Create_Char_R]    Script Date: 06.02.2013 07:11: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

SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0
SET @SkillPoint = 5

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
02/06/2013 11:07 MrComodoDragon#9
Hmm a bit confused a ran that query successfully an restarted my server
an db an it still keeps telling me the same.

Maybe this might help u a bit better :)