[Dev.Ri3o]

هتعمل Table تحط فيها ال Item و ال ID اللى هو الرقم بتاعو ولازم تسمى ال Table اسمو RANDOM_LOTTERY
وبعد كدة تعمل Scroll وده ال Procedure بتاعها فى ال AddLogItem

if( @ItemRefID ='46092' and @Operation = '41') begin -- By Dev.Ri3o
        declare @Charname varchar(128)     
        DECLARE @Item_Code_Lottery Varchar(256) = (Select CodeName from SRO_VT_SHARD.dbo._RANDOM_GIFT where ID between '1' and '20' 
             order by  NEWID())
              set @charname = (select CharName16  from SRO_VT_SHARD.dbo._Char where CharID=@CharID)
                  if @CharName not like '$%^GM$%^'  
                  begin 
                  exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code_Lottery,1,0