Hello guys, Louis,
I am using Louis Emulator Update 27.
I have a problem with WZ_CustomArenaRanking. My CashShopData has not been updated when the event is over (CustomArena with index 0).
Here is the code in WZ_CustomArenaRanking:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomArenaRanking] Script Date: 9/19/2021 2:03:34 PM ******/
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 WCoinC=WCoinC+1000 WHERE AccountID=@Account
END
END
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
If someone has an idea where I am wrong, please help me.
Thank you in advance for your help,
Asen