[RELEASE] Name Change Fix by Shaiya Dev Group

USE [PS_GameData]
GO

ALTER TABLE Chars ALTER COLUMN [UserID] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL
ALTER TABLE Chars ALTER COLUMN [OldCharName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NULL
GO

DROP INDEX IX_Chars_CharName ON PS_GameData.dbo.Chars
GO

ALTER TABLE Chars ALTER COLUMN [CharName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL
GO

USE [PS_GameData]
GO
/****** Object: Index [IX_Chars_CharName] Script Date: 03/28/2010 10:17:12 ******/
CREATE NONCLUSTERED INDEX [IX_Chars_CharName] ON [dbo].[Chars]
(
[CharName] ASC
)WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER   Proc [dbo].[usp_Save_Char_Name_E]

@ServerID tinyint,
@CharID int,
@OldCharName nvarchar(30),
@NewCharName nvarchar(30)

AS

SET NOCOUNT ON
--SET XACT_ABORT ON

--DECLARE @NameCnt int
--DECLARE @Ret int

SET @OldCharName = LTRIM(RTRIM(@OldCharName))
SET @NewCharName = LTRIM(RTRIM(@NewCharName))

--SET @Ret = 0

IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@NewCharName AND Del=0)
BEGIN
	RETURN -2
END

--BEGIN TRANSACTION

UPDATE Chars SET CharName=@NewCharName,RenameCnt=RenameCnt-1,OldCharName=@OldCharName WHERE CharID=@CharID AND Del=0
IF @@ERROR <> 0
BEGIN
	GOTO ERROR_ROLLBACK
END

UPDATE Guilds SET MasterName=@NewCharName WHERE MasterCharID=@CharID
--IF @@ERROR <> 0
--BEGIN
--	GOTO ERROR_ROLLBACK
--END
UPDATE FriendChars SET FriendName=@NewCharName WHERE FriendID=@CharID
--IF @@ERROR <> 0
--BEGIN
--	GOTO ERROR_ROLLBACK
--END
UPDATE BanChars SET BanName=@NewCharName WHERE BanID=@CharID
--IF @@ERROR <> 0
--BEGIN
--	GOTO ERROR_ROLLBACK
--END
INSERT INTO CharRenameLog( ServerID, CharID, CharName) VALUES(@ServerID, @CharID, @NewCharName )
--UPDATE PS_USERDB01.PS_UserData.dbo.CreatedChars SET CharName=@NewCharName WHERE ServerID=@ServerID AND CharID=@CharID
--IF @@ERROR <> 0
--BEGIN
--	GOTO ERROR_ROLLBACK
--END

--COMMIT TRANSACTION
RETURN 1


ERROR_ROLLBACK:
--ROLLBACK TRANSACTION
RETURN -2



SET NOCOUNT OFF