Autor Tema: Problem with WZ_CustomArenaRanking  (Leído 475 veces)

Desconectado brazill

  • *


  • 89

    9

    7
  • bg
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:

Código
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

Desconectado Louis

  • *
  • *


  • 1192

    164

    17533
  • br
  • Louis Emulator
    • +55 15 997401274 +55 15 997401274
    • @jogandomu @jogandomu
    • tec-facil tec-facil
IF (@ArenaNumber = 0)

add a reward to arena index 0 only, need to check
Please donate to keep this website running. Thank you for your support.

Gracias:


Desconectado brazill

  • *


  • 89

    9

    7
  • bg
Hello Louis,

Thank you for the reply.

It works fine, I am stupid!

Just need to switch characters and the coins are displayed correctly. I did not check the CashShopTable. My Bad.

If you want you can delete this post, it is useless.

Regards.

Gracias:


 

.