Plus Auto Notice(Sample + Source)

Yes 2008 R2, no errors during install.
http://prntscr.com/1e2w5e


I think it has something to do with premissions of writing/editing files.

Edit : there is nothing like test.txt in C:\

null = file not writed
1 = sucess
that means:
1) no write permisions like you say
2) dll is not correctly installed
what to do
1) no idea, i dont know how sql manages permissions
2) reinstall the dll and try again

Windows Server 2003 R2 Enterprise fully updated.
64 Bit, No errors, at task manager DW20.exe pops up.
Something with the program is wrong.
On another test dedicated server with windows xp 32bit and 64bit, Im getting visual studio error.

Quote:

---

Originally Posted by TryToMakeServer

Windows Server 2003 R2 Enterprise fully updated.
64 Bit, No errors, at task manager DW20.exe pops up.
Something with the program is wrong.
On another test dedicated server with windows xp 32bit and 64bit, Im getting visual studio error.

---

never tested it on 2003/xp, only 2008 and 7 (in fact, i really doubt is going to work on xp, but anything can happend)
so cant say if its the program, os or if you need to edit something
dw20.. i have no idea what is that
so far installed on some servers with w2008 and 7 and is working 100%

its working for me too im using it on my server since i was done recreating the gui and adding the settings im using sql server 2008 r2 and windows server 2008 (os)

Is it possible to change the path instead C:\ to be D:\ ?

yes, you need to change on source and recompile

or to make your life easier, pm me where you want to check for files (like x:\files, or w/e you want) , i change, recompile and pm you back with a link with the new file

Quote:

---

Originally Posted by Caosfox

yes, you need to change on source and recompile

or to make your life easier, pm me where you want to check for files (like x:\files, or w/e you want) , i change, recompile and pm you back with a link with the new file

---

Adding a config.ini for this path would be great but yeah pmed you :) Thanks in advance !

hmmm what about if i want the auto plus thing start to say when players make + 15 and higher ?

Quote:

---

Originally Posted by pr0xy1337

Adding a config.ini for this path would be great but yeah pmed you :) Thanks in advance !

---

in v3 there is a config.xml as its C# i used xml instead of ini file format, look inside the source on how to add a path setting for it and edit it

Quote:

---

Originally Posted by saxz

hmmm what about if i want the auto plus thing start to say when players make + 15 and higher ?

---

change the stored procedure read pages 10~13 for more info on that this question was asked many times before but with +8 just change 8 to 15 and youre good to go

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