الموضوع: ارجو الحل
عرض مشاركة واحدة
قديم 14-04-2015, 11:25 AM   #5

sha2lato
عضو مجتهد





• الانـتـسـاب » Jun 2014
• رقـم العـضـويـة » 117944
• المشـــاركـات » 126
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
sha2lato صـاعـد

sha2lato غير متواجد حالياً



افتراضي رد: ارجو الحل



بص يباشا عشان متوجعش دماغك استخدم الكويرى دة هيظبطلك notice +8 غيرها انتا اعملها 13 y.png" border="0" alt="" title="Helmety" class="inlineimg" />

كود:
USE [SRO_VT_SHARDLOG] 
GO 
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 14/2/2015 04:33:00 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
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   
   declare @strDesc_separado varchar(128)   
   declare  @len_desc1 int  
   set @len_pos = len(@EventPos)    
   set @len_desc = len(@strDesc)    
   if (@len_pos > 0 and @len_desc > 0)    
   begin    
            insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold)    -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼  
            values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold)        -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼  
   end    
   else if (@len_pos > 0 and @len_desc = 0)    
   begin    
            insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold)            -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼  
            values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold)                -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼   
   end    
   else if (@len_pos = 0 and @len_desc > 0)    
   begin    
            insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold)            -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼  
            values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold)                    -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼   
   end    
   else if (@len_pos = 0 and @len_desc = 0)    
   begin    
            insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold)                        -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼  
            values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold)                            -- #ifdef EXTEND_GOLD_TYPE ±³?ƒ¼  
   end    
   -- ?€¯·?? ¾?†?€?Œ?…?› ±¸?€?”?€?Œ¸é!    
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35    
   if (@Operation = 35)    
   begin    
    insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)    
    values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)    
   end  
   if (@Operation = 90 OR @Operation = 160)    
   begin    
   set @len_desc1 = CHARINDEX (']',@strDesc)   
  if(@len_desc1 = 9)    
     begin  
     set @strDesc = SUBSTRING(@strDesc,0,9)  
     set @strDesc_separado = SUBSTRING(@strDesc, 8, 1)  
    end  
   else if(@len_desc1 = 10)  
        begin  
        set @strDesc = SUBSTRING(@strDesc,0,10)  
        set @strDesc_separado = SUBSTRING(@strDesc, 8, 2)  
        end  
        if(@strDesc_separado >= 8)  
        begin  
        --set @strDesc_separado = @len_desc1  
      insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0')    
    end   
   end  
   if(@Operation = 90) 
   begin 
    declare @iname varchar(129) 
    declare @iid int 
    declare @cname varchar(64) 
    select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial 
    select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in 
    (select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid)  
    select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID 
    if(@strDesc_separado >= 8) 
    insert PlusNotice(Sent, Message)values(0,'[' +@cname + '] has increased [' + @iname + '] to [Plus ' + CAST(@strDesc_separado AS NVARCHAR) + ']') 
 end   
Print 'Done Auto Notice from +8'  
Print 'Querry By Sha2lato'



التعديل الأخير تم بواسطة Hamza FiGo ; 15-04-2015 الساعة 12:38 PM