lottery system

[hodamoseba]

عاوز اعمل lottery تديك ايتم واحد كل مرة من 10 معايا البروسيد دة
declare @CharName6 varchar(64) Select @CharName6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID declare @LotteryAvatar varchar(129) set @LotteryAvatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID()) exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName6,@LotteryAvatar,1,0 end