Old system bringer

Results 1 to 10 of 10
  1. #1
    Member Drafys17 is offline
    MemberRank
    Aug 2013 Join Date
    37Posts

    Old system bringer


    RaGEZONE Recommends

    RaGEZONE Recommends

    Hello! I added to the database this procedure cabal_sp_lordofwar_set_new_lord, at the moment I have 6 bringers class. I want to do to have only 1 of bring and 6 guardians of light and storms.
    I tried to add these procedures but nothing came of it, who can give the push that you need to add these procedures.

    - create new table for guardians same with lordofwar table
    - create new SP to get_new_guardian
    - modify the SP set_new_lord to set bringers and guardians (rank1 = bringer, rank2 = guardian)
    - modify the SP get_cabal_character
    - modify the SP set_cabal_character


  2. #2
    Account Upgraded | Title Enabled! joel de paula is offline
    True MemberRank
    May 2011 Join Date
    389Posts

    Re: Old system bringer

    I think it would be a good discussion about this system that many are behind, I know a user named Jaguar published, something related to that, but I do not remember if it is with 1 bringer and 6 guardian

  3. #3
    Moderator AzureSensei is offline
    ModeratorRank
    Aug 2013 Join Date
    GN-z11 / f451Location
    214Posts

    Re: Old system bringer

    6 Bringers:
    Code:
    USE [CBL_Server01]GO/****** Object:  StoredProcedure [dbo].[cabal_sp_lordofwar_set_new_lord]    Script Date: 4/19/2014 2:45:28 AM ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:            PX2000-- Create date:        2013.11.22-- Description:        LORDOFWAR PER CLASS/NATIONS-- Project User:    OnidGames.net-- =============================================ALTER PROCEDURE [dbo].[cabal_sp_lordofwar_set_new_lord]  @OverWaRJoinCount int)ASBEGIN    DECLARE @warChannelType INT, @count1 int, @count2 int    DELETE [cabal_LordOfWar_table]    SET @warChannelType = 0    WHILE @warChannelType < 10)    BEGIN        SET @count1 = 1         WHILE @count1 <= 2)        BEGIN            SET @count2 = 1            WHILE @count2 <= 6)            BEGIN                IF (EXISTS(SELECT * FROM dbo.cabal_LordOfWar_point_table AS A, dbo.cabal_character_table AS B                WHERE A.CharacterIdx = B.CharacterIdx AND (B.Style/POWER(2,0)&(POWER(2,3)-1)) @count2))                BEGIN                    INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)                    SELECT top 1 C.CharacterIdx, @warChannelType, max(D.Nation)                    FROM dbo.cabal_LordOfWar_point_table AS C, dbo.cabal_character_table AS D                    WHERE C.characterIdx = D.characterIdx AND D.Nation = @count1 AND (D.Style/POWER(2,0)&(POWER(2,3)-1)) @count2                    AND C.WarChannelType = @warChannelType AND C.ValidPoint = 1                    GROUP BY C.characterIdx HAVING count(*) >= @OverWaRJoinCount                    ORDER BY sum(C.WarPoint) desc, max(D.LEV) desc, C.characterIdx                END            SET @count2 = @count2+1            END        SET @count1 = @count1+1        END    SET @warChannelType = @warChannelType + 1    END    DELETE [cabal_LordOfWar_Rank_table]    DELETE [cabal_LordOfWar_point_table]END

    1 Bringer
    Code:
    USE [Server01]GO/****** Object:  StoredProcedure [dbo].[cabal_sp_lordofwar_set_new_lord]    Script Date: 06/11/2016 20:20:11 ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[cabal_sp_lordofwar_set_new_lord]  @OverWaRJoinCount int)ASBEGIN    DECLARE @warChannelType INT    SET @warChannelType = 0    DELETE [cabal_LordOfWar_table]    WHILE @warChannelType < 10)    BEGIN        INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, @warChannelType, max(nation)        FROM dbo.cabal_LordOfWar_point_table AS A, DBO.cabal_character_table B        WHERE A.characterIdx = B.characterIdx AND nation = 1 AND WarChannelType = @warChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= @OverWaRJoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx                INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, @warChannelType, max(nation)        FROM dbo.cabal_LordOfWar_point_table AS A, DBO.cabal_character_table B        WHERE A.characterIdx = B.characterIdx AND nation = 2 AND WarChannelType = @warChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= @OverWaRJoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx        SET @warChannelType = @warChannelType + 1    END    DELETE [cabal_LordOfWar_Rank_table]    DELETE [cabal_LordOfWar_point_table]END

    Although I am curious about Guardians myself, would be nice if someone shared some queries or hints / tips on setuping 6 guardians of each class.
    Attached Files Attached Files
    Like or Rep is the best way to show appreciation!


  4. #4
    Account Upgraded | Title Enabled! luis R is offline
    True MemberRank
    Nov 2015 Join Date
    467Posts

    Re: Old system bringer

    try this

    Code:
    USE [Server01]GO/****** Object:  StoredProcedure [dbo].[cabal_sp_lordofwar_set_new_lord]    Script Date: 4/19/2014 2:45:28 AM ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:			PX2000-- Create date:		2013.11.22-- Description:		LORDOFWAR PER CLASS/NATIONS-- Project User:	OnidGames.net-- =============================================ALTER PROCEDURE [dbo].[cabal_sp_lordofwar_set_new_lord]   @OverWaRJoinCount int)ASBEGIN	DECLARE  @warChannelType INT,  @count1 int,  @count2 int	DELETE [cabal_LordOfWar_table]	SET  @warChannelType = 0	WHILE  @warChannelType < 10)	BEGIN		SET  @count1 = 1 		WHILE  @count1 <= 2)		BEGIN			SET  @count2 = 1			WHILE  @count2 <= 6)			BEGIN				IF (EXISTS(SELECT * FROM dbo.cabal_LordOfWar_point_table AS A, dbo.cabal_character_table AS B				WHERE A.CharacterIdx = B.CharacterIdx AND (B.Style/POWER(2,0)&(POWER(2,3)-1))  @count2))				BEGIN					INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)					SELECT top 1 C.CharacterIdx,  @warChannelType, max(D.Nation)					FROM dbo.cabal_LordOfWar_point_table AS C, dbo.cabal_character_table AS D					WHERE C.characterIdx = D.characterIdx AND D.Nation =  @count1 AND (D.Style/POWER(2,0)&(POWER(2,3)-1))  @count2					AND C.WarChannelType =  @warChannelType AND C.ValidPoint = 1					GROUP BY C.characterIdx HAVING count(*) >=  @OverWaRJoinCount					ORDER BY sum(C.WarPoint) desc, max(D.LEV) desc, C.characterIdx				END			SET  @count2 =  @count2+1			END		SET  @count1 =  @count1+1		END	SET  @warChannelType =  @warChannelType + 1	END	DELETE [cabal_LordOfWar_Rank_table]	DELETE [cabal_LordOfWar_point_table]END
    - - - Updated - - -

    Quote Originally Posted by Augis24 View Post
    6 Bringers:
    Code:
    USE [CBL_Server01]GO/****** Object:  StoredProcedure [dbo].[cabal_sp_lordofwar_set_new_lord]    Script Date: 4/19/2014 2:45:28 AM ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:            PX2000-- Create date:        2013.11.22-- Description:        LORDOFWAR PER CLASS/NATIONS-- Project User:    OnidGames.net-- =============================================ALTER PROCEDURE [dbo].[cabal_sp_lordofwar_set_new_lord]  @OverWaRJoinCount int)ASBEGIN    DECLARE @warChannelType INT, @count1 int, @count2 int    DELETE [cabal_LordOfWar_table]    SET @warChannelType = 0    WHILE @warChannelType < 10)    BEGIN        SET @count1 = 1         WHILE @count1 <= 2)        BEGIN            SET @count2 = 1            WHILE @count2 <= 6)            BEGIN                IF (EXISTS(SELECT * FROM dbo.cabal_LordOfWar_point_table AS A, dbo.cabal_character_table AS B                WHERE A.CharacterIdx = B.CharacterIdx AND (B.Style/POWER(2,0)&(POWER(2,3)-1)) @count2))                BEGIN                    INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)                    SELECT top 1 C.CharacterIdx, @warChannelType, max(D.Nation)                    FROM dbo.cabal_LordOfWar_point_table AS C, dbo.cabal_character_table AS D                    WHERE C.characterIdx = D.characterIdx AND D.Nation = @count1 AND (D.Style/POWER(2,0)&(POWER(2,3)-1)) @count2                    AND C.WarChannelType = @warChannelType AND C.ValidPoint = 1                    GROUP BY C.characterIdx HAVING count(*) >= @OverWaRJoinCount                    ORDER BY sum(C.WarPoint) desc, max(D.LEV) desc, C.characterIdx                END            SET @count2 = @count2+1            END        SET @count1 = @count1+1        END    SET @warChannelType = @warChannelType + 1    END    DELETE [cabal_LordOfWar_Rank_table]    DELETE [cabal_LordOfWar_point_table]END

    1 Bringer
    Code:
    USE [Server01]GO/****** Object:  StoredProcedure [dbo].[cabal_sp_lordofwar_set_new_lord]    Script Date: 06/11/2016 20:20:11 ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[cabal_sp_lordofwar_set_new_lord]  @OverWaRJoinCount int)ASBEGIN    DECLARE @warChannelType INT    SET @warChannelType = 0    DELETE [cabal_LordOfWar_table]    WHILE @warChannelType < 10)    BEGIN        INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, @warChannelType, max(nation)        FROM dbo.cabal_LordOfWar_point_table AS A, DBO.cabal_character_table B        WHERE A.characterIdx = B.characterIdx AND nation = 1 AND WarChannelType = @warChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= @OverWaRJoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx                INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, @warChannelType, max(nation)        FROM dbo.cabal_LordOfWar_point_table AS A, DBO.cabal_character_table B        WHERE A.characterIdx = B.characterIdx AND nation = 2 AND WarChannelType = @warChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= @OverWaRJoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx        SET @warChannelType = @warChannelType + 1    END    DELETE [cabal_LordOfWar_Rank_table]    DELETE [cabal_LordOfWar_point_table]END

    Although I am curious about Guardians myself, would be nice if someone shared some queries or hints / tips on setuping 6 guardians of each class.
    what do you mean by 6 bringers? is it each class?

  5. #5
    Member Drafys17 is offline
    MemberRank
    Aug 2013 Join Date
    37Posts

    Re: Old system bringer

    Luis This procedure makes 6 Bringers. I want to know how to do 1 Bringer and 6 guards in the class

  6. #6
    Account Upgraded | Title Enabled! joel de paula is offline
    True MemberRank
    May 2011 Join Date
    389Posts

    Re: Old system bringer

    The 6 guardians is like a bringer protector, it is a bonitficação an old system if I am not mistaken, the only ones I saw that have these system is the Cabal Nexus

  7. #7
    Member Drafys17 is offline
    MemberRank
    Aug 2013 Join Date
    37Posts

    Re: Old system bringer

    Cabal Nexus. Cabal Ncls,it was another 2 servers but I can't remember what I want to understand what is happening in these 2 databases.
    - create new table for guardians same with lordofwar table
    - create new SP to get_new_guardian

  8. #8
    Account Upgraded | Title Enabled! joel de paula is offline
    True MemberRank
    May 2011 Join Date
    389Posts

    Re: Old system bringer

    Send the Link of this Cabal Ncls please

  9. #9
    Member Drafys17 is offline
    MemberRank
    Aug 2013 Join Date
    37Posts

    Re: Old system bringer

    https://www.facebook.com/NusantaraGa...nf&pnref=story.
    As far as I know the moonlight also added this system!

  10. #10
    Nothing Personal xFly is offline
    True MemberRank
    Jan 2014 Join Date
    410Posts

    Re: Old system bringer

    you only can add manual by your self that tittle.

    or you can set at sp_set_character

    idk how to do it, you can try to modify that sp to search top 2 in war and add update tittle.




Advertisement