By completing this guide, you should be able to trigger successful job suit equips to function and build your own custom systems.
Stored Procedure: _OnJobEquipSuccess
Parameters:
@CharID INT - Character ID
@JobType TINYINT - Job type
@Equipping TINYINT - Equipping status
@CharName16 VARCHAR(64) - Character name
@NickName16 VARCHAR(64) - Job nickname
1 - Character equipped the job suit successfully
0 - Character unequipped the job suit successfully
Let's send a text notification to the character using _Char_SendTextNotification to ensure that the trigger works fine for us.
USE [vPlus]
GO
/****** Object: StoredProcedure [dbo].[_OnJobEquipSuccess] Script Date: 1/16/2024 1:29:41 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- ALTER date: <ALTER Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_OnJobEquipSuccess]
@CharID INT,
@JobType TINYINT,
@Equipping TINYINT,
@CharName16 VARCHAR(64),
@NickName16 VARCHAR(64)
AS
BEGIN
SET NOCOUNT ON;
/*
This procedure is executed whenever a character
successfully equips or unequips a job suit.
@Equipping = 1 means the character equipped the job suit.
@Equipping = 0 means the character unequipped the job suit.
*/
--------- Your code starts here --------
-- Checking if the character equipped the job suit
IF (@Equipping = 1)
BEGIN
EXEC _Char_SendTextNotification @CharID, 'You have equipped a job suit successfully!', 1, 0, 0;
END
END
