Essa query irá premiar um player sempre que ele der um MasterReset usando o comado /mreset no jogo.
ANTES DE QUALQUER ALTERAÇÃO FAÇA UM BACKUP DA SUA DATABASE
Rode essa query, lembre-se de editar o campo em vermelho para quantidade de golds que você deseja premiar o player.
-Troque onde está gold pela tabela da moeda que você vai premiar o player, Padrão: gold ou cash
-Troque onde está 100 pela quantidade que você vai dar por cada MasterReset.
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 02/07/2020 13:32:42 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WZ_SetMasterResetInfo]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WZ_SetMasterResetInfo]
GO
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 02/07/2020 13:32:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[WZ_SetMasterResetInfo]
@Account varchar(10),
@Name varchar(10),
@Reset int,
@MasterReset int,
@MasterResetDay int,
@MasterResetWek int,
@MasterResetMon int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
UPDATE Character SET ResetCount=@Reset,MasterResetCount=@MasterReset WHERE AccountID=@Account AND Name=@Name
UPDATE MEMB_INFO SET gold=gold+100 WHERE memb___id=@Account
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
GO
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 02/07/2020 13:32:42 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WZ_SetMasterResetInfo]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WZ_SetMasterResetInfo]
GO
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 02/07/2020 13:32:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[WZ_SetMasterResetInfo]
@Account varchar(10),
@Name varchar(10),
@Reset int,
@MasterReset int,
@MasterResetDay int,
@MasterResetWek int,
@MasterResetMon int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
UPDATE Character SET ResetCount=@Reset,MasterResetCount=@MasterReset WHERE AccountID=@Account AND Name=@Name
UPDATE MEMB_INFO SET gold=gold+100 WHERE memb___id=@Account
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
GO
Feito cada vez que o player usar o comando /mreset será premiado automaticamente.