Advertisement
Guest User

Untitled

a guest
Sep 21st, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. if (@EventID = '19' )
  2. begin
  3.  
  4. if (@strPos like '%(0x696%)%')
  5. begin
  6. IF (@Desc LIKE '%Trader, Neutral, no freebattle team%' -- Trader
  7. OR @Desc LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
  8. OR @Desc LIKE '%Robber, Neutral, no freebattle team%' -- Thief
  9. )
  10. BEGIN
  11. --Killer
  12. Declare @Killername varchar(65) = @Desc
  13.  
  14. SELECT @killername = REPLACE (@killername, LEFT (@killername, CHARINDEX('(', @killername)), '')
  15. SELECT @killername = REPLACE (@killername, RIGHT (@killername, CHARINDEX(')', REVERSE(@killername))), '')
  16. Declare @KillerCharID int = (Select CharID From SRO_VT_SHARD.._Char Where CharID = @killername)
  17.  
  18. --Killed
  19. Declare @Killedname varchar(65) = (Select CharName16 From SRO_VT_SHARD.._Char Where CharID = @KilledCharID)
  20.  
  21.  
  22. DECLARE @ReqLevel INT = ( SELECT CurLevel FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = @KilledName)
  23.  
  24. if(@ReqLevel >=120)
  25. begin
  26. Exec [_Wanted] @CharID , @EventID , @Desc
  27.  
  28. DECLARE @KilledKills INT = ( Select Kills From _RowKills Where KilledID = @KilledCharID )
  29. DECLARE @KillerKills INT = ( Select Kills From _RowKills Where KillerID = @KillerCharID )
  30. Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values ('1','Private',@KilledName,+' Your Point IS '+@KilledKills+'',Getdate())
  31. Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values ('1','Private',@killername,+' Your Point IS '+@KillerKills+'',Getdate())
  32. end
  33.  
  34.  
  35. end
  36. end
  37.  
  38.  
  39.  
  40.  
  41. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement