ٍ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