Plus Auto Notice(Sample + Source)

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!