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
Printable View
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
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] @[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 = 30;
SET @[Only registered and activated users can see links. Click Here To Register...]ue_1 = 30;
SET @[Only registered and activated users can see links. Click Here To Register...]ue_2 = 30;
SET @[Only registered and activated users can see links. Click Here To Register...]ue_3 = 30;
-- SET O TYPE DA MOEDA
SET @TypeMoeda = 1;
-- 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
END
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 23
Sintaxe incorreta próxima a '@account'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 69
Sintaxe incorreta próxima a '@value_0'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 75
Sintaxe incorreta próxima a '@account'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 90
Sintaxe incorreta próxima a '@value_1'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 96
Sintaxe incorreta próxima a '@account'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 111
Sintaxe incorreta próxima a '@value_2'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 117
Sintaxe incorreta próxima a '@account'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 132
Sintaxe incorreta próxima a '@value_3'.
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_SetMasterResetInfo, Linha 138
Sintaxe incorreta próxima a '@account'.
Tenta corrigir isso : WHERE AccountID=@account AND Name=@Name
ta sem o "=" o código, lá em cima após AccountID