Alguem tem query pra quando da master reset web ferrarezi

[Gengar]

Alguem tem a query para quando dar master reset ganha uma quantidade de moedas no site ferrarezi se alguem puder ajuda e tbm se alguem puder me indicar como deixo pra abri so 2 mu por pc no louis emulador

[luigi01]

USE [muonline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetMasterResetInfo] Script Date: 19/11/2017 11:45:24 ******/
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]


[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 = 30;
SET value_1 = 30;
SET value_2 = 30;
SET value_3 = 30;


-- 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
END

[Gengar]

Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 23
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 69
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 75
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 90
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 96
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 111
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 117
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 132
[Only registered and activated users can see links]
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 138
[Only registered and activated users can see links]

[cleniojr]

[Only registered and activated users can see links]
ta sem o "=" o código, lá em cima após AccountID