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

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

Members: 0

Guests: 205

more...

Donat-O-Meter

Stats
Goal: AU$15.00
Due Date: Apr 30
Gross Amount: AU$0.00
Net Balance: AU$0.00
Left to go: AU$15.00
Make donations with PayPal!

Latest GitHub Commits