Mostrar posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Anemone

Paginas: 1 ... 9 10 [11]
201
Alguien que pueda ayudarme porfavor.

202
Presentaciones / PRESENTACION Presentacion.
« on: June 10, 2018, 07:49:46 AM »
Buenos Días

Espero que se encuentren bien, hace muy poco descubrí esta pagina y esta excelente.
Yo ya tengo mis años, hace años cree mi servidor S6E3 con guiás de otro foro, ahora he retomado nuevamente
Como desafió personal poder levantar un servidor S12 de unos files presentados aquí lo cual agradezco mucho.

Les cuento y espero que no me juzguen y puedan comprender, siendo sincero, en estos momentos me encuentro con arresto domiciliario y con un juicio a seguir en unos meses.
Y en estos me sobra mucho tiempo ahora, siendo un poco optimista dentro de todo esto y retomar nuevamente después de muchos años esta pasión que era el MU, pero ahora me encuentro con ya el S12, los años han pasado volando y ver todo lo que tiene
Ahora es algo nuevo para mi, pero eso me anima a poder desconectarme y mantener mi mente ocupada.

Tratare de resolver los problemas de este proyecto con sus guiás lo cual veo son muy didácticas la mayoría y así poder evitar molestarlos, pero si tengo alguna duda tirare algún hilo a soporte.

Bueno, esa es mi situación en estos momentos, siendo optimista, aprender, actualizarme con este antiguo hobby que he retomado.

Saludos y Gracias por su Atención.


203
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.

Paginas: 1 ... 9 10 [11]