Auto plus notice request

[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

    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 

[MentaL]

[herolord46]

up up

[mido22421]

up ....

[lemoniscool]

use the following 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

[mido22421]

Thx lemoniscool

Me need text _ItemName add Item_

auto Plus + 9 > +15

[lemoniscool]

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

[mido22421]

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

i need Auto Notice shows 9 +> 15 +

[lemoniscool]

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

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

[mido22421]

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

begin
--set @strDesc_separado = @Len_desc1