Job Counter Add Kill

By completing this guide, you should be able to trigger adding job kills to the counter and build your own custom systems.

Stored Procedure: _JobCounter_AddKill
Parameters:

@GroupID INT - Group ID
@JobType TINYINT - Killer job type
@Name VARCHAR(129) - Column 1 name
@P INT - Points

Let's add points to the selected job counter and send a global text notification using _Command_Global_SendTextNotification to ensure that the trigger works fine for us.

USE [vPlus]
GO
/****** Object:  StoredProcedure [dbo].[_JobCounter_AddKill]    Script Date: 5/18/2026 6:41:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_JobCounter_AddKill]
	@GroupID INT,
	@JobType TINYINT,
	@Name VARCHAR(129),
	@P INT
AS
BEGIN
	SET NOCOUNT ON;
	
	UPDATE _BattleLogLeagueData SET Points += @P WHERE GroupID = @GroupID AND JobType = @JobType AND Name = @Name
	IF (@@ROWCOUNT = 0)
		INSERT INTO _BattleLogLeagueData (GroupID, JobType, Name, Points) VALUES (@GroupID, @JobType, @Name, @P)


	DECLARE @MSG VARCHAR(255) = @Name + ' has earned ' + CAST (@P AS NVARCHAR) + ' Points'
	EXEC _Command_Global_SendTextNotification @MSG,1,0,1

END

The selected job character will receive points in the custom job counter, and a global notification will be sent when the procedure is executed.