1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Search User From Last Activity ?

Discussion in 'XenForo Questions and Support' started by tafreehm, May 27, 2012.

  1. tafreehm

    tafreehm Well-Known Member

    How can I search user from Last activity? For example I wanna list of user who did not visit forum from last 4 months....
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    You can run a query:

    Code:
    SELECT *
    FROM xf_user
    WHERE last_activity < UNIX_TIMESTAMP('2012-05-01 00:00:00');
    
    Just specify the date cutoff.
     
  3. tafreehm

    tafreehm Well-Known Member

    well, I was hoping to put those user in separate category with other other critera. and also to send email....
    So I guess this criteria is not available via admincp ?
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Correct. That criteria isn't available in the control panel.
     
  5. ragtek

    ragtek Guest

  6. tafreehm

    tafreehm Well-Known Member

  7. ragtek

    ragtek Guest

    I've added a "empty" method which is being run after the mail notification, so it's very easy to add own extensions o this (e.g. set new usergroup, log data,...)

    PHP:
        protected function _runAfterNotification($users)
        {
     
        }
     

Share This Page