Character

A good understanding of color values is recommended.

Stored Procedure: _Char_SendTextNotification

Parameters:

• @CharID INT - Target character ID
• @Message VARCHAR(255) - Message to display
• @AlertType TINYINT - Top notification color
  • 0 = None
  • 1 = Pink
  • 2 = Green
  • 3 = Blue
  • 4 = Indigo
  • 5 = Custom
• @ChatboxType TINYINT - Chatbox behavior
  • 1 = Normal (All tab)
  • 2 = Whisper
  • 3 = Notice (All tabs)
  • 4 = Party
  • 5 = Guild
  • 6 = Global
  • 11 = Union
  • 16 = Academy
• @SystemBox BIT - Show in the bottom-right system box (1 = Yes)
• @Color INT - Custom color (NULL for default)

Let us test the command by sending a text notification to a specific character.

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
EXEC _Char_SendTextNotification @CharID, 'Hello World!', 1, 0, 1;

For real usage, use @CharID directly from your calling procedure.

EXEC _Char_SendTextNotification @CharID, 'Hello World!', 1, 0, 1;