[Plugin: Prune Users] Not catching any users

  • SplashTOMATO

    (@splashtomato)


    13 years, 1 month ago

    I’m looking at my userlist and see almost 50 people who should have been caught (I assign permission levels to people who comment or post), but instead I get nothing:

    Results:
    SELECT u.ID, u.user_login FROM wp_users u LEFT JOIN wp_posts p ON u.ID = p.post_author LEFT JOIN wp_comments c ON u.ID = c.user_id LEFT JOIN wp_usermeta um ON u.ID = um.user_id WHERE p.post_author is NULL AND c.user_id is NULL AND um.meta_key = ‘wp_capabilities’ AND LOCATE(‘administrator’, um.meta_value) = 0 AND LOCATE(‘editor’, um.meta_value) = 0 AND LOCATE(‘author’, um.meta_value) = 0 AND LOCATE(‘contributor’, um.meta_value) = 0 AND DATEDIFF (CURDATE(), u.user_registered) > 1
    Users who will be deleted: 0

Viewing 1 replies (of 1 total)
  • darkwolf74

    (@darkwolf74)

    12 years, 8 months ago

    IF the users you are trying to delete are anything BUT guests, it will pass them by. You need to edit the script and comment out the lines, like this.

    //if ($skip_authors) $skip_check .= ” AND LOCATE(‘author’, um.meta_value) = 0 “;
    //if ($skip_contributors) $skip_check .= ” AND LOCATE(‘contributor’, um.meta_value) = 0 “;

    I needed to kill off anything lower than Editor, so I commented out the above lines. Worked like a charm.

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: Prune Users] Not catching any users’ is closed to new replies.