Master Reset Configuração

esse post é referente aos seguintes post:


http://perfectzone.com.br/showthread.php?t=3360


http://perfectzone.com.br/showthread.php?t=3372






----
execultei a query que o @hanzel me passou da seguinte forma:

Quote[MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 07/12/2016 01:40:36 ******//****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 07/12/2016 01:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[WZ_SetMasterResetInfo] Procedure [dbo].[WZ_SetMasterResetInfo]
@Account varchar(10),@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+10 WHERE memb___id=@Account

SET NOCOUNT OFF
SET XACT_ABORT OFF

END

e configurei o command.dat assim:

Quote;============================================ ======
; Master Reset Command Settings
;================================================= =
CommandMasterResetSwitch = 0
CommandMasterResetType = 0
CommandMasterResetEnable_AL0 = 1
CommandMasterResetEnable_AL1 = 1
CommandMasterResetEnable_AL2 = 1
CommandMasterResetEnable_AL3 = 1
CommandMasterResetCheckItem_AL0 = 0
CommandMasterResetCheckItem_AL1 = 0
CommandMasterResetCheckItem_AL2 = 0
CommandMasterResetCheckItem_AL3 = 0
CommandMasterResetMove_AL0 = 1
CommandMasterResetMove_AL1 = 1
CommandMasterResetMove_AL2 = 1
CommandMasterResetMove_AL3 = 1
CommandMasterResetQuest_AL0 = 0
CommandMasterResetQuest_AL1 = 0
CommandMasterResetQuest_AL2 = 0
CommandMasterResetQuest_AL3 = 0
CommandMasterResetSkill_AL0 = 0
CommandMasterResetSkill_AL1 = 0
CommandMasterResetSkill_AL2 = 0
CommandMasterResetSkill_AL3 = 0
CommandMasterResetLevel_AL0 = 400
CommandMasterResetLevel_AL1 = 400
CommandMasterResetLevel_AL2 = 400
CommandMasterResetLevel_AL3 = 400
CommandMasterResetReset_AL0 = 1000
CommandMasterResetReset_AL1 = 800
CommandMasterResetReset_AL2 = 700
CommandMasterResetReset_AL3 = 500
CommandMasterResetMoney_AL0 = 0
CommandMasterResetMoney_AL1 = 0
CommandMasterResetMoney_AL2 = 0
CommandMasterResetMoney_AL3 = 0
CommandMasterResetCount_AL0 = 1
CommandMasterResetCount_AL1 = 1
CommandMasterResetCount_AL2 = 1
CommandMasterResetCount_AL3 = 1
CommandMasterResetLimit_AL0 = 10000
CommandMasterResetLimit_AL1 = 10000
CommandMasterResetLimit_AL2 = 10000
CommandMasterResetLimit_AL3 = 10000
CommandMasterResetLimitDay_AL0 = 10000
CommandMasterResetLimitDay_AL1 = 10000
CommandMasterResetLimitDay_AL2 = 10000
CommandMasterResetLimitDay_AL3 = 10000
CommandMasterResetLimitWek_AL0 = 10000
CommandMasterResetLimitWek_AL1 = 10000
CommandMasterResetLimitWek_AL2 = 10000
CommandMasterResetLimitWek_AL3 = 10000
CommandMasterResetLimitMon_AL0 = 10000
CommandMasterResetLimitMon_AL1 = 10000
CommandMasterResetLimitMon_AL2 = 10000
CommandMasterResetLimitMon_AL3 = 10000
CommandMasterResetStartLevel_AL0 = 0
CommandMasterResetStartLevel_AL1 = 0
CommandMasterResetStartLevel_AL2 = 0
CommandMasterResetStartLevel_AL3 = 0
CommandMasterResetStartReset_AL0 = 0
CommandMasterResetStartReset_AL1 = 0
CommandMasterResetStartReset_AL2 = 0
CommandMasterResetStartReset_AL3 = 0
CommandMasterResetPoint_AL0 = 0
CommandMasterResetPoint_AL1 = 0
CommandMasterResetPoint_AL2 = 0
CommandMasterResetPoint_AL3 = 0
CommandMasterResetPointRateDW = 0
CommandMasterResetPointRateDK = 0
CommandMasterResetPointRateFE = 0
CommandMasterResetPointRateMG = 0
CommandMasterResetPointRateDL = 0
CommandMasterResetPointRateSU = 0

eu pensei da seguinte forma: um player tem 1500 resets, e é vip master (_AL3), ao dar /mreset seria descontado apenas os 500 resets, e ele voltaria com 1000 e ganhasse suas 10 gold conforme a query, porem na seguinte configuração :


CommandMasterResetStartReset_AL0 = 0
CommandMasterResetStartReset_AL1 = 0
CommandMasterResetStartReset_AL2 = 0
CommandMasterResetStartReset_AL3 = 0


ao invez dele voltar com 1000, ele volta com 0 resets, então oque que eu fiz configurei assim:




CommandMasterResetStartReset_AL0 = -1
CommandMasterResetStartReset_AL1 = -1
CommandMasterResetStartReset_AL2 = -1
CommandMasterResetStartReset_AL3 = -1

funcionou, o player perdeu 500 resets e ganhou suas 10 golds, porem o gameserver começou a fechar sozinho e gerar arquivo de despejo de memoria, como eu configuro o master reset pra funcionar da forma que eu citei ?


perdendo apenas a quantidade X de resets e não zerando ele todo?





utilizo xteam season 4 premium, windows server 2008 r2, sql 2012 e MuSite Daldegam

creio que isso deve ser limitação no codigo fonte, vai ter que solicitar da xteam uma correção uma vez que é premium. ou pegar a source na net e fixar.

Ta faltando coisa ai nessa procedure, altera onde ta Z_Credits para coluna/table que amarzena sua moeda como Nunca usei daldegam não faço minima ideia.

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 24/07/2016 02:56:42 ******/
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


UPDATE Character SET
ResetCount=@Reset,
MasterResetCount=@MasterReset,
MasterResetCountDay=MasterResetCountDay+1,
MasterResetCountWeek=MasterResetCountWeek+1,
MasterResetCountMonth=MasterResetCountMonth+1
WHERE AccountID=@Account AND Name=@Name


-- DECLARA OS NÍVEL DE VIP DE 0 ATÉ 3
DECLARE @AccountLevel_0 INT;
DECLARE @AccountLevel_1 INT;
DECLARE @AccountLevel_2 INT;
DECLARE @AccountLevel_3 INT;


-- DECLARA OS VALORES DADO NO MASTER RESET
DECLARE @Value_0 INT;
DECLARE @Value_1 INT;
DECLARE @Value_2 INT;
DECLARE @Value_3 INT;


-- DECLARA O TIPO DA MOEDA DADA NO MR
DECLARE @TypeMoeda INT;


-- SETA O NUMERO DO ACCOUNTLEVEL
SET @AccountLevel_0 = 0;
SET @AccountLevel_1 = 1;
SET @AccountLevel_2 = 2;
SET @AccountLevel_3 = 3;


-- SETA O VALOR DADO NO MR A CADA TIPO DE VIP
SET @Value_0 = 10;
SET @Value_1 = 10;
SET @Value_2 = 10;
SET @Value_3 = 10;


-- SET O TYPE DA MOEDA
SET @TypeMoeda = 1;


-- MASTER RESET FREE
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @Account AND AccountLevel = @AccountLevel_0)
BEGIN


IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @Account AND type = @TypeMoeda)
BEGIN
UPDATE MEMB_INFO SET gold=gold+10 WHERE memb___id=@Account
END


ELSE
BEGIN
INSERT INTO Z_Credits (memb___id, value, type) VALUES (@Account, @Value_0, @TypeMoeda)
END


END
-- FIM


-- MASTER RESET AccountLevel 1
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @Account AND AccountLevel = @AccountLevel_1)
BEGIN


IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @Account AND type = @TypeMoeda)
BEGIN
UPDATE MEMB_INFO SET gold=gold+10 WHERE memb___id=@Account
END


ELSE
BEGIN
INSERT INTO Z_Credits (memb___id, value, type) VALUES (@Account, @Value_1, @TypeMoeda)
END


END
-- FIM


-- MASTER RESET AccountLevel 2
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @Account AND AccountLevel = @AccountLevel_2)
BEGIN


IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @Account AND type = @TypeMoeda)
BEGIN
UPDATE MEMB_INFO SET gold=gold+10 WHERE memb___id=@Account
END


ELSE
BEGIN
INSERT INTO Z_Credits (memb___id, value, type) VALUES (@Account, @Value_2, @TypeMoeda)
END


END
-- FIM


-- MASTER RESET AccountLevel 3
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @Account AND AccountLevel = @AccountLevel_3)
BEGIN


IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @Account AND type = @TypeMoeda)
BEGIN
UPDATE MEMB_INFO SET gold=gold+10 WHERE memb___id=@Account


END


ELSE
BEGIN
INSERT INTO Z_Credits (memb___id, value, type) VALUES (@Account, @Value_3, @TypeMoeda)
END


END
-- FIM


SET NOCOUNT OFF
SET XACT_ABORT OFF


END






;================================================= =
; Master Reset Command Settings
;================================================= =
CommandMasterResetSwitch = 1
CommandMasterResetType = 1
CommandMasterResetEnable_AL0 = 1
CommandMasterResetEnable_AL1 = 1
CommandMasterResetEnable_AL2 = 1
CommandMasterResetEnable_AL3 = 1
CommandMasterResetCheckItem_AL0 = 0
CommandMasterResetCheckItem_AL1 = 0
CommandMasterResetCheckItem_AL2 = 0
CommandMasterResetCheckItem_AL3 = 0
CommandMasterResetMove_AL0 = 1
CommandMasterResetMove_AL1 = 1
CommandMasterResetMove_AL2 = 1
CommandMasterResetMove_AL3 = 1
CommandMasterResetQuest_AL0 = 0
CommandMasterResetQuest_AL1 = 0
CommandMasterResetQuest_AL2 = 0
CommandMasterResetQuest_AL3 = 0
CommandMasterResetSkill_AL0 = 0
CommandMasterResetSkill_AL1 = 0
CommandMasterResetSkill_AL2 = 0
CommandMasterResetSkill_AL3 = 0
CommandMasterResetLevel_AL0 = 400
CommandMasterResetLevel_AL1 = 400
CommandMasterResetLevel_AL2 = 400
CommandMasterResetLevel_AL3 = 400
CommandMasterResetReset_AL0 = 1000
CommandMasterResetReset_AL1 = 800
CommandMasterResetReset_AL2 = 700
CommandMasterResetReset_AL3 = 500
CommandMasterResetMoney_AL0 = 0
CommandMasterResetMoney_AL1 = 0
CommandMasterResetMoney_AL2 = 0
CommandMasterResetMoney_AL3 = 0
CommandMasterResetCount_AL0 = 1
CommandMasterResetCount_AL1 = 1
CommandMasterResetCount_AL2 = 1
CommandMasterResetCount_AL3 = 1
CommandMasterResetLimit_AL0 = 10000
CommandMasterResetLimit_AL1 = 10000
CommandMasterResetLimit_AL2 = 10000
CommandMasterResetLimit_AL3 = 10000
CommandMasterResetLimitDay_AL0 = 5
CommandMasterResetLimitDay_AL1 = 5
CommandMasterResetLimitDay_AL2 = 5
CommandMasterResetLimitDay_AL3 = 5
CommandMasterResetLimitWek_AL0 = 100
CommandMasterResetLimitWek_AL1 = 100
CommandMasterResetLimitWek_AL2 = 100
CommandMasterResetLimitWek_AL3 = 100
CommandMasterResetLimitMon_AL0 = 500
CommandMasterResetLimitMon_AL1 = 500
CommandMasterResetLimitMon_AL2 = 500
CommandMasterResetLimitMon_AL3 = 500
CommandMasterResetStartLevel_AL0 = 400
CommandMasterResetStartLevel_AL1 = 400
CommandMasterResetStartLevel_AL2 = 400
CommandMasterResetStartLevel_AL3 = 400
CommandMasterResetStartReset_AL0 = -1
CommandMasterResetStartReset_AL1 = -1
CommandMasterResetStartReset_AL2 = -1
CommandMasterResetStartReset_AL3 = -1
CommandMasterResetPoint_AL0 = 0
CommandMasterResetPoint_AL1 = 0
CommandMasterResetPoint_AL2 = 0
CommandMasterResetPoint_AL3 = 0
CommandMasterResetPointRateDW = 100
CommandMasterResetPointRateDK = 100
CommandMasterResetPointRateFE = 100
CommandMasterResetPointRateMG = 100
CommandMasterResetPointRateDL = 100
CommandMasterResetPointRateSU = 100