Silk/Hour

[Mr.Rover]

i've made the system from this thread

and i wanna make a required level to get the silk
how can i do it ?

[EdwardTeach+-]

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