online and offline notice

[anapse]

_AddLogChar

declare
    @Charnombre varchar(64)

IF (@EventID = 4)
begin
select    @Charnombre = CharName16 from SRO_VT_SHARD.dbo._Char where CharID =    @CharID
and CurLevel > '80'
begin
insert PlusNotice(Sent, Message)values(0,'[ '    @Charnombre+' Se ha Conectado al Juego]')
end
end


IF (@EventID = 6)
begin
select    @Charnombre = CharName16 from SRO_VT_SHARD.dbo._Char where CharID =    @CharID
and CurLevel > '80'
begin
insert PlusNotice(Sent, Message)values(0,'['    @Charnombre+' Se ha Desconectado al Juego')
end

they can change the level of char in "CurLevel> '80' '

[MentaL]

[Madelyn]

Bad and Spam! The users not like this.. :S

[anapse]

Bad and Spam! The users not like this.. :S

this is for server noob for see player high lvl in or off

if you no like no problem other dev can use

all no think equal

[andzia098]

good release , can edit some stuff like curlevel >=140 (140) so that only gm's get this notice. thanks.

[Tyr]

what's so useful in this?

[fuddreckers2]

useless as hell

[blapanda]

Well... SMC authorized people can track players through... SMC without getting spammed the chat window. And well, it's not quite well limited to authorized GMs / Staff Members ingame.
Players don't have know how many players and who exactly logs in and out. Facebook2/Whatsapp2. Double check!

But well, who ever likes it..

[ongamanext]

Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 210
Incorrect syntax near 'Charnombre'.
Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 220
Incorrect syntax near 'Charnombre'.

[Dev Albert]

Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 210
Incorrect syntax near 'Charnombre'.
Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 220
Incorrect syntax near 'Charnombre'.

same error :@

- - - Updated - - -

Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 210
Incorrect syntax near 'Charnombre'.
Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 220
Incorrect syntax near 'Charnombre'.

same error :@

[karemsame]

Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 210
Incorrect syntax near 'Charnombre'.
Mens 102, Level 15, State 1, Procedure _AddLogChar, Line 220
Incorrect syntax near 'Charnombre'.

here is fix..

declare
@Charnombre varchar(64)

IF (@EventID = 4)
begin
select @Charnombre = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
and CurLevel > '80'
begin
insert PlusNotice(Sent, Message)values(0,'[ '+@Charnombre+' Se ha Conectado al Juego]')
end
end


IF (@EventID = 6)
begin
select @Charnombre = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
and CurLevel > '80'
begin
insert PlusNotice(Sent, Message)values(0,'['+@Charnombre+' Se ha Desconectado al Juego')
end
end

[FelipeRomero]

how add this?

[Miiguel Ramirez]

quien me ayuda para poner los aviso de linea y fuera de linea que no me agarran

[kotsh]

Stupid release really :D

[Flavio Eh Kelly]

Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@EventID".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@EventID".
Msg 137, Level 15, State 2, Line 16
Must declare the scalar variable "@CharID".

BRO HELP ME PLSS.