Premiação ao dar Master Reset (Ganhar moedas)

Printable View

14/05/2018, 12:49 PM
chrorius

Premiação ao dar Master Reset (Ganhar moedas)

Galera, bom boa tarde.

Estou precisando adicionar um scritp que de moedas ao dar Master Reset. Alguém poderia me ajudar?

Obrigado.
14/05/2018, 03:54 PM
lkt22

Você quer colocar um Master Reset automático? É isso? E se a pessoa não quiser realizar esse M.R. ?? e.e
14/05/2018, 06:05 PM
maniacoo

Citação:

Originally Posted by chrorius [Only registered and activated users can see links. Click Here To Register...]

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
14/05/2018, 06:39 PM
chrorius

Season 4 Web Ferrarezi.
14/05/2018, 06:49 PM
lkt22

a Web do Ferrarezi já possui Sistema de Master Reset's ;)
15/05/2018, 01:55 AM
chrorius

Não, kkkk ..

Quero uma JOB para premiar quem der Master Resets. Ganhar X moeda.
15/05/2018, 02:11 AM
lkt22

Verdade, acho que assim é melhor mesmo. :)

Testa

Informação

Código:

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] @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...] AND Name=@Name -- DECLARA OS NÍVEL DE VIP DE 0 ATÉ 3 DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_3 INT; -- DECLARA OS VALORES DADO NO MASTER RESET DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_3 INT; -- DECLARA O TIPO DA MOEDA DADA NO MR DECLARE @TypeMoeda INT; -- SETA O NUMERO DO ACCOUNTLEVEL SET @[Only registered and activated users can see links. Click Here To Register...]Level_0 = 0; SET @[Only registered and activated users can see links. Click Here To Register...]Level_1 = 1; SET @[Only registered and activated users can see links. Click Here To Register...]Level_2 = 2; SET @[Only registered and activated users can see links. Click Here To Register...]Level_3 = 3; -- SETA O VALOR DADO NO MR A CADA TIPO DE VIP SET @[Only registered and activated users can see links. Click Here To Register...]ue_0 = 40; -- VALOR DA BONIFICAÇÃO DO VIP 0 SET @[Only registered and activated users can see links. Click Here To Register...]ue_1 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 1 SET @[Only registered and activated users can see links. Click Here To Register...]ue_2 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 2 SET @[Only registered and activated users can see links. Click Here To Register...]ue_3 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 3 -- SET O TYPE DA MOEDA SET @TypeMoeda = 2; -- TIPO DA MOEDA -- MASTER RESET FREE IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_0) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_0 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_0, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 1 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_1) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_1 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_1, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 2 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_2) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_2 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_2, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 3 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_3) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_3 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_3, @TypeMoeda) END END -- FIM SET NOCOUNT OFF SET XACT_ABORT OFF END GO

Citação:

Originally Posted by maniacoo [Only registered and activated users can see links. Click Here To Register...]

Testa

Informação

Código:

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] @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...] AND Name=@Name -- DECLARA OS NÍVEL DE VIP DE 0 ATÉ 3 DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_3 INT; -- DECLARA OS VALORES DADO NO MASTER RESET DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_3 INT; -- DECLARA O TIPO DA MOEDA DADA NO MR DECLARE @TypeMoeda INT; -- SETA O NUMERO DO ACCOUNTLEVEL SET @[Only registered and activated users can see links. Click Here To Register...]Level_0 = 0; SET @[Only registered and activated users can see links. Click Here To Register...]Level_1 = 1; SET @[Only registered and activated users can see links. Click Here To Register...]Level_2 = 2; SET @[Only registered and activated users can see links. Click Here To Register...]Level_3 = 3; -- SETA O VALOR DADO NO MR A CADA TIPO DE VIP SET @[Only registered and activated users can see links. Click Here To Register...]ue_0 = 40; -- VALOR DA BONIFICAÇÃO DO VIP 0 SET @[Only registered and activated users can see links. Click Here To Register...]ue_1 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 1 SET @[Only registered and activated users can see links. Click Here To Register...]ue_2 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 2 SET @[Only registered and activated users can see links. Click Here To Register...]ue_3 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 3 -- SET O TYPE DA MOEDA SET @TypeMoeda = 2; -- TIPO DA MOEDA -- MASTER RESET FREE IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_0) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_0 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_0, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 1 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_1) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_1 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_1, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 2 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_2) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_2 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_2, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 3 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_3) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_3 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_3, @TypeMoeda) END END -- FIM SET NOCOUNT OFF SET XACT_ABORT OFF END GO

Rapaz, ate minha procedure está rolando nos forums hahahaha.

15/05/2018, 05:39 PM
maniacoo

Citação:

Originally Posted by rian12 [Only registered and activated users can see links. Click Here To Register...]

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
15/05/2018, 07:30 PM
rian12

Citação:

Originally Posted by maniacoo [Only registered and activated users can see links. Click Here To Register...]

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.
15/05/2018, 07:33 PM
lkt22

Citação:

Originally Posted by rian12 [Only registered and activated users can see links. Click Here To Register...]

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!
16/05/2018, 06:41 PM
chrorius

Então foi algum desses dois ai que vazou sua procedure. rs

Testei e não funcionou.crying
16/05/2018, 07:27 PM
rian12

Citação:

Originally Posted by chrorius [Only registered and activated users can see links. Click Here To Register...]

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.
18/05/2018, 01:53 PM
chrorius

Concordo! Mas a procedure da erro. Mesmo tendo que configurar no muserver ela deveria pelo menos dar starting na job. Foi não. xD
13/06/2018, 12:37 AM
MuSoul

Bom utilizo a web Ferrarezi e o muemu s4 e deu várias erros ao executar a querry segue abaixo os erros

Citação:

Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 16
Incorrect syntax near '@account'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 54
Incorrect syntax near '@value_0'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 59
Incorrect syntax near '@account'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 71
Incorrect syntax near '@value_1'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 76
Incorrect syntax near '@account'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 88
Incorrect syntax near '@value_2'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 93
Incorrect syntax near '@account'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 105
Incorrect syntax near '@value_3'.
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 110
Incorrect syntax near '@account'.

Citação:

Originally Posted by maniacoo [Only registered and activated users can see links. Click Here To Register...]

Testa

Informação

Código:

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] @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...] AND Name=@Name -- DECLARA OS NÍVEL DE VIP DE 0 ATÉ 3 DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_3 INT; -- DECLARA OS VALORES DADO NO MASTER RESET DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_3 INT; -- DECLARA O TIPO DA MOEDA DADA NO MR DECLARE @TypeMoeda INT; -- SETA O NUMERO DO ACCOUNTLEVEL SET @[Only registered and activated users can see links. Click Here To Register...]Level_0 = 0; SET @[Only registered and activated users can see links. Click Here To Register...]Level_1 = 1; SET @[Only registered and activated users can see links. Click Here To Register...]Level_2 = 2; SET @[Only registered and activated users can see links. Click Here To Register...]Level_3 = 3; -- SETA O VALOR DADO NO MR A CADA TIPO DE VIP SET @[Only registered and activated users can see links. Click Here To Register...]ue_0 = 40; -- VALOR DA BONIFICAÇÃO DO VIP 0 SET @[Only registered and activated users can see links. Click Here To Register...]ue_1 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 1 SET @[Only registered and activated users can see links. Click Here To Register...]ue_2 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 2 SET @[Only registered and activated users can see links. Click Here To Register...]ue_3 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 3 -- SET O TYPE DA MOEDA SET @TypeMoeda = 2; -- TIPO DA MOEDA -- MASTER RESET FREE IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_0) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_0 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_0, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 1 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_1) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_1 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_1, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 2 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_2) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_2 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_2, @TypeMoeda) END END -- FIM -- MASTER RESET AccountLevel 3 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_3) BEGIN IF EXISTS (SELECT memb___id FROM Z_Credits WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda) BEGIN UPDATE Z_Credits SET value=value @[Only registered and activated users can see links. Click Here To Register...]ue_3 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND type = @TypeMoeda END ELSE BEGIN INSERT INTO Z_Credits (memb___id, value, type) VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ue_3, @TypeMoeda) END END -- FIM SET NOCOUNT OFF SET XACT_ABORT OFF END GO

Tem pra MuSite?

07/07/2018, 12:47 PM
Arcade

Citação:

Originally Posted by Fusion [Only registered and activated users can see links. Click Here To Register...]

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:

Código:

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] @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...] AND Name=@Name -- DECLARA OS NÍVEL DE VIP DE 0 ATÉ 3 DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_3 INT; -- DECLARA OS VALORES DADO NO MASTER RESET DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_3 INT; -- DECLARA O TIPO DA MOEDA DADA NO MR DECLARE @TypeMoeda INT; -- SETA O NUMERO DO ACCOUNTLEVEL SET @[Only registered and activated users can see links. Click Here To Register...]Level_0 = 0; SET @[Only registered and activated users can see links. Click Here To Register...]Level_1 = 1; SET @[Only registered and activated users can see links. Click Here To Register...]Level_2 = 2; SET @[Only registered and activated users can see links. Click Here To Register...]Level_3 = 3; -- SETA O VALOR DADO NO MR A CADA TIPO DE VIP SET @[Only registered and activated users can see links. Click Here To Register...]ue_0 = 40; -- VALOR DA BONIFICAÇÃO DO VIP 0 SET @[Only registered and activated users can see links. Click Here To Register...]ue_1 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 1 SET @[Only registered and activated users can see links. Click Here To Register...]ue_2 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 2 SET @[Only registered and activated users can see links. Click Here To Register...]ue_3 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 3 -- SET O TYPE DA MOEDA SET @TypeMoeda = 2; -- TIPO DA MOEDA -- MASTER RESET FREE IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_0) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_0 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] END -- FIM -- MASTER RESET AccountLevel 1 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_1) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_1 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] END -- FIM -- MASTER RESET AccountLevel 2 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_2) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_2 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] END -- FIM -- MASTER RESET AccountLevel 3 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_3) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_3 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] 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.

Citação:

Originally Posted by bruninho [Only registered and activated users can see links. Click Here To Register...]

Bom utilizo a web Ferrarezi e o muemu s4 e deu várias erros ao executar a querry segue abaixo os erros

Acusações de Incorrect syntax significam que não estão declaradas as variáveis que o erro está informando. O SQL Server utiliza case sensitive para suas querys e procedures, sendo assim se eu declarar uma variável com o nome @Account e mandar ele buscar a variável @account (tudo minúsculo) ele não vai encontrar e vai informar que a variável não foi declarada (não existe).

Verifique se as variáveis que estão sendo buscadas estão escritas exatamente iguais as variáveis declaradas.

Citação:

Originally Posted by rian12 [Only registered and activated users can see links. Click Here To Register...]

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

Citação:

Originally Posted by rian12 [Only registered and activated users can see links. Click Here To Register...]

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á.
08/07/2018, 11:58 PM
Fusion

Citação:

Originally Posted by Arcade [Only registered and activated users can see links. Click Here To Register...]

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:

Código:

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] @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...] AND Name=@Name -- DECLARA OS NÍVEL DE VIP DE 0 ATÉ 3 DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]Level_3 INT; -- DECLARA OS VALORES DADO NO MASTER RESET DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_0 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_1 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_2 INT; DECLARE @[Only registered and activated users can see links. Click Here To Register...]ue_3 INT; -- DECLARA O TIPO DA MOEDA DADA NO MR DECLARE @TypeMoeda INT; -- SETA O NUMERO DO ACCOUNTLEVEL SET @[Only registered and activated users can see links. Click Here To Register...]Level_0 = 0; SET @[Only registered and activated users can see links. Click Here To Register...]Level_1 = 1; SET @[Only registered and activated users can see links. Click Here To Register...]Level_2 = 2; SET @[Only registered and activated users can see links. Click Here To Register...]Level_3 = 3; -- SETA O VALOR DADO NO MR A CADA TIPO DE VIP SET @[Only registered and activated users can see links. Click Here To Register...]ue_0 = 40; -- VALOR DA BONIFICAÇÃO DO VIP 0 SET @[Only registered and activated users can see links. Click Here To Register...]ue_1 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 1 SET @[Only registered and activated users can see links. Click Here To Register...]ue_2 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 2 SET @[Only registered and activated users can see links. Click Here To Register...]ue_3 = 50; -- VALOR DA BONIFICAÇÃO DO VIP 3 -- SET O TYPE DA MOEDA SET @TypeMoeda = 2; -- TIPO DA MOEDA -- MASTER RESET FREE IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_0) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_0 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] END -- FIM -- MASTER RESET AccountLevel 1 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_1) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_1 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] END -- FIM -- MASTER RESET AccountLevel 2 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_2) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_2 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] END -- FIM -- MASTER RESET AccountLevel 3 IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] AND AccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level_3) BEGIN UPDATE "Tabela da Moeda" SET "Coluna da Moeda"="Coluna da Moeda"+@[Only registered and activated users can see links. Click Here To Register...]ue_3 WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...] 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.

Acusações de Incorrect syntax significam que não estão declaradas as variáveis que o erro está informando. O SQL Server utiliza case sensitive para suas querys e procedures, sendo assim se eu declarar uma variável com o nome @Account e mandar ele buscar a variável @account (tudo minúsculo) ele não vai encontrar e vai informar que a variável não foi declarada (não existe).

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:
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 17Incorrect syntax near '@account'.
09/07/2018, 03:29 AM
Arcade

Citação:

Originally Posted by Fusion [Only registered and activated users can see links. Click Here To Register...]

Deu esse erro parça:
Msg 102, Level 15, State 1, Procedure WZ_SetMasterResetInfo, Line 17Incorrect syntax near @[Only registered and activated users can see links. Click Here To Register...]'.

Imagino que no MuEmu essa procedure já existe, nesse caso altere essa linha:

Código:

CREATE Procedure [dbo].[WZ_SetMasterResetInfo] @[Only registered and activated users can see links. Click Here To Register...] varchar(10),

por essa:

Código:

ALTER Procedure [dbo].[WZ_SetMasterResetInfo] @[Only registered and activated users can see links. Click Here To Register...] varchar(10),

PS: Dê um enter na palavra @[Only registered and activated users can see links. Click Here To Register...] também, SQL as vezes é chatinho nisso...

Teste e veja se dá gol.