avenbreaks Posted January 28 Share Posted January 28 I Already Tested Just 1 Race ( Accretia ) RF Version : 2232 GU Enable Honor Guild All Race --created by : Roslaw-- --03-06-2013-- Use RF_World GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DECLARE @b1 int; DECLARE @b2 int; DECLARE @b3 int; DECLARE @b4 int; DECLARE @b5 int; DECLARE @br1 tinyint; DECLARE @br2 tinyint; DECLARE @br3 tinyint; DECLARE @br4 tinyint; DECLARE @br5 tinyint; DECLARE @c1 int; DECLARE @c2 int; DECLARE @c3 int; DECLARE @c4 int; DECLARE @c5 int; DECLARE @cr1 tinyint; DECLARE @cr2 tinyint; DECLARE @cr3 tinyint; DECLARE @cr4 tinyint; DECLARE @cr5 tinyint; DECLARE @a1 int; DECLARE @a2 int; DECLARE @a3 int; DECLARE @a4 int; DECLARE @a5 int; DECLARE @ar1 tinyint; DECLARE @ar2 tinyint; DECLARE @ar3 tinyint; DECLARE @ar4 tinyint; DECLARE @ar5 tinyint; SELECT @b1=Serial, @br1=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 0) as TempBD Where RankB = 1 SELECT @b2=Serial, @br2=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 0) as TempBD Where RankB = 2 SELECT @b3=Serial, @br3=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 0) as TempBD Where RankB = 3 SELECT @b4=Serial, @br4=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 0) as TempBD Where RankB = 4 SELECT @b5=Serial, @br5=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 0) as TempBD Where RankB = 5 SELECT @c1=Serial, @cr1=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 1) as TempBD Where RankB = 1 SELECT @c2=Serial, @cr2=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 1) as TempBD Where RankB = 2 SELECT @c3=Serial, @cr3=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 1) as TempBD Where RankB = 3 SELECT @c4=Serial, @cr4=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 1) as TempBD Where RankB = 4 SELECT @c5=Serial, @cr5=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 1) as TempBD Where RankB = 5 SELECT @a1=Serial, @ar1=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 2) as TempBD Where RankB = 1 SELECT @a2=Serial, @ar2=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 2) as TempBD Where RankB = 2 SELECT @a3=Serial, @ar3=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 2) as TempBD Where RankB = 3 SELECT @a4=Serial, @ar4=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 2) as TempBD Where RankB = 4 SELECT @a5=Serial, @ar5=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 2) as TempBD Where RankB = 5 BEGIN Update tbl_honor_guild Set DCK = '1', IsNext = '1', dtDisable = getdate() Where DCK = '0' END BEGIN INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@br1, @b1, 15, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@br2, @b2, 15, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@br3, @b3, 10, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@br4, @b4, 5, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@br5, @b5, 5, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@cr1, @c1, 15, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@cr2, @c2, 15, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@cr3, @c3, 10, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@cr4, @c4, 5, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@cr5, @c5, 5, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@ar1, @a1, 15, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@ar2, @a2, 15, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@ar3, @a3, 10, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@ar4, @a4, 5, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@ar5, @a5, 5, 0) END GO Link to comment https://rfdev.net/topic/456-activation-honor-guild-from-sql-query/ Share on other sites More sharing options...
avenbreaks Posted January 28 Author Share Posted January 28 Images https://asset.cloudinary.com/dwzyjombu/fd3ededc1b1ba99adcaaee56fcb7a115Images Link to comment https://rfdev.net/topic/456-activation-honor-guild-from-sql-query/#findComment-757 Share on other sites More sharing options...
avenbreaks Posted January 28 Author Share Posted January 28 You Need Create Guild First Before Execute The Query. Example i have 2 Guild with 4 Grade and i try run query just 1 race (Accretia) Query Use RF_World GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DECLARE @a1 int; DECLARE @a2 int; DECLARE @ar1 tinyint; DECLARE @ar2 tinyint; SELECT @a1=Serial, @ar1=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 2) as TempBD Where RankB = 1 SELECT @a2=Serial, @ar2=Race FROM (SELECT ROW_NUMBER() OVER(ORDER BY a2.Grade DESC, a1.GuildPower DESC) AS RankB, a2.Serial, a2.Race, a2.id, a2.Grade, a1.GuildPower From tbl_GuildRankToday as a1, tbl_Guild as a2 Where a1.Serial = a2.Serial and a2.Race = 2) as TempBD Where RankB = 2 BEGIN Update tbl_honor_guild Set DCK = '1', IsNext = '1', dtDisable = getdate() Where DCK = '0' END BEGIN INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@ar1, @a1, 15, 0) INSERT INTO [dbo].[tbl_honor_guild] (race, guildserial, taxrate, IsNext ) VALUES (@ar2, @a2, 15, 0) END GO Link to comment https://rfdev.net/topic/456-activation-honor-guild-from-sql-query/#findComment-758 Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now