1
urbanspacema
new modules and 'online' table

hello, I'm working on a new module. I always need to know in real time what users are logged on the site.

I saw that there is a table online but I have two questions:

1. how often is updated?
2. how do I retrieve the list of users online?

@ this moment my code is

$sql "SELECT s.*, t.* FROM ".$xoopsDB->prefix('online')." s, ".$xoopsDB->prefix('users')." t WHERE t.uid = s.online_uid ORDER BY s.online_updated DESC";

    
$result $xoopsDB->query($sql);
http://www.ultrasonica.it
http://www.noisecollective.net

Login

Who's Online

60 user(s) are online (40 user(s) are browsing Support Forums)


Members: 0


Guests: 60


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Feb 28
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits