[SQL] Kill Fetch [KillEvent/Points/Survival]

[​Exo]

PHP Code:

CREATE PROCEDURE Exo_KillFetch
-- =============================================
-- Author:        <Exo>
-- Create date: <13.5.2014>
-- Description:    <KillFetch>
-- =============================================
  @CharID INT, 
  @Desc   VARCHAR(512),
  @strPos VARCHAR(64)
AS
BEGIN SET NOCOUNT ON;
--//---------------------------------------------------------------
  DECLARE
        @KillerName   VARCHAR(max),
        @KillerID     INT,
        @JobType      VARCHAR(max),
        @StartPos     TINYINT
--//---------------------------------------------------------------    

  SELECT @StartPos   = (SELECT CHARINDEX('(',@desc)) + 1
  SELECT @KillerName = (SELECT SUBSTRING(@Desc, @StartPos, CHARINDEX(')', @Desc, @StartPos) - @StartPos))
  SELECT @KillerID   = (SELECT CharID FROM Fayox_Shard.._Char WHERE CharName16 = @KillerName)
--//---------------------------------------------------------------
    SELECT @JobType = CASE
           WHEN   (@desc LIKE '%My: Trader%') 
               OR (@desc LIKE '%My: Robber%')
               OR (@desc LIKE '%My: Hunter%')
                    THEN 'Job'
         WHEN (@desc LIKE '%Murderer%')  
                    THEN 'Murder'
           ELSE 'Free'
                  END
--//---------------------------------------------------------------
BEGIN TRANSACTION     
--ADD your event conditions here example:
--IF (@strPos = '0x0000')
     --BEGIN
        -- Give silk
     --END

  INSERT Fayox_Log.._KillLogs VALUES (@KillerID,@CharID,@strPos,@JobType)
COMMIT TRANSACTION
END 


To run this procedure, go to your _AddLogChar SP and add this:

PHP Code:

IF (@EventID = 20)
BEGIN
EXEC Exo_KillFetch @CharID,@Desc,@strPos
END 


[Justin1337*]

Nice brother, thanks a lot. =)

[zizoelnigm]

there is some thing wrong in this Query

[​Exo]

Originally Posted by zizoelnigm

there is some thing wrong in this Query

which is?

[X-Vortex]

Nice Work Keep It Up ^_^

[geomangy]

I Like Your Way Of Coding.

[_0x0000]

thx you

[​Exo]

PS: Play with the trans as you like, hint: characters killed by mobs will be added and the KillerID will be null, you can skip that, just add you condition.

[leader*]

Nice Job !

[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 made mine like 1 or 2 years ago but its still faster then this...

feel free to use it

[​Exo]

^ Because I fetch other kills? Actually all of them, and you jut fetch the job kills.

Also you have less conditions, even if it would be faster it wouldn't be more than 10ms or smth, nothing major there.

[Syloxx]

just add some more OR @Desc LIKE '' and you are ready to go

[​Exo]

Whatever...

[raptter]

can u tell me how it start or where's the time to edit it i don't know how to start it

[​Exo]

Originally Posted by raptter

can u tell me how it start or where's the time to edit it i don't know how to start it

PHP Code:

IF (@EventID = 20)
BEGIN
EXEC Exo_KillFetch @CharID,@Desc,@strPos
END