Make a Custom Ranking plugin like CS,ARKA, for Ice Wind Valley.
Like this:
But pushing information by Server and Map.
Example:
Event will occur on server 10 on map 2. Therefore, you can apply this adjustment in the plugin or directly in SQL to obtain this information about where the event will occur. This will separate the deaths on this map.
USE [Ranking] -- 20.1.3.0 S
GO
/****** Object: Table [dbo].[IGC_IceWindKillRanking] Script Date: 01-Apr-25 4:53:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IGC_IceWindKillRanking](
[Server] [tinyint] NOT NULL,
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NOT NULL,
[GuildName] [varchar](8) NOT NULL,
[Class] [int] NOT NULL,
[KillCount] [int] NOT NULL,
[DeathCount] [int] NOT NULL,
CONSTRAINT [PK_IGC_IceWindKillRanking] PRIMARY KEY CLUSTERED
(
[Server] ASC,
[AccountID] ASC,
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[IGC_GetIceWindKillRanking] Script Date: 18/3/2025 00:11:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[IGC_GetIceWindKillRanking]
@Server tinyint
AS
BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON
SELECT TOP 100 Name, GuildName, Class, KillCount, DeathCount FROM IGC_IceWindKillRanking WHERE Server = @Server ORDER BY KillCount DESC, DeathCount ASC
SET NOCOUNT OFF
END
GO
/****** Object: StoredProcedure [dbo].[IGC_SaveIceWindKillRanking] Script Date: 18/3/2025 00:12:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[IGC_SaveIceWindKillRanking]
@Server tinyint,
@AccountID varchar(10),
@Name varchar(10),
@GuildName varchar(8),
@Class int,
@KillCount int,
@DeathCount int
AS
BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS (SELECT Name FROM IGC_IceWindKillRanking WHERE Server = @Server AND AccountID = @AccountID AND Name = @Name)
BEGIN
UPDATE IGC_IceWindKillRanking SET Class = @Class, GuildName = @GuildName, KillCount = KillCount + @KillCount, DeathCount = DeathCount + @DeathCount WHERE Server = @Server AND AccountID = @AccountID AND Name = @Name
END
ELSE
BEGIN
INSERT INTO IGC_IceWindKillRanking (Server, AccountID, Name, GuildName, Class, KillCount, DeathCount) VALUES (@Server, @AccountID, @Name, @GuildName, @Class, @KillCount, @DeathCount)
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
END
.thumb.png.1f5d2f8380255aca3acc63bdd56eb803.png)
kristensen2109 changed their profile photo