Stored Procedure: _Logger_GlobalMessage
Parameters:
@CharID INT- Character ID@Message VARCHAR(254)- Message text
Let us redirect the global chat message to a global text notification using the _Command_Global_SendTextNotification command to make sure that the trigger works correctly.
USE [vPlus]
GO
/****** Object: StoredProcedure [dbo].[_Logger_GlobalMessage] Script Date: 1/9/2024 5:25:57 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_Logger_GlobalMessage]
@CharID INT,
@Message VARCHAR(254)
AS
BEGIN
SET NOCOUNT ON;
--------- Your code starts here --------
-- Redirecting the character global chat message to a global notification
EXEC _Command_Global_SendTextNotification @Message, 1, 0, 0
END