Plus Auto Notice(Sample + Source)

[saxz]

well i am using a bit diff query
here it's

declare @iname varchar(200)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(200)    
    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
    select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
    select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
    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)

i have no idea how to make it read only + 8 and above -.-

[pr0xy1337]

well i am using a bit diff query
here it's

declare @iname varchar(200)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(200)    
    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
    select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
    select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
    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)

i have no idea how to make it read only + 8 and above -.-

Well I am using the original query from the first post and also the old tool that had the auto notice thingie (the original version)... Modified the query to read weapon names from a table and it works great it has a delay from around 4 seconds but I think it's okay. :) pm me if you need the query :)

[lemoniscool]

    declare @iname varchar(200)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(200)    
    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
    select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
    select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
    SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
    select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
    if (@plus >= 15) begin
        SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
    end

this code should work for you saxz

[loveme]

dont login _

[Caosfox]

you dont login on that part, you login at oyun part

[loveme]

login and +9 puss dont hava notice ?

[saxz]

    declare @iname varchar(200)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(200)    
    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
    select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
    select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
    SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
    select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
    if (@plus >= 15) begin
        SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
    end

this code should work for you saxz

this one for above + 15 or + 8 ? xD

[loveme]

2. notice

[Caosfox]

and what that mean? i only speak (and read) spanish and english

[loveme]

[Caosfox]

and you created c:\mssqltips folder on same machine you are running the notice program?

[loveme]

and you created c:\mssqltips folder on same machine you are running the notice program?

now program open dont error and now dont notice ? puss for

[lemoniscool]

now program open dont error and now dont notice ? puss for

the error tells you that you need to create the folder C:\MSSQLTips

this one for above + 15 or + 8 ? xD

its for +15 and above you can edit if (@plus >= 15) begin to make it +8 and above or any other number you want

[a22345875]

C:\MSSQLTips can not create any files,my os is win2003 x64

[Caosfox]

procedure create files at mssqltips, check procedure