Plus Auto Notice(Sample + Source)

Quote:

---

Originally Posted by saxz

anything wrong with this query ?

PHP Code:

---

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?

So what's wrong with that ?

http://i.epvpimg.com/oeEof.jpg

#Edit fixed

Quote:

---

Originally Posted by Crue

So what's wrong with that ?

http://i.epvpimg.com/oeEof.jpg

---

Cannot Connect to Gateway Server

Quote:

---

Originally Posted by B1QB0SS

Cannot Connect to Gateway Server

---

Old ver work fine

but this not

so use old ver -.-

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

Quote:

---

Originally Posted by LeMbo

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

Quote:

---

Originally Posted by Comandante

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

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 ?

Quote:

---

Originally Posted by 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 ?

---

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.

Quote:

---

Originally Posted by Witchy Moo

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 ?

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
http://d.f21.photo.zdn.vn/upload/ori...11_574_574.jpg

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

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

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