Silk/Hour

07/16/2016 20:52 Mr.Rover#1

i've made the system from this thread
[Only registered and activated users can see links. Click Here To Register...]
and i wanna make a required level to get the silk
how can i do it ?

07/17/2016 11:30 EdwardTeach+-#2

IF (@'CharID IN (select charid from SRO_VT_SHARD.dbo._User with (nolock) where UserJID in (select JID from SRO_VT_ACCOUNT.dbo.TB_User with (nolock) where sec_content = 3))
and exists (Select * from SRO_VT_SHARD.dbo._Char where CurLevel = 'YOUR CAP LEVEL' and CharID = @'charid)
and not exists (SELECT CharID FROM _OnlineOffline WHERE CharID = @'CharID) )
BEGIN