Plus Auto Notice(Sample + Source)

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

Well

There is no data inserting on the PlusNotic table

addlogitem

if(@Operation = 90)
begin
declare @iname varchar(129)
declare @iid int
declare @NoMbre varchar(200)
declare @plus varchar(5)
declare @cname varchar(64)
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
select @iname = NameStrID128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid
select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
select @NoMbre = itemname from SRO_VT_SHARD.dbo.nombredeitems where itemcode = @iname
select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(@strDesc))
insert PlusNotice(Sent, Message, Date)values(0,'[' + @cname +']'+ ' has increased '+'[' + @NoMbre + ']'+' to lvl [' + @plus ,GETDATE())
declare @Veremos varchar(200)
select @Veremos = '[' + @cname +']'+ ' has increased '+'[' + @NoMbre + ']'+' to level [' + @plus
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)
end

any solutions? i use V3

v3 dont use any table, so i dont know why is not adding values

Quote:

---

Originally Posted by Caosfox

v3 dont use any table, so i dont know why is not adding values

---

wired

i dont have any notics

you register the dll inside sql? (and ofc change the db compatibility?)

Quote:

---

Originally Posted by Caosfox

you register the dll inside sql? (and ofc change the db compatibility?)

---

i dont think so let me check


any hints?

guide is on main post of v3, try to re install it (the dll + the 2 new procedures)

Quote:

---

Originally Posted by denise456

caosfox
lemoniscool

when i change the port of the agentserver can't loga my gm on schedule

when i use the port 15882 gm account 100% more when mute the door of agent not loga at plusnotice.


Srry my bad inglesh '-'

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

---

hello bro i have this problem any cant help me plsss i use db ortai

disable firewall and try again, to check if FW is your problem
and ofc you are using defaults ports?

Quote:

---

Originally Posted by Caosfox

disable firewall and try again, to check if FW is your problem
and ofc you are using defaults ports?

---

hello bro no have firewall defaul port its 15779 u cant add my in skype: carlosk22 and give u T.V pls

i cant help, i dont know c#

why I cant enter my server?

https://imagizer.imageshack.us/v2/11...90/89/939h.jpg

your server ip is 25.193.209.66? and firewall is open on that ports?
and this is relative to auto notice?

http://i62.tinypic.com/9zxdhk.jpg

pressing activate only connect to your db ( i think, i dont use table version)
if cant connect to your db, check firewall, maybe is blocking port 1433

Quote:

---

Originally Posted by Caosfox

pressing activate only connect to your db ( i think, i dont use table version)
if cant connect to your db, check firewall, maybe is blocking port 1433

---

Information on SQL Work:

1	Player [Sun] has increased [CROSSBOW_10 (Seal Of Star)] to [Plus 7]	2014-05-03 17:27:10.673
1	Player [iStark] has increased [DAGGER_10 (Seal Of Moon)] to [Plus 9]	2014-05-03 21:36:41.690
1	Player [Sun] has increased [DAGGER_09_C_RARE_HONOR] to [Plus 9]	2014-05-03 22:32:58.217
NULL	NULL

But menssage dont send to gamE!

Hello , i've already done everything properly in procedures. But i do have a serious problem , the version is setted on 188 as a default what if i've updated my client already to another version like 195. When i try to enter the version type in the prog it says incorrect version , please restart the program. Even the default version type also it says the same here is some screenshots:

http://i.imgur.com/MTcT0X8.png
http://i.imgur.com/KQJy6lh.png

in the oyun part, you are supposed to log in a gm char info, to do the "shouting". get me a screenshoot of oyun part (ofc delete the login info data)

- - - Updated - - -

locale is normaly 22, you changed it?

Quote:

---

Originally Posted by Caosfox

in the oyun part, you are supposed to log in a gm char info, to do the "shouting". get me a screenshoot of oyun part (ofc delete the login info data)

- - - Updated - - -

locale is normaly 22, you changed it?

---

Screenshots form the oyun part > http://i.imgur.com/MTcT0X8.png http://i.imgur.com/MTcT0X8.png
As far as i know and i've tried that before , you've to connect to the server first which gives me an error > The version is incorrect please restart the program.

As far as i know the ' Locale " number is the protocol number of smc , and the actual number on the smc is 24. Since i've made some updates i think it changes from 22 to 24.

The problem are in the version.. it says incorrect version which is really disappointing me so much.

well, really i have no idea. using locale 22 works perfect for me (in fact, even if i made any update locale always keep on 22)
if program dont works on locale 24, you must ask the program cretor or any programmer to check it

Quote:

---

Originally Posted by Caosfox

well, really i have no idea. using locale 22 works perfect for me (in fact, even if i made any update locale always keep on 22)
if program dont works on locale 24, you must ask the program cretor or any programmer to check it

---

Well yea it always stays at 22 you're right. However it worked i had to pass this " incorrect version , please restart the program " and just enter my id and pw and login normally.