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

[krakersito]

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


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


My Notice V3 program:



This is how looks like my _AddLogItem procedure:

-------------------------------------------------------------------------------------------------------------------
-- 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:

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 ;)

[MentaL]