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

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

Problema custom arena, pvp

Started by djpigua Soporte / Ayudas

custom arena

Started by djpigua Soporte / Ayudas

Ajuda Custom Jewels - MS Louis Up 35

Started by Sup_Anjo Soporte / Ayudas