How Create a Procedure to PVP_LOG

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 .

http://s16.postimg.org/yyo9woe45/Sem_t_tulo.png

Then to write in _LogPvP

http://s22.postimg.org/81rfga7zl/Sem_t_tulo2.png

Like as 'EXEMPLE' :

Code:

---

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 :

Code:

---

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 '/')

---

Code:

---

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

Quote:

---

Originally Posted by Syloxx

Code:

---

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 '/')

---

Code:

---

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'

thats why u use wildcards

Quote:

---

Originally Posted by Syloxx

thats why u use wildcards

---

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