[MORJANA]

أتفضل جرب ده

--// ©JuStiCe ---RecodedBy MORJANA ---

DECLARE @HwanLevel int = (Select HwanLevel From SRO_VT_SHARD.._Char Where CharID = @CharID) 

DECLARE @JuStiCe varchar(64) = (Select Charname16 from SRO_VT_SHARD.._Char Where CharID = @CharID and HwanLevel = '7') 

If (@EventID = '9') Or (@EventID = '11') 

Begin 

If Exists (Select top 1 RemainGold from SRO_VT_SHARD.dbo._Char 

Order by RemainGold DESC) 

Begin 

Update SRO_VT_SHARD.dbo._Char Set HwanLevel = '7' Where CharID = @CharID And HwanLevel not in (9,11,12,13,14,15,16,184,200,202,204,209,214,215,218) 

Update SRO_VT_SHARD.dbo._Char Set HwanLevel = '0' Where HwanLevel = '7' and not CharID = @CharID And HwanLevel not in (9,11,12,13,14,15,16,184,200,202,204,209,214,215,218) 

END 

END