1. 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

Discussion in 'XenForo Questions and Support' started by toy4x4, Feb 23, 2014.

  1. toy4x4

    toy4x4 Member

    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.
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query on your database using a program like phpmyadmin:

    SELECT *
    FROM xf_user
    WHERE register_date = last_activity;

Share This Page