PDA

View Full Version : |Pedido| Alguem me ajuda a desativar essa Script nao quero mais



admmu
26/03/2020, 08:32 PM
-- /////////////////////////////////////////////////////////////////////////////////////////////////
-- International Gaming Center, copyright 2010-2015 -- [Only registered and activated users can see links]
--
-- Script allows to enable creation of Summoner or/and RageFighter without
-- a need to purchase Character Cards from Cash Shop
-- /////////////////////////////////////////////////////////////////////////////////////////////////


USE [MuOnline] -- set a current MuOnline database name here
GO


-- ##### ([Only registered and activated users can see links] %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23% 23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23 %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##
-- If set to 1 the option will remove previously added triggers
-- ##### ([Only registered and activated users can see links] %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23% 23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23 %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##
[Only registered and activated users can see links]


-- ///// CONFIG SECTION START //////////////////////////////////////////////////////////////////////
-- ##### ([Only registered and activated users can see links] %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23% 23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23 %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##
-- SECTION A -- if any value from section A set to 1 then section B must be set to 0, and vice-versa
-- ##### ([Only registered and activated users can see links] %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23% 23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23 %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##


-- set to 1 if wanting allow all players creating Summoner from level 1
[Only registered and activated users can see links]


-- set to 1 if wanting allow all players creating Rage Fighter from level 1
[Only registered and activated users can see links]


-- /////////////////////////////////////////////////////////////////////////////////////////////////
-- ##### ([Only registered and activated users can see links] %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23% 23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23 %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##
-- SECTION B -- if any value from section B set to 1 then section A must be set to 0, and vice-versa
-- ##### ([Only registered and activated users can see links] %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23% 23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23 %23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%2 3%23%23%23%23%23%23%23%23%23%23%23%23%23%23) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##


-- set to 1 if wanting restrict players to create Summoner from specified level
[Only registered and activated users can see links]


-- set to 1 if wanting reset ability to create Summoner to current players
[Only registered and activated users can see links]


-- set minimum level of character requiring to create Summoner
[Only registered and activated users can see links]




-- set to 1 if wanting restrict players to create Rage Fighter from specified level
[Only registered and activated users can see links]


-- set to 1 if wanting reset ability to create Rage Fighter to current players
[Only registered and activated users can see links]


-- set minimum level of character requiring to create Rage Fighter
[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'RageFighterActivation' AND type = 'TR')
BEGIN
DROP TRIGGER RageFighterActivation
print (N'INFO: RageFighterActivation deleted succesfully');
END

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'SummonerActivation' AND type = 'TR')
BEGIN
DROP TRIGGER SummonerActivation
print (N'INFO: SummonerActivation deleted succesfully');
END
RETURN
END
-- /////////////////////////////////////////////////////////////////////////////////////////////////
-- ##### ([Only registered and activated users can see links]) CONFIG SECTION END -- DO NOT MODIFY BELOW ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ####


-- CASE 1
[Only registered and activated users can see links]
BEGIN
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_AccountCharacter_Summoner]'))
BEGIN
ALTER TABLE dbo.AccountCharacter DROP CONSTRAINT DF_AccountCharacter_Summoner
END


ALTER TABLE dbo.AccountCharacter ADD CONSTRAINT DF_AccountCharacter_Summoner DEFAULT ((1)) FOR Summoner;

UPDATE dbo.AccountCharacter SET Summoner = 1
print (N'CASE 1: ALL OK')
END


[Only registered and activated users can see links]
print CHAR(13) + N'Something went wrong, verify configuration' + CHAR(13) + N'CASE 1: AllowCreateSummonnerFromLevel1 or AllowCreateSummonerAtDesiredLevel mis-configured, refer to Section A and B description'




-- CASE 2
[Only registered and activated users can see links]
BEGIN
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_AccountCharacter_RageFighter]'))
BEGIN
ALTER TABLE dbo.AccountCharacter DROP CONSTRAINT DF_AccountCharacter_RageFighter
END


ALTER TABLE dbo.AccountCharacter ADD CONSTRAINT DF_AccountCharacter_RageFighter DEFAULT ((1)) FOR RageFighter;

UPDATE dbo.AccountCharacter SET RageFighter = 1
print (N'CASE 2: ALL OK')
END


[Only registered and activated users can see links]
[Only registered and activated users can see links]




-- CASE 3
[Only registered and activated users can see links]
BEGIN
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_AccountCharacter_Summoner]'))
BEGIN
ALTER TABLE dbo.AccountCharacter DROP CONSTRAINT DF_AccountCharacter_Summoner
END


ALTER TABLE dbo.AccountCharacter ADD CONSTRAINT DF_AccountCharacter_Summoner DEFAULT ((0)) FOR Summoner;

[Only registered and activated users can see links]
BEGIN
UPDATE dbo.AccountCharacter SET Summoner = 0
END


IF EXISTS (SELECT * FROM sys.objects WHERE [type] = 'TR' AND [name] = 'SummonerActivation')
DROP TRIGGER SummonerActivation;

EXEC ('
CREATE TRIGGER SummonerActivation ON [dbo].[Character]
FOR UPDATE
AS
SET NOCOUNT ON
DECLARE accountID varchar(10);
[Only registered and activated users can see links]
SELECT accountID=i.AccountID FROM inserted i;
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE dbo.AccountCharacter SET Summoner = 1 WHERE Id = accountID
')
print (N'CASE 3: ALL OK')
END


[Only registered and activated users can see links]
print CHAR(13) + N'Something went wrong, verify configuration' + CHAR(13) + N'CASE 3: AllowCreateSummonnerFromLevel1 or AllowCreateSummonerAtDesiredLevel mis-configured, refer to Section A and B description'




-- CASE 4
[Only registered and activated users can see links]
BEGIN


IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_AccountCharacter_RageFighter]'))
BEGIN
ALTER TABLE dbo.AccountCharacter DROP CONSTRAINT DF_AccountCharacter_RageFighter
END


ALTER TABLE dbo.AccountCharacter ADD CONSTRAINT DF_AccountCharacter_RageFighter DEFAULT ((0)) FOR RageFighter;

[Only registered and activated users can see links]
BEGIN
UPDATE dbo.AccountCharacter SET RageFighter = 0
END


IF EXISTS (SELECT * FROM sys.objects WHERE [type] = 'TR' AND [name] = 'RageFighterActivation')
DROP TRIGGER RageFighterActivation;

EXEC ('
CREATE TRIGGER RageFighterActivation ON [dbo].[Character]
FOR UPDATE
AS
SET NOCOUNT ON
DECLARE accountID varchar(10);
[Only registered and activated users can see links]
SELECT accountID=i.AccountID FROM inserted i;
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE dbo.AccountCharacter SET RageFighter = 1 WHERE Id = accountID
')
print (N'CASE 4: ALL OK')
END


[Only registered and activated users can see links]
print CHAR(13) + N'Something went wrong, verify configuration' + CHAR(13) + N'CASE 4: AllowCreateRageFighterFromLevel1 or AllowCreateRageFighterAtDesiredLevel mis-configured, refer to Section A and B description'
GO

andredeco
26/03/2020, 08:57 PM
Pelo o que está escrito aí, em Inglês, basta colocar ZERo onde está 1 para desativar e depois rodar a Query novamente.

-- ///// CONFIG SECTION START //////////////////////////////////////////////////////////////////////
-- ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##
-- SECTION A -- if any value from section A set to 1 then section B must be set to 0, and vice-versa
-- ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##### ([Only registered and activated users can see links]) ##


-- set to 1 if wanting allow all players creating Summoner from level 1
[Only registered and activated users can see links]


-- set to 1 if wanting allow all players creating Rage Fighter from level 1
[Only registered and activated users can see links]