Plus Auto Notice(Sample + Source)

i have problem into Procedures he don't save any thing when i do PLUS ? can help

anyone found a fix for the notice showing +1 +2 +3 even though "if(@strDesc_separado >= 10) is used in the proc.
I checked PlusNotice table and the informations are written correctly, it only store the pluses more or equal than 10 but it will still notice the lower pluses. So it basicaly send notice to _LogItemPlus table but shouldn't it only send notice of PlusNotice table only?

what version are you using?

Can you make video explanation?

i done added the plus notice but little problem that release on notice even on +1,2,3, etc
how i can change it to only write notice on +7,8 etc

Also notice only write weapons/shield status nothing about set / accessory :(
my producer operation here

PHP Code:

---

    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 = 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
    insert PlusNotice(Sent, Message)values(0,@cname + ' has succeeded in augmenting  [ ' + @iname + ' ] to Plus (' + CAST(@strDesc_separado AS NVARCHAR) + ')')
  end 


---

I want to onward +8 , +1 if it is taking notice

Quote:

---

Originally Posted by mazazekoo

i done added the plus notice but little problem that release on notice even on +1,2,3, etc
how i can change it to only write notice on +7,8 etc

Also notice only write weapons/shield status nothing about set / accessory :(
my producer operation here

PHP Code:

---

    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)
    declare @optlevel int
    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
    
    set @optlevel = @strDesc_separado

    if (@optlevel >= 8)
       begin
             insert PlusNotice(Sent, Message)values(0,@cname + ' has succeeded in augmenting  [ ' + @iname + ' ] to Plus (' + @optlevel + ')')
       end
  end 


---

---

I hope this will work!!

Please
The work of a special video explanation

Quote:

---

Originally Posted by PX2000

I hope this will work!!

---

Not working :(

how to make this special notice?only logged players show this notice
Attachment 136844

guy's any one know how to change port of login in this program ?

any one help +1 +2+ 3 problem ?

this query only show +8 and more's:D thanks all

Code:

---

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 09/15/2013 20:20:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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 = 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
        if(@strDesc_separado >= 8)
        insert PlusNotice(Sent, Message)values(0,'[' +@cname + '] has increased [' + @iname + '] to [Lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']')
 end

---

Attachment 136909

any one maked armor's and accesories ?

Quote:

---

Originally Posted by SuperHer0

guy's any one know how to change port of login in this program ?

---

for what version?