online and offline notice

[anapse]

_AddLogChar

declare
    [USER=551894]Char[/USER]nombre varchar(64)

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


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

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

 

[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

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

 

[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.