PDA

View Full Version : |Suporte| Master Reset Configuração


mcostta
21/07/2016, 11:28 PM
esse post é referente aos seguintes post:


[Only registered and activated users can see links]


[Only registered and activated users can see links]






----
[Only registered and activated users can see links]



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]
[Only registered and activated users can see links]
@Name varchar(10),
@Reset int,
@MasterReset int,
@MasterResetDay int,
@MasterResetWek int,
@MasterResetMon int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

[Only registered and activated users can see links]

[Only registered and activated users can see links]

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
Marco_Aurélio
22/07/2016, 11:34 AM
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.
lorranmota
24/07/2016, 02:58 AM
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
[Only registered and activated users can see links]
[Only registered and activated users can see links]
MasterResetCountDay=MasterResetCountDay+1,
MasterResetCountWeek=MasterResetCountWeek+1,
MasterResetCountMonth=MasterResetCountMonth+1
[Only registered and activated users can see links]


-- DECLARA OS NÍVEL DE VIP DE 0 ATÉ 3
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- DECLARA OS VALORES DADO NO MASTER RESET
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- DECLARA O TIPO DA MOEDA DADA NO MR
[Only registered and activated users can see links]


-- SETA O NUMERO DO ACCOUNTLEVEL
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- SETA O VALOR DADO NO MR A CADA TIPO DE VIP
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- SET O TYPE DA MOEDA
[Only registered and activated users can see links]


-- MASTER RESET FREE
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END


ELSE
BEGIN
[Only registered and activated users can see links]
END


END
-- FIM


-- MASTER RESET AccountLevel 1
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END


ELSE
BEGIN
[Only registered and activated users can see links]
END


END
-- FIM


-- MASTER RESET AccountLevel 2
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END


ELSE
BEGIN
[Only registered and activated users can see links]
END


END
-- FIM


-- MASTER RESET AccountLevel 3
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]


END


ELSE
BEGIN
[Only registered and activated users can see links]
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