Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (@EventID = '19' )
- begin
- if (@strPos like '%(0x696%)%')
- begin
- IF (@Desc LIKE '%Trader, Neutral, no freebattle team%' -- Trader
- OR @Desc LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
- OR @Desc LIKE '%Robber, Neutral, no freebattle team%' -- Thief
- )
- BEGIN
- --Killer
- Declare @Killername varchar(65) = @Desc
- SELECT @killername = REPLACE (@killername, LEFT (@killername, CHARINDEX('(', @killername)), '')
- SELECT @killername = REPLACE (@killername, RIGHT (@killername, CHARINDEX(')', REVERSE(@killername))), '')
- Declare @KillerCharID int = (Select CharID From SRO_VT_SHARD.._Char Where CharID = @killername)
- --Killed
- Declare @Killedname varchar(65) = (Select CharName16 From SRO_VT_SHARD.._Char Where CharID = @KilledCharID)
- DECLARE @ReqLevel INT = ( SELECT CurLevel FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = @KilledName)
- if(@ReqLevel >=120)
- begin
- Exec [_Wanted] @CharID , @EventID , @Desc
- DECLARE @KilledKills INT = ( Select Kills From _RowKills Where KilledID = @KilledCharID )
- DECLARE @KillerKills INT = ( Select Kills From _RowKills Where KillerID = @KillerCharID )
- Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values ('1','Private',@KilledName,+' Your Point IS '+@KilledKills+'',Getdate())
- Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values ('1','Private',@killername,+' Your Point IS '+@KillerKills+'',Getdate())
- end
- end
- end
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement