Add Kill

By completing this guide, you should be able to trigger War Of League event kill and build your own custom systems.

Stored Procedure: _EventWOL_AddKill
Parameters:

@CharID INT - Killer character ID
@CharName VARCHAR(64) - Killer character name
@NickName VARCHAR(64) - Killer nickname
@DeadCharID INT - Dead character ID
@DeadCharName VARCHAR(64) - Dead character name
@DeadNickName VARCHAR(64) - Dead character nickname

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

USE [vPlus]
GO

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

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

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

ALTER PROCEDURE [dbo].[_EventWOL_AddKill]
    @CharID INT,
    @CharName VARCHAR(64),
    @NickName VARCHAR(64),
    @DeadCharID INT,
    @DeadCharName VARCHAR(64),
    @DeadNickName VARCHAR(64)
AS
BEGIN
    SET NOCOUNT ON;

    /*
        This procedure is executed when a player kills another
        player in the War Of League event.

        RETURN 1 means the kill is valid and will be counted.
        RETURN 0 means the kill is not valid and will not be counted.
    */

    --------- Your code starts here --------

    EXEC _Char_SendTextNotification @CharID, 'You killed a player in the War Of League event', 1, 0, 0;

    RETURN 1;
END

Cookies