Galera, bom boa tarde.
Estou precisando adicionar um scritp que de moedas ao dar Master Reset. Alguém poderia me ajudar?
Obrigado.
Printable View
Galera, bom boa tarde.
Estou precisando adicionar um scritp que de moedas ao dar Master Reset. Alguém poderia me ajudar?
Obrigado.
Você quer colocar um Master Reset automático? É isso? E se a pessoa não quiser realizar esse M.R. ?? e.e
Qual versao do servidor e qual site esta usandoCitação:
Originally Posted by chrorius [Only registered and activated users can see links. Click Here To Register...]
Season 4 Web Ferrarezi.
a Web do Ferrarezi já possui Sistema de Master Reset's ;)
Não, kkkk ..
Quero uma JOB para premiar quem der Master Resets. Ganhar X moeda.
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
Rapaz, ate minha procedure está rolando nos forums hahahaha.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 criouCitação:
Originally Posted by rian12 [Only registered and activated users can see links. Click Here To Register...]
só recebi e estou repassando