USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 14/06/2017 15:04:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER 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
set @Reset = 1
UPDATE Character SET MasterResetCount=MasterResetCount+@Reset,mresets_d iario=mresets_diario+@Reset, mresets_semanal = mresets_semanal +@Reset, mreset_mensal = mreset_mensal+@Reset, exp_war = exp_war +30
WHERE AccountID=@Account AND Name=@Name
UPDATE CashShopData SET WCoinP = WCoinP + 10, GoblinPoint = GoblinPoint+30 WHERE AccountID=@Account
SET NOCOUNT OFF
SET XACT_ABORT OFF
END