phillippec1
10/12/2017, 03:31 PM
Boa tarde, 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[/MENTION] varchar(10),
@Name varchar(10),
@ArenaNumber int,
@UserScore int,
@UserRank int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 5 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
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[/MENTION] varchar(10),
@Name varchar(10),
@ArenaNumber int,
@UserScore int,
@UserRank int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 5 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint + 100 WHERE AccountID account
UPDATE MEMB_INFO SET Cash = Cash + 20 where memb___id = account
END
END
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
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