Plus Auto Notice(Sample + Source)

[longway]

i have Error in Notice plus the Notice work Perfect in SRO_SHARD-LOG but no notic Send i use = Notice V3

[Tazdingo]

Anybody implement a re-login system for this tool ?

[Rango]

I can not login

[Caosfox]

you are using default port (15779)?
program is allowed to connect on your firewall?

[thebigbody]

all work fin guys
but when i make +12 like i made in log no any notice shown
nothing happen O.o
any help ?

[Caosfox]

for what version? (table or not table version?)

[thebigbody]

for what version? (table or not table version?)

using SQL 2012 , V3 from the program ( btw i used all V available and nothing :D )

[Caosfox]

is about procedure then (you must check if its limited to +12 or not)
never used sql 2012 so no idea if v3 is installing correct or not

[thebigbody]

is about procedure then (you must check if its limited to +12 or not)
never used sql 2012 so no idea if v3 is installing correct or not

iam saying i used all kind of programs not only V3
about procedure iam sure 100% it works
even some one have this auto notice work already gave me all his log
and nothing too :S

[Tonyemma]

What about This problem :S .....Can Tell Me !!

[Caosfox]

@Tonyemma
exists that directory? is exactly named like that?


@thebigbody
v3 and the other versions uses diferent procedures (in fact, v3 uses a .dll file, not a tbale or things like that)
do this, close notice.exe v3. plus a item to +13 and a txt with random name must be created inside c:\mssqltips folder
containing the msg

if no file is created means a) procedure is wrong or b)dll is not installed
if file is created and say something like "xxxxx to lvl 13" or w/e the lvl is means the exe cant read it (in that case you must contact commandante, the exe creator)

[a22345875]

don't suport chinese and win2003 64x

[Caosfox]

cant say it works on it, was made over w7 64 and spanish locale
no idea about 2003 and chinese

[Witchy Moo]

I just read this yesterday and this is a very interesting release, since the author released the source, we might actually modify to make it work with any table and column (the v3 even better!, just need text file, easier). I made this PVP Fetching thingy which also prepared for this program (with different column name).

--

Alright, thanks for the source, modification made easy. And now it works with my Job/FreePVP Kill Fetching system ;)

Video:

Spoiler:

[saxz]

anything wrong with this query ?

ELSE IF (@Operation in (90))
            BEGIN
                declare @iname varchar(200)
    declare @iid int
    declare @nombre varchar(200)
    declare @plus varchar(200)    
    declare @cname varchar(64)
    declare @veremos varchar(max)
    declare @azar INT
    declare @randomfile varchar(max)
    select @iid = RefItemID from SHARD_VT_INT.dbo._Items where Serial64 = @ItemSerial
    select @iname = Name from SHARD_VT_INT.dbo._ItemName where CodeName128 in(select CodeName128 from SHARD_VT_INT.dbo._RefObjCommon where id = @iid)
    select @cname = CharName16 from SHARD_VT_INT.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)

            END