[HELP] How Create a Procedure to PVP_LOG

[spinal2]

Hello Dear .

Someone have a idea how make a procedure to write in one tablet LOGS for a PVP ?

So i have one idea about using _Logeventchar.

IN case After Char Die in PVP we have a EVENTID = 20 .

 Spoiler

Then to write in _LogPvP

 Spoiler

Like as 'EXEMPLE' :

Declare @eventid int = ( select EventID from _LogEventChar where EventID = @EventID )

If @eventid = '20'

Begin
INSERT INTO _LogPvP (CharWinner , CharLost , Data) VALUES (@CharID , @K_CharID,'1')
END

Any Help :