WordPress.org

Ready to get started?Download WordPress

Forums

Clobber spam users
No resullts (2 posts)

  1. Dabrowski
    Member
    Posted 1 year ago #

    What reasons might there be for no users showing up in the list? I know there are spam users with posts that are drafts.

    Hoping this works. Looks like just what I need.

    http://wordpress.org/extend/plugins/clobber-spam-users/

  2. Corey Salzano
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks for trying my plugin. I pulled the database query out of the plugin to post it here, and you could run this on your database if your table prefixes are the default wp_.

    SELECT wp_users.ID, wp_posts.ID AS post_ID
    FROM wp_users
    LEFT JOIN wp_posts ON wp_users.ID = wp_posts.post_author
    WHERE wp_posts.post_title <> 'Auto Draft'
    AND wp_posts.post_type = 'post'
    ORDER BY post_date DESC
    LIMIT 30

    This finds all the recent posts with the exception of Auto Drafts. This will include posts that are not spam. The plugin does not detect spam, it simply spits out the authors of the latest posts or drafts and allows you to choose which ones are spam.

    If you see nothing in the list, I wonder how your installation is different from mine. Are your posts being created with a post_type of post? Are the submitters of items to your site real users that are in the wp_users table?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.