Plus Auto Notice(Sample + Source)

[onurgs59]

Heyyy Please Help me !
Can notice write +8 or above +8 ??? Emergency!

[Caosfox]

Still does not support 32-bit windows and Unicode
and
15779 cannot be changed

what version? v3 or normal?
tested on windows 7 32 bits and runs ok

and you have source code, change port and compile it again

[a22345875]

what version? v3 or normal?
tested on windows 7 32 bits and runs ok

and you have source code, change port and compile it again

32bits xp or 64bits win2003 does not support

[Caosfox]

ahh, windows 2003 and xp, it have lastest net framework (4 or 4.5)?

try this version, is slower and using lame 32 bits debug code + libs, but again, all was done with lastest .net + w7 and w 2008r2
Notice.rar

[a22345875]

ahh, windows 2003 and xp, it have lastest net framework (4 or 4.5)?

try this version, is slower and using lame 32 bits debug code + libs, but again, all was done with lastest .net + w7 and w 2008r2
Notice.rar

I have installed net4.0

Still does not support 32-bit windows xp or 2003 ,But still thank you!

[Caosfox]

no idea why dont works on your system, i got it working so far on 4 servers, 1 64 bits and 3 32 bits

[onurgs59]

no idea why dont works on your system, i got it working so far on 4 servers, 1 64 bits and 3 32 bits

Please reply .Can notice write +8 or above +8 ???

[Caosfox]

Please reply .Can notice write +8 or above +8 ???

depend of the procedure, you define it there.

[saxz]

CREATE ASSEMBLY for assembly 'TextFileTips' failed because assembly 'TextFileTips' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. ,,, when i do this CREATE ASSEMBLY TextFileTips
FROM 'C:\MSSQLTips\TextFileTips.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS

[Caosfox]

execute step 6, both commands (only and only in sql2008 normal and r2)

[saxz]

execute step 6, both commands (only and only in sql2008 normal and r2)

I am using sql2008 r2 already
and still same error -.-
CREATE ASSEMBLY for assembly 'TextFileTips' failed because assembly 'TextFileTips' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission.

[Caosfox]

wnd you reused this querry?

USE SRO_VT_SHARDLOG GO ALTER DATABASE SRO_VT_SHARDLOG SET TRUSTWORTHY ON GO
?
using r2 express or datacenter?

[saxz]

nvm fixed xD

wnd you reused this querry?

USE SRO_VT_SHARDLOG GO ALTER DATABASE SRO_VT_SHARDLOG SET TRUSTWORTHY ON GO
?
using r2 express or datacenter?

i fixed this problem already xD thx anyway
but i have another problem
about this : SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
what is this WriteTextFile ?

[Caosfox]

WriteTextFile is a procedure, you create it at step 5
@veremos = the msg you want to send in the notice like " Saxz as leveled copper sword to +25475"
randomfile = name of the file where the msg is saved
0 = is about asynchronic write

[saxz]

WriteTextFile is a procedure, you create it at step 5
@veremos = the msg you want to send in the notice like " Saxz as leveled copper sword to +25475"
randomfile = name of the file where the msg is saved
0 = is about asynchronic write

thx for your fast reply , what about this one

if (@Operation = 90 OR @Operation = 160)
begin
set @len_desc1 = CHARINDEX (']',@strDesc)
if(@len_desc1 = 9)
begin
set @strDesc = SUBSTRING(@strDesc,0,9)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 1)
end
else if(@len_desc1 = 10)
begin
set @strDesc = SUBSTRING(@strDesc,0,10)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 2)
end
if(@strDesc_separado >= 8)
begin
--set @strDesc_separado = @len_desc1
insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido)
values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0')
end
end
i have to add this as well ?