Plus Auto Notice(Sample + Source)

[Comandante]

Empty!

Actually it's normal while PlusNotice table is empty :) check it out and be sure that its not empty

[DieEyes]

Yeah was empty, when i try to plus now something and its success i get error, System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.

Maybe i create rows with null let me check.

[Comandante]

Yeah was empty, when i try to plus now something and its success i get error, System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.

Maybe i create rows with null let me check.

Never ever allow nulls. :) Sent column is used by application to check if its already sent(coz it sends notice every 10 sec so there must be a limit) Message column is the body of application which contains notice and date column is used by application to send messages in an order :) (newest first)

Important: Default values are important. Take a look to first post. I've added them.

[Caosfox]

working perfect, only need to change some small values on proc (varchar got small and miss the last part of the msg)

[Comandante]

working perfect, only need to change some small values on proc (varchar got small and miss the last part of the msg)

Do not add "+" symbol to that message :) that's why i call it as lvl instead of opt :) That symbol is invisible while sending notice :)

[DieEyes]

First of all, its not working with me if i did not remove "_separado" from strDesc thats why i asked you before.

After removing it became work, but its keep spamming in game that chr did the + for the item

[Comandante]

First of all, its not working with me if i did not remove "_separado" from strDesc thats why i asked you before.

After removing it became work, but its keep spamming in game that chr did the + for the item

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

Change your procedure with this :P Let me know if it gives an error coz i cut some codes from there :)

[Caosfox]

yes, im trying to parse the strdesc , is missing on the proc you posted (var strdesc_separado). i change it later
now im adding some vars to the source, to do the "login" part automatic with my values, im lazy to type that much data

nvm, you posted the full proc ^^

[Comandante]

yes, im trying to parse the strdesc , is missing on the proc you posted (var strdesc_separado). i change it later
now im adding some vars to the source, to do the "login" part automatic with my values, im lazy to type that much data

I thought i'm not the only one who uses http://forum.ragezone.com/f722/db-lo...lobals-934558/ this thread :)) sorry for that, changed that procedure with new one :)

[DieEyes]

Worked fine now , Only keep spamming , i think its from the program i will restart it and check it again.

[Comandante]

Worked fine now , Only keep spamming , i think its from the program i will restart it and check it again.

It's about application's packet sending. I'll take a look to that while i got some time :)

[DieEyes]

It's about application's packet sending. I'll take a look to that while i got some time :)

Yeah later please check it couse still spamming :)

Thank you again and have a nice day.

[Caosfox]

dont worry, i have my proc edited in weird ways

[nandyyto]

Good job, work.

[denise456]

:D

http://forum.ragezone.com/f722/db-lo...lobals-934558/

System iSRO