Hello Guys
I want to make 3 kinds of Lottery Scroll with a different Reward
table
Procedure
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 :D
I want to make 3 kinds of Lottery Scroll with a different Reward
table
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
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
if @[Only registered and activated users can see links. Click Here To Register...]RefID = 777949 and @[Only registered and activated users can see links. Click Here To Register...] = 16)
begin--Usage:--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @[Only registered and activated users can see links. Click Here To Register...]me1 varchar(64)
select @[Only registered and activated users can see links. Click Here To Register...]me = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @[Only registered and activated users can see links. Click Here To Register...]D
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
select @[Only registered and activated users can see links. Click Here To Register...] = MAX(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
select @[Only registered and activated users can see links. Click Here To Register...] = Min(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
declare @[Only registered and activated users can see links. Click Here To Register...]name varchar(64)
etik:
SELECT @[Only registered and activated users can see links. Click Here To Register...] = (CONVERT(INT, RAND() * @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]+1))+ @[Only registered and activated users can see links. Click Here To Register...]))
select @[Only registered and activated users can see links. Click Here To Register...]name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @[Only registered and activated users can see links. Click Here To Register...]
select @[Only registered and activated users can see links. Click Here To Register...]name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @[Only registered and activated users can see links. Click Here To Register...]
print @[Only registered and activated users can see links. Click Here To Register...]
print @[Only registered and activated users can see links. Click Here To Register...]name
if(PATINDEX('%ITEM%' @[Only registered and activated users can see links. Click Here To Register...]name)>0)
begin
print 'not present'
end
else begin
begin--Usage:--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @[Only registered and activated users can see links. Click Here To Register...]me1 varchar(64)
select @[Only registered and activated users can see links. Click Here To Register...]me = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @[Only registered and activated users can see links. Click Here To Register...]D
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
select @[Only registered and activated users can see links. Click Here To Register...] = MAX(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
select @[Only registered and activated users can see links. Click Here To Register...] = Min(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
declare @[Only registered and activated users can see links. Click Here To Register...]name varchar(64)
etik:
SELECT @[Only registered and activated users can see links. Click Here To Register...] = (CONVERT(INT, RAND() * @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]+1))+ @[Only registered and activated users can see links. Click Here To Register...]))
select @[Only registered and activated users can see links. Click Here To Register...]name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @[Only registered and activated users can see links. Click Here To Register...]
select @[Only registered and activated users can see links. Click Here To Register...]name = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @[Only registered and activated users can see links. Click Here To Register...]
print @[Only registered and activated users can see links. Click Here To Register...]
print @[Only registered and activated users can see links. Click Here To Register...]name
if(PATINDEX('%ITEM%' @[Only registered and activated users can see links. Click Here To Register...]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 :D
