[question] login global notice for GMs

[B13.]

hey guys i would like to know how to make a notice for all users in game
when i login / log out
like [GM]b13 logged in
can it be done ?

[Devsome]

Just write the notice when you are logged in or logging off, easiest way.

[B13.]

that's what i'm doing and i'm sick of it
is there is any other way ?

[zando]

Write me pm i will help u

[​Exo]

Well you have 2 options:

1) Using EventIDs and executing some command by a 3rd party application that will write the notice.

2) Using a proxy-based filter and sending local notice to all connected clients.

[​Goofie​]

Originally Posted by ​Exo

Well you have 2 options:

1) Using EventIDs and executing some command by a 3rd party application that will write the notice.

2) Using a proxy-based filter and sending local notice to all connected clients.

Or using the AutoPlus system + Silk per hour.

By having a trigger at _OnlineOffline when a char comes online it can execute the stuff for PlusNotice to send a notice in-game.

Also a way to go, not recommended do.

[​Exo]

Originally Posted by ​Goofie​

Or using the AutoPlus system + Silk per hour.



By having a trigger at _OnlineOffline when a char comes online it can execute the stuff for PlusNotice to send a notice in-game.



Also a way to go, not recommended do.

A trigger at such a table isn't really good *performance wise* you shouldn't use dem triggers on frequently used tabs

Originally Posted by ​Goofie​

Or using the AutoPlus system + Silk per hour.




Also a way to go, not recommended do.

Just telling him why it's not recommended

[Anonymous-6723]

Get an auto notice program, head to logdb.._AddLogEventChar (stored procedure)

IF(@EventID = 4)
get charname16 with select command
add line in the table that the auto notice reads with charname + has appearead

do same for EventID = 6
charname has disappeared.. There you go, done.. Pretty much summed up above comments for you. If you need help with the exact queries you will need, write the table structure you will be using here, so me or someone else could give you the proper queries to do it.