Account

A good understanding of color values is recommended.

Stored Procedure: _Account_SendTextNotification

Parameters:

• @UserJID INT - Target account 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 account.

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

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

EXEC _Account_SendTextNotification @UserJID, 'Hello World!', 1, 0, 1;