phillippecarvalho
Usuário XPZ
Boa noite, estou utilizando a seguinte query para premiar as Custom Arena, mas não sei se está correto. Só testei no Survivor ainda, e aparentemente a premiação em goblin está indo, porém, a de cash não. Poderiam me da uma força?
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomArenaRanking] Script Date: 12/10/2017 14:02:10 ******/
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 CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 5 where memb___id = @Account
END
END
IF(@ArenaNumber = 1)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 2)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 3)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 4)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 5)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 6)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 7)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomArenaRanking] Script Date: 12/10/2017 14:02:10 ******/
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 CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 5 where memb___id = @Account
END
END
IF(@ArenaNumber = 1)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 2)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 3)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 4)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 5)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 6)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
IF(@ArenaNumber = 7)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID=@Account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = @Account
END
END
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
