Plus Auto Notice(Sample + Source)

[saxz]

replace this

    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

for this

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 @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(@strDesc)) 
    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

I have to restart the notice program after i edit the proc ?

[Caosfox]

i dont think so, but restart it , better safer than sorry

[saxz]

i dont think so, but restart it , better safer than sorry

shit -.-
no notice in game -.-
no idea why
, also i can see that the table _LogItemsPlus is empty -.-
no codes inside it at all
no idea why

[Xanaxius]

Help me

[jsqdcdh]

My Release

[Caosfox]

My Release

good job!
btw, saxz problem was in procedure, looks like is the hardest part of the v3

[Caosfox]

Help me

try this one (is version 1.02 i think)
Notice1.0.rar

[fuddreckers2]

Help me

it.s Not Problem Write id and pw gm and continue

[ahmedzaki]

Help Guys When i Write User Name And Pw Account Gm Dont Give Me Select Char or any Thing when i write normal char its work but normal char without notice Help

[Caosfox]

gm char have the [GM] on the name? if yes, idk why dont show, create a new gm account with no [GM] in name and works perfect

[a22345875]

My Release

HOW to support Unicode?


CAN you share ?

[saxz]

first Screenshot by Lightshot
then when i try to click on Account login , nothing happen ? why

[ahmedzaki]

i am make new account gm and same don't give me any thing when i write normal account worked any help

[lemoniscool]

with the Auto Notice v3 you can also make an automated notice when a GM logs in or logs out, simply add the following to SRO_VT_SHARDLOG stored procedure "_AddLogChar" and change the char names (in case you got more add another line, in case you got less delete them)

IF @EventID = 6 begin
	if @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME1') OR
	   @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME2') OR
	   @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME3') OR
	   @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME4') begin
		declare @veremos_out varchar(200)
		declare @cname_out varchar(50) = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
		select @veremos_out = '[GM] ' + @cname_out + ' has logged out!'
		declare @azar_out INT
		declare @randomfile_out varchar(50) 
		SELECT top 1 @azar_out = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
		select @randomfile_out = 'C:\MSSQLTips\' + convert(varchar, @azar_out) + '.txt'
		SELECT dbo.WriteTextFile(@veremos_out, @randomfile_out, 0)	
	end
end
IF @EventID = 4
BEGIN
	if @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME1') OR
	   @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME2') OR
	   @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME3') OR
	   @CharID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 like 'CHARNAME3') begin
		declare @veremos varchar(200)
		declare @cname varchar(50) = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
		select @veremos = '[GM] ' + @cname + ' has logged in!'
		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
END

[Caosfox]

in fact, if you get the right eventid or operation, you can show on msg almost everything, like:
reaching max lvl
xxxx player got yyyy especial item
xxx item is destroyed
xxx player killed a gm

the sky (and your knowlege of sql) is the limit

btw, the part with "--" on the sql code is not need, i forgot to take it out on the original procedure release