XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. XOOPS Module Development
  4. Code Sharing and Library 
  5.  / new modules and 'online' table
Register
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

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

133 user(s) are online (112 user(s) are browsing Support Forums)

Members: 0

Guests: 133

more...

Donat-O-Meter

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

Latest GitHub Commits