(Caosfox, lemmoniscool) Notice V3, weird and unbelievable :P

Hey. I Tryed yesterday with normal Auto Plus notice i mean that of Comandante , and its work, showing alchemy notice in game and writing notice in DB PlusNotice etc.
But i decided today to try a Notice V3 relased by Caosfox. First i fight abt 4 hours cuz cannot get some permissions in my own db, after i handle this shity DB, i excuted rest queries etc etc etc from
this ofc:
http://forum.ragezone.com/f722/plus-...9/index10.html
SO in 1 word -> EVERYTHING i did "SUCCESS". ( I did everything STEP by STEP from Caosfox tutorial)

Well:
1* - i dont care abt writing notice to DB PlusNotice in SRO_VT_SHARDLOG so i cuted from MainProcedure
2* - Notice V3 its working but -> its not making any .txt file or any other file in C:\MSSQLTips
I dont know why and i dont care abt that , cuz Main THING (NOTICE PLUS) is working(but not in a 100%): Look at that

1st screenshot Alchemy ON TOTLY CLEAN ITEM: NO VISUAL ERRORS
Attachment 155721

2th screenshot Alchemy with 1 lucky stone , WTH IS that ? :/
Attachment 155719

My Notice V3 program:

Attachment 155720

This is how looks like my _AddLogItem procedure:

Code:

---




-------------------------------------------------------------------------------------------------------------------
-- 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 
  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)
  begin
    declare @iname varchar(129)
    declare @iid int
   
        declare @plus varchar(5)   
        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
   
    select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(@strDesc))
   
    declare @Veremos varchar(200)
    select @Veremos = '[' + @CnaMe +']'+ ' has increased '+'[' + @iname + ']'+' to level [' + @plus
    declare @Azar INT
    declare @randomfile varchar(50)
    SELECT top 1 @Azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
    select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @Azar) + '.txt'
    SELECT dbo.WriteTextFile @Veremos, @randomfile, 0)
    end

---

I also tryed with INsert PlusNotice , it write well to DB , but VISUAL error still the same.
I try to modify this row in few ways:

select @Veremos = '[' + @CnaMe +']'+ ' has increased '+'[' + @iname + ']'+' to level [' + @plus

But still the same wich means nothing ;/




What can i do with that?

Please help me somehow ;p :)

ps. sql 2008r2



I THINK IS FIXED: I ADD THIS TO MY PROCEDURE:

Code:

---

if    @operation = 90 OR @operation = 160)
 begin 
    set @Len_desc = CHARINDEX (']',@strDesc) 
    if  @Len_desc = 9)
    begin
        set @strDesc = SUBSTRING(@strDesc,0,9)


    end
    else if  @Len_desc = 10)
    begin
        set @strDesc = SUBSTRING(@strDesc,0,10)
     
end

---

BUhahahhah finally after over 6 hours >< >< >< :D :) IT seems be correct, btw it still dont writhing .TXT files but who cares :D :P :)

Now its looks liks this :)

[Notice][party1] has increased [Hell Dragon Blade] to level [7]
[Notice][party1] has increased [Hell Dragon Blade] to level [1]
[Notice][party1] has increased [Hell Dragon Blade] to level [2]

Ohh btw:

Big THANKS TO Caosfox , lemmoniscool,Comandante,Awesome , Great Job Guys !!! <3 ;)