Oi algem poderia me ajudar com o Ranking Custom Arena do muserver S8 UP19 estou tentando colocar os Rankings separados tipo Survivor vai ficar os pontos em Score mesmo mas os outros como DMxDM quero mandar os pontos para essas coluna VitoriasMG e do GMxGM para a coluna VitoriasSM
Quando vou no evento GMxGM os pontos ganhos são Distribuído em todas as colunas VitoriasMG VitoriasSM VitoriasBM VitoriasRF VitoriasDL VitoriasElfa VitoriasSum
Assim por diante
Segue a baixo a procedure que mexi
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomArenaRanking] Script Date: 30/06/2017 00:56:08 ******/
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
--ALL Classe
IF(@ArenaNumber = 0)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +10 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET Score=Score+@UserScore WHERE Name=@Name
END
--MGxMG
IF(@ArenaNumber = 1)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +30 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET VitoriasMG=VitoriasMG+@UserScore WHERE Name=@Name
END
--SMxSM
IF(@ArenaNumber = 2)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +100 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET VitoriasSM=VitoriasSM + @UserScore WHERE Name=@Name
END
--BMxBM
IF(@ArenaNumber = 3)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +100 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET VitoriasBM=VitoriasBM + @UserScore WHERE Name=@Name
END
--RFxRF
IF(@ArenaNumber = 4)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +100 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET VitoriasRF=VitoriasRF + @UserScore WHERE Name=@Name
END
--DLxDL
IF(@ArenaNumber = 5)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +100 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET VitoriasDL=VitoriasDL + @UserScore WHERE Name=@Name
END
--ElfaxElfa
IF(@ArenaNumber = 6)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +100 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET VitoriasElfa=VitoriasElfa + @UserScore WHERE Name=@Name
END
--SumxSum
IF(@ArenaNumber = 7)
BEGIN
IF(@UserRank = 1)
BEGIN
UPDATE CashShopData SET GoblinPoint=GoblinPoint +100 WHERE AccountID=@Account
END
END
IF NOT EXISTS (SELECT Name FROM RankingCustomArena WHERE Name=@Name)
BEGIN
INSERT INTO RankingCustomArena (Name,Score,Arena) VALUES (@Name,@UserScore,@ArenaNumber)
END
ELSE
BEGIN
UPDATE RankingCustomArena SET VitoriasSum=VitoriasSum + @UserScore WHERE Name=@Name
END
END
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
