- Joined
- May 26, 2009
- Messages
- 17,308
- Reaction score
- 3,219
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
Click OK
under "WZ_CreateCharacter"
there is "WZ_CreateCharacter_GetVersion"
do the same thing you did with wz_createcharacter and put this script
Then you go and enjoy !
Thats all you gotta do to fix it , otherwise restore your database again or use other one.
regards
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
Code:
/****** 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
Code:
/****** 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