[question] login global notice for GMs

10/13/2015 09:32 B13.#1
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 ?
10/13/2015 09:43 Devsome#2
Just write the notice when you are logged in or logging off, easiest way.
10/13/2015 15:24 B13.#3
that's what i'm doing and i'm sick of it :D
is there is any other way ?
10/13/2015 18:01 zando#4
Write me pm i will help u
10/13/2015 20:18 ​Exo#5
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.
10/16/2015 11:08 ​Goofie​#6
Quote:
Originally Posted by ​Exo View Post
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.
10/16/2015 13:26 ​Exo#7
Quote:
Originally Posted by ​Goofie​ View Post
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

Quote:
Originally Posted by ​Goofie​ View Post
Or using the AutoPlus system + Silk per hour.




Also a way to go, not recommended do.

Just telling him why it's not recommended
10/16/2015 18:45 Anonymous-6723#8
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.