Plus Auto Notice(Sample + Source)

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

Quote:

---

Originally Posted by a22345875

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

Quote:

---

Originally Posted by Caosfox

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

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
Attachment 133974

Quote:

---

Originally Posted by 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
Attachment 133974

---

I have installed net4.0

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

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

Quote:

---

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

---

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

Quote:

---

Originally Posted by onurgs59

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

---

depend of the procedure, you define it there.

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

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

Quote:

---

Originally Posted by Caosfox

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.

wnd you reused this querry?

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

nvm fixed xD

Quote:

---

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

---

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 ?

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

Quote:

---

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

---

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 ?