طلب

[ruxana]

طب دلوقتي انا و صلت لحل بس ال notice بتجي كده مع العلم ان الي برفع عليه دا سورد مش نيكلاس مع العلم برضو ان الكلام الي مكتوب في itemname صح


دا الكيوري بعد التعديل

كود PHP:

select @iname = RealName from SRO_VT_SHARD.dbo._ItemName select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid 


[Jayden]

ال Query دى متعملش اى حاجة دى بتعمل Select مش أكتر
إتأكد انك كاتب الأكواد صح والأسماء صح لإن كده اكيد مكتوبة غلط
وورينى صورة برضو من التيبل انا مش شايف اللى عندك عشان اعرف العيب منين

[ruxana]

اهو انا عامل البلص علي اول حاجه الي هيا السورد

[Dev.Ri3o]

مش ده ال Query اللى انا قولتلك اعملو انا قولتلك اعمل ده

USE [SRO_VT_SHARLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 09/15/2013 20:20:09 ******/
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 »?AO    
  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   
   -- A¯·? ¾?A??U ±¸AOA?¸é!   
   -- #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)
    declare @RealName Varchar(Max) 
    select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
    select @iname = CodeName128 From SRO_VT_SHARD.dbo._RefObjCommon where id = @iid
    Select @RealName =  RealName From SRO_VT_SHARD.dbo._itemName Where CodeName128 = @iname
    select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
    if(@strDesc_separado >= 12)
     insert PlusNotice(Sent, Message)values(0,'[' +@cname + '] has increased  [' + @RealName + '] to [Lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']')
 end

والسطر اللى فوق مختلف عن السطر اللى هنا

[Dev.Ri3o]

##