DECLARE @Name varchar(10)
DECLARE @Name2 varchar(10)
DECLARE @Name3 varchar(10)
SELECT TOP 1 @Name=Name FROM RankingDevilSquare order by Score_Semanal desc, Name desc
SELECT TOP 1 @Name2=Name FROM RankingDevilSquare where Name<>@Name order by Score_Semanal desc, Name desc
SELECT TOP 1 @Name3=Name FROM RankingDevilSquare where Name<>@Name and Name<>@Name2 order by Score_Semanal desc, Name desc
UPDATE dbo.[CashShopData] SET WCoinC=WCoinC+50 FROM dbo.[CashShopData]
JOIN dbo.Character ON dbo.Character.AccountID = dbo.CashShopData.[AccountID]
WHERE dbo.Character.Name=@Name
UPDATE dbo.[CashShopData] SET WCoinC=WCoinC+30 FROM dbo.[CashShopData]
JOIN dbo.Character ON dbo.Character.AccountID = dbo.CashShopData.[AccountID]
WHERE dbo.Character.Name=@Name2
UPDATE dbo.[CashShopData] SET WCoinC=WCoinC+10 FROM dbo.[CashShopData]
JOIN dbo.Character ON dbo.Character.AccountID = dbo.CashShopData.[AccountID]
WHERE dbo.Character.Name=@Name3
UPDATE dbo.[MK_MEDALHAS] SET medal_evento=medal_evento+1 FROM dbo.[CashShopData]
JOIN dbo.Character ON dbo.Character.AccountID = dbo.CashShopData.[AccountID]
WHERE dbo.Character.Name=@Name
UPDATE dbo.[MK_MEDALHAS] SET medal_evento=medal_evento+1 FROM dbo.[CashShopData]
JOIN dbo.Character ON dbo.Character.AccountID = dbo.CashShopData.[AccountID]
WHERE dbo.Character.Name=@Name2
UPDATE dbo.[MK_MEDALHAS] SET medal_evento=medal_evento+1 FROM dbo.[CashShopData]
JOIN dbo.Character ON dbo.Character.AccountID = dbo.CashShopData.[AccountID]
WHERE dbo.Character.Name=@Name3
UPDATE dbo.RankingDevilSquare SET Score_Semanal = '0'