Plus Auto Notice(Sample + Source)

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

Code:

---

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 -.-

Quote:

---

Originally Posted by saxz

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

Code:

---

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 :)

Code:

---

    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

dont login _http://img543.imageshack.us/img543/7596/z5wj.png

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

login and +9 puss dont hava notice ?

http://img209.imageshack.us/img209/2033/8yn.png

Quote:

---

Originally Posted by lemoniscool

Code:

---

    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

2. notice

http://img580.imageshack.us/img580/7290/kg7g.png

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

http://img580.imageshack.us/img580/7290/kg7g.png

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

Quote:

---

Originally Posted by Caosfox

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

Quote:

---

Originally Posted by loveme

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

---

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

Quote:

---

Originally Posted by saxz

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

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

procedure create files at mssqltips, check procedure