ٍSilk Scroll

[che_9299]

Silk Scroll
Create Procedure
SRO_VT__SHARDLOG
USE SRO_VT_SHARDLOG
GO

/****** Object: StoredProcedure [dbo].[_SILKSCROLL] Script Date: 3/13/2014 12:43:06 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
CREATE procedure [dbo].[_SILKSCROLL]
@CharID int,
@Operation tinyint,
@ItemRefID int
AS
DECLARE @CharName VARCHAR(56)
declare @USERID_1 varchar(64);
declare @USERID_2 varchar(64);
declare @USERID_3 varchar(64);
declare @USERID_4 varchar(64);
declare @USERID_5 varchar(64);
declare @USERID_6 varchar(64);
declare @USERID_7 varchar(64);
declare @USERID_8 varchar(64);
declare @USERID_9 varchar(64);
declare @USERID_10 varchar(64);
declare @USERID_11 varchar(64);
declare @USERID_12 varchar(64);
declare @USERID_13 varchar(64);
IF @Operation = '41'
BEGIN
IF @ItemRefID = '46061' -- Silk (50)
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 = 50, @Price = 50
END
ELSE IF @ItemRefID = '46062' -- Silk (100)
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 = 100, @Price = 100
END
ELSE IF @ItemRefID = '46063' -- Silk (150)
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 = 150, @Price = 150
END
ELSE IF @ItemRefID = '46064' -- Silk (200)
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 = 200, @Price = 200
END
ELSE IF @ItemRefID = '46065' -- Silk (250)
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 = 250, @Price = 250
END
ELSE IF @ItemRefID = '46066' -- Silk (300)
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 = 300, @Price = 300
END
ELSE IF @ItemRefID = '46067' -- Silk (350)
BEGIN
SET @USERID_7 = (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_7, @PkgID = NULL, @NumSilk = 350, @Price = 350
END
ELSE IF @ItemRefID = '46068' -- Silk (400)
BEGIN
SET @USERID_8 = (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_8, @PkgID = NULL, @NumSilk = 400, @Price = 400
END
ELSE IF @ItemRefID = '46069' -- Silk (450)
BEGIN
SET @USERID_9 = (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_9, @PkgID = NULL, @NumSilk = 450, @Price = 450
END
ELSE IF @ItemRefID = '46070' -- Silk (500)
BEGIN
SET @USERID_10 = (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_10, @PkgID = NULL, @NumSilk = 500, @Price = 500
END
ELSE IF @ItemRefID = '46071' -- Silk (550)
BEGIN
SET @USERID_11 = (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_11, @PkgID = NULL, @NumSilk = 550, @Price = 550
END
ELSE IF @ItemRefID = '46072' -- Silk (600)
BEGIN
SET @USERID_12 = (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_12, @PkgID = NULL, @NumSilk = 600, @Price = 600
END
ELSE IF @ItemRefID = '46073' -- Silk (1000)
BEGIN
SET @USERID_13 = (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_13, @PkgID = NULL, @NumSilk = 1000, @Price = 1000
END
END

GO



AND add This Query
SRO_VT_SHARDLOG
ADDLOGCHAR
IF @Operation = '41'
BEGIN
EXEC SRO_VT_SHARDLOG.[dbo].[_SILKSCROLL] @CharID , @Operation ,@ItemRefID
END