Plus Auto Notice(Sample + Source)

Quote:

---

Originally Posted by Caosfox

replace this

Code:

---

    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

Code:

---

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 ?

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

Quote:

---

Originally Posted by Caosfox

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

Help me

Attachment 134098

My Release

Attachment 134109Attachment 134110Attachment 134111

Quote:

---

Originally Posted by jsqdcdh

My Release

Attachment 134109Attachment 134110Attachment 134111

---

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

Quote:

---

Originally Posted by Xanaxius

Help me

Attachment 134098

---

try this one (is version 1.02 i think)
Attachment 134127

Quote:

---

Originally Posted by Xanaxius

Help me

Attachment 134098

---

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

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

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

Quote:

---

Originally Posted by jsqdcdh

My Release

Attachment 134109Attachment 134110Attachment 134111

---

HOW to support Unicode?


CAN you share ?

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

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

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)

Code:

---

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

---

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