USE MuOnline
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WZ_SetMasterResetInfo]') AND type in (N'P', N'PC'))
DROP PROCEDURE WZ_SetMasterResetInfo
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE 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