Another question about [Plus Notice]

[Hamza FiGo]

There is anyway to make the + notice for 14D-15D only ?

Its works fine for all degrees. But i just need for 14D - 15D if possible

Ty

[​Exo]

PHP Code:

DECLARE @ItemCode varchar(max)
SELECT @ItemCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID =(SELECT RefItemID FROM _Items WHERE Serial64 = @ItemSerial))
IF (@ItemCode LIKE '%14%' OR @ItemCode LIKE '%15%')
BEGIN
-- Your notice --
END 


Should be like this

[Hamza FiGo]

Originally Posted by xExorcist

PHP Code:

DECLARE @ItemCode varchar(max)
SELECT @ItemCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID =(SELECT RefItemID FROM _Items WHERE Serial64 = @ItemSerial))
IF (@ItemCode LIKE '%14%' OR @ItemCode LIKE '%15%')
BEGIN
-- Your notice --
END 


Should be like this

Ty i gonna try this.

*********
Didn`t work and there is no plus notice appeared. just nothing.

USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 14/11/2014 08:35:35 م ******/
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  
   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)   
   DECLARE @ItemCode varchar(max)
SELECT @ItemCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID =(SELECT RefItemID FROM _Items WHERE Serial64 = @ItemSerial))
IF (@ItemCode LIKE '%14%' OR @ItemCode LIKE '%15%')
   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 <= 6)
        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 = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid
	select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
	insert PlusNotice(Sent, Message)values(0,@cname + ' has increased ' + @iname + ' to [lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']')  
  end

[​Exo]

If you can't get this to work then just ....

PHP Code:

IF (@Operation=90)
BEGIN
DECLARE @_CharName varchar(16),
        @ItemCode varchar(129),


SELECT  @ItemCode = (SELECT CodeName128 FROM SRO_VT_SHARD.._RefObjCommon WHERE ID =(SELECT RefItemID FROM SRO_VT_SHARD.._Items WHERE Serial64 = @ItemSerial)), 
        @_CharName = (SELECT CharName16 FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID)

  IF (@ItemCode LIKE '%14%' OR @ItemCode LIKE '%15%')
  BEGIN
  INSERT INTO PlusNotice(Sent, Message) VALUES (0,@_CharName + ' has increased ' + @ItemCode + ' to [lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']')  
  END      

END 


If the notice isn't written then it's your fault, you failed in configuring the application, how to test if it should work? After fusing got to PlusNotice table and check if a new row was added.