[HIDE]
[/HIDE]
SQL:
if @eventID = '22' and @data2 = '110'
begin
declare @CharNameTop varchar(64) = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID)
Declare @LimitReward Varchar(5) =
(Select count(_Char.CharID) from [SRO_VT_SHARD].[dbo].[_Char]
LEFT JOIN SRO_VT_SHARD.._User ON _User.CharID=_Char.CharID
LEFT JOIN SRO_VT_ACCOUNT..TB_User ON TB_User.JID=_User.UserJID
where CurLevel = '110' and sec_content=3)
DECLARE @Sec_Content int = (select sec_content from SRO_VT_ACCOUNT..TB_User
LEFT JOIN SRO_VT_SHARD.._User ON _User.CharID = @CharID
where TB_User.JID = _User.UserJID)
If @LimitReward < 110 and @Sec_Content = 3
Begin
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharNameTop,'ITEM_ETC_ARENA_COIN',1,1
END
END
