Se nao estiver executa essa table no sql e ja era rere
set ANSI_NULLS ON
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)
EXEC [dbo].[spRegularUpdateClanRanking]
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
|