You will need to obtain the character ID for the character whose body mode you want to change. 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_SetBodyMode
Parameters:
@CharID INT- Target character ID@Mode TINYINT- Body mode type
0 = Normal
1 = Berserker
2 = Untouchable (spawn protection)
3 = Game Master Invincible
4 = Game Master Invisible
5 = Unknown
6 = Stealth
7 = Invisible
@DurationSeconds REAL- Duration in seconds
The duration defines how long the selected mode will remain active. After that, it resets to Normal.
To keep the mode permanently, use 0.
Let us first test whether the command works by using the following code, which will set the Berserker body mode for a specific character.
USE [vPlus] GO DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name') EXEC _Char_SetBodyMode @CharID, 1;
For real usage, use @CharID directly from your calling procedure.
EXEC _Char_SetBodyMode @CharID, 1;