• 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 ?

tafreehm

Well-known member
#1
How can I search user from Last activity? For example I wanna list of user who did not visit forum from last 4 months....
 

Jake Bunce

XenForo moderator
Staff member
#2
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.
 

tafreehm

Well-known member
#3
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 ?
 
R

ragtek

Guest
#7
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)
    {
 
    }