Gengar
20/02/2019, 07:07 PM
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
20/02/2019, 08:44 PM
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
20/02/2019, 10:23 PM
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
06/06/2019, 11:46 AM
[Only registered and activated users can see links]
ta sem o "=" o código, lá em cima após AccountID
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.