cant create new characters [not fixed]

[anquietas]

ive deleted all my databases except for Account,
and restored empty ones (the same ones i use all the time)

when i try to create a character it says that name is already in use, please choose another.

there are no characters in the database.

any suggestions?

[MentaL]

[Crystalz]

Try this:

USE [World00_Character]
GO
/****** Object:  StoredProcedure [dbo].[p_Char_Create]    Script Date: 05/04/2011 22:09:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[p_Char_Create] 
/*
Character Create 
2004.6 By CJC
 input:
   All Args
 output: 
   nCharNo = 1~? ??? ??? ??(??? = 0 )
           =  0 ?? ?? ??
           = -1 ?? ??? ??? ??? ??.
           = -2 ?? ?? ?? ??
           = -3 ?? ?? ?? ??
*/
@nUserNo int,			-- 1	1 ~ ?
@nCreateWorld tinyint,	-- 2	0 ~ ?
@nAdminLevel tinyint,	-- 3	0=USER, 1~?=GM Level 1~?
@nSlotNo tinyint,		-- 4	0 ~ 5
@sID nvarchar(40),		-- 5  
@nRace tinyint,			-- 6	0 = Human, 1 = Elf, 2 = Dark elf
@nClass tinyint,		-- 7	1 = Fighter,4 = Cleric, 7 = Archer, 10 = Mage
@nGender tinyint,		-- 8	0 = Male, 1 = Female
@nHairType tinyint,		-- 9	0 ~ ?
@nHairColor tinyint,	-- 10	0 ~ ?
@nFaceShape tinyint,	-- 11	0 ~ ?
@nCharNo int OUTPUT     -- 12
AS
SET NOCOUNT ON
-- ???? ?? ??
SET @nCharNo = 0
-- ????? ????? ??? ??? ??
IF EXISTS (SELECT sID FROM tCharacter(NOLOCK) WHERE sID = @sID)
    BEGIN
    RETURN
    END
    ELSE
BEGIN TRAN
INSERT tCharacter (  nUserNo,  nSlotNo,  sID,  nCreateWorld,  nAdminLevel )
VALUES            ( @nUserNo, @nSlotNo, @sID, @nCreateWorld, @nAdminLevel )
IF @@ERROR <> 0
BEGIN
	ROLLBACK TRAN
	RETURN
END
SET @nCharNo = @@IDENTITY
-- ?? ?? ??
INSERT tCharacterShape (  nCharNo,  nRace,  nClass,  nGender,  nHairType,  nHairColor,  nFaceShape )
VALUES                 ( @nCharNo, @nRace, @nClass, @nGender, @nHairType, @nHairColor, @nFaceShape ) 
IF @@ERROR <> 0
BEGIN
	ROLLBACK TRAN
	SET @nCharNo = -2
	RETURN
END
-- ?? ?? ??
INSERT tCharacterOptions (  nCharNo )
VALUES                   ( @nCharNo )
IF @@ERROR <> 0
BEGIN
	ROLLBACK TRAN
	SET @nCharNo = -3
	RETURN
END
-- ?? ?? ??
COMMIT TRAN
-- end

Not sure if it's the right one, just something I found. It's worth a try though.

[anquietas]

nope didnt help.
Ive also completely reinstalled windows, and still am unable to create characters.
and i have used 2 different database backups.

[anquietas]

ive tried 2 different sets of server files (one ive been using for over a month)

ive tried removing all the databases and restoring from clean ones

ive removed windows and reinstalled.

i can connect/login, and get to character select screen on the client, i just cant make any characters.

i have executed that create script and it hasnt helped.

[Crusher]

one tipp... take a look on your shns i got this problem for few days i sync my server and client files hairinfo, face that should help you if not sent me a pm and ill help you its not the db