Event Timer (Character)

You will need to obtain the character ID for the character you want to show or hide the event timer for. You can use the following query to get the character ID from the database.

SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name'

Stored Procedure: _Char_EventTimer

Parameters:

• @CharID INT - Target character ID
• @SecondsLeft INT - Timer duration in seconds

Let us test the command by starting a 2-minute event timer for a specific character.

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
EXEC _Char_EventTimer @CharID, 120;

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

EXEC _Char_EventTimer @CharID, 120;

To disable the event timer for a specific character, use the following command:

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
EXEC _Char_EventTimer @CharID, 0;