User count / list of active users

[rivet]

I know I can get a count of the active users, but can I get a list of the active 'account' name and a list of acctive 'user' names

[Computer Geek]

The only way I know of is from the FM server. Would be fantastic if there was a function that did this!!

[Deep Thought II]

there is a way, but it's probably a little troublesome...

u can maintain a user's table that has every username and an "Active" state field, with values 1 and 0. then each time the database is opened, an open script assigned the particular's state to 1... etc.

then when the user logs off, use a close script to assign the particular user's state to 0.

whala... now u have it, list of online users, u can also count how many users are online...

u can also use an "Online Table" instead of a "User Table", simple put an open script that adds a record to it, with Get (AccountName), then use a close script that deletes the online record. then u'll have it too...

if u maintain a user's table, i believe u can also implement an IM system using this method. by using 1's and 0's, to trigger different state at real time, event-driven scripts.

[Computer Geek]

I tried something similar in the past, with mixed results. There are situations where a close script won't fire, such as an improper shut down, loss of connection, etc. As long as these things didn't happen, it worked ok. I found it more trouble then it was worth, so I just pull a list from the server. However, I like the IM thought ....