On Mar 4, 1:52 am, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> How find number of logged in users if they don't log out properly?
>
> My only guess would be to count the number of session objects in
> memory....I just can't figure out how to deal with people that don't
> log out  explicitly.
>
> Chris

In SQL it would be something like

SELECT count(*)
FROM visit v
    Inner join visit_identity vi on v.visit_key=vi.visit_key
Where
    vi.expiry > current_timestamp

Basically, check for visit sessions that haven't expired.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to