Esta é a query de premiação automatica da Arena Custom. Porem ela só está premiando 1 (uma) Arena, Como fazer pra ela premiar outras arenas com valores diferentes de pc point? Possuo 4 arenas em meu servidor.
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomArenaRanking] Script Date: 04/21/2017 01:06:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_CustomArenaRanking]
@Account varchar(10),
@name varchar(10),
@ArenaNumber int,
@UserScore int,
@UserRank int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
IF(@ArenaNumber = 0)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE PcPointData SET PcPoint= PcPoint+2000 WHERE AccountID=@Account
END
END
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomArenaRanking] Script Date: 04/21/2017 01:06:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_CustomArenaRanking]
@Account varchar(10),
@name varchar(10),
@ArenaNumber int,
@UserScore int,
@UserRank int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
IF(@ArenaNumber = 0)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE PcPointData SET PcPoint= PcPoint+2000 WHERE AccountID=@Account
END
END
SET NOCOUNT OFF
SET XACT_ABORT OFF
END