Plus Auto Notice(Sample + Source)

[Caosfox]

thx for your fast reply , what about this one

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
i have to add this as well ?

yes ofc, at that procedure, you must add this:


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)

this part creates the txt file so noteice.exe can read it

[saxz]

yes ofc, at that procedure, you must add this:


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)

this part creates the txt file so noteice.exe can read it

thx ^_^

EDIT : BTW it works with every plus ?
example : if the item is + 0 and it became + 1 , it will make a notice ? thx

[Caosfox]

yup, you define it on the procedure, in fact if you copy a text file with "im epic" inside and copy it at mssqltips folder, you send a notice with "im epic"

[saxz]

yup, you define it on the procedure, in fact if you copy a text file with "im epic" inside and copy it at mssqltips folder, you send a notice with "im epic"

well i have problem
i think i have to make my gateway port 15779 right ?
cant change it ?

[Caosfox]

pm me your port and i send a new version, or if you have visual studio 2010 you can recompile it with the port you want

[saxz]

pm me your port and i send a new version, or if you have visual studio 2010 you can recompile it with the port you want

ah i will download visual studio 2010 to do it xD
thx anyway

[Caosfox]

try this one, in theory you can set the port
Notice.rar

tell me if works

[saxz]

try this one, in theory you can set the port
Notice.rar

tell me if works

thx ^_^

try this one, in theory you can set the port
Notice.rar

tell me if works

hmmm no notice in game xD
no idea why
i made everything right

[Caosfox]

and you see the plus something enable on the prog?

[saxz]

and you see the plus something enable on the prog?

yes ,
ah btw auto notice is working very well
but the plus notice no xD

[Caosfox]

post the procedure of adlogitem, the part about notice, i check it

[saxz]

post the procedure of adlogitem, the part about notice, i check it

declare @azar INT , @veremos 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)



DECLARE @len_desc1 varchar(50) , @strDesc_separado varchar(50) ;

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

END

[Caosfox]

backup your proc and try this in place of your operation 90 part

   if(@Operation = 90)
   begin
    declare @iname varchar(129)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(5)    
    declare @cname varchar(64)
    select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
    select @iname = NameStrID128 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 '+'[' + @nombre + ']'+' 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 create this in like 5 minutes, so expect bugs, but at least must show some notice

[saxz]

backup your proc and try this in place of your operation 90 part

   if(@Operation = 90)
   begin
    declare @iname varchar(129)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(5)    
    declare @cname varchar(64)
    select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
    select @iname = NameStrID128 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 '+'[' + @nombre + ']'+' 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 create this in like 5 minutes, so expect bugs, but at least must show some notice

	   if(@Operation = 90)
   begin
    declare @iname varchar(129)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(5)    
    declare @cname varchar(64)
    select @iid = RefItemID from SRO_VT_SHARD_INIT.dbo._Items where Serial64 = @ItemSerial
    select @iname = NameStrID128 from SRO_VT_SHARD_INIT.dbo._RefObjCommon where id = @iid
    select @cname = CharName16 from SRO_VT_SHARD_INIT.dbo._Char where CharID = @CharID
    select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(@strDesc)) 
    declare @veremos varchar(200)
    select @veremos = '[' + @cname +']'+ ' has increased '+'[' + @nombre + ']'+' 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		
    
    
    DECLARE @len_desc1 varchar(50) , @strDesc_separado varchar(50) ;
    
    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
END

so this is right ?

[Caosfox]

replace this

    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

for this

if(@Operation = 90)
   begin
    declare @iname varchar(129)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(5)    
    declare @cname varchar(64)
    select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
    select @iname = NameStrID128 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 '+'[' + @nombre + ']'+' 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