Add Kill Score Winner

By completing this guide, you should be able to trigger Madness Solo event kill score winner and build your own custom systems.

Stored Procedure: _EventMadness_AddKillScoreWinner
Parameters:

@CharID INT - Winner character ID
@Top INT - Winner ranking position

Let's send a text notification to the winner character using _Char_SendTextNotification to ensure that the trigger works fine for us.

USE [vPlus]
GO

/****** Object: StoredProcedure [dbo].[_EventMadness_AddKillScoreWinner] ******/

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:      <Author,,Name>
-- ALTER date:  <ALTER Date,,>
-- Description: <Description,,>
-- =============================================

ALTER PROCEDURE [dbo].[_EventMadness_AddKillScoreWinner]
    @CharID INT,
    @Top INT
AS
BEGIN
    SET NOCOUNT ON;

    /*
        This procedure is executed when a player becomes one of
        the Madness Solo event kill score winners.

        @Top represents the player's ranking position.
    */

    --------- Your code starts here --------
    IF (@Top = 1)
        EXEC _Char_SendTextNotification @CharID, 'You have won Madness Solo with rank #1!', 1, 0, 0;
END