حصريااا Change Name Scroll after Fix

[™Dev Microsoft™]

Welcome Dear S4A Members

Today I Get Qeury Change name Scroll After Fix

here :d
[SPOILER]

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

[/SPOILER]

Finnaly I also found one line in a procedure that was uncommented which probably was causing trouble

here :d
[SPOILER]

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

[/SPOILER]

منقول :)

بالتوفيق للجيمع ,,,

[Yousef Ayyoub]

ايه الهري ده ,, انتا فاهم اصلا انتا كاتب ايه

[Ch3tos]

طيب انت ناقل الجزء اللي اتعملو Fix بس
فين الباقي :D

[Tigger]

nice