View Full Version : |Pedido| Premiação ao dar Master Reset (Ganhar moedas)
chrorius
14/05/2018, 12:49 PM
Galera, bom boa tarde.
Estou precisando adicionar um scritp que de moedas ao dar Master Reset. Alguém poderia me ajudar?
Obrigado.
lkt22
14/05/2018, 03:54 PM
Você quer colocar um Master Reset automático? É isso? E se a pessoa não quiser realizar esse M.R. ?? e.e
maniacoo
14/05/2018, 06:05 PM
Galera, bom boa tarde.
Estou precisando adicionar um scritp que de moedas ao dar Master Reset. Alguém poderia me ajudar?
Obrigado.
Qual versao do servidor e qual site esta usando
chrorius
14/05/2018, 06:39 PM
Season 4 Web Ferrarezi.
lkt22
14/05/2018, 06:49 PM
a Web do Ferrarezi já possui Sistema de Master Reset's ;)
chrorius
15/05/2018, 01:55 AM
Não, kkkk ..
Quero uma JOB para premiar quem der Master Resets. Ganhar X moeda.
lkt22
15/05/2018, 02:11 AM
Verdade, acho que assim é melhor mesmo. :)
maniacoo
15/05/2018, 02:16 AM
Testa
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 05/08/2016 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE 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
[Only registered and activated users can see links]
-- 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
[Only registered and activated users can see links]
-- 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 = 40; -- VALOR DA BONIFICAÇÃO DO VIP 0
SET value_1 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 1
SET value_2 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 2
SET value_3 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 3
-- SET O TYPE DA MOEDA
[Only registered and activated users can see links]
-- MASTER RESET FREE
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = account AND AccountLevel = accountLevel_0)
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
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = account AND AccountLevel = accountLevel_1)
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
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = account AND AccountLevel = accountLevel_2)
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
IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = account AND AccountLevel = accountLevel_3)
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
GO
rian12
15/05/2018, 03:17 PM
Testa
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 05/08/2016 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[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]
-- 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
GO
Rapaz, ate minha procedure está rolando nos forums hahahaha.
maniacoo
15/05/2018, 05:39 PM
Rapaz, ate minha procedure está rolando nos forums hahahaha.
Se é sua eu nao sei, nao tem nome de quem criou
só recebi e estou repassando
rian12
15/05/2018, 07:30 PM
Se é sua eu nao sei, nao tem nome de quem criou
só recebi e estou repassando
Po sem stress mano, so e engraçado como que essas coisa vaza sendo que passei para no maximo ums 2 amigos só rsrs.
lkt22
15/05/2018, 07:33 PM
Po sem stress mano, so e engraçado como que essas coisa vaza sendo que passei para no maximo ums 2 amigos só rsrs.
1 > 2 > 4 > 8 > 16 > 32 > 64... ao infinito, e além!
chrorius
16/05/2018, 06:41 PM
Então foi algum desses dois ai que vazou sua procedure. rs
Testei e não funcionou.crying
rian12
16/05/2018, 07:27 PM
Então foi algum desses dois ai que vazou sua procedure. rs
Testei e não funcionou.crying
Se for web ferrarezi ela funciona 100% porem não e so instalar a procedure tem que configurar no MuServer também.
chrorius
18/05/2018, 01:53 PM
Concordo! Mas a procedure da erro. Mesmo tendo que configurar no muserver ela deveria pelo menos dar starting na job. Foi não. xD
MuSoul
13/06/2018, 12:37 AM
Bom utilizo a web Ferrarezi e o muemu s4 e deu várias erros ao executar a querry segue abaixo os erros
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 16
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 54
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 59
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 71
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 76
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 88
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 93
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 105
[Only registered and activated users can see links]
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 110
[Only registered and activated users can see links]
Fusion
07/07/2018, 04:06 AM
Testa
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 05/08/2016 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[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]
-- 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
GO
Tem pra MuSite?
Arcade
07/07/2018, 12:47 PM
Tem pra MuSite?
Com o básico de conhecimento, um pouco de dedicação para entender a query postada, qualquer admin pode alterar ao seu gosto. Eis como ficaria para MuSite:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 05/08/2016 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[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]
-- 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]
END
-- FIM
-- MASTER RESET AccountLevel 1
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END
-- FIM
-- MASTER RESET AccountLevel 2
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END
-- FIM
-- MASTER RESET AccountLevel 3
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END
-- FIM
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
GO
OBS: Onde está "Tabela da Moeda" você altera para o nome da tabela onde se encontra a coluna da moeda que você quer premiar e onde está "Coluna da Moeda" você altera para o nome da coluna da moeda.
Bom utilizo a web Ferrarezi e o muemu s4 e deu várias erros ao executar a querry segue abaixo os erros
[Only registered and activated users can see links]
Verifique se as variáveis que estão sendo buscadas estão escritas exatamente iguais as variáveis declaradas.
Rapaz, ate minha procedure está rolando nos forums hahahaha.
Até onde eu fiquei sabendo essa query foi criada por Vagner C. alguém que já trabalhou com o tal de Leo Ferrarezi, mas vai saber né, sempre dizem que é de um, que é de outro, só sei que nada sei :ott1
Po sem stress mano, so e engraçado como que essas coisa vaza sendo que passei para no maximo ums 2 amigos só rsrs.
Isso é fácil, qualquer um que tenha acesso ao fórum da X-Team pega essa query, pois a mesma está (ou pelo menos estava) postada lá.
Fusion
08/07/2018, 11:58 PM
Com o básico de conhecimento, um pouco de dedicação para entender a query postada, qualquer admin pode alterar ao seu gosto. Eis como ficaria para MuSite:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 05/08/2016 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[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]
-- 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]
END
-- FIM
-- MASTER RESET AccountLevel 1
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END
-- FIM
-- MASTER RESET AccountLevel 2
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END
-- FIM
-- MASTER RESET AccountLevel 3
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END
-- FIM
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
GO
OBS: Onde está "Tabela da Moeda" você altera para o nome da tabela onde se encontra a coluna da moeda que você quer premiar e onde está "Coluna da Moeda" você altera para o nome da coluna da moeda.
[Only registered and activated users can see links]
Verifique se as variáveis que estão sendo buscadas estão escritas exatamente iguais as variáveis declaradas.
Até onde eu fiquei sabendo essa query foi criada por Vagner C. alguém que já trabalhou com o tal de Leo Ferrarezi, mas vai saber né, sempre dizem que é de um, que é de outro, só sei que nada sei :ott1
Isso é fácil, qualquer um que tenha acesso ao fórum da X-Team pega essa query, pois a mesma está (ou pelo menos estava) postada lá.
Deu esse erro parça:
[Only registered and activated users can see links]
Arcade
09/07/2018, 03:29 AM
Deu esse erro parça:
[Only registered and activated users can see links]
Imagino que no MuEmu essa procedure já existe, nesse caso altere essa linha:
[Only registered and activated users can see links]
por essa:
ALTER Procedure [dbo].[WZ_SetMasterResetInfo]
@account ([Only registered and activated users can see links]) varchar(10),
[Only registered and activated users can see links]
Teste e veja se dá gol.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.