Bugsuz Silk Scroll

[ßyMesMes]

HERAKLES Otomatik Avlı kalıcı sunucu. 19 Haziran'da açılıyor. Atius & Wizard güvencesiyle hemen kayıt ol, ön kayıt ödülleri aktif. HEMEN TIKLA!

Database'ye Eklenecekler:
RefObjCommon:

1    52003    ITEM_SILK_SCROLL_500    ?????    xxx    SN_ITEM_SILK_SCROLL_500    SN_ITEM_SILK_SCROLL_500_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    100    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\silk_scroll.ddj    xxx    xxx    54003

RefObjİtem :

54003    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    1000    COOLTIME:0x00000000    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0

SRO_VT_LOG ( Execute) Ediniz Kendinize Göre Fazla Silk Scroll Yapabilirsiniz . Operation Her Zaman '41' Kullanın Bug Olmaması İçin .

USE [SRO_VT_LOG]
GO
GO
/****** Object:  StoredProcedure [dbo].[_SILKSCROLL]    Script Date: 28.01.2017 04:45:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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 = '52003' -- Silk (500)
   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 = 500, @Price = 500
               END
          
               END

SRO_VT_LOG ( ADDLOGİTEM) As'dan Sonra Ekleyin .

 IF (@Operation = '41')
                          BEGIN
             EXEC [SRO_VT_LOG].[dbo].[_SILKSCROLL] @CharID , @Operation ,@ItemRefID
                                          END

Media Kısmı :

İtemdata45000 txt :

1    52003    ITEM_SILK_SCROLL_500    ?????    xxx    SN_ITEM_SILK_SCROLL_500    SN_ITEM_SILK_SCROLL_500_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    100    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\silk_scroll.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    1000    COOLTIME:0x00000000    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0

TextdataObject.txt :

1    SN_ITEM_SILK_SCROLL_500                            Silk Scroll (500)   
1    SN_ITEM_SILK_SCROLL_500_TT_DESC                            Silk 500

 

[|herkul01|]

Teşekkürler