Remove Character Event Register

This is used to unregister a specific character from an internal or external event instantly.

You will need to obtain the character ID for the character whose registration you want to remove. You can use the following query to get the character ID from the database.

SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name'

You will also need to obtain the event ID for the event you want to remove the registration from. You can use the following query to get the event ID from the database.

SELECT ID FROM _RefEvent WHERE [Name] = 'event_name'

Stored Procedure: _Char_RemoveEventRegister

Parameters:

• @CharID INT - Target character ID
• @EventID INT - Event ID

Let us first test whether the command works by using the following code, which will remove a character's registration from the Last Man Standing event.

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

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

EXEC _Char_RemoveEventRegister @CharID, 5;