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

XF 1.2 User Cleanup - Search on Joined Date and Last Activity Date being the same

#1
Anyone seen a add-on to search for users that have the same joined date and last activity date?

I have several hundred accounts that are registered and look to be bot created that I need a quick way to search for them.
 

Jake Bunce

XenForo moderator
Staff member
#2
Run this query on your database using a program like phpmyadmin:

Code:
SELECT *
FROM xf_user
WHERE register_date = last_activity;