teko007
03-05-2017, 03:55 PM
--// ©JuStiCe
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 = '8')
If (@EventID = '9') Or (@EventID = '11')
Begin
If Exists (Select top 1 Charname16 from SRO_VT_SHARD.dbo._Char
Order by RemainGold DESC)
Begin
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = '8' Where CharID = @CharID And HwanLevel not in (9,11,12,184,200,202,204,209,214,215,218)
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = '0' Where HwanLevel = '8' and not CharID = @CharID And HwanLevel not in (9,11,12,184,200,202,204,209,214,215,218)
END
END
دلوقتي - المفروضـ ان التاتيل تكون مع اكتر واحد معااه جولد - لكن للاسف كل البلاير بتاجيلهم تلقائي ..
ممكن حل يا شباب ؟!
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 = '8')
If (@EventID = '9') Or (@EventID = '11')
Begin
If Exists (Select top 1 Charname16 from SRO_VT_SHARD.dbo._Char
Order by RemainGold DESC)
Begin
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = '8' Where CharID = @CharID And HwanLevel not in (9,11,12,184,200,202,204,209,214,215,218)
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = '0' Where HwanLevel = '8' and not CharID = @CharID And HwanLevel not in (9,11,12,184,200,202,204,209,214,215,218)
END
END
دلوقتي - المفروضـ ان التاتيل تكون مع اكتر واحد معااه جولد - لكن للاسف كل البلاير بتاجيلهم تلقائي ..
ممكن حل يا شباب ؟!