Old system bringer

[Drafys17]

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

 

[joel de paula]

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

 

[MrSensei]

6 Bringers:

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]  [USER=489796]OverWaR[/USER]JoinCount int)ASBEGIN    DECLARE [USER=318766]war[/USER]ChannelType INT, [USER=138004]count[/USER]1 int, [USER=138004]count[/USER]2 int    DELETE [cabal_LordOfWar_table]    SET [USER=318766]war[/USER]ChannelType = 0    WHILE [USER=318766]war[/USER]ChannelType < 10)    BEGIN        SET [USER=138004]count[/USER]1 = 1         WHILE [USER=138004]count[/USER]1 <= 2)        BEGIN            SET [USER=138004]count[/USER]2 = 1            WHILE [USER=138004]count[/USER]2 <= 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)) [USER=138004]count[/USER]2))                BEGIN                    INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)                    SELECT top 1 C.CharacterIdx, [USER=318766]war[/USER]ChannelType, 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 = [USER=138004]count[/USER]1 AND (D.Style/POWER(2,0)&(POWER(2,3)-1)) [USER=138004]count[/USER]2                    AND C.WarChannelType = [USER=318766]war[/USER]ChannelType AND C.ValidPoint = 1                    GROUP BY C.characterIdx HAVING count(*) >= [USER=489796]OverWaR[/USER]JoinCount                    ORDER BY sum(C.WarPoint) desc, max(D.LEV) desc, C.characterIdx                END            SET [USER=138004]count[/USER]2 = [USER=138004]count[/USER]2+1            END        SET [USER=138004]count[/USER]1 = [USER=138004]count[/USER]1+1        END    SET [USER=318766]war[/USER]ChannelType = [USER=318766]war[/USER]ChannelType + 1    END    DELETE [cabal_LordOfWar_Rank_table]    DELETE [cabal_LordOfWar_point_table]END

1 Bringer

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]  [USER=489796]OverWaR[/USER]JoinCount int)ASBEGIN    DECLARE [USER=318766]war[/USER]ChannelType INT    SET [USER=318766]war[/USER]ChannelType = 0    DELETE [cabal_LordOfWar_table]    WHILE [USER=318766]war[/USER]ChannelType < 10)    BEGIN        INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, [USER=318766]war[/USER]ChannelType, 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 = [USER=318766]war[/USER]ChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= [USER=489796]OverWaR[/USER]JoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx                INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, [USER=318766]war[/USER]ChannelType, 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 = [USER=318766]war[/USER]ChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= [USER=489796]OverWaR[/USER]JoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx        SET [USER=318766]war[/USER]ChannelType = [USER=318766]war[/USER]ChannelType + 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.

 

[luis R]

try this

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]   [USER=489796]OverWaR[/USER]JoinCount int)ASBEGIN	DECLARE  [USER=318766]war[/USER]ChannelType INT,  [USER=138004]count[/USER]1 int,  [USER=138004]count[/USER]2 int	DELETE [cabal_LordOfWar_table]	SET  [USER=318766]war[/USER]ChannelType = 0	WHILE  [USER=318766]war[/USER]ChannelType < 10)	BEGIN		SET  [USER=138004]count[/USER]1 = 1 		WHILE  [USER=138004]count[/USER]1 <= 2)		BEGIN			SET  [USER=138004]count[/USER]2 = 1			WHILE  [USER=138004]count[/USER]2 <= 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))  [USER=138004]count[/USER]2))				BEGIN					INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)					SELECT top 1 C.CharacterIdx,  [USER=318766]war[/USER]ChannelType, 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 =  [USER=138004]count[/USER]1 AND (D.Style/POWER(2,0)&(POWER(2,3)-1))  [USER=138004]count[/USER]2					AND C.WarChannelType =  [USER=318766]war[/USER]ChannelType AND C.ValidPoint = 1					GROUP BY C.characterIdx HAVING count(*) >=  [USER=489796]OverWaR[/USER]JoinCount					ORDER BY sum(C.WarPoint) desc, max(D.LEV) desc, C.characterIdx				END			SET  [USER=138004]count[/USER]2 =  [USER=138004]count[/USER]2+1			END		SET  [USER=138004]count[/USER]1 =  [USER=138004]count[/USER]1+1		END	SET  [USER=318766]war[/USER]ChannelType =  [USER=318766]war[/USER]ChannelType + 1	END	DELETE [cabal_LordOfWar_Rank_table]	DELETE [cabal_LordOfWar_point_table]END

6 Bringers:

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]  @[I][B][URL="http://forum.ragezone.com/members/489796.html"]OverWaR[/URL][/B][/I]JoinCount int)ASBEGIN    DECLARE @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType INT, @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]1 int, @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]2 int    DELETE [cabal_LordOfWar_table]    SET @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType = 0    WHILE @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType < 10)    BEGIN        SET @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]1 = 1         WHILE @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]1 <= 2)        BEGIN            SET @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]2 = 1            WHILE @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]2 <= 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)) @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]2))                BEGIN                    INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)                    SELECT top 1 C.CharacterIdx, @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType, 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 = @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]1 AND (D.Style/POWER(2,0)&(POWER(2,3)-1)) @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]2                    AND C.WarChannelType = @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType AND C.ValidPoint = 1                    GROUP BY C.characterIdx HAVING count(*) >= @[I][B][URL="http://forum.ragezone.com/members/489796.html"]OverWaR[/URL][/B][/I]JoinCount                    ORDER BY sum(C.WarPoint) desc, max(D.LEV) desc, C.characterIdx                END            SET @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]2 = @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]2+1            END        SET @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]1 = @[I][B][URL="http://forum.ragezone.com/members/138004.html"]count[/URL][/B][/I]1+1        END    SET @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType = @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType + 1    END    DELETE [cabal_LordOfWar_Rank_table]    DELETE [cabal_LordOfWar_point_table]END

1 Bringer

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]  @[I][B][URL="http://forum.ragezone.com/members/489796.html"]OverWaR[/URL][/B][/I]JoinCount int)ASBEGIN    DECLARE @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType INT    SET @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType = 0    DELETE [cabal_LordOfWar_table]    WHILE @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType < 10)    BEGIN        INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType, 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 = @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= @[I][B][URL="http://forum.ragezone.com/members/489796.html"]OverWaR[/URL][/B][/I]JoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx                INSERT [cabal_LordOfWar_table](CharacterIdx, WarChannelType, Nation)        SELECT top 1 A.characterIdx, @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType, 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 = @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType                AND ValidPoint = 1        GROUP BY A.characterIdx        HAVING count(*) >= @[I][B][URL="http://forum.ragezone.com/members/489796.html"]OverWaR[/URL][/B][/I]JoinCount        ORDER BY sum(WarPoint) desc, max(B.LEV) desc, A.characterIdx        SET @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType = @[I][B][URL="http://forum.ragezone.com/members/318766.html"]war[/URL][/B][/I]ChannelType + 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?

 

[Drafys17]

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

 

[joel de paula]

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

 

[Drafys17]

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

 

[joel de paula]

Send the Link of this Cabal Ncls please

 

[Drafys17]

You must be registered to see links

.
As far as I know the moonlight also added this system!

 

[xFly]

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.

 

[Tryout]

Do I need to change WarChannelType to 16? Or just copy/paste and exec the query for 1 bringer?