Account

You must create an entry inside textuisystem.txt with a custom code name.

1    VPLUS_CUSTOM_MESSAGE_HELLO_WORLD        Hello World    Hello World    Hello World    Hello World    Hello World    Hello World    Hello World    Hello World

A good understanding of color values is also recommended.

Stored Procedure: _Account_SendNotification

Parameters:

• @UserJID INT - Target account ID
• @CodeName VARCHAR(255) - Code name defined in textuisystem.txt
• @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 bottom-right system box (1 = Yes)
• @Color INT - Custom color (NULL for default)

Let us test the command by sending a custom notification to a specific account.

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

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

EXEC _Account_SendNotification @UserJID, 'VPLUS_CUSTOM_MESSAGE_HELLO_WORLD', 1, 0, 1;