[Release] _Manageshardname Fix - less lags - no errors

[TryToMakeServer]

USE [ACCOUNTDB]
GO
/****** Object: StoredProcedure [dbo].[_ManageShardCharName] Script Date: 04/18/2012 15:00:27 ******/

/****** By Li ******/

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_ManageShardCharName]
@job tinyint,
@UserJID int,
@ShardID smallint,
@CharName varchar(64),
@OldName varchar(64)
as
-- add new char name
if (@job = 0)
begin
return
end
-- remove char name
else if (@job = 1)
begin
return
end
-- rename previous one
else if (@job = 2)
begin
return
end

Enjoy

 

[3d2000]

thanks for Sharing


can you plzz add some More details about it :: i mean explain what doe it do

 

[TryToMakeServer]

Globalmanager doesnt give any errors anymore, about managing shard names.
Also it doesnt insert into the db any useless lines anymore.

 

[Statiic]

hmm cool

 

[sladlejrhfpq]

nice one, thank you for sharing

 

[SnapPop]

Globalmanager doesnt give any errors more, about managing shard names.
Also it doesnt insert into the db any useless lines anymore.

well done Li

 

[ahmedelbeah]

Thanx for you