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.