Plus Auto Notice(Sample + Source)

[Caosfox]

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 

depends, you are using ver3 or ver1?
ver3 need a dll installed in the db (in fact, that proc is only for ver3)
ver1 no need dll, works with table, but dont use that querry

what error you get?

[Crue]

So what's wrong with that ?



#Edit fixed

[B1QB0SS]

So what's wrong with that ?

Cannot Connect to Gateway Server

[Crue]

Cannot Connect to Gateway Server

Old ver work fine

but this not

[B1QB0SS]

so use old ver -.-

[LeMbo]

want to make write notice from +7 and higher
using V1.0.5

[B1QB0SS]

want to make write notice from +7 and higher
using V1.0.5

how you call your self developer if you cant help your self ? -.-

[B1QB0SS]

Actually its so simple :) i prefer you guys to edit it a bit :) especially the timer :) its sending notice every 10 secs and gets the newest plus message (ordering by date)

did you know this alone ? o.O

[saxz]

to be honest the tool is good but there's something bad at it
it close always after some times
maybe after some hours , maybe after 1 day .etc
so why is this ?

[Witchy Moo]

to be honest the tool is good but there's something bad at it
it close always after some times
maybe after some hours , maybe after 1 day .etc
so why is this ?

Program auto-closing or (maybe) crash might related to your windows environment, if this happens a lot in your PC do take some time to check your Windows Event Viewer and see what happened.

[saxz]

Program auto-closing or (maybe) crash might related to your windows environment, if this happens a lot in your PC do take some time to check your Windows Event Viewer and see what happened.

Faulting application name: Notice.exe, version: 0.0.0.0, time stamp: 0x51bb2cf1
Faulting module name: KERNELBASE.dll, version: 6.1.7601.18229, time stamp: 0x51fb1116
Exception code: 0xe0434352
Fault offset: 0x0000c41f
Faulting process id: 0x276c
Faulting application start time: 0x01cf034520744cac
Faulting application path: C:\Notice\Notice.exe
Faulting module path: C:\Windows\syswow64\KERNELBASE.dll
Report Id: 5bf423b9-6f93-11e3-b3a9-08606ee5ba32

this info may say what is wrong ?

[mylove0990]

All OKE But when many Noitices , Window noitece GLOBAL is full
I Want edit to this notifice show in a newwindow
Can u Fix it

[marwanayman]

pls does any one know how to auto write Gz for unique killer like in Falcon Sro

[CandyQ]

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)
errors
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@veremos".

[Caosfox]

that is only part of the procedure, so ofc variables are not declared