Stored Procedure: _OnAlchemyFuseSuccess
Parameters:
@CharID INT- Character ID@CharName16 VARCHAR(64)- Character name@Slot TINYINT- Slot ID@RefItemID INT- Item ID@CurrentOptLevel TINYINT- Current item plus value@NewOptLevel TINYINT- New item plus value
Let us send a text notification using _Char_SendTextNotification to make sure that the trigger works correctly.
USE [vPlus]
GO
/****** Object: StoredProcedure [dbo].[_OnAlchemyFuseSuccess] Script Date: 1/18/2024 6:18:12 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- ALTER date: <ALTER Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_OnAlchemyFuseSuccess]
@CharID INT,
@CharName16 VARCHAR(64),
@Slot TINYINT,
@RefItemID INT,
@CurrentOptLevel TINYINT,
@NewOptLevel TINYINT
AS
BEGIN
SET NOCOUNT ON;
/*
This procedure is executed when the player successfully fuses an item
and its plus value is upgraded.
*/
--------- Your code starts here --------
DECLARE @Message VARCHAR(255) = 'You have fused your item from +' + CAST(@CurrentOptLevel AS NVARCHAR) + ' to +' + CAST(@NewOptLevel AS NVARCHAR) + ' successfully!'
EXEC _Char_SendTextNotification @CharID, @Message, 1, 0, 0
END