USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomArenaRanking] Script Date: 05/01/2016 15:29:00 ******/
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 Gold=Gold + 3000 WHERE AccountID=@Account
UPDATE Character SET ScoreCustomArena= ScoreCustomArena + @UserScore WHERE AccountID=@Account and Name=@Name
UPDATE Character SET RankCustomArena= RankCustomArena + @UserRank WHERE AccountID=@Account and Name=@Name
END
END
SET NOCOUNT OFF
SET XACT_ABORT OFF
END