Announcement

Collapse
No announcement yet.

Subtracting "lastactivity" for a user from GMT time...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Subtracting "lastactivity" for a user from GMT time...

    Hi Everyone,

    I want to add a hack to my VB 2.3.4 forum, where I show which registered members have logged onto the forum since midnight GMT time.....

    I've been working with this code:

    $todayusers=$DB_site->query("SELECT userid, username, usergroupid, lastactivity, invisible FROM user
    WHERE lastactivity > " . (gmmktime(0,0,0,date("m"),date("d"),date("Y"))) . "
    ORDER BY username");
    But, if it is not midnight GMT yet, I would like to find members who signed in the midnight the day before....

    Does anyone have any ideas to help?

    Thanks,

    Khashyar
    Last edited by Khashyar; Sun 14 Aug '05, 12:40am.
    www.DalaiLamaFilm.com/community
    www.russianmeetingplace.com/forums/
    www.russianmeetingplace.com/russianforum/
    www.wakan.com/forum
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X