Silk Scroll ( NEW )

Konuyu başlatan #1
Katılım
12 Ara 2016
Mesajlar
121
Beğeniler
0
Konum
EDİRNE
Merhaba arkadaşlar yeni silk scroll prosedür düzenledim istediğiniz kadar silk scroll ekleye bilirsiniz. Mega upload ettim RAR ın içinde 11 adet silk scroll bulunmakta siz istedğiniz kadar çoğaltabilirsiniz :)  Şimdiden iyi kullanmalar 

NOT:Başka bi DB den kodları aldım fakat bozuktu 30 dklık düzenleme sonucunda çalışır hale getirilmiştir.

:indir:

Link:  https://mega.nz/#!L4AW2ACa!S3yDqx-gwry490t3_f-_G3khIJkfWh-CCFDw-gDn0gc

@evonred​
 
Katılım
18 Şub 2016
Mesajlar
8
Beğeniler
0
Konum
BURSA
by_hero' Alıntı:
Merhaba, nerede yanlış yaptım bilmiyoru ama scrollu basınca silk yüklenmiyor :/
Hocam server dosyalarınızda log tutma kapalı ise bu tarz prosedüre bağlı sistemler çalışmaz. Logları açmanız gerekmekte. Eğer loglarınız açıksa muhtemelen AddLogItem'e item ID lerini yanlış girmişsinizdir.
 
Katılım
10 Haz 2016
Mesajlar
112
Beğeniler
1
Konum
KOCAELİ
bdrhan' Alıntı:
by_hero' Alıntı:
Merhaba, nerede yanlış yaptım bilmiyoru ama scrollu basınca silk yüklenmiyor :/
Hocam server dosyalarınızda log tutma kapalı ise bu tarz prosedüre bağlı sistemler çalışmaz. Logları açmanız gerekmekte. Eğer loglarınız açıksa muhtemelen AddLogItem'e item ID lerini yanlış girmişsinizdir.

AddLogItem i kontrol ettim idiler doğru, logoları nasıl aktif hale getirebilirim?
 
Konuyu başlatan #12
Katılım
12 Ara 2016
Mesajlar
121
Beğeniler
0
Konum
EDİRNE
samuray12' Alıntı:
prosodur eksik denedim calismiyor arkadaslar indirmeyin bosuna return atiyor ama silk vermiyo
Silk veriyormu çalışmıyormu sen yapamıyorsun kardeşim bende gayet sağlıklı bir şekilde çalışıyor? gelip burda yok o çalışmıyor bu çalışmıyor laga lugayı kes dostum..  Yapamıyorsan ben nabayım. al buda kanıtı çalıştığına dair.  RESİMDEN BAKABİLİRSİNİZ !!
https://i.hizliresim.com/mJnnvy.jpg
 
Katılım
26 Eyl 2016
Mesajlar
124
Beğeniler
2
Konum
İSTANBUL
evonred' Alıntı:
samuray12' Alıntı:
prosodur eksik denedim calismiyor arkadaslar indirmeyin bosuna return atiyor ama silk vermiyo
Silk veriyormu çalışmıyormu sen yapamıyorsun kardeşim bende gayet sağlıklı bir şekilde çalışıyor? gelip burda yok o çalışmıyor bu çalışmıyor laga lugayı kes dostum..  Yapamıyorsan ben nabayım. al buda kanıtı çalıştığına dair.  RESİMDEN BAKABİLİRSİNİZ !!
https://i.hizliresim.com/mJnnvy.jpg
ben ekledim fakat bende o asagıdaki yazı cıkmıyor neden acaba baska prosodur ıle ekledim senin yaptıgın prosodurle as den sonrası ekledim fakat kabul etmiyor 2ciyi bana bi yardım edebilir misin
 
Konuyu başlatan #16
Katılım
12 Ara 2016
Mesajlar
121
Beğeniler
0
Konum
EDİRNE
samuray12' Alıntı:
evonred' Alıntı:
Silk veriyormu çalışmıyormu sen yapamıyorsun kardeşim bende gayet sağlıklı bir şekilde çalışıyor? gelip burda yok o çalışmıyor bu çalışmıyor laga lugayı kes dostum..  Yapamıyorsan ben nabayım. al buda kanıtı çalıştığına dair.  RESİMDEN BAKABİLİRSİNİZ !!
https://i.hizliresim.com/mJnnvy.jpg
ben ekledim fakat bende o asagıdaki yazı cıkmıyor neden acaba baska prosodur ıle ekledim senin yaptıgın prosodurle as den sonrası ekledim fakat kabul etmiyor 2ciyi  bana bi yardım edebilir misin
kendiniz araştırarak bulabilirsiniz. Herşeyi ayağınaza beklemeyin... + prodosür eksikmiş o eksik bu eksik diye saçma sapan yorumlar yapmayın gördünüz çalışıyor. bilip bilmeden konuşmayınız. iyi günler
 
Katılım
10 Haz 2016
Mesajlar
112
Beğeniler
1
Konum
KOCAELİ
AddLogItem

Kod:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 17.12.2017 18:28:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase            : Shard Log  
ALTER  procedure [dbo].[_AddLogItem]  
  @CharID  int,  
  @ItemRefID int,  
  @ItemSerial bigint,  
  @dwData int,  
  @TargetStorage tinyint,  
  @Operation tinyint,  
  @Slot_From tinyint,  
  @Slot_To tinyint,  
  @EventPos varchar(64),  
  @strDesc varchar(128),
  @Gold        bigint            -- #ifdef EXTEND_GOLD_TYPE »ğÀÔ   
  as  
   declare @len_pos int  
   declare @len_desc int  
   set @len_pos = len(@EventPos)  
   set @len_desc = len(@strDesc)  
   if (@len_pos > 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos > 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    else if (@len_pos = 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos = 0 and @len_desc = 0)  
   begin  
        return -1
     end  

	   IF (@Operation = '16') 
                          BEGIN
             EXEC [SRO_VT_LOG].[dbo].[_SILKSCROLL] @CharID , @Operation ,@ItemRefID
                                          END
    -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if (@Operation = 35)  
  begin  
        return -1
     end
SilkScrool
Kod:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_SILKSCROLL]    Script Date: 17.12.2017 18:29:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER 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 = '16'
   BEGIN
   IF @ItemRefID = '41868' -- Silk (5)
   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 = 5, @Price = 5
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41869' -- Silk (10)
   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 = 10, @Price = 10
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41870' -- Silk (25)
   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 = 25, @Price = 25
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41871' -- 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
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41872' -- 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
			     IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41873' -- Silk (200)
   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 = 200, @Price = 200
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41874' -- Silk (300)
   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 = 300, @Price = 300
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41875' -- 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
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41876' -- Silk (750)
   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 = 750, @Price = 750
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41877' -- Silk (1,000)
   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 = 1000, @Price = 1000
               END
			   			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41878' -- Silk (10,000)
   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 = 10000, @Price = 10000
               END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
_RefObjCommon
Kod:
1 41869 ITEM_SILK_SCROLL_10 ????? xxx SN_ITEM_SILK_SCROLL_10 SN_ITEM_SILK_SCROLL_10_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 21358
1 41872 ITEM_SILK_SCROLL_100 ????? xxx SN_ITEM_SILK_SCROLL_100 SN_ITEM_SILK_SCROLL_100_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 21361
1 41877 ITEM_SILK_SCROLL_1000 ????? xxx SN_ITEM_SILK_SCROLL_1000 SN_ITEM_SILK_SCROLL_1000_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 21366
0 41878 ITEM_SILK_SCROLL_10000 ????? xxx SN_ITEM_SILK_SCROLL_10000 SN_ITEM_SILK_SCROLL_10000_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 21367
1 41873 ITEM_SILK_SCROLL_200 ????? xxx SN_ITEM_SILK_SCROLL_200 SN_ITEM_SILK_SCROLL_200_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 21362
1 41870 ITEM_SILK_SCROLL_25 ????? xxx SN_ITEM_SILK_SCROLL_25 SN_ITEM_SILK_SCROLL_25_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 21359
1 41874 ITEM_SILK_SCROLL_300 ????? xxx SN_ITEM_SILK_SCROLL_300 SN_ITEM_SILK_SCROLL_300_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 21363
1 41868 ITEM_SILK_SCROLL_5 ????? xxx SN_ITEM_SILK_SCROLL_5 SN_ITEM_SILK_SCROLL_5_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 21357
1 41871 ITEM_SILK_SCROLL_50 ????? xxx SN_ITEM_SILK_SCROLL_50 SN_ITEM_SILK_SCROLL_50_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 21360
1 41875 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 21364
1 41876 ITEM_SILK_SCROLL_750 ????? xxx SN_ITEM_SILK_SCROLL_750 SN_ITEM_SILK_SCROLL_750_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 21365
 
Konuyu başlatan #18
Katılım
12 Ara 2016
Mesajlar
121
Beğeniler
0
Konum
EDİRNE
by_hero' Alıntı:
AddLogItem

Kod:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 17.12.2017 18:28:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase            : Shard Log  
ALTER  procedure [dbo].[_AddLogItem]  
  @CharID  int,  
  @ItemRefID int,  
  @ItemSerial bigint,  
  @dwData int,  
  @TargetStorage tinyint,  
  @Operation tinyint,  
  @Slot_From tinyint,  
  @Slot_To tinyint,  
  @EventPos varchar(64),  
  @strDesc varchar(128),
  @Gold        bigint            -- #ifdef EXTEND_GOLD_TYPE »ğÀÔ   
  as  
   declare @len_pos int  
   declare @len_desc int  
   set @len_pos = len(@EventPos)  
   set @len_desc = len(@strDesc)  
   if (@len_pos > 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos > 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    else if (@len_pos = 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos = 0 and @len_desc = 0)  
   begin  
        return -1
     end  

	   IF (@Operation = '16') 
                          BEGIN
             EXEC [SRO_VT_LOG].[dbo].[_SILKSCROLL] @CharID , @Operation ,@ItemRefID
                                          END
    -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if (@Operation = 35)  
  begin  
        return -1
     end
SilkScrool
Kod:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_SILKSCROLL]    Script Date: 17.12.2017 18:29:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER 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 = '16'
   BEGIN
   IF @ItemRefID = '41868' -- Silk (5)
   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 = 5, @Price = 5
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41869' -- Silk (10)
   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 = 10, @Price = 10
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41870' -- Silk (25)
   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 = 25, @Price = 25
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41871' -- 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
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41872' -- 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
			     IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41873' -- Silk (200)
   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 = 200, @Price = 200
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41874' -- Silk (300)
   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 = 300, @Price = 300
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41875' -- 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
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41876' -- Silk (750)
   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 = 750, @Price = 750
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41877' -- Silk (1,000)
   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 = 1000, @Price = 1000
               END
			   			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41878' -- Silk (10,000)
   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 = 10000, @Price = 10000
               END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
_RefObjCommon
Kod:
1 41869 ITEM_SILK_SCROLL_10 ????? xxx SN_ITEM_SILK_SCROLL_10 SN_ITEM_SILK_SCROLL_10_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 21358
1 41872 ITEM_SILK_SCROLL_100 ????? xxx SN_ITEM_SILK_SCROLL_100 SN_ITEM_SILK_SCROLL_100_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 21361
1 41877 ITEM_SILK_SCROLL_1000 ????? xxx SN_ITEM_SILK_SCROLL_1000 SN_ITEM_SILK_SCROLL_1000_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 21366
0 41878 ITEM_SILK_SCROLL_10000 ????? xxx SN_ITEM_SILK_SCROLL_10000 SN_ITEM_SILK_SCROLL_10000_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 21367
1 41873 ITEM_SILK_SCROLL_200 ????? xxx SN_ITEM_SILK_SCROLL_200 SN_ITEM_SILK_SCROLL_200_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 21362
1 41870 ITEM_SILK_SCROLL_25 ????? xxx SN_ITEM_SILK_SCROLL_25 SN_ITEM_SILK_SCROLL_25_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 21359
1 41874 ITEM_SILK_SCROLL_300 ????? xxx SN_ITEM_SILK_SCROLL_300 SN_ITEM_SILK_SCROLL_300_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 21363
1 41868 ITEM_SILK_SCROLL_5 ????? xxx SN_ITEM_SILK_SCROLL_5 SN_ITEM_SILK_SCROLL_5_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 21357
1 41871 ITEM_SILK_SCROLL_50 ????? xxx SN_ITEM_SILK_SCROLL_50 SN_ITEM_SILK_SCROLL_50_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 21360
1 41875 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 21364
1 41876 ITEM_SILK_SCROLL_750 ????? xxx SN_ITEM_SILK_SCROLL_750 SN_ITEM_SILK_SCROLL_750_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 21365
operation 16 yerine 41 yapınız.. 16 ile bug oluyor.  önceden dosya güncelleme yapamadım k.b yın +  [font=Monaco, Consolas, Courier, monospace]0[/font][font=Monaco, Consolas, Courier, monospace] 41878 ITEM_SILK_SCROLL_10000..   0 ın servicee 1 yapın[/font]
 
Katılım
10 Haz 2016
Mesajlar
112
Beğeniler
1
Konum
KOCAELİ
evonred' Alıntı:
by_hero' Alıntı:
AddLogItem

Kod:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 17.12.2017 18:28:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase            : Shard Log  
ALTER  procedure [dbo].[_AddLogItem]  
  @CharID  int,  
  @ItemRefID int,  
  @ItemSerial bigint,  
  @dwData int,  
  @TargetStorage tinyint,  
  @Operation tinyint,  
  @Slot_From tinyint,  
  @Slot_To tinyint,  
  @EventPos varchar(64),  
  @strDesc varchar(128),
  @Gold        bigint            -- #ifdef EXTEND_GOLD_TYPE »ğÀÔ   
  as  
   declare @len_pos int  
   declare @len_desc int  
   set @len_pos = len(@EventPos)  
   set @len_desc = len(@strDesc)  
   if (@len_pos > 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos > 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    else if (@len_pos = 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos = 0 and @len_desc = 0)  
   begin  
        return -1
     end  

	   IF (@Operation = '16') 
                          BEGIN
             EXEC [SRO_VT_LOG].[dbo].[_SILKSCROLL] @CharID , @Operation ,@ItemRefID
                                          END
    -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if (@Operation = 35)  
  begin  
        return -1
     end
SilkScrool
Kod:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_SILKSCROLL]    Script Date: 17.12.2017 18:29:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER 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 = '16'
   BEGIN
   IF @ItemRefID = '41868' -- Silk (5)
   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 = 5, @Price = 5
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41869' -- Silk (10)
   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 = 10, @Price = 10
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41870' -- Silk (25)
   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 = 25, @Price = 25
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41871' -- 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
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41872' -- 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
			     IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41873' -- Silk (200)
   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 = 200, @Price = 200
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41874' -- Silk (300)
   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 = 300, @Price = 300
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41875' -- 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
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41876' -- Silk (750)
   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 = 750, @Price = 750
               END
			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41877' -- Silk (1,000)
   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 = 1000, @Price = 1000
               END
			   			    IF @Operation = '16'
   BEGIN
   IF @ItemRefID = '41878' -- Silk (10,000)
   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 = 10000, @Price = 10000
               END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
			   END
_RefObjCommon
Kod:
1 41869 ITEM_SILK_SCROLL_10 ????? xxx SN_ITEM_SILK_SCROLL_10 SN_ITEM_SILK_SCROLL_10_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 21358
1 41872 ITEM_SILK_SCROLL_100 ????? xxx SN_ITEM_SILK_SCROLL_100 SN_ITEM_SILK_SCROLL_100_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 21361
1 41877 ITEM_SILK_SCROLL_1000 ????? xxx SN_ITEM_SILK_SCROLL_1000 SN_ITEM_SILK_SCROLL_1000_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 21366
0 41878 ITEM_SILK_SCROLL_10000 ????? xxx SN_ITEM_SILK_SCROLL_10000 SN_ITEM_SILK_SCROLL_10000_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 21367
1 41873 ITEM_SILK_SCROLL_200 ????? xxx SN_ITEM_SILK_SCROLL_200 SN_ITEM_SILK_SCROLL_200_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 21362
1 41870 ITEM_SILK_SCROLL_25 ????? xxx SN_ITEM_SILK_SCROLL_25 SN_ITEM_SILK_SCROLL_25_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 21359
1 41874 ITEM_SILK_SCROLL_300 ????? xxx SN_ITEM_SILK_SCROLL_300 SN_ITEM_SILK_SCROLL_300_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 21363
1 41868 ITEM_SILK_SCROLL_5 ????? xxx SN_ITEM_SILK_SCROLL_5 SN_ITEM_SILK_SCROLL_5_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 21357
1 41871 ITEM_SILK_SCROLL_50 ????? xxx SN_ITEM_SILK_SCROLL_50 SN_ITEM_SILK_SCROLL_50_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 21360
1 41875 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 21364
1 41876 ITEM_SILK_SCROLL_750 ????? xxx SN_ITEM_SILK_SCROLL_750 SN_ITEM_SILK_SCROLL_750_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 21365
operation 16 yerine 41 yapınız.. 16 ile bug oluyor.  önceden dosya güncelleme yapamadım k.b yın +  [font=Monaco, Consolas, Courier, monospace]0[/font][font=Monaco, Consolas, Courier, monospace] 41878 ITEM_SILK_SCROLL_10000..   0 ın servicee 1 yapın[/font]
[font=Monaco, Consolas, Courier, monospace]41878 'i bilerek 0 yaptım hata veriyordu[/font]

Sorun güncel+
 
Katılım
26 Ağu 2016
Mesajlar
7
Beğeniler
0
Konum
BURDUR
Exercute de sorun yaşıyorum yardımcı olabilecek arkadaş var mı ? 

Msg 208, Level 16, State 6, Procedure _SILKSCROLL, Line 9

Invalid object name 'dbo._SILKSCROLL'.
 
Üst