|Suporte| Problema com o limite de resets [Arquivo] - Bau Perfectzone - 2013

View Full Version : |Suporte| Problema com o limite de resets

MarquitoXx

29/05/2019, 06:12 PM

Denis Alves

30/05/2019, 01:31 AM

Boa tarde membros de PerfectZone, queria fazer uma consulta ... Acontece que eu quero colocar r3sets por dia, semana e mês, eu li algum post sobre esse tópico e acho que configurei tudo corretamente ...
O problema é este: Estes WZ_SetResetInfo e WZ_GetResetInfo, são redefinidos por dia? Se eu definir o limite 3 r3s3ts por dia e fizer os respectivos r3sets no jogo a tabela Character atualiza sua tabela ResetDay = 3, no dia seguinte a tabela será atualizada para 0?
Eu queria fazer um teste ontem, mas o jogo continua dizendo que eu ultrapassei as reinicializações por dia, alguma ajuda ???

Muito obrigado

Nesse caso a WZ_SetResetInfo e WZ_GetResetInfo são arquivos de configuração feitos para que manipule o armazenamento dos resets nas colunas específicas. Com base no que você especificou, o que quer é um sistema de ranking que zere a coluna (que seja diariamente, semanalmente ou mensalmente). Respectivamente, isso é feito através de sistema Jobs. Dê uma pesquisada no fórum que fala sobre preparo de Rankings Diario/Semanal/Mensal. Claro, você aplica o que você achar melhor.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Jobs: Reset Diário

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

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[uncategorized (Local)]') < 1
[Only registered and activated users can see links]

[Only registered and activated users can see links]

[Only registered and activated users can see links]
BEGIN

[Only registered and activated users can see links]
BEGIN

RAISERROR (N'Unable to import job ''ResetDay'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END

BEGIN

[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]
[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]

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

END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
[Only registered and activated users can see links]
EndSave:

Job Reset Semanal

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

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[uncategorized (Local)]') < 1
[Only registered and activated users can see links]

[Only registered and activated users can see links]

[Only registered and activated users can see links]
BEGIN

[Only registered and activated users can see links]
BEGIN

RAISERROR (N'Unable to import job ''ResetWek'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END

BEGIN

[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]
[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]

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

END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
[Only registered and activated users can see links]
EndSave:

Job Reset Mensal

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

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[uncategorized (Local)]') < 1
[Only registered and activated users can see links]

[Only registered and activated users can see links]

[Only registered and activated users can see links]
BEGIN

[Only registered and activated users can see links]
BEGIN

RAISERROR (N'Unable to import job ''ResetMon'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END

BEGIN

[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]
[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]

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

END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
[Only registered and activated users can see links]
EndSave:

Vale lembrar que configure cada um com as colunas que você irá utilizar para zerar, ou seja, se for pra zerar ranking mensal procure a coluna "ResetMon" e configure com a tabela utilizada para tal ranking.

MarquitoXx

30/05/2019, 09:33 PM

Caro denizinhu, antes de tudo, muito obrigado pela sua resposta, vou executar as querys que você mencionou e vou ver se funciona. Eu só tinha "configurado" tanto WZ_GetResetInfo e WZ_SetResetinfo como segue:

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_GetResetInfo] Script Date: 05/30/2019 20:43:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_GetResetInfo] account varchar(10),
@Name varchar(10)
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]
[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 NOCOUNT OFF
SET XACT_ABORT OFF

END

__________________________________________________ ________________________________________

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetResetInfo] Script Date: 05/30/2019 20:43:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_SetResetInfo] account varchar(10),
@Name varchar(10),
@Reset int,
@ResetDay int,
@ResetWek int,
@ResetMon 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

Peço desculpas por ser irritante e se surgir um problema eu notifico no post ...
Mais uma vez, muito obrigado e vou estar relatando!

Denis Alves

30/05/2019, 11:20 PM

Caro denizinhu, antes de tudo, muito obrigado pela sua resposta, vou executar as querys que você mencionou e vou ver se funciona. Eu só tinha "configurado" tanto WZ_GetResetInfo e WZ_SetResetinfo como segue:

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_GetResetInfo] Script Date: 05/30/2019 20:43:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[Only registered and activated users can see links]
@Name varchar(10)
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]
[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 NOCOUNT OFF
SET XACT_ABORT OFF

END

__________________________________________________ ________________________________________

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetResetInfo] Script Date: 05/30/2019 20:43:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[Only registered and activated users can see links]
@Name varchar(10),
@Reset int,
@ResetDay int,
@ResetWek int,
@ResetMon 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

Peço desculpas por ser irritante e se surgir um problema eu notifico no post ...
Mais uma vez, muito obrigado e vou estar relatando!

Tudo bem, qualquer coisa pode entrar em contato :)

MarquitoXx

31/05/2019, 04:07 AM

Tudo bem, qualquer coisa pode entrar em contato :)

Eu atualizo o post, eu não posso executar os trabalhos acima mencionados. O erro que aparece é "SQLServerAgent is not currently running so it cannot be notified of this action." E eu acho que, infelizmente, eu não posso executar a consulta, eu não posso executar o SQL Agent, eu acho que um erro de "the request failed or the service did not respond in a timely fashion." Talvez fosse porque eu instalei o SQL errado... Estou pensando em reinstalar o programa, mas se houver alguma solução para isso me ajudaria muito!!!

Denis Alves

31/05/2019, 04:48 PM

Eu atualizo o post, eu não posso executar os trabalhos acima mencionados. O erro que aparece é "SQLServerAgent is not currently running so it cannot be notified of this action." E eu acho que, infelizmente, eu não posso executar a consulta, eu não posso executar o SQL Agent, eu acho que um erro de "the request failed or the service did not respond in a timely fashion." Talvez fosse porque eu instalei o SQL errado... Estou pensando em reinstalar o programa, mas se houver alguma solução para isso me ajudaria muito!!!

entre em contato!