Silk Scrolls (New Release)

/* Silk Scrolls SEction 2 */ 
DECLARE @CharName VARCHAR(56)
declare @USERID_1 varchar(64);
declare @USERID_2 varchar(64);
IF @Operation = '41' 
BEGIN
IF @ItemRefID = '8000154' -- Silk (100)
BEGIN
SET @USERID_1 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_1, @PkgID = NULL, @NumSilk = 100, @Price = 100
END


ELSE IF @ItemRefID = '8000157' -- Silk (2000)
BEGIN
SET @USERID_2 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_2, @PkgID = NULL, @NumSilk = 2000, @Price = 2000
END
END

DECLARE @CharName1 VARCHAR(56)
declare @USERID_3 varchar(64);
declare @USERID_4 varchar(64);
IF @Operation = '41' 
BEGIN
IF @ItemRefID = '8000155' -- Silk (500)
BEGIN
SET @USERID_3 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_3, @PkgID = NULL, @NumSilk = 500, @Price = 500
END


ELSE IF @ItemRefID = '8000153' -- Silk (50)
BEGIN
SET @USERID_4 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_4, @PkgID = NULL, @NumSilk = 50, @Price = 50
END
END

DECLARE @CharName2 VARCHAR(56)
declare @USERID_5 varchar(64);

IF @Operation = '41' 
BEGIN
IF @ItemRefID = '8000152' -- Silk (20)
BEGIN
SET @USERID_5 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_5, @PkgID = NULL, @NumSilk = 20, @Price = 20
END

DECLARE @CharName3 VARCHAR(56)
declare @USERID_6 varchar(64);

IF @Operation = '41' 
BEGIN
IF @ItemRefID = '8000156' -- Silk (1000)
BEGIN
SET @USERID_6 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_6, @PkgID = NULL, @NumSilk = 1000, @Price = 1000
END

/* Silk Scrolls SEction 2 */
END
END