I am in the process of updating the UsersOnline macro which has been submitted for WebGUI 6. I am almost there. However, there remains an issue with time stamps.

Active users are found by the following SQL query:

SELECT COUNT(DISTINCT userId) FROM userSession where (lastPageView >= $epoch) and (userId != 1)

The original code relied on WebGUI::DateTime functions for creating the timestamp in $epoch:

$epoch = WebGUI::DateTime::time();
$epoch = WebGUI::DateTime::addToTime($epoch, 0, -$minutes, 0);

Unfortunately, these functions have disappeared in WebGUI 7. I tried to replace them by

$epoch = time() - $minutes*60;

However, I get unreasonable results. So how do I create correct timestamps in WebGUI 7 such that there compatible with the ones used in the database backend?

--
Trying to build a non-profit community portal for free-climbers around Magdeburg/Germany. Check out http://kletterfreunde-md.kashyyyk.de (under construction).

Have a look at webgui::session::datetime, aka $session->datetime

JT

I'm not even sure what it is that you're working on, I just offered  help based upon what you asked. But yeah, there's a chance that  anything can make it into the core provided it follows all the guidelines for submitting stuff to the core.

The macro is meant to display users (members and visitors) that are currently active on a site. Optionally, a list of members with links to their profiles can be displayed.

I think this is a very nice extension for community portals. At the moment, however, the macro is still very unflexible. In addition, it uses direct queries for finding active users. I was wondering if there are any appropriate API functions for replacing these?

--
Trying to build a non-profit community portal for free-climbers around Magdeburg/Germany. Check out http://kletterfreunde-md.kashyyyk.de (under construction).

That seems like a nice idea. There's one thing I need you to agree to however. Something new we're trying to avoid the dump and run syndrome of the past. I need you to agree to support your code (bug fix wise) for at least one year after it gets added to the core. Can you agree to that?

--
Trying to build a non-profit community portal for free-climbers around Magdeburg/Germany. Check out http://www.klettern-md.de (under construction).