Fix lỗi số thành viên trong Guild không cập nhật đuợc

[bongma_2x]

Để Fix lỗi này chạy câu 2 lệnh sau thì số thành viên của Guild sẽ đuợc Fix
Chúc Zui zẽ

-- Code by Bongma_2x
-- Date: 07/06/2009
-- For MudangCap [Only registered and activated users can see links. ]

DECLARE @GName VARCHAR(30)
DECLARE @CountMember int

DECLARE OGuild CURSOR FOR
select G_Name from Guild

Open OGuild
FETCH NEXT FROM OGuild
INTO @GName
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @CountMember = count( * ) from GuildMember WHERE G_Name=@Gname group by G_Name
UPDATE Guild SET MemberCount=@CountMember WHERE G_Name=@Gname
FETCH NEXT FROM OGuild
INTO @GName
END
CLOSE OGUILD
DEALLOCATE OGuild

-- Procedure CreateGuilde Create by WZ
-- Refix by : Bongma_2x
-- Date refix : 05/06/2009

ALTER procedure [dbo].[WZ_GuildCreate]
@GuildName varchar(8),
@MasterName varchar(10)
as
BEGIN
DECLARE @ErrorCode int

SET @ErrorCode = 0
SET XACT_ABORT ON

Set nocount on
begin transaction

INSERT INTO Guild (G_Name, G_Master,G_Score,MemberCount) VALUES (@GuildName, @MasterName,0,1)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 1
END

IF ( @ErrorCode = 0 )
BEGIN
INSERT GuildMember (Name, G_Name, G_Level) VALUES (@MasterName, @GuildName, 1)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 2
END
END

IF ( @ErrorCode <> 0 )
rollback transaction
ELSE
commit transaction

select @ErrorCode

Set nocount off
SET XACT_ABORT OFF
END

--------------------- Het ----------

[Mr.Noob]

Thanks for share.Pro quá đi.Hjhj