How Create a Procedure to PVP_LOG

Results 1 to 5 of 5
  1. #1
    Member hellangel2 is offline
    MemberRank
    Jul 2006 Join Date
    cardosoLocation
    85Posts

    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 .



    Then to write in _LogPvP



    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 :


  2. #2
    Member Syloxx is offline
    MemberRank
    Aug 2014 Join Date
    GermanyLocation
    68Posts

    Re: How Create a Procedure to PVP_LOG

    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

  3. #3
    Member hellangel2 is offline
    MemberRank
    Jul 2006 Join Date
    cardosoLocation
    85Posts

    Re: How Create a Procedure to PVP_LOG

    Quote Originally Posted by Syloxx View Post
    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'

  4. #4
    Member Syloxx is offline
    MemberRank
    Aug 2014 Join Date
    GermanyLocation
    68Posts

    Re: How Create a Procedure to PVP_LOG

    thats why u use wildcards

  5. #5
    Member hellangel2 is offline
    MemberRank
    Jul 2006 Join Date
    cardosoLocation
    85Posts

    Re: How Create a Procedure to PVP_LOG

    Quote Originally Posted by Syloxx View Post
    thats why u use wildcards
    wildcards ? what is it? what I need do to take a Specific Fixed Line in @desc ?



Advertisement