I'd like to be able to count the number of registered users, guests online and members logged in...
Registered users is easy, - SELECT COUNT(*) FROM auuth_user, Guests online are equally easy (although a little inaccurate) - SELECT COUNT(*) FROM active_sessions.
But what about members logged in? I can't figure out any way to get this.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2002-01-11
active_sessions.name - havn`t you noticed differrent values depends of "database_classes" for each connections...
also column sid values shows who`s already connected
>But what about members logged in? I can't figure out any way to get this
smth.like
select count(*) from active_session,auth_user where active_session.sid = auth_user.uid
all others - are guests.
AM I RIGHT ? who can tell any others methods?
correct if so pls.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'd like to be able to count the number of registered users, guests online and members logged in...
Registered users is easy, - SELECT COUNT(*) FROM auuth_user, Guests online are equally easy (although a little inaccurate) - SELECT COUNT(*) FROM active_sessions.
But what about members logged in? I can't figure out any way to get this.
active_sessions.name - havn`t you noticed differrent values depends of "database_classes" for each connections...
also column sid values shows who`s already connected
>But what about members logged in? I can't figure out any way to get this
smth.like
select count(*) from active_session,auth_user where active_session.sid = auth_user.uid
all others - are guests.
AM I RIGHT ? who can tell any others methods?
correct if so pls.