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 .
Then to write in _LogPvP
Like as 'EXEMPLE' :
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 .
Then to write in _LogPvP
Like as 'EXEMPLE' :
Any Help :Quote:
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