Lottery Scroll Procedure Problem

[xEslamHamed]

Hello Guys

I want to make 3 kinds of Lottery Scroll with a different Reward
table

 Spoiler

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_LotteryTABLE] Script Date: 07/24/2017 19:54:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LotteryTABLE](
[ID] [int] NULL,
[CodeName128] [varchar](250) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Procedure

 Spoiler

if @RefID = 777949 and @ = 16)
begin--Usage:--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @me1 varchar(64)
select @me = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @D
declare @ int
declare @ int
declare @ int
declare @ int
select @ = MAX(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
select @ = Min(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
declare @name varchar(64)
etik:
SELECT @ = (CONVERT(INT, RAND() * @ @+1))+ @))
select @name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @
select @name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @
print @
print @name
if(PATINDEX('%ITEM%' @name)>0)
begin
print 'not present'
end
else begin

problem is i cant use this procedure 3 times
So does anyone have an idea to edit this procedure
Sorry bad english i use google translate

[sonzenbi]

 Spoiler

if @RefID =777949 and @ = 41
begin
declare @d int = (select top 1 id from SRO_VT_SHARD.._LotteryTABLE order by NEWID())
declare @name varchar(64)
select @name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @d
exec SRO_VT_SHARD.dbo._Additembyname @,itemname ,1,0
end

[xEslamHamed]

Originally Posted by sonzenbi

 Spoiler

if @RefID =777949 and @ = 41
begin
declare @d int = (select top 1 id from SRO_VT_SHARD.._LotteryTABLE order by NEWID())
declare @name varchar(64)
select @name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @d
exec SRO_VT_SHARD.dbo._Additembyname @,itemname ,1,0
end

Thanks
I will try it

[iMenzz]

i have the same problem!

[sonzenbi]

Originally Posted by xEslamHamed

Thanks
I will try it

use this instead _ADD_ITEM_EXTERN