Buenas Noches
Tengo una duda la cual es el poder incluir al Rage Fighter y Summoner para poder crearlos con un cierto lvl, similar al darklord y mg....creo que en estos files se crean con la moneda wcoin.
he buscado en los files del cliente, files y sql, pero no logro dar con la opción y que debería colocar,
he buscado en soporte alguna solución pero no la encuentro, solo encuentro la que dan zen o items al crearse un PJ pero con otros files.
He encontrado esto en las guiás de MuEmu:
SUM / RF Creation Level Requirement
The tutorial will describe how to restrict creation of summoner or ragefighter from a certain level.
Follow to
\Server\Database\Extras\Triggers and open with notepad
Summoner_RageFighter_Creation.sql file
*Copy the query given below and replace with existing in
Summoner_RageFighter_Creation.sql.
*Adjust your
level for RF / SUM creation in
SECTION B,
CASE 3 and
CASE 4.
*For a custom configuration with for example SUM available at start, and RF from
certain level - edit
@AllowCreate property in
SECTION A and
SECTION B.
* Save and execute
Summoner_RageFighter_Creation.sql.Spoiler for Hiden:
USE [MuOnline] -- set a current MuOnline database name here
GO
ALTER TABLE [AccountCharacter] DROP CONSTRAINT [DF_AccountCharacter_Summoner];
ALTER TABLE [AccountCharacter] ALTER COLUMN [Summoner] int not null;
ALTER TABLE [AccountCharacter] ADD CONSTRAINT [DF_AccountCharacter_Summoner] DEFAULT ((0)) FOR [Summoner];
ALTER TABLE [AccountCharacter] DROP CONSTRAINT [DF_AccountCharacter_RageFighter];
ALTER TABLE [AccountCharacter] ALTER COLUMN [RageFighter] int not null;
ALTER TABLE [AccountCharacter] ADD CONSTRAINT [DF_AccountCharacter_RageFighter] DEFAULT ((0)) FOR [RageFighter];
-- #################################################################################################
-- If set to 1 the option will remove previously added triggers
-- #################################################################################################
DECLARE @RemoveTriggers INT = 0
-- ///// CONFIG SECTION START //////////////////////////////////////////////////////////////////////
-- #################################################################################################
-- SECTION A -- if any value from section A set to 1 then section B must be set to 0, and vice-versa
-- #################################################################################################
-- set to 1 if wanting allow all players creating Summoner from level 1
DECLARE @AllowCreateSummonnerFromLevel1 INT = 0
-- set to 1 if wanting allow all players creating Rage Fighter from level 1
DECLARE @AllowCreateSummonnerFromLevel1 INT = 0
-- /////////////////////////////////////////////////////////////////////////////////////////////////
-- #################################################################################################
-- SECTION B -- if any value from section B set to 1 then section A must be set to 0, and vice-versa
-- #################################################################################################
-- set to 1 if wanting restrict players to create Summoner from specified level
DECLARE @AllowCreateSummonerAtDesiredLevel INT = 1
-- set to 1 if wanting reset ability to create Summoner to current players
DECLARE @ResetCurrentPlayersPossibilityToCreateSummoner INT = 0
-- set minimum level of character requiring to create Summoner
DECLARE @SummonerCreateLevel INT = 150
-- set to 1 if wanting restrict players to create Rage Fighter from specified level
DECLARE @AllowCreateRageFighterAtDesiredLevel INT = 1
-- set to 1 if wanting reset ability to create Rage Fighter to current players
DECLARE @ResetCurrentPlayersPossibilityToCreateRageFighter INT = 0
-- set minimum level of character requiring to create Rage Fighter
DECLARE @RageFighterCreateLevel INT = 200
IF (@RemoveTriggers = 1)
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
-- /////////////////////////////////////////////////////////////////////////////////////////////////
-- ##### CONFIG SECTION END -- DO NOT MODIFY BELOW #################################################
-- CASE 1
IF (@AllowCreateSummonnerFromLevel1 = 1 AND @AllowCreateSummonerAtDesiredLevel = 0)
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
ELSE IF (@AllowCreateSummonnerFromLevel1 = 1 AND @AllowCreateSummonerAtDesiredLevel = 1)
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
IF (@AllowCreateRageFighterFromLevel1 = 1 AND @AllowCreateRageFighterAtDesiredLevel = 0)
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
ELSE IF (@AllowCreateRageFighterFromLevel1 = 1 AND @AllowCreateRageFighterAtDesiredLevel = 1)
print CHAR(13) + N'Something went wrong, verify configuration' + CHAR(13) + N'CASE 2: AllowCreateRageFighterFromLevel1
or @AllowCreateRageFighterAtDesiredLevel mis-configured, refer to Section A and B description'
-- CASE 3
IF (@AllowCreateSummonnerFromLevel1 = 0 AND @AllowCreateSummonerAtDesiredLevel = 1)
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 ((150)) FOR Summoner;
IF (@ResetCurrentPlayersPossibilityToCreateSummoner = 1)
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);
DECLARE @cLevel int;
SELECT @AccountID=i.AccountID FROM inserted i;
SELECT @cLevel=i.cLevel FROM inserted i;
IF (UPDATE(cLevel) AND (@cLevel >= ' + @SummonerCreateLevel + '))
UPDATE dbo.AccountCharacter SET Summoner = 1 WHERE Id = @AccountID
')
print (N'CASE 3: ALL OK')
END
ELSE IF (@AllowCreateSummonnerFromLevel1 = 1 AND @AllowCreateSummonerAtDesiredLevel = 1)
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
IF (@AllowCreateRageFighterFromLevel1 = 0 AND @AllowCreateRageFighterAtDesiredLevel = 1)
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 ((200)) FOR RageFighter;
IF (@ResetCurrentPlayersPossibilityToCreateRageFighter = 1)
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);
DECLARE @cLevel int;
SELECT @AccountID=i.AccountID FROM inserted i;
SELECT @cLevel=i.cLevel FROM inserted i;
IF (UPDATE(cLevel) AND (@cLevel >= ' + @RageFighterCreateLevel + '))
UPDATE dbo.AccountCharacter SET RageFighter = 1 WHERE Id = @AccountID
')
print (N'CASE 4: ALL OK')
END
ELSE IF (@AllowCreateRageFighterFromLevel1 = 1 AND @AllowCreateRageFighterAtDesiredLevel = 1)
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 |
Esto es lo que quiero hacer exactamente, poder crearlos RF y SUM como un determinado lvl sin la Wcoin, pero no encuentro esta carpeta \Extras\Triggers en mi DataBase para poder pegarlo.
Estoy usando los files Files Season 12 IGCN y SQL2012 RE - MuEmu aportados aqui en el foro.
Ruego si podrían ayudarme por favor que estoy hace días con este problema, Disculpen las molestias causadas, muchas gracias.
Home
TOP Ranking MU
Magichand
Fanpage
Tags
Login
Register
Topic: Poder Habilitar Rage Fighter y Summoner, Files Season 12 IGCN Muemu (Visto 5946 veces)
July 12, 2018, 05:22:04 PM
