_AddLogItem / _LogEventItem doesn't work.

Hey,

I have been trying lately to add a new scroll "overlimit system" which grants the player a item after using it. However, there is nothing wrong with my query.

It should be from _AddLogItem since It doesn't really insert anything into _LogEventItem.. Been trying to fix it for 2 days and still couldn't find a solution so I thought about posting here, maybe someone could help.

Some pictures for explanation:

[Only registered and activated users can see links. Click Here To Register...]

^ It doesn't insert anything into _LogEventItem "I used a instant return scroll before checking"

So I thought about creating a new table to check if _AddLogItem doesn't work at all and found out that:

[Only registered and activated users can see links. Click Here To Register...]

It does work lol, I'm thinking right now of creating a new procedure and use _OperationDetectHUH instead but I think It may not work..

_AddLogItem Procedure:

Code:

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 02/13/2014 13:04:26 ******/
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  
  
  
  
insert into _OperationDetectHUH values (@CharID, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemRefID, GETDATE())
RETURN
   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  
			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  srsly learn how to use TV next time xDDD  I don't use meeting :s 
   if (@Operation = 35)  
   begin  
    insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)  
    values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)  
   end
   
   IF (@Operation = '41')
        -- ##############################################
        -- TESTING AT LEAST
        -- ##############################################
     begin
    
  IF (@ItemRefID = '47063')
  begin
  Declare  @Charname varchar(64);
      Select  @Charname = Charname16
  FROM sro_vt_Shard.dbo._Char where CharID = @CharID
  
  	exec sro_vt_shard.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_EVENT_RENT_REVERSE_RETURN_SCROLL',5,1  
  
  end
  end

Thank you so much and I'm really sorry If i have wasted your time.