How Create a Procedure to PVP_LOG

[hellangel2]

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' :

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

In Case 'CharWinner' we need extract form _Logeventchar 'StrDesc' and 'CharLost' from 'CharID'
Any Help :

[MentaL]

[Syloxx]

IF     @eventID = 19
    AND     @desc LIKE '/[My: Robber, %, no freebattle team/] /[His(%): Trader, %, no freebattle team/]' ESCAPE '/'
    OR     @desc LIKE '/[My: Trader, %, no freebattle team/] /[His(%): Robber, %, no freebattle team/]' ESCAPE '/'
    OR     @desc LIKE '/[My: Hunter, %, no freebattle team/] /[His(%): Robber, %, no freebattle team/]' ESCAPE '/'
    OR     @desc LIKE '/[My: Robber, %, no freebattle team/] /[His(%): Hunter, %, no freebattle team/]' ESCAPE '/')

SELECT    @KillerName = SUBSTRING @desc, (CHARINDEX('[His(', @desc) +5), (CHARINDEX('): ', @desc) - (CHARINDEX('[His(', @desc) +5)))

i released that for job once just modofy it for your pvp and you are done

[hellangel2]

IF     @eventID = 19
    AND     @desc LIKE '/[My: Robber, %, no freebattle team/] /[His(%): Trader, %, no freebattle team/]' ESCAPE '/'
    OR     @desc LIKE '/[My: Trader, %, no freebattle team/] /[His(%): Robber, %, no freebattle team/]' ESCAPE '/'
    OR     @desc LIKE '/[My: Hunter, %, no freebattle team/] /[His(%): Robber, %, no freebattle team/]' ESCAPE '/'
    OR     @desc LIKE '/[My: Robber, %, no freebattle team/] /[His(%): Hunter, %, no freebattle team/]' ESCAPE '/')

SELECT    @KillerName = SUBSTRING @desc, (CHARINDEX('[His(', @desc) +5), (CHARINDEX('): ', @desc) - (CHARINDEX('[His(', @desc) +5)))

i released that for job once just modofy it for your pvp and you are done

Yes But im EventID don't have a Fixed line to be take KILLER name only Killed Name in '@desc'

[Syloxx]

thats why u use wildcards

[hellangel2]

thats why u use wildcards

wildcards ? what is it? what I need do to take a Specific Fixed Line in @desc ?