Auto plus notice request

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 


---

up up

up ....

use the following code:

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
                insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values @CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') 
                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 
end

---

Thx lemoniscool

Me need text _ItemName add Item_

auto Plus + 9 > +15

what do you need? didnt really understand what you meant with your last post

Quote:

---

Originally Posted by lemoniscool

what do you need? didnt really understand what you meant with your last post

---

i need Auto Notice shows 9 +> 15 +

below is the code for that .. btw try to learn something from this .. look at the changes i made, keep them in mind .. also learning some programming basics (if clauses, loops, operators etc) should help you quite a bit

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 and @strDesc_separado < 16) begin
                insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values @CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') 
                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 
end

---

thx if(@strDesc_separado > 8 and @strDesc_separado < 16) begin

begin
--set @strDesc_separado = @Len_desc1