Fix (Incorrect character name was entered ) at Character Creation

[KarLi]

I am reposting this from my old account because in google you cannot find this thread.


That problem when you try to make a character and it says
"Incorrect character name was entered or same character name exists"

That happens when u make changes on your database wz createcharacter procedure


to fix it you do this.


1. Open enteprise manager
2. Go to MuOnline Database
3.Go to Stored Procedures
4. Find "WZ_CreateCharacter" right Click on it click "Properties"
5. Delete whatever it is in there and paste that

/****** Object:  Stored Procedure dbo.WZ_CreateCharacter    Script Date: 28.11.2008 19:52:26 ******/




CREATE Procedure WZ_CreateCharacter 




 [USER=162874]account[/USER]ID		varchar(10),
 [USER=1333344765]name[/USER]			varchar(10),
 [USER=437263]clas[/USER]s			tinyint
AS
Begin




	SET NOCOUNT ON
	SET	XACT_ABORT ON
	DECLARE	 [USER=22433]resu[/USER]lt		tinyint




	SET [USER=22433]resu[/USER]lt = 0x00	




	If EXISTS ( SELECT  Name  FROM  Character WHERE Name = [USER=1333344765]name[/USER] )
	begin
		SET [USER=22433]resu[/USER]lt	= 0x01		
		GOTO ProcEnd						
	end 




	BEGIN TRAN




	If NOT EXISTS ( SELECT  Id  FROM  AccountCharacter WHERE Id = [USER=162874]account[/USER]ID )
		begin
			INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC) 
			VALUES [USER=162874]account[/USER]ID, [USER=1333344765]name[/USER], NULL, NULL, NULL, NULL, NULL)




			SET [USER=22433]resu[/USER]lt  = @@Error
		end 
	else
		begin
			Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)						
			SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = [USER=162874]account[/USER]ID 			
			if( ( @g1 Is NULL) OR (Len(@g1) = 0))




				begin
					UPDATE AccountCharacter SET  GameID1 = [USER=1333344765]name[/USER]
					WHERE Id = [USER=162874]account[/USER]ID
										
					SET [USER=22433]resu[/USER]lt  = @@Error
				end 
			else	 if( @g2  Is NULL OR Len(@g2) = 0)
				begin
					UPDATE AccountCharacter SET  GameID2 = [USER=1333344765]name[/USER]
					WHERE Id = [USER=162874]account[/USER]ID




					SET [USER=22433]resu[/USER]lt  = @@Error
				end 
			else	 if( @g3  Is NULL OR Len(@g3) = 0)
				begin			
					UPDATE AccountCharacter SET  GameID3 = [USER=1333344765]name[/USER]
					WHERE Id = [USER=162874]account[/USER]ID




					SET [USER=22433]resu[/USER]lt  = @@Error
				end 
			else	 if( @g4 Is NULL OR Len(@g4) = 0)
				begin
					UPDATE AccountCharacter SET  GameID4 = [USER=1333344765]name[/USER]
					WHERE Id = [USER=162874]account[/USER]ID




					SET [USER=22433]resu[/USER]lt  = @@Error
				end 
			else	 if( @g5 Is NULL OR Len(@g5) = 0)
				begin
					UPDATE AccountCharacter SET  GameID5 = [USER=1333344765]name[/USER]
					WHERE Id = [USER=162874]account[/USER]ID




					SET [USER=22433]resu[/USER]lt  = @@Error
				end 		
			else 
				begin					
					SET [USER=22433]resu[/USER]lt	= 0x03							
					GOTO TranProcEnd								
				end 			 
		end 




	if( [USER=22433]resu[/USER]lt <> 0 )
		begin
			GOTO TranProcEnd		
		end 
	else
		begin
			INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, 
					Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,  MDate, LDate, Quest, DbVersion, Leadership,money )
			SELECT [USER=162874]account[/USER]ID As AccountID, [USER=1333344765]name[/USER] As Name, Level, 0, [USER=437263]clas[/USER]s As Class, 
				Strength, Dexterity, Vitality, Energy, Inventory,MagicList,  Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
				getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,0
			FROM  DefaultClassType WHERE Class = [USER=437263]clas[/USER]s					




			SET [USER=22433]resu[/USER]lt  = @@Error
		end 




TranProcEnd:
	IF ( [USER=22433]resu[/USER]lt  <> 0 )
		ROLLBACK TRAN
	ELSE
		COMMIT	TRAN




ProcEnd:




	SET NOCOUNT OFF
	SET	XACT_ABORT OFF




	SELECT
	   CASE [USER=22433]resu[/USER]lt
	      WHEN 0x00 THEN 0x01
	      WHEN 0x01 THEN 0x00
	      WHEN 0x03 THEN 0x03
	      ELSE 0x02
	   END AS Result 
End








GO

Click OK
under "WZ_CreateCharacter"
there is "WZ_CreateCharacter_GetVersion"


do the same thing you did with wz_createcharacter and put this script

/****** Object:  Stored Procedure dbo.WZ_CreateCharacter_GetVersion    Script Date: 28.11.2008 19:52:26 ******/
CREATE PROCEDURE WZ_CreateCharacter_GetVersion
ASBEGIN	SELECT 1EndGO

Then you go and enjoy !
Thats all you gotta do to fix it , otherwise restore your database again or use other one.

regards

 

[nw101353]

how about for delete character?
im using muemu s6 ep3
cant delete even the query is correct it still asks for password and if i type 1111111111 still cant delete