Blank Clan Stats?

[nubbynub]

Hi. On my server, in my clan channel, we are going to clan war, but there are no stats in the box..


Here is a pic.





Any help will be appriciated greatly

[MentaL]

[own_prox]

excute this in db
DECLARE @RC int
EXECUTE @RC = [dbo].[spRegularUpdateClanRanking]
EXECUTE @RC = [dbo].[spRegularUpdateClanRankIncrease]

[own_prox]

and this
USE [GunZDB]
GO
/****** Object: StoredProcedure [dbo].[spWinTheClanGame] Script Date: 05/20/2009 20:20:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- 클랜전 결과 업데이트
ALTER PROC [dbo].[spWinTheClanGame]
@WinnerCLID int,
@LoserCLID int,
@IsDrawGame tinyint,
@WinnerPoint int,
@LoserPoint int,
@WinnerClanName varchar(24),
@LoserClanName varchar(24),
@RoundWins tinyint,
@RoundLosses tinyint,
@MapID tinyint,
@GameType tinyint,
@WinnerMembers varchar(110),
@LoserMembers varchar(110)
AS
SET NOCOUNT ON -- 추가.

IF @IsDrawGame = 0
BEGIN
BEGIN TRAN
-- 이긴팀 Wins+1
UPDATE Clan SET Wins=Wins+1, Point=Point+@WinnerPoint, TotalPoint=TotalPoint+@WinnerPoint WHERE CLID=@WinnerCLID
IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END

-- 진팀 Losses+1
UPDATE Clan SET Losses=Losses+1, Point= dbo.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID
IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END
-- UPDATE Clan SET Point=0 WHERE CLID=@LoserCLID AND Point<0

-- 전적 로그를 남긴다.
INSERT INTO ClanGameLog(WinnerCLID, LoserCLID, WinnerClanName, LoserClanName, RoundWins, RoundLosses, MapID, GameType, RegDate, WinnerMembers, LoserMembers, WinnerPoint, LoserPoint)
VALUES (@WinnerCLID, @LoserCLID, @WinnerClanName, @LoserClanName, @RoundWins, @RoundLosses, @MapID, @GameType, GETDATE(), @WinnerMembers, @LoserMembers, @WinnerPoint, @LoserPoint)
IF 0 <> @@ERROR BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END
COMMIT TRAN
END
ELSE
BEGIN
UPDATE Clan SET Draws=Draws+1 WHERE CLID=@WinnerCLID OR CLID=@LoserCLID
END

[nubbynub]

Thank you very much Ownprox.


EDIT: They're still blank..

A little newb question, do you have to actually PLAY a clanwar to get the stats?