طلب

[ruxana]

دا ال Procedure الي بيجيب code name

كود PHP:

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


عدلت عليه و خلتو كده

كود PHP:

select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid) 


الاول شغال تمام و التاني مش بيجيب ال notice

[Dev.Ri3o]

لو عايز تخليها حسب ال Item Name هتعمل ال Table ده

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_ItemName]    Script Date: 09/11/2013 12:38:45 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_ItemName](
    [CodeName128] [varchar](50) NOT NULL,
    [RealName] [varchar](50) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF


GO

وهتعمل ال Procedure ده بدل التانى

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

متنساش تعدل على ال Procedure وتكتب الرقم اللى عايز ال Notice يبدأ من عندو