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);

Login

Who's Online

65 user(s) are online (32 user(s) are browsing Support Forums)


Members: 0


Guests: 65


more...

Donat-O-Meter

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

Latest GitHub Commits